0

I am trying to export data to excel .using alasql

but i am getting [object object] in excel sheet .

    var sql = 'SELECT INTO XLSX("' + dashboardName + '.xlsx",?) FROM ?';
    var res = alasql(sql, [sheetNames, exportData]);
Raj Dugar
  • 13
  • 2
  • can you share the format of your data? – Muhammad Kamran Oct 01 '20 at 07:58
  • var data1 = [{a:1,b:10},{a:2,b:20}]; var data2 = [{a:100,b:10},{a:200,b:20}]; var exportData = [data1,data2]; @MuhammadKamran this is the format of data, can you help – Vinita Oct 07 '20 at 13:40
  • I had added the same question https://stackoverflow.com/questions/64212306/alasql-excel-from-json-styling-in-multiple-sheets with all data and outputs can you please check – Vinita Oct 07 '20 at 13:41

0 Answers0