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.

Java

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[])
  {
    boolean success = false;

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