Send to Excel Limitation Row

[marcohadiyanto]

Hi all,

i want to ask, is there any limitation in qlikview when we want use "Send to Excel" function?

need for explanation..

i already try but only 65536 row and then change sheet. can i get only one sheet?

Regards,

Marco

[Anonymous · Accepted solution]

Marco,

When exporting to Excel from QV the data will get split across sheets every 65536 rows even though you use a newer version of Excel that can handle more.

The reason for this implementation is backwards compatibility.

Excel used to have a limit for 65536 rows with their old BIFF format, before moving over to OOXML and support for more rows.

In order to support the older versions, QV exports a maximum of 65536 rows to each sheet when you do a Send to Excel.

[marcohadiyanto]

Hi Jo,

thanks for u're answer...

Thanks,

Marco

[mountaindude]

Reviving this old thread...

Johannes, do you know if that limitation is still in place for QV11?

If so it's kind of disturbing... Backwards compatibility is always nice, but it feels REALLY outdated these days to have such a limitation in place, considering it's been quite a few years since Excel itself got the more-than-64k-rows capability.

Thx,

Göran

[Anonymous]

Hej Goran,

Not sure how it's implemented in v11 with regards to backwards compatibility but I ran a quick test and exported 100K+ rows to Excel that all went to one sheet so it seems to ork the way you wish these days.

Cheers,

Johannes

[mountaindude]

Great - sounds like a reason to upgrade then!

[#7]

In QlikView 11, it export to CSV instead of XLS.

[mountaindude]

Ah, sweet!

[#9]

Does anyone know why I am unable to Export to Excel from a table object using IE9, Chrome or any other popular browser? Works on on IE8, and we can exort from pivot tables using IE9/Chrome/etc.

Best,

Rich