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
(Unicode C) 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.
#include <C_CkCsvW.h> void ChilkatSample(void) { HCkCsvW csv; BOOL success; int col; int weightColumn; csv = CkCsvW_Create(); // Load the following CSV: // Name;City;Weight // John;Chicago;180 // Lisa;Denver;120 // Indicate that the 1st line contains column names. CkCsvW_putHasColumnNames(csv,TRUE); success = CkCsvW_LoadFile(csv,L"qa_data/csv/insertColumnTest.csv"); // We can insert a column before the 1st column. CkCsvW_InsertColumn(csv,0); wprintf(L"%s\n",CkCsvW_saveToString(csv)); // The CSV now looks like this: // ;Name;City;Weight // ;John;Chicago;180 // ;Lisa;Denver;120 // Set the cells in column 0. col = 0; CkCsvW_SetColumnName(csv,col,L"id"); CkCsvW_SetCell(csv,0,col,L"100"); CkCsvW_SetCell(csv,1,col,L"101"); wprintf(L"%s\n",CkCsvW_saveToString(csv)); // 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 = CkCsvW_GetIndex(csv,L"Weight"); wprintf(L"Weight Column Index = %d\n",weightColumn); CkCsvW_InsertColumn(csv,weightColumn); wprintf(L"%s\n",CkCsvW_saveToString(csv)); // We now have: // id;Name;City;;Weight // 100;John;Chicago;;180 // 101;Lisa;Denver;;120 // Set the cells in the new column: CkCsvW_SetColumnName(csv,weightColumn,L"Height"); CkCsvW_SetCell(csv,0,weightColumn,L"6' 2\""); CkCsvW_SetCell(csv,1,weightColumn,L"5' 7\""); wprintf(L"%s\n",CkCsvW_saveToString(csv)); // We now have: // id;Name;City;Height;Weight // 100;John;Chicago;"6' 2""";180 // 101;Lisa;Denver;"5' 7""";120 CkCsvW_Dispose(csv); } |
© 2000-2024 Chilkat Software, Inc. All Rights Reserved.