Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Export to XLSX (Excel 2007/2010)

Is it possible to export data tables to XLSX? The standard XLS cannot cope with the large amount of records that we generate.

I understood that it was not possible from the XLS icon on tables?

Has the situation changed? Is this format available "out of the box"?

thanks

Arnaud

3 Replies
deepakk
Partner - Specialist III
Partner - Specialist III

HI ,

Try out the attach application. I couldnt try it since I dont have Office 2007 in my system.

Let me know if it works fine.

Not applicable
Author

Thanks, we will look at it tomorrow.

I will get back to you then.

Thanks again,

Arnaud

azimabadi
Creator III
Creator III

Hi Deepak,

I have used the same syntax as in your code, but when i want to open xlsx file in my excel 2010, i get an error message that file is not a valid excel file. But when i change the code and export data as xls, it works withot Error.

Do you have any idea?

Best regards

Peyman