topic Send to Excel Limitation Row in QlikView

Send to Excel Limitation Row

marcohadiyanto — Tue, 21 Jun 2011 08:07:40 GMT

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

Send to Excel Limitation Row

SunilChauhan — Tue, 21 Jun 2011 08:26:36 GMT

hello macro,

Excel limitation is 65536 and beyond this excel take it into next sheet.you can try Csv file.i thing csv has more capacity than excel in one sheet.

Csv can export to only one sheet but excel can export to many sheetas

thanks

Sunil

Send to Excel Limitation Row

marcohadiyanto — Tue, 21 Jun 2011 08:34:44 GMT

Hi sunil,

excel can only 65536 row? but when i create new excel file then i copy and paste, excel can over than 65536 row.

btw my name marco, not macro.

thanks,

Marco

Send to Excel Limitation Row

kaushiknsolanki — Tue, 21 Jun 2011 08:35:28 GMT

Hi,

Its because you are using 2003 version of excel.

Excel 2007 has more storage capability. install excel 2007 and check the difference.

Regards,

Kaushik Solanki

Send to Excel Limitation Row

marcohadiyanto — Tue, 21 Jun 2011 08:38:56 GMT

i use Excel 2007 with Qlikview 10.

any one ever try this?

thanks,

Marco

Send to Excel Limitation Row

kaushiknsolanki — Tue, 21 Jun 2011 08:50:18 GMT

Hi,

With what procedure you are exporting data to excel.

Regards,

Kaushik Solanki

Send to Excel Limitation Row

marcohadiyanto — Tue, 21 Jun 2011 08:55:18 GMT

Hi,

i use qlikview 10, make straight table, and then click "Send to Excel".

after then excel comes up, my straight table become 3 sheet excel.

Thanks,

Marco

Send to Excel Limitation Row

kaushiknsolanki — Tue, 21 Jun 2011 08:59:47 GMT

Hi,

Can you please send me that application as i dont have application with that hugh data.

Let me check what happens at my side.

Regards,

Kaushik Solanki

Send to Excel Limitation Row

marcohadiyanto — Tue, 21 Jun 2011 09:31:07 GMT

Hi,

sorry i can't give you my application..

still confuse bout this..

Thanks,

Marco

Send to Excel Limitation Row

kaushiknsolanki — Tue, 21 Jun 2011 09:35:19 GMT

Hi,

Its ok i understand.

Regards,

Kaushik Solanki

Send to Excel Limitation Row

Anonymous — Wed, 22 Jun 2011 00:04:46 GMT

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.

Send to Excel Limitation Row

marcohadiyanto — Wed, 22 Jun 2011 02:48:25 GMT

Hi Jo,

thanks for u're answer...

Thanks,

Marco

Send to Excel Limitation Row

mountaindude — Thu, 24 May 2012 15:53:21 GMT

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

Send to Excel Limitation Row

Anonymous — Fri, 25 May 2012 02:17:27 GMT

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

Send to Excel Limitation Row

mountaindude — Fri, 25 May 2012 06:26:09 GMT

Great - sounds like a reason to upgrade then!

Send to Excel Limitation Row

Fri, 25 May 2012 06:33:40 GMT

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

Send to Excel Limitation Row

mountaindude — Fri, 25 May 2012 07:03:20 GMT

Ah, sweet!

Re: Send to Excel Limitation Row

Wed, 24 Oct 2012 10:52:15 GMT

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