Qlik Community

Qlik Sense Integration, Extensions, & APIs

Discussion board where members can learn more about Integration, Extensions and API’s for Qlik Sense.

s29124141
Contributor II

Export to CSV issue.

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

Export_Issue.JPG

1 Solution

Accepted Solutions
s29124141
Contributor II

Re: Export to CSV issue.

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

1 Reply
s29124141
Contributor II

Re: Export to CSV issue.

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

Community Browser