How to export data to multiple Excel worksheets
Environment
| Product | Progress® Telerik® Reporting |
| Product Version | 12.0 18.227 |
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.