How to export data to multiple Excel worksheets

Environment

Product	Progress® Telerik® Reporting
Product Version	12.0 18.227

Important

We issued this article before introducing the SplitWorksheetOnPageBreak Excel device info setting, allowing to split the resulting document into sheets based on the applied soft page breaks. See:

• Progress® Telerik® Reporting R2 2022 SP1 (16.1.22.622)
• Excel 2007 Device Information Settings
• Excel 2003 Device Information Settings
• Understanding Pagination

You can still apply the approach described in the current article if it better suits your scenario.

Description

Telerik Reporting Excel rendering extension exports a report into a single worksheet in Excel workbook. How to export report content to multiple worksheets.

Solution

To export the data into multiple worksheets, add several reports to a ReportBook. Each report in a ReportBook will occupy a separate worksheet in Excel workbook.

ReportBook can be created programmatically or using Standalone report designer.

ReportBook support for Standalone designer was added in R1 2017 release. To start creating ReportBook, select File | New from the designer menu and choose a ReportBook report template.

See Also

How to: Create a Report Book at run-time Design Considerations for Excel Rendering