(Node.js) XLSX Convert Sheet to CSV

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

Note: This example requires Chilkat v11.3.0 or greater.

Install Chilkat for Node.js and Electron using npm at Chilkat npm packages for Node.js Chilkat npm packages for Electron on Windows, Linux, MacOS

var os = require('os');
if (os.platform() == 'win32') {  
  var chilkat = require('@chilkat/ck-node23-win64'); 
} else if (os.platform() == 'linux') {
    if (os.arch() == 'arm') {
        var chilkat = require('@chilkat/ck-node23-linux-arm');
    } else if (os.arch() == 'arm64') {
        var chilkat = require('@chilkat/ck-node23-linux-arm64');
    } else {
        var chilkat = require('@chilkat/ck-node23-linux-x64');
    }
} else if (os.platform() == 'darwin') {
  var chilkat = require('@chilkat/ck-node23-mac-universal');
}

function chilkatExample() {

    var success = false;

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

    // .xlsx files are Zip archives
    var zip = new chilkat.Zip();
    success = zip.OpenZip("qa_data/excel/fakeCompanies.xlsx");
    if (success == false) {
        console.log(zip.LastErrorText);
        return;
    }

    var csv = new chilkat.Csv();
    var sheetNames = new chilkat.StringTable();
    success = csv.XlsxGetSheets(zip,sheetNames);
    if (success == false) {
        console.log(csv.LastErrorText);
        return;
    }

    if (sheetNames.Count == 0) {
        console.log("There are no sheets in the .xlsx");
        return;
    }

    // Get the name of the 1st sheet.
    var sheetName = sheetNames.StringAt(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.XlsxLoadSheet(zip,sheetName);
    if (success == false) {
        console.log(zip.LastErrorText);
        return;
    }

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

    var csvStr = csv.SaveToString();
    console.log(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.SaveFile2("c:/temp/qa_output/fakeCompanies.csv","utf-8");
    if (success == false) {
        console.log(csv.LastErrorText);
        return;
    }


}

chilkatExample();