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

Declaration

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

Property Value

Type Default Description
XlsExportMode

SingleFile

An XlsExportMode enumeration value.

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.Xls.ExportMode
ExportOptions
.Xls.ExportMode
PrintingSystemBase
.ExportOptions.Xls.ExportMode
WinForms Controls PrintingSystem
.ExportOptions.Xls.ExportMode
XtraSchedulerReport
.ExportOptions.Xls.ExportMode
WPF Controls ExportOptionsContainer
.Xls.ExportMode
PrintingSystem
.ExportOptions.Xls.ExportMode
PrintingSystem
.ExportOptions.Xls.ExportMode
Reporting XtraReport
.ExportOptions.Xls.ExportMode
DocumentOperationRequest
.ExportOptions.Xls.ExportMode
Silverlight Controls PrintingSystem
.ExportOptions.Xls.ExportMode
PrintingSystem
.ExportOptions.Xls.ExportMode

Remarks

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

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