Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
romain_bourdon
Contributor II
Contributor II

Excel/CSV export table

Hello,

Do you know why a table export switch automatically from XLS to CSV ? It seems to be related to the number of lines exported ...

Thanks

Labels (1)
1 Solution

Accepted Solutions
Clever_Anjos
Support
Support

You can set this limit using an Eastern Egg

Help / About

Right clik on Qlik logo on bottom left

Search for RowLimitForCsvInsteadOfXls 

http://www.clever.com.br/?p=98

View solution in original post

5 Replies
ecolomer
Master II
Master II

Yes, format csv don't have limit in lines number

avinashelite
MVP
MVP

Yes, if you have more number of line than the excel limit , it will automatically switch from excel to csv.

sudeepkm
Specialist III
Specialist III

65499 records I think beyond this point the export will be automatically set to CSV.

Clever_Anjos
Support
Support

You can set this limit using an Eastern Egg

Help / About

Right clik on Qlik logo on bottom left

Search for RowLimitForCsvInsteadOfXls 

http://www.clever.com.br/?p=98

romain_bourdon
Contributor II
Contributor II
Author

Thanks !