topic Export to excel Error... in QlikView

Export to excel Error...

Mon, 07 Nov 2011 16:26:21 GMT

Hi All,

When i try to export more than 100,000 rows to excel using IE-Plugin it works fine for me.

But with Ajax i am able to export only 65,000. When i try to export more thank this number i get the fallowing error(Please find Attachment)

Any help on this would be Appreciated.

Thanks

Export to excel Error...

erichshiino — Fri, 11 Nov 2011 20:37:03 GMT

HI, Ganesh.

Do you get the error when you click on the XL icon or when you use a right click on the object and select export?

Maybe one of them can be an alternative for you.

I suggest you report this as a bug to QlikTech

Regards,

Erich

Export to excel Error...

Mon, 14 Nov 2011 15:44:59 GMT

Hi Erich,

i get this error when the do both actions, when i click on the excel icon and when i right click and select export.

This occurs only with Ajax-Client.

Export to excel Error...

vgutkovsky — Mon, 14 Nov 2011 18:26:39 GMT

The problem is that, as far as I know, in AJAX mode there is no way to tell QV to Send-To-Excel in XLSX format. It will always send to .XLS, which has a logical limit of 64K rows. Bummer Maybe QV Support knows of a way around this restriction, I'm not sure...

Vlad