Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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 !