Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW

QlikView and Export to XLSX or XLS

No ratings
cancel
Showing results for 
Search instead for 
Did you mean: 
Chris_Rice
Support
Support

QlikView and Export to XLSX or XLS

Last Update:

Dec 10, 2021 6:49:18 AM

Updated By:

Sonja_Bauernfeind

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:

  1. Stop the QlikView Server Service/Close the QlikView Desktop client
  2. Locate the settings.ini file
  3. Open the file and locate the settings you wish to modify. See the table below.
  4. Save the settings.ini file.
  5. 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
Labels (1)
Contributors
Version history
Last update:
‎2021-12-10 06:49 AM
Updated by: