Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for Data Integration and Data Analytics gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

Send to Excel Limitation Row

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

1 Solution

Accepted Solutions
Highlighted
Master
Master

Send to Excel Limitation Row

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.

View solution in original post

17 Replies
Highlighted
Champion
Champion

Send to Excel Limitation Row

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

Highlighted
Partner
Partner

Send to Excel Limitation Row

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

Highlighted
MVP & Luminary
MVP & Luminary

Send to Excel Limitation Row

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

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
Highlighted
Partner
Partner

Send to Excel Limitation Row

hi

i use Excel 2007 with Qlikview 10.

any one ever try this?

thanks,

Marco

Highlighted
MVP & Luminary
MVP & Luminary

Send to Excel Limitation Row

Hi,

   With what procedure you are exporting data to excel.

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
Highlighted
Partner
Partner

Send to Excel Limitation Row

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

Highlighted
MVP & Luminary
MVP & Luminary

Send to Excel Limitation Row

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

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
Highlighted
Partner
Partner

Send to Excel Limitation Row

Hi,

     sorry i can't give you my application..

still confuse bout this..

Thanks,

Marco

Highlighted
MVP & Luminary
MVP & Luminary

Send to Excel Limitation Row

Hi,

   Its ok i understand.

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".