Excel - Exporting Multiple Tables

If a report contains multiple tables, they can be exported into the same or different worksheets in a single Excel file.

By default, all tables in a report definition will be exported into the same Excel worksheet during an export operation. However, you can instead include tables selectively by entering them as a comma-separated list in the Export Data Table ID attribute of the Target.Native Excel element. For example, the configuration shown above will only export two of the report's three tables to Excel.

By adding Excel Sheet Break elements in the Body of your report definition, as shown above, you can cause multiple tables to be sent to separate worksheets. The order of the tables in the report definition dictates the order of the worksheets containing them in the export.