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

Chilkat Java Downloads Java Libs for Windows, MacOS, Linux, Alpine Linux, Solaris Java Libs for Android

import com.chilkatsoft.*;

public class ChilkatExample {

  static {
    try {
        System.loadLibrary("chilkat");
    } catch (UnsatisfiedLinkError e) {
      System.err.println("Native code library failed to load.\n" + e);
      System.exit(1);
    }
  }

  public static void main(String argv[])
  {
    CkCsv 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.put_HasColumnNames(true);
    boolean success = 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
  }
}