topic Export to XLSX (Excel 2007/2010) in QlikView

Export to XLSX (Excel 2007/2010)

Sat, 13 Nov 2010 22:23:10 GMT

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

Export to XLSX (Excel 2007/2010)

deepakk — Sun, 14 Nov 2010 07:35:12 GMT

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.

Export to XLSX (Excel 2007/2010)

Mon, 15 Nov 2010 16:55:23 GMT

Thanks, we will look at it tomorrow.

I will get back to you then.

Thanks again,

Arnaud

Re: Export to XLSX (Excel 2007/2010)

azimabadi — Wed, 05 Sep 2012 10:25:17 GMT

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