Zig

Update CSV File

See more CSV Examples

Demonstrates how to read a CSV, update some cells, and save.

The Chilkat CSV library/component/class is freeware. The downloads for .NET, C++, Perl, Java, Ruby, and Python contain all of the Chilkat classes, some of which are freeware and some of which require licensing.

Zig

const std = @import("std");
const chilkat = @import("chilkat");

pub fn main(init: std.process.Init) !void {
    const alloc = init.arena.allocator();

    // This example program loads a file (sample.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
    //
    // The first row contains the column names.
    // This file is available at:
    // http://www.chilkatsoft.com/testData/sample.csv

    const csv = try chilkat.Csv.init();
    defer csv.deinit();

    // Prior to loading the CSV file, indicate that the 1st row
    // should be treated as column names:
    csv.setHasColumnNames(true);

    // Load the CSV records from the file:

    csv.loadFile("sample.csv") catch {
        std.debug.print("{s}\n", .{try csv.getLastErrorText(alloc)});
        return;
    };

    // Change "cheese" to "baguette"
    // ("cheese" is at row=0, column=3
    try csv.setCell(0, 3, "baguette");

    // Change "blue" to "magenta"
    try csv.setCell(1, 1, "magenta");

    // Write the updated CSV to a string and display:
    const csv_doc = try csv.saveToString(alloc);
    std.debug.print("{s}\n", .{csv_doc});

    // Save the CSV to a file:
    csv.saveFile("out.csv") catch {
        std.debug.print("{s}\n", .{try csv.getLastErrorText(alloc)});
    };
}