Excel¶

The Excel export creates an XLS or XLSX file, depending on which ‘Excel version’ you choose. The default is XLS (Excel 2003).

All data can be put on a single worksheet or one sheet can be created for each page. Note that Excel versions before 2010 have a maximum of 65,536 rows per worksheet.

By default, the program attempts to export the file into a format that visually corresponds to the original report (more or less). It uses the rows and columns of Excel as a drawing grid, which you can manipulate by changing the ‘Column width’ setting. Exporting the report without any alignments and markup can be done by selecting the ‘Export data only’ checkbox.

The exported data by default uses the formatting applied to the objects in the report. This confuses Excel as it does not know if it is a number or a date, etc. When the export is meant to be used for further operations, such as calculations, the checkbox 'Export data using native Excel datatypes' can be selected. Currently, this is only used for numeric (currency) values and not for dates and strings.

In contrast to the CSV format, Excel files have a lot of styling options, which makes report sections identifiable. Therefore, by default, they are included in the export. If that is not desired, the checkboxes can be deselected.

Excel has a number of limitations, which means that your report may not export in full to Excel due to these limitations. For more information on limitations, refer to Microsoft’s documentation: Excel limitations.