Chilkat HOME .NET Core C# Android™ AutoIt C C# C++ Chilkat2-Python CkPython Classic ASP DataFlex Delphi ActiveX Delphi DLL Go Java Lianja Mono C# Node.js Objective-C PHP ActiveX PHP Extension Perl PowerBuilder PowerShell PureBasic Ruby SQL Server Swift 2 Swift 3,4,5... Tcl Unicode C Unicode C++ VB.NET VBScript Visual Basic 6.0 Visual FoxPro Xojo Plugin
(Swift 2) CSV Insert ColumnSee more CSV ExamplesInsert 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.
func chilkatTest() { let csv = CkoCsv() // Load the following CSV: // Name;City;Weight // John;Chicago;180 // Lisa;Denver;120 // Indicate that the 1st line contains column names. csv.HasColumnNames = true var success: Bool = csv.LoadFile("qa_data/csv/insertColumnTest.csv") // We can insert a column before the 1st column. csv.InsertColumn(0) print("\(csv.SaveToString())") // The CSV now looks like this: // ;Name;City;Weight // ;John;Chicago;180 // ;Lisa;Denver;120 // Set the cells in column 0. var col: Int = 0 csv.SetColumnName(col, columnName: "id") csv.SetCell(0, col: col, content: "100") csv.SetCell(1, col: col, content: "101") print("\(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. var weightColumn: Int = csv.GetIndex("Weight").intValue print("Weight Column Index = \(weightColumn)") csv.InsertColumn(weightColumn) print("\(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, columnName: "Height") csv.SetCell(0, col: weightColumn, content: "6' 2\"") csv.SetCell(1, col: weightColumn, content: "5' 7\"") print("\(csv.SaveToString())") // We now have: // id;Name;City;Height;Weight // 100;John;Chicago;"6' 2""";180 // 101;Lisa;Denver;"5' 7""";120 } |
© 2000-2024 Chilkat Software, Inc. All Rights Reserved.