topic Re: Export to Excel limitation from a table in QlikView

Export to Excel limitation from a table

kkkumar82 — Thu, 30 Jul 2015 07:11:25 GMT

Hi Qlikers,

I know that there is a limitation in the number of rows when we are exporting to Excel, I just want to confirm whether it is solved in any of the recent releases.

I actually want from a straight table and pivot table title icon not from macros.

How ever is this problem can be solved using macros

Thanks

Kiran Kumar

Re: Export to Excel limitation from a table

pokassov — Thu, 30 Jul 2015 07:22:32 GMT

Hello!

1. Help->About QlikView->right mouse on icon->

RowLimitForCsvInsteadOfXls

and change limit.

I think you can do it in macros also

Re: Export to Excel limitation from a table

kkkumar82 — Thu, 30 Jul 2015 09:41:49 GMT

Thanks Pokasov I found this suggestion earlier but it didn't help me, after 65K records the file is converted to CSV and it is taking much time to convert it.

Thanks

Kiran Kumar

Re: Export to Excel limitation from a table

awhitfield — Thu, 30 Jul 2015 11:52:39 GMT

Hi Kiran,

can you not just open the resultant .csv in a later version of excel?

Andy

Re: Export to Excel limitation from a table

kkkumar82 — Thu, 30 Jul 2015 12:29:55 GMT

Thanks for your idea, infact the exporting into csv is taking longer time, that it is a mash up application.

Thanks

Kiran Kumar