Qlik Community

QlikView Management

Discussion Board for collaboration on QlikView Management.

Not applicable

Excel export rows limit

Hi,

I've just installed a QlikView Server 11 SR2 but I have problem exporting rows to Excel from a straight table.

I can't export more than 65535 rows and on my pc I've installed Excel 2010.

What I have to check ? Why the export functionality doesn't create more sheet on the Exel file exported ?

Thanks a lot

6 Replies
Support
Support

Re: Excel export rows limit

Hi,

Two things here.

1. 65535 is the most you will be able to export without it being a CVS file.

2. Export to excel was never designed for large amount of data.

Bill

Bill - Designated Support Engineer at Qlik
To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.
MVP & Luminary
MVP & Luminary

Re: Excel export rows limit

Hi,

You can export more than 65535 to a CSV file instead of Excel file.  Please find attached screenshot.

Help Menu-> About Qlikview -> Right mouse click on Qlikview icon -> Then reset the value for RowLimitForCSVInsteadofExcel option to your choice.

PFA screenshot for the same.

Hope this helps you.

Regards,

Jagan.

Support
Support

Re: Excel export rows limit

That is only client side. You can add this to the QVS setting.ini file to have it work server side.

Bill

Bill - Designated Support Engineer at Qlik
To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.
Not applicable

Re: Excel export rows limit

Hi,

I'm sorry but on previous versions (Qlikview Server 10) exporting to Excel generated xls file with multiple sheet, each with 65535 records.

On the new envinroment it generates just one sheet.

Have you got any idea ?

Thanks

MVP & Luminary
MVP & Luminary

Re: Excel export rows limit

Hi Bill,

could you please post this (and similar) entries for the settings.ini. Thanks.

- Marcus

Support
Support

Re: Excel export rows limit

Marcus,

Most of the setting in the easter egg can be used. However, I would check with support before you use them.

Bill

Bill - Designated Support Engineer at Qlik
To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.