Objective-C

CSV Insert Column

See more CSV Examples

Insert a new column into an existing CSV.

Note: This example requires Chilkat v9.5.0.89 or greater because the InsertColumn method was added in v9.5.0.89.

Objective-C

#import <CkoCsv.h>

BOOL success = NO;

CkoCsv *csv = [[CkoCsv alloc] init];

//  Load the following CSV:

//   Name;City;Weight
//   John;Chicago;180
//   Lisa;Denver;120

//  Indicate that the 1st line contains column names.
csv.HasColumnNames = YES;
success = [csv LoadFile: @"qa_data/csv/insertColumnTest.csv"];

//  We can insert a column before the 1st column.
[csv InsertColumn: [NSNumber numberWithInt: 0]];

NSLog(@"%@",[csv SaveToString]);

//  The CSV now looks like this:

//   ;Name;City;Weight
//   ;John;Chicago;180
//   ;Lisa;Denver;120

//  Set the cells in column 0.

int col = 0;
[csv SetColumnName: [NSNumber numberWithInt: col] columnName: @"id"];
[csv SetCell: [NSNumber numberWithInt: 0] col: [NSNumber numberWithInt: col] content: @"100"];
[csv SetCell: [NSNumber numberWithInt: 1] col: [NSNumber numberWithInt: col] content: @"101"];

NSLog(@"%@",[csv SaveToString]);

//  We now have:

//   id;Name;City;Weight
//   100;John;Chicago;180
//   101;Lisa;Denver;120

//  Insert a new column between City and Weight
//  In other words, add a new column before the Weight column.
int weightColumn = [[csv GetIndex: @"Weight"] intValue];
NSLog(@"%@%d",@"Weight Column Index = ",weightColumn);
[csv InsertColumn: [NSNumber numberWithInt: weightColumn]];

NSLog(@"%@",[csv SaveToString]);

//  We now have:

//   id;Name;City;;Weight
//   100;John;Chicago;;180
//   101;Lisa;Denver;;120

//  Set the cells in the new column:

[csv SetColumnName: [NSNumber numberWithInt: weightColumn] columnName: @"Height"];
[csv SetCell: [NSNumber numberWithInt: 0] col: [NSNumber numberWithInt: weightColumn] content: @"6' 2\""];
[csv SetCell: [NSNumber numberWithInt: 1] col: [NSNumber numberWithInt: weightColumn] content: @"5' 7\""];

NSLog(@"%@",[csv SaveToString]);

//  We now have:

//   id;Name;City;Height;Weight
//   100;John;Chicago;"6' 2""";180
//   101;Lisa;Denver;"5' 7""";120