I would like to be able to export data from several tables to an excel document on several sheets, that is, a table on each excel sheet.
I am working with codeigniter 3.
My code is as follows:
window.saveFile = function saveFile () {
var opts = [{
sheetid: 'Sheet 1',
headers: false
}, {
sheetid: 'Sheet 2',
headers: false
}];
var res = alasql ('SELECT INTO XLSX ("TestExcel.xlsx",?) FROM HTML, [opts, ["# Table1", "Table2"]];
}