topic Export Huge table in Excel in QlikView

Export Huge table in Excel

Mon, 26 Jan 2026 18:19:17 GMT

Dear All,

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

Regards

Himanshu

Export Huge table in Excel

suniljain — Thu, 27 Jan 2011 11:07:28 GMT

There is no such limitation.

Export Huge table in Excel

bismart — Thu, 27 Jan 2011 11:16:15 GMT

Limitation is with Excel, by the sounds of it

Check out

http://excel.tips.net/Pages/T002533_Importing_Huge_Data_Files.html

Export Huge table in Excel

suniljain — Thu, 27 Jan 2011 12:55:18 GMT

I am talking about Excel 2007

Export Huge table in Excel

Thu, 27 Jan 2011 18:28:08 GMT

The problem seems to be that QV exports in xls format rather than xlsx format.. so it drops rows..

Export Huge table in Excel

suniljain — Fri, 28 Jan 2011 08:07:05 GMT

QV export in XLS or XLSX . it is totally depends on MS Office version you intalled on QV Server.

if it is below 2007 then it will export in XLS otherwise in XLSX.

Export Huge table in Excel

etay_netintent — Sun, 03 Apr 2011 15:35:08 GMT

Hello

I Just attempted to "Send to excel" in an Excel2007 enviroment.

Got a xls file...

Etay Elazar

Export Huge table in Excel

jcarpenter9 — Fri, 27 May 2011 15:45:20 GMT

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?

James

Export Huge table in Excel

Wed, 15 Jun 2011 14:50:16 GMT

you can see this post

http://community.qlik.com/message/89681#89681

bye

Export Huge table in Excel

jcarpenter9 — Thu, 14 Jul 2011 13:29:03 GMT

Sorry, the example application in that post doesn't work either. It simply changes the output file extension to .XLS, but the output file is still BIFF, the same as a .XLS file.

QlikView script can READ a .XLSX file; I need for it to WRITE a file in that format.