(Node.js) 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.

Install Chilkat for Node.js and Electron using npm at Chilkat npm packages for Node.js Chilkat npm packages for Electron on Windows, Linux, MacOSX, and ARM

var os = require('os');
if (os.platform() == 'win32') {  
    if (os.arch() == 'ia32') {
        var chilkat = require('@chilkat/ck-node21-win-ia32');
    } else {
        var chilkat = require('@chilkat/ck-node21-win64'); 
    }
} else if (os.platform() == 'linux') {
    if (os.arch() == 'arm') {
        var chilkat = require('@chilkat/ck-node21-arm');
    } else if (os.arch() == 'x86') {
        var chilkat = require('@chilkat/ck-node21-linux32');
    } else {
        var chilkat = require('@chilkat/ck-node21-linux64');
    }
} else if (os.platform() == 'darwin') {
    if (os.arch() == 'arm64') {
        var chilkat = require('@chilkat/ck-node21-mac-m1');
    } else {
        var chilkat = require('@chilkat/ck-node21-macosx');
    }
}

function chilkatExample() {

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

}

chilkatExample();