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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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

1 Solution

Accepted Solutions
Clever_Anjos
Employee
Employee

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

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
Employee
Employee

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 !