Node.js

XLSX Get Sheet Names

Open an Excel spreadsheet (.xlsx) and get the names of the sheets. Node.js

NODEJS_PRELUDE

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

    var i = 0;
    while (i < sheetNames.Count) {
        console.log(sheetNames.StringAt(i));
        i = i+1;
    }


}

chilkatExample();