(JavaScript) CSV Insert Column

See more CSV Examples

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

Note

This example is intended for running within a Chilkat.Js embedded JavaScript engine. All Chilkat JavaScript examples require Chilkat v11.4.0 or greater.

var success = false;

var csv = new 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;
success = 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.

var 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.
var 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