Paginated report export to Excel timeout

[AbcFitness]

We have this odd error that happens whe exporting over 85k rows to excel in the service.

Can you please help?

Thanks,

Jaouad

[Anonymous]

Hi @AbcFitness ,

 

Microsoft Excel places limitations on exported reports due to the capabilities of Excel and its file formats. The most significant are the following，please check if you have met them:

• The maximum column width is limited to 255 characters or 1726.5 points. The renderer does not verify that the column width is less than the limit.

• The maximum number of characters in a cell is limited to 32,767. If this is exceeded, the renderer displays an error message.

• The maximum row height is 409 points. If the contents of the row cause the row height to increase beyond 409 points, the Excel cell shows a partial amount of text up to 409 points. The rest of the cell contents is still within the cell (up to Excel's max number of characters of 32,767).

• Because the maximum row height is 409 points, if the defined height of the cell in the report is something larger than 409 points, Excel splits the cell contents into multiple rows.

• The maximum number of worksheets is not defined in Excel, but external factors, such as memory and disk space, might causes limitations to be applied.

• In outlines, Excel permits up to seven nested levels only.

• If the report item that controls whether another item is toggled is not in the previous or next row or column of the item being toggled, the outline is disabled also.

For more details about Excel limitations, see Excel specifications 

Best regards.
Community Support Team_ Caitlyn