Skip to main content
A newer version of this page is available. .

XlsxExportOptions.ExportMode Property

Specifies whether the document should be exported to a single XLSX file or different XLSX files, page-by-page, or not.

Namespace: DevExpress.XtraPrinting

Assembly: DevExpress.Printing.v17.2.Core.dll

Declaration

[XtraSerializableProperty]
[DefaultValue(XlsxExportMode.SingleFile)]
public XlsxExportMode ExportMode { get; set; }

Property Value

Type Default Description
XlsxExportMode

SingleFile

An XlsxExportMode enumeration value, representing the XLSX export mode.

Available values:

Name Description
SingleFile

A document is exported to a single file. Note that in this mode, page headers and footers are added to the resulting XLSX file only once, at the beginning and at the end of the document.

SingleFilePageByPage

A document is exported to a single file, page-by-page. In this mode, each page is exported to an individual sheet of the same XLSX file.

DifferentFiles

A document is exported to multiple files, page-by-page. In this mode every document page is exported to a single XLSX file.

Property Paths

You can access this nested property as listed below:

Library Object Type Path to ExportMode
Cross-Platform Class Library ExportOptions
.Xlsx.ExportMode
WPF Controls ExportOptionsContainer
.Xlsx.ExportMode

Remarks

Use the ExportMode property, to specify whether a document should be exported to a single XLSX file and, if so - whether each page should be shown on a separate sheet.

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the ExportMode property.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

See Also