Lua

Read Japanese utf-8 CSV File

See more CSV Examples

Demonstrates how to read a utf-8 .csv file containing some Japanese characters. Lua

local chilkat = require("chilkat")

-- 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,"太志","森田"
--

local csv = chilkat.Csv.new()

-- Prior to loading the CSV file, indicate that the 1st row
-- should be treated as column names:
csv.has_column_names = true

-- Load the CSV records from the file.
-- Important: Make sure to call LoadFile2 so that the charset (utf-8)
-- of the CSV file can be indicated.
local success = csv:load_file2("qa_data/csv/japanese.csv", "utf-8")
if not success then
    print(csv.last_error_text)
    return
end

-- Display the contents of the 3rd column
local n = csv.num_rows
for row = 0, n - 1 do
    print(csv:get_cell(row, 2))
end