Export large excel file xlsx

athenas3000

I have a report with 4800+ pages, I need to export it to excel. However, due to the volume of data I need the format to be exported is "xlsx", the component only allows exporting to "xls". How do I export to "xlsx" format?
I have the latest version of the component and I use the AllowPrintToFile and AllowPrintToArchive option set to True

nicocizik

Hi Athenas,

The latest version of ReportBuilder (21.01) fully supports exporting to the XLSX format for Delphi XE2 or later. The two formats from the export dialog are "XLSX Report" and "XLSX Data".

In code:

uses
  ppTypes;

...

Report.DeviceType := dtXlsxData;  //or dtXlsxReport