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.v20.1.Core.dll

Declaration

[DefaultValue(XlsxExportMode.SingleFile)]
public XlsxExportMode ExportMode { get; set; }
<DefaultValue(XlsxExportMode.SingleFile)>
Public Property ExportMode As XlsxExportMode

Property Value

Type Default Description
XlsxExportMode

SingleFile

An XlsxExportMode enumeration value, representing the XLSX export mode.

Property Paths

You can access this nested property as listed below:

Show 12 property paths
Library Object Type Path to ExportMode
Cross-Platform Class Library RemotePrintingSystem
.ExportOptions.Xlsx.ExportMode
ExportOptions
.Xlsx.ExportMode
PrintingSystemBase
.ExportOptions.Xlsx.ExportMode
WinForms Controls PrintingSystem
.ExportOptions.Xlsx.ExportMode
XtraSchedulerReport
.ExportOptions.Xlsx.ExportMode
WPF Controls ExportOptionsContainer
.Xlsx.ExportMode
PrintingSystem
.ExportOptions.Xlsx.ExportMode
PrintingSystem
.ExportOptions.Xlsx.ExportMode
Reporting XtraReport
.ExportOptions.Xlsx.ExportMode
DocumentOperationRequest
.ExportOptions.Xlsx.ExportMode
Silverlight Controls PrintingSystem
.ExportOptions.Xlsx.ExportMode
PrintingSystem
.ExportOptions.Xlsx.ExportMode

Remarks

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.
            report.ExportToXlsx(reportPath);

            //...
        }
//...
See Also