Posted 24 January 2018, 6:05 am EST
Hello,
The export to excel feature is not working for me correctly. Problems I have are:
-
There are a lot of columns with data in the web page; but when exported only some of them appear.
-
The column headers are not getting exported.
Version of spreadjs is gc.spread.sheets.all.10.2.0.min.js
Version of excelIO is gc.spread.excelio.10.2.0.min.js
Below is the code that I am using:
var exportToExcel = function(e){
var excelIO = new GC.Spread.Excel.IO();
var fileName = $("#AnalysisName").text() + '.xlsx';
//Get the work book
var workbook = $('#' + spreadSheetId).data('workbook');
if (workbook) {
workbook.refresh();
var json = JSON.stringify(workbook.toJSON());
excelIO.save(json, function (blob) {
saveAs(blob, fileName);
},
function (e) {
if (e.errorCode === 1) {
Scds.Framework.Messages.showError('There was an error while exporting to excel. ' + e.errorMessage);
}
});
}
};
Please help urgently. Thank you!