Skip to main content Skip to complementary content

ExportData method

Exports the data of any generic object to an Excel file or a open XML file. If the object contains excluded values, those excluded values are not exported. This API has limited functionality and will not support CSV export from all types of objects. Consider using Excel export instead. Treemap and bar chart are not supported.

Information note

ExportData method is not supported in SaaS Editions of Qlik Sense.

Default limitations in number of rows and columns

The default maximum number of rows and columns in the Excel export file is:

  • 1048566 rows per sheet. For pivot tables: 1048566 column dimensions. 10 rows can be added after the export.
  • 16384 columns per sheet. If the number of columns exceeds the limit, the exported file is truncated and a warning message is sent.

Default limitation in number of columns

The default maximum number of columns in the export file is:

  • 1000 to export to a CSV file

The exported file is truncated if the number of cells exceeds the limit. A warning message with code 1000 is sent.

Information note

There is an option to export only the possible values ( qExportState is P).

Default limitation in size

If the exported file is larger than the maximum value, then an out-of-memory error with code 13000 is returned.

Information note

Exported files are temporary and are available only for a certain time span and only to the user who created them.

Parameters

Name Description Mandatory Type
qFileType

Type of the file to export.

One of:

  • CSV_C or EXPORT_CSV_C
  • CSV_T or EXPORT_CSV_T
  • OOXML or EXPORT_OOXML
  • PARQUET or EXPORT_PARQUET
Yes String
qPath

Path to the definition of the object to be exported. For example, /qHyperCubeDef . This parameter is mandatory if the file type is CSV_C or CSV_T .

No String
qFileName

Name of the exported file after download from browser. This parameter is optional and only used in Qlik Sense Desktop.

No String
qExportState

Defines the values to be exported. The default value is A.

One of:

  • P or EXPORT_POSSIBLE
  • A or EXPORT_ALL
No String
qServeOnce

If the exported file should be served only once This parameter is optional and only used in Qlik Sense Enterprise (Windows) Default value: false

No Boolean

Returns

Name Description Type
qUrl

<url of the exported file>

String
qWarnings

[1000] Maximum number of cells in exported file exceeded. Data has been truncated.

Array of Integer

Access Control

exportdata

See also

Export the data of a generic object

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!