(PHP Extension) 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 PHP Downloads PHP Extension for Windows, Linux, MacOS, Alpine Linux, Solaris

<?php

// The version number (9_5_0) should match version of the Chilkat extension used, omitting the micro-version number.
// For example, if using Chilkat v9.5.0.48, then include as shown here:
include("chilkat_9_5_0.php");

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

print $csv->saveToString() . "\n";

// The CSV now looks like this:

//  ;Name;City;Weight
//  ;John;Chicago;180
//  ;Lisa;Denver;120

// Set the cells in column 0.

$col = 0;
$csv->SetColumnName($col,'id');
$csv->SetCell(0,$col,'100');
$csv->SetCell(1,$col,'101');

print $csv->saveToString() . "\n";

// 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.
$weightColumn = $csv->GetIndex('Weight');
print 'Weight Column Index = ' . $weightColumn . "\n";
$csv->InsertColumn($weightColumn);

print $csv->saveToString() . "\n";

// 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\'');

print $csv->saveToString() . "\n";

// We now have:

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

?>