Lua

Create CSV File

See more CSV Examples

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

local chilkat = require("chilkat")

-- 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

local csv = chilkat.Csv.new()

-- Indicate that the 1st row
-- should be treated as column names:
csv.has_column_names = true

local success = csv:set_column_name(0, "year")
success = csv:set_column_name(1, "color")
success = csv:set_column_name(2, "country")
success = csv:set_column_name(3, "food")

success = csv:set_cell(0, 0, "2001")
success = csv:set_cell(0, 1, "red")
success = csv:set_cell(0, 2, "France")
success = csv:set_cell(0, 3, "cheese")

success = csv:set_cell(1, 0, "2005")
success = csv:set_cell(1, 1, "blue")
success = csv:set_cell(1, 2, "United States")
success = csv:set_cell(1, 3, "hamburger")

-- Write the CSV to a string and display:
local csvDoc = csv:save_to_string()
print(csvDoc)

-- Save the CSV to a file:
success = csv:save_file("out.csv")
if not success then
    print(csv.last_error_text)
end