Skip to main content

XlsxExportOptions.ExportMode Property

Specifies whether the source is exported as a single XLSX file or multiple files, and whether each page is exported as a separate worksheet.

Namespace: DevExpress.XtraPrinting

Assembly: DevExpress.Printing.v23.1.Core.dll

NuGet Packages: DevExpress.Printing.Core, DevExpress.Win.Dashboard.Design


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

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.


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.


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:

Object Type Path to ExportMode
.Xlsx .ExportMode


The code below demonstrates to export a report to XLSX with the specific export options.

using DevExpress.XtraPrinting;
    public partial class Form1 : Form {
        private void button1_Click(object sender, EventArgs e) {
            // A path to export a report.
            string reportPath = "c:\\Test.xlsx";

            // Create a report instance.
            XtraReport1 report = new XtraReport1();

            // Get its XLSX export options.
            XlsxExportOptions xlsxOptions = report.ExportOptions.Xlsx;

            // Set XLSX-specific export options.
            xlsxOptions.ShowGridLines = true;
            xlsxOptions.TextExportMode = TextExportMode.Value;
            xlsxOptions.ExportHyperlinks = true;
            xlsxOptions.SheetName = "My Sheet";
            xlsxOptions.ExportMode = XlsxExportMode.DifferentFiles;

            // Export the report to XLSX.

See Also