Export to CSV issue.

s29124141 — Mon, 27 Nov 2017 16:33:30 GMT

Qlik Sense Version: Qlik Sense September 2017 - 11.14.3

We are getting error while opening CSV file generated from the Qlik Export.Below is the code snippet used to export the table data into excel.

var table;
table = app.createTable(transactionDimensions, null);
table.OnData.unbind(ExportToCSV);
table.exportData({ format: 'CSV_C', download: false }, function (link) {
     window.open('http' + (config.isSecure ? 's' : '') + '://' + config.host + ':' + config.port + link, '_blank');
});

Error message while opening CSV:-

Re: Export to CSV issue.

s29124141 — Mon, 27 Nov 2017 18:40:25 GMT

After little more research, its an excel issue not qlik sense issue. When the export file has first column starting with uppercase "ID", this error is thrown from excel.

Microsoft KB Reference : https://support.microsoft.com/en-us/help/323626/-sylk-file-format-is-not-valid-error-message-when-you-open-file

topic Export to CSV issue. in Integration, Extension & APIs

Export to CSV issue.

Re: Export to CSV issue.