(MFC) Create CSV File

Demonstrates how to create a new CSV file with some simple content.

Chilkat C/C++ Library Downloads MS Visual C/C++ Libs

See Also: Using MFC CString in Chilkat

#include <CkCsv.h>

void ChilkatSample(void)
    {
    CkString strOut;

    // This sample code creates a new CSV file (sample.csv)
    // that contains this content:
    // 
    // year,color,country,food
    // 2001,red,France,cheese
    // 2005,blue,"United States",hamburger

    CkCsv csv;

    // Indicate that the 1st row
    // should be treated as column names:
    csv.put_HasColumnNames(true);

    bool success = csv.SetColumnName(0,"year");
    success = csv.SetColumnName(1,"color");
    success = csv.SetColumnName(2,"country");
    success = csv.SetColumnName(3,"food");

    success = csv.SetCell(0,0,"2001");
    success = csv.SetCell(0,1,"red");
    success = csv.SetCell(0,2,"France");
    success = csv.SetCell(0,3,"cheese");

    success = csv.SetCell(1,0,"2005");
    success = csv.SetCell(1,1,"blue");
    success = csv.SetCell(1,2,"United States");
    success = csv.SetCell(1,3,"hamburger");

    // Write the CSV to a string and display:
    const char *csvDoc = 0;
    csvDoc = csv.saveToString();
    strOut.append(csvDoc);
    strOut.append("\r\n");

    // Save the CSV to a file:
    success = csv.SaveFile("out.csv");
    if (success != true) {
        strOut.append(csv.lastErrorText());
        strOut.append("\r\n");
    }



    SetDlgItemText(IDC_EDIT1,strOut.getUnicode());

    }