How to parse multiple sheets in the same xslx file?

[rivershertz]

Im using this package to create json files for translations.
The different languages content is separated into multiple sheets in the same file.
Im trying to figure out how can I iterate over the sheets and execute code for each one?

Is it possible?
Thanks a lot!

[pmartinspt]

Hey!

I am using this to export all the sheets to one unique json file.

Hope it can help!

const fs = require('fs');
var parser = new (require('simple-excel-to-json').XlsParser)();
var doc = parser.parseXls2Json('input-values.xlsx', { isNested: true });

let export_all = [];
let number_of_sheets = 5

for (let i = 0; i < number_of_sheets; i++) {
    export_all.push(doc[i]);  
  }

json=  JSON.stringify(export_all.flat())
fs.writeFile("export-all.json", json, (err) => err && console.error(err));