How to display report pages on separate sheets in Excel

2019-10-14

Until recently, the export of multi-page reports in Excel format was done on one sheet. That is, all pages of the report were displayed on one sheet in Excel. Of course, this is not always convenient; it would be better to be able to display each page of the report on a separate sheet in an Excel document. Now there is such an opportunity. A new option Split Pages (separate pages) has appeared in the Excel export settings:

 

Here's what the report looks like if Split Pages is disabled:

 

Now enable the option:

 

Three sheets appeared. Each of them has a corresponding report page:

We have long lacked such an option. Now export to .xlsx format has become even more functional.

November 20, 2024

Localization and Language Switching in FastReport VCL

FastReport VCL supports 40 languages for interface localization and allows you to change the language on the fly through menus or code, without recompilation.
November 01, 2024

New Features of the FastReport VCL Editor

We are considering new features of the report editor: extension lines, highlighting of intersecting objects, updated report and data trees.
October 30, 2024

Using Styles When Creating Reports in FastReport VCL

The article discusses one of the new features of FastReport VCL — the use of styles and style sheets.
Fast Reports
  • 800-985-8986 (English, US)
  • +4930568373928 (German)
  • +55 19 98147-8148 (Portuguese)
  • info@fast-report.com
  • 66 Canal Center Plaza, Ste 505, Alexandria, VA 22314

© 1998-2024 Fast Reports Inc.