Export to CSV issue.

[s29124141]

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:-

[s29124141 · Accepted solution]

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-yo...