Excel exporting with excel 2010

[priyarane]

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.

[giakoum]

1,048,576 rows by 16,384 columns

[Gabriel]

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

[pokassov]

Hello!

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

At least you could export 1048576 rows.

Sergey

[priyarane]

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

Could you please suggest on this?

[priyarane]

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

Could you please suggest on this?

[giakoum]

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

[#8]

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.

[priyarane]

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

[giakoum]

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.