Even i am facing an issue at my end . when I export the huge table into excel through IE it works fine and when i export the small file in ajax then also works fine but it wont work when no of rows are more than 65K. . is this a limitation in ajax or something else . can anybody suggest me on this
We also need to be able to export to the native .xlsx format from QlikView. I've tested some cases and conclude that a) this does not depend on the Excel 2007 "Save files in this format" option nor b) it is not controlled by the version of Excel running in the environment.
I have tested this both on the server and in the desktop 9.0 client. Both environments are using Excel 2007 with the default save format set to .xlsx. In both cases QlikView exports to an .xls file when using the XLS icon. When using the Export command, .xlsx isn't even an available option.
Can someone from QlikTech please weigh in on this?