Find Answers
Qlik Community
Collaborate with over 60,000 Qlik technologists and members around the world to get answers to your questions, and maximize success.
Join Us
Contact
Find Answers
Join Qlik Community
Collaborate with over 60,000 Qlik technologists and members around the world to get answers to your questions, and maximize success.
Join Us
Talk with a Representative
Critical Issues
Request assisted support for your highly complex issues.
Submit a CaseExperiencing a business critical service interruption? Click here to view phone numbers and hours by region.
Contact UsWelcome Guest
Installed Qlik Products
My Environments
Log your environments to ensure faster and more targeted troubleshooting.
View Available Licenses
My Licenses
Understand your licenses to help you maximize your experience.
- ALERT: Support Alert Click here
Knowledge
QlikView November 2017 Export to XLSX
Article Number: 000040322 | Last Modified: 2019/12/04Description
QlikView November 2017 / QlikView 12.20 features export to XLSX by default. Here are some hidden options along with that.
The options are set in the respective C:\ProgramData\QlikTech\QlikViewServer\settings.ini file for either QlikView Server or the C:\Users\<User>\AppData\Roaming\QlikTech\QlikView\Settings.ini file for Desktop client.
To modify it, you first need to stop the QlikView Server Service. (or close QlikView Desktop client)
When the Service is stopped, open the Settings.ini file in a text editor. (Notepad for example)
Environment:
The options are set in the respective C:\ProgramData\QlikTech\QlikViewServer\settings.ini file for either QlikView Server or the C:\Users\<User>\AppData\Roaming\QlikTech\QlikView\Settings.ini file for Desktop client.
To modify it, you first need to stop the QlikView Server Service. (or close QlikView Desktop client)
When the Service is stopped, open the Settings.ini file in a text editor. (Notepad for example)
Environment:
- QlikView 12.20
Resolution
| Option Name | Meaning | Default Value |
|---|---|---|
| SELOG_Export |
if print out log message related to Export function. 0: disable 1: enable | 1 |
| SendToExcelLegacyFormat |
default "Send To Excel" behavior. 1: Legacy mode, export to xls 0: new mode, export to xlsx | 0 |
| QvExportTimeLimitSec |
Time limit for exporting object to Xlsx. Integer number in seconds. Use -1 if you don't want time limit; |
Server: 180 Desktop: -1 |
| QvExportMemoryLimitMB |
Memory limit for exporting object to Xlsx. Integer number in MB. Use 0 if you don't want memory limit; | 0 |
Get Answers
Find Answers
Get Support
Have a Question?
Search Qlik's Support Knowledge database or request assisted support for highly complex issues.
Submit a case
Talk with a Representative
Critical Issues
Experiencing a serious issue, please contact us by phone. View phone numbers and hours by region.