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