topic Re: Excel exporting with excel 2010 in QlikView

Excel exporting with excel 2010

priyarane — Mon, 06 Apr 2015 13:14:19 GMT

Hi Experts,

How many columns and rows can be export from Table box to Excel 2010.

Beforethey used some old version of Excel so they could export 256 columns now they have upgraded to Excel 2010 then is there any limitations for the Excel 2010.

Re: Excel exporting with excel 2010

giakoum — Mon, 06 Apr 2015 13:19:32 GMT

1,048,576 rows by 16,384 columns

Re: Excel exporting with excel 2010

Gabriel — Mon, 06 Apr 2015 13:27:15 GMT

Hi,

Both QlikView and Excel 2010 will have performance issue displaying 1 million rows and 16,384 column.

It is advice to limit the number of rows and column in QlikView.

Here is the article for Excel performance

Re: Excel exporting with excel 2010

pokassov — Mon, 06 Apr 2015 13:34:32 GMT

Hello!

You have the limit only with excel's dimensions of rows and columns, I think.

At least you could export 1048576 rows.

Sergey

Re: Excel exporting with excel 2010

priyarane — Mon, 06 Apr 2015 14:10:45 GMT

But still not able to export all the columns, need to do any configuration at excel or QV.

Could you please suggest on this?

Re: Excel exporting with excel 2010

priyarane — Mon, 06 Apr 2015 14:11:16 GMT

But still not able to export all the columns, need to do any configuration at excel or QV.

Could you please suggest on this?

Re: Excel exporting with excel 2010

giakoum — Mon, 06 Apr 2015 14:40:51 GMT

You have excel 2010 installed, but I think QV is using its own excel engine to export which is a prior to 2010 edition.

Not very sure about this, please double check it

Re: Excel exporting with excel 2010

Mon, 06 Apr 2015 14:48:23 GMT

Qlikview supports 97-2003 format which is .xls. This format only supports sheets with maximum of 65 536 rows and 256 columns. Tables larger than this limitation should be exported to Excel as comma separated (.CSV) text files instead, to get around the file format limitation.

Re: Excel exporting with excel 2010

priyarane — Mon, 06 Apr 2015 14:54:58 GMT

Thanks Ioannis,

so is there any way to check which Excel engine its using and is there any way to change it to updated version or any other way to over come this issue

Re: Excel exporting with excel 2010

giakoum — Mon, 06 Apr 2015 14:57:38 GMT

I don't think so.

You can use a macro to export to excel but i don't advise you to do so.

Export it as a text file and then open it with excel.

Re: Excel exporting with excel 2010

priyarane — Mon, 06 Apr 2015 15:05:44 GMT

Yeah, thats good idea. But users are looking direct export from QV to Excel. they are upgraded excel to 2010 for this reason only

Re: Excel exporting with excel 2010

giakoum — Mon, 06 Apr 2015 15:09:43 GMT

that is unfortunate