AutoIt

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.

AutoIt

Local $bSuccess = False

$oCsv = ObjCreate("Chilkat.Csv")

;  Load the following CSV:

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

;  Indicate that the 1st line contains column names.
$oCsv.HasColumnNames = True
$bSuccess = $oCsv.LoadFile("qa_data/csv/insertColumnTest.csv")

;  We can insert a column before the 1st column.
$oCsv.InsertColumn(0)

ConsoleWrite($oCsv.SaveToString() & @CRLF)

;  The CSV now looks like this:

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

;  Set the cells in column 0.

Local $iCol = 0
$oCsv.SetColumnName($iCol,"id")
$oCsv.SetCell(0,$iCol,"100")
$oCsv.SetCell(1,$iCol,"101")

ConsoleWrite($oCsv.SaveToString() & @CRLF)

;  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.
Local $iWeightColumn = $oCsv.GetIndex("Weight")
ConsoleWrite("Weight Column Index = " & $iWeightColumn & @CRLF)
$oCsv.InsertColumn($iWeightColumn)

ConsoleWrite($oCsv.SaveToString() & @CRLF)

;  We now have:

;   id;Name;City;;Weight
;   100;John;Chicago;;180
;   101;Lisa;Denver;;120

;  Set the cells in the new column:

$oCsv.SetColumnName($iWeightColumn,"Height")
$oCsv.SetCell(0,$iWeightColumn,"6' 2""")
$oCsv.SetCell(1,$iWeightColumn,"5' 7""")

ConsoleWrite($oCsv.SaveToString() & @CRLF)

;  We now have:

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