To specify how a document is exported to Excel, AQM provides the XlsxExportOptions.ExportMode property. Here are the three possible values of that property:
| Name | Description |
|---|---|
| SingleFile | The document is exported to a single file. In this mode, headers and footers are added to the resulting XLSX file only once, at the beginning and end of the document. |
| DiferentFiles | The document is exported to multiple files, one report page per file. |
| SingleFilePageByPage | The document is exported to a single file, but an individual sheet is created for each page. |
During the Excel export process, the reports are divided into parts according to the definitions in the report. For example, it is possible to split the report into different files or individual sheets for each of the groups in the report.
The RollPaper property
The following is a report with several groups:
The following image shows the same report with an inserted group footer band. The height of the band is zero and its PageBreak property is set to AfterBand:
Selecting the Page Break enables the XtraReport.RollPaper property. On the Preview You see a document with several pages of different lengths. Each page represents a group.
When this report is exported to Excel using the SingleFilePageByPage export mode, each report suite occupies its own sheet in the resulting file:
