Enum ReportXlsxSheets

Namespace

DocWright.Reporting.Export

Assembly

DocWright.Reporting.Export.dll

How a report's pages are laid out across worksheets.

public enum ReportXlsxSheets

Fields

Single = 0

One worksheet for the whole report, pages written one after another — the reference implementation's own behaviour.

Measured: a two-page report rendered through Reporting Services' EXCELOPENXML renderer produces a single Sheet1. Its Excel renderer is a soft-page renderer, so the physical page breaks that govern the PDF do not become sheet breaks. A spreadsheet is a place to work with data, and a column total that stops at an arbitrary page boundary is not what anyone opening one wants.

PerPage = 1

One worksheet per physical page, named from the page name where it has one.