Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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
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
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
hi
i use Excel 2007 with Qlikview 10.
any one ever try this?
thanks,
Marco
Hi,
With what procedure you are exporting data to excel.
Regards,
Kaushik Solanki
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
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
Hi,
sorry i can't give you my application..
still confuse bout this..
Thanks,
Marco
Hi,
Its ok i understand.
Regards,
Kaushik Solanki