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 |