Qlik Community

Ask a Question

Integration, Extension & APIs

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

Announcements
QlikWorld starts MONDAY! last chance to register is now ! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
s29124141
Partner
Partner

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
Partner
Partner
Author

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

View solution in original post

1 Reply
s29124141
Partner
Partner
Author

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

View solution in original post