Exporting High-Volume Data Reports to Excel (Row-based Engine Enabled)

When you export high-volume data reports on PCs, two scenarios may occur: successful export with data displayed in multiple sheets, and failed export with invalid Excel content. Why do these issues occur?

Note:

The data to be exported should not exceed 10 million rows by 20 columns, because when the volume of data to be exported is extremely high, only a portion of the data may be exported.

Without the row-based engine enabled, two results are possible: successful export within the server's capacity, or failed export beyond the server's capacity. The scenarios and export results are shown below:

Within the Server's Capacity

The data volume is high; the number of records in a report exceeds Excel's maximum row limit, but the number is not extremely large (for example, 100,000 records), with a simple data structure. In this scenario, the report can be successfully exported to Excel when the server has sufficient memory and a stable network connection.

Export result

Data that exceeds Excel’s maximum row or column limit will be displayed in the next sheet.

Note:

Excel has maximum row or column limits (e.g., Excel2003 supports a maximum of 65,536 rows and 256 columns).

Beyond the Server's Capacity

The data volume is extremely high (for example, hundreds of thousands or millions of records). In this scenario, export may fail due to memory limitations.

Export result

The content of the Excel file exported from the report is invalid.

Reasons for the Two Export Results

The key factors are data volume and complexity (column count). Without the row-based engine enabled, there's a maximum threshold for export: When the data volume is below the threshold, the report can be exported successfully as an Excel file with multiple sheets; otherwise, the content of the Excel file exported from the report is invalid.

High-volume data reports are often displayed with the row-based engine enabled. These reports can always be successfully exported to Excel.

During the process of exporting a high-volume data report with the row-based engine enabled to Excel, the report is split into multiple XLS files and delivered as a compressed package to the client.

The maximum row limit for a single Excel file is as follows:

The maximum number of rows in a single Excel file must be an integer multiple of the value set for Number of Rows Displayed Per Page under Pagination Preview Setting.

The maximum number of rows in a single Excel file must not exceed 65,536, which is the maximum row limit for Excel files in the XLS format.