I've been attempting to retrieve data from multiple sheets in an Excel file using a single promise statement, but I keep getting the data only from the first sheet. Any help is appreciated. Thank you.
alasql.promise('select * from xls("raw/food.xls",[{sheetid:"Data"}, {sheetid:"Guideline"}])')
.then(function (data) {
console.log(data);
}).catch(function (err) {
console.log('Error:', err);
});
Is there a way to fetch data from both sheets using just one promise statement?