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) Write utf-8 CSV Compatible with ExcelSee more CSV ExamplesA CSV containing non-English characters that is saved using the utf-8 character encoding must include a BOM (also known as a preamble) if it is to be correctly loaded into Excel. See https://en.wikipedia.org/wiki/Byte_order_mark This example shows how to save the CSV to a file using utf-8 with a BOM. Note: This example requires Chilkat v9.5.0.93 or later.
#include <C_CkCsvW.h> void ChilkatSample(void) { HCkCsvW csv; BOOL success; // This example program loads a file (japanese.csv) // that contains this content: // // year,color,country,food // 2001,red,France,cheese // 2005,blue,"United States",hamburger // 2008,green,Italy,pasta // 1998,orange,Japan,sushi // 2010,silver,"","" // csv = CkCsvW_Create(); CkCsvW_putHasColumnNames(csv,TRUE); success = CkCsvW_LoadFile2(csv,L"qa_data/csv/test.csv",L"utf-8"); if (success != TRUE) { wprintf(L"%s\n",CkCsvW_lastErrorText(csv)); CkCsvW_Dispose(csv); return; } // To save the CSV using utf-8 with a BOM/preamble, // add "EMIT_BOM" to the UncommonOptions. // (This feature was added in Chilkat v9.5.0.93) CkCsvW_putUncommonOptions(csv,L"EMIT_BOM"); success = CkCsvW_SaveFile2(csv,L"qa_output/test.csv",L"utf-8"); if (success != TRUE) { wprintf(L"%s\n",CkCsvW_lastErrorText(csv)); CkCsvW_Dispose(csv); return; } wprintf(L"OK, try to load the CSV in Excel to see if the non-English chars are correct.\n"); CkCsvW_Dispose(csv); } |
© 2000-2024 Chilkat Software, Inc. All Rights Reserved.