.png)
Former Employee
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
QlikView and Export to XLSX or XLS
Last Update:
Dec 10, 2021 6:49:18 AM
Updated By:
Created date:
Oct 9, 2017 7:26:58 AM
XLSX is the default export format used by QlikView.
The format can be switched and logging of exports enabled or disabled in the settings.ini file.
Note: This feature is not available in the out-of-support version 11.00 or 11.20.
The options are set in the respective
- C:\ProgramData\QlikTech\QlikViewServer\settings.ini file for either QlikView Server
- C:\Users\<User>\AppData\Roaming\QlikTech\QlikView\Settings.ini file for Desktop client.
To modify:
- Stop the QlikView Server Service/Close the QlikView Desktop client
- Locate the settings.ini file
- Open the file and locate the settings you wish to modify. See the table below.
- Save the settings.ini file.
- Restart the Server or Desktop client
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 |
7,320 Views