topic Re: Excel export rows limit in QlikView

Excel export rows limit

Mon, 26 Jan 2026 18:19:17 GMT

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

Bill_Britt — Tue, 16 Jul 2013 19:03:54 GMT

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

jagan — Tue, 16 Jul 2013 19:26:45 GMT

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.

Bill_Britt — Tue, 16 Jul 2013 20:16:31 GMT

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

Bill

Wed, 17 Jul 2013 09:22:50 GMT

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

marcus_sommer — Wed, 17 Jul 2013 11:53:23 GMT

Hi Bill,

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

- Marcus

Bill_Britt — Wed, 17 Jul 2013 19:38:17 GMT

Marcus,

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

Bill