Lua Requires Chilkat v11.3.0+

XLSX Convert Sheet to CSV

Open an Excel spreadsheet (.xlsx) and loads a sheet into a CSV object. Lua

local chilkat = require("chilkat")

-- This example assumes the Chilkat API to have been previously unlocked.
-- See Global Unlock Sample for sample code.

-- .xlsx files are Zip archives
local zip = chilkat.Zip.new()
local success = zip:open_zip("qa_data/excel/fakeCompanies.xlsx")
if not success then
    print(zip.last_error_text)
    return
end

local csv = chilkat.Csv.new()
local sheetNames = chilkat.StringTable.new()
success = csv:xlsx_get_sheets(zip, sheetNames)
if not success then
    print(csv.last_error_text)
    return
end

if sheetNames.count == 0 then
    print("There are no sheets in the .xlsx")
    return
end

-- Get the name of the 1st sheet.
local sheetName = sheetNames:string_at(0)

-- Load the 1st sheet into the CSV.
-- We could've also loaded the 1st sheet by passing an empty string for the sheet name.
success = csv:xlsx_load_sheet(zip, sheetName)
if not success then
    print(zip.last_error_text)
    return
end

-- The Chilkat CSV API can now be used to read, modify, or insert cells.
-- ...
-- ...

local csvStr = csv:save_to_string()
print(csvStr)

-- Sample output:
-- CompanyName,Address,City,State,Zip,Phone
-- Acme Innovations LLC,7428 Westbrook Blvd,Oak Bend,IL,60514,630-555-2398
-- BlueHorizon Data Systems,1850 Crestline Park Suite 210,Rivergate,CA,92814,714-555-8821
-- Pinnacle Manufacturing Corp,3912 Industrial Loop,Maple Ridge,TX,77301,281-555-4477
-- Evergreen Analytics Inc,1250 Highland Terrace,Stonefield,WA,98290,425-555-9914
-- NovaTech Solutions Group,578 Marketview Drive,Clearwater,FL,33760,727-555-6032

-- Save to a .csv file.
success = csv:save_file2("c:/temp/qa_output/fakeCompanies.csv", "utf-8")
if not success then
    print(csv.last_error_text)
    return
end