topic Excel 2010 export - capping at 65K and should not in QlikView

Excel 2010 export - capping at 65K and should not

Thu, 24 Feb 2011 19:49:35 GMT

Excel 2010 is installed on a Windows Server 2010 R2 operating system. We are using QlikView 10.0 for 64bit.

The problem is that when one clicks on the "send to excel" icon at the top of a Qlikview pivot table report, the resulting excel output file is capping the data at 65536 records, when in fact there are many more records than that. My understanding is that Excel 2010 should allow 1,048,576 rows and 16,384 columns.

Please advise.

Thanks,

Stephanie Lind

Excel 2010 export - capping at 65K and should not

isaiah82 — Thu, 24 Feb 2011 19:55:39 GMT

Hi Stephanie > I believe the export format from QlikView is the 97 -2003 format (note the .xls extension) and hence the 65k limit. These must take forever to export! -Isaiah

Excel 2010 export - capping at 65K and should not

Thu, 24 Feb 2011 21:27:03 GMT

Thank you, Isaiah!!! That makes sense 🙂

Anywhere this may be documented, as I would like to send to my customer?

Stephanie

Excel 2010 export - capping at 65K and should not

isaiah82 — Thu, 24 Feb 2011 21:39:54 GMT

Haha not to the best of my knowledge. This is pretty standard for apps to export in this format. One alternative may be to export out as a .CSV or similar (usually .csv is associated with Excel) and that may get around this (right-click on the chart header and click Export..or you could set up a button.)

I did check the APIGuide seeing if there was an option to export in the 2010 (ooxml) format but I don't believe that's the case. I would imagine it will be before long though..

-Isaiah

Re: Excel 2010 export - capping at 65K and should not

Tue, 12 Mar 2013 15:07:13 GMT

Hi Stephanie!

On the server, go to help, about QlikView. Right click the icon in the lower left corner. Navigate to RowLimitForCsvInsteadOfXls. Change the value in the box and click set. This will change the QlikView.ini file on the server and apply to all QlikView applications.

Cheers!

Larry Travnicek

Re: Excel 2010 export - capping at 65K and should not

Tue, 12 Mar 2013 16:56:20 GMT

Hi!

I did not find this window!

by Rebeca

Re: Excel 2010 export - capping at 65K and should not

Tue, 12 Mar 2013 18:16:50 GMT

Help, about, right click the logo

Re: Excel 2010 export - capping at 65K and should not

Tue, 12 Mar 2013 18:32:18 GMT

Thanks!

Re: Excel 2010 export - capping at 65K and should not

Mon, 21 Apr 2014 06:43:00 GMT

I'm trying but it's not work..any suggest so it can automatic create another sheet?

thanks

Re: Re: Excel 2010 export - capping at 65K and should not

ashfaq_haseeb — Mon, 21 Apr 2014 07:03:44 GMT

Hi,

Hi Open QlikView Desktop on your server, Click on help menu and select about Qlikview Option.

Right click on the ikon show in picture.

Regards

ASHFAQ

Re: Excel 2010 export - capping at 65K and should not

Mon, 21 Apr 2014 07:06:36 GMT

uppss..yes i'm sorry..it works..but how about export into xls in the qlikview server?

can we put the same cinfiguration there?

thx

Re: Excel 2010 export - capping at 65K and should not

Mon, 21 Apr 2014 07:12:09 GMT

i put same config in the server and it works..yipikaye..

Re: Excel 2010 export - capping at 65K and should not

ashfaq_haseeb — Mon, 21 Apr 2014 07:24:43 GMT

Hi,

If it answer your question,

Then I would suggest you to mark this question as answered.

As it might help others to find the relevant answers.

Regards

ASHFAQ

Re: Excel 2010 export - capping at 65K and should not

Mon, 21 Apr 2014 07:29:18 GMT

i'm sorry but this is not my question..so i cannot mark as an answer..

thx

Re: Excel 2010 export - capping at 65K and should not

pibarguren — Mon, 12 Feb 2018 18:54:00 GMT

Hi Ano Milo,

Where in the qmc did you configurate this so it applies to publish apps?

Pamela