Dart

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.

Dart

import 'package:chilkat/chilkat.dart';

void main() {
  final csv = CkCsv();

  // Load the following CSV:

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

  // Indicate that the 1st line contains column names.
  csv.hasColumnNames = true;
  csv.loadFile('qa_data/csv/insertColumnTest.csv');

  // We can insert a column before the 1st column.
  csv.insertColumn(0);

  print(csv.saveToString());

  // The CSV now looks like this:

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

  // Set the cells in column 0.

  final col = 0;
  csv.setColumnName(col, 'id');
  csv.setCell(0, col, '100');
  csv.setCell(1, col, '101');

  print(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.
  final weightColumn = csv.getIndex('Weight');
  print('Weight Column Index = $weightColumn');
  csv.insertColumn(weightColumn);

  print(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(weightColumn, 'Height');
  csv.setCell(0, weightColumn, '6\' 2"');
  csv.setCell(1, weightColumn, '5\' 7"');

  print(csv.saveToString());

  // We now have:

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