Qlik Community

Knowledge

Search or browse our knowledge base to find answers to your questions ranging from account questions to troubleshooting error messages. The content is curated and updated by our global Support team

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.

QlikView and Export to XLSX or XLS

Chris_Rice
Support
Support

QlikView and Export to XLSX or XLS

XLSX is the default export format used by QlikView (since November 2017).

The format can be switched and logging of exports enabled or disabled in the settings.ini file. 

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)
Version history
Revision #:
2 of 2
Last update:
‎2021-05-20 08:14 AM
Updated by:
 
Contributors