It should be possible to export a folder with multiple reports (from the report section) as a single XLSX file, rather than a .zip file where each report is created as a separate Excel file.
Current, but costly workaround: copy all desired reports as individual spreadsheets into one report (or pay attention to this structure when creating a new report) and export as one report after publishing under the "Reports".
a customer's need for exporting XLSX file from 2 different reports with multiple sheets in a single file. As an example, a report with five different sheets:
One sheet from the Profit and Loss report for the year 2017.
Another sheet from the Profit and Loss report for 2018.
A sheet from the Balance Sheet report for the client "10 Best Bike Seller AG."
A sheet for the client "20 Beta E-commerce LTD" from the Balance Sheet report.
And a sheet from the Balance Sheet for the client "30 Bike Trade Sari."
This is currently not possible and it can only be done by exporting XLSX files separately.