Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:-
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...
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...