XlsExportOptions.ExportMode Property

Specifies whether the document should be exported to a single or different XLS files, each page in a separate file.

Namespace: DevExpress.XtraPrinting

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


public XlsExportMode ExportMode { get; set; }

Property Value

Type Default Description


An XlsExportMode enumeration value.

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 XLS 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 XLS file.


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

Property Paths

You can access this nested property as listed below:

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


The code below demonstrates to export a report to XLS 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.xls";

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

            // Get its XLS export options.
            XlsExportOptions xlsOptions = report.ExportOptions.Xls;

            // Set XLS-specific export options.
            xlsOptions.ShowGridLines = true;
            xlsOptions.TextExportMode = TextExportMode.Value;
            xlsOptions.ExportHyperlinks = true;
            xlsOptions.SheetName = "My Sheet";
            xlsOptions.ExportMode = XlsExportMode.DifferentFiles;

            // Export the report to XLS.

See Also