React Native

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.

React Native

import { Csv } from '@chilkat/react-native'

function chilkatExample() {
  const csv = new Csv();

  // 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);

  console.log(csv.saveToString());

  // The CSV now looks like this:

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

  // Set the cells in column 0.

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

  console.log(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.
  const weightColumn = csv.getIndex('Weight');
  console.log(`Weight Column Index = ${weightColumn}`);
  csv.insertColumn(weightColumn);

  console.log(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"');

  console.log(csv.saveToString());

  // We now have:

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