Java

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.

Chilkat2 Java

import com.chilkatsoft.chilkat2.Csv;

public class ChilkatExample {

    public static void main(String[] args) {
        Csv 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.setHasColumnNames(true);
        csv.loadFile("qa_data/csv/insertColumnTest.csv");

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

        System.out.println(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(col, "id");
        csv.setCell(0, col, "100");
        csv.setCell(1, col, "101");

        System.out.println(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");
        System.out.println("Weight Column Index = " + weightColumn);
        csv.insertColumn(weightColumn);

        System.out.println(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\"");

        System.out.println(csv.saveToString());

        // We now have:

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