XlsExportOptions Class

Contains options which define how a document is exported to XLS format.

Namespace: DevExpress.XtraPrinting

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

Declaration

C#

public class XlsExportOptions :
    XlExportOptionsBase

VB.NET

Public Class XlsExportOptions
    Inherits XlExportOptionsBase

Related API Members

The following members accept/return XlsExportOptions objects:

• ExportOptions.Xls

Remarks

In addition to the common export settings inherited from the base XlExportOptionsBase class, the XlsExportOptions class provides the following properties which define how a document is exported to XLS format.

• XlsExportOptions.ExportMode;
• XlsExportOptions.PageRange;
• XlsExportOptions.Suppress256ColumnsWarning;
• XlsExportOptions.Suppress65536RowsWarning.

For more information, refer to Export to XLS.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the XlsExportOptions class.

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.

C#

Reporting_how-to-export-different-report-groups-to-different-sheets-in-an-xls-file-e1352/CS/WindowsApplication1/XtraForm1.cs#L16

}
public XlsExportOptions ExportOptions {
    get {

XAF_how-to-customize-the-export-action-behavior-e2335/CS/CustomizeExportAction.Module/Controllers/CustomizeExportController.cs#L33

if (e.ExportTarget == ExportTarget.Xls) {
   XlsExportOptions options = (XlsExportOptions)e.ExportOptions;
   if (options == null) {

how-to-export-grid-columns-text-to-excel-e2585/CS/FilterCombo/Window1.xaml.cs#L63

{
    view.ExportToXls(@"1.xls", new XlsExportOptions() { TextExportMode = TextExportMode.Text });
}

XAF_how-to-customize-export-options-of-the-printing-system-in-winforms-e2108/CS/WinSolution.Module.Win/ConfigurePrintingSystemViewController.cs#L39

}
private static void SetXlsOptions(XlsExportOptions xlsExportOptions) {
    // XLS-specific options:

Reporting_how-to-export-a-report-to-xls-format-e46/CS/Form1.cs#L25

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

VB.NET

Reporting_how-to-export-different-report-groups-to-different-sheets-in-an-xls-file-e1352/VB/WindowsApplication1/XtraForm1.vb#L18

End Sub
Public ReadOnly Property ExportOptions() As XlsExportOptions
    Get

XAF_how-to-customize-the-export-action-behavior-e2335/VB/CustomizeExportAction.Module/Controllers/CustomizeExportController.vb#L35

If e.ExportTarget = ExportTarget.Xls Then
   Dim options As XlsExportOptions = CType(e.ExportOptions, XlsExportOptions)
   If options Is Nothing Then

how-to-export-grid-columns-text-to-excel-e2585/VB/FilterCombo/Window1.xaml.vb#L64

Private Sub button1_Click(ByVal sender As Object, ByVal e As RoutedEventArgs)
    view.ExportToXls("1.xls", New XlsExportOptions() With {.TextExportMode = TextExportMode.Text})
End Sub

XAF_how-to-customize-export-options-of-the-printing-system-in-winforms-e2108/VB/WinSolution.Module.Win/ConfigurePrintingSystemViewController.vb#L40

End Sub
Private Shared Sub SetXlsOptions(ByVal xlsExportOptions As XlsExportOptions)
    ' XLS-specific options:

Reporting_how-to-export-a-report-to-xls-format-e46/VB/Form1.vb#L27

' Get its XLS export options.
Dim xlsOptions As XlsExportOptions = report.ExportOptions.Xls

Inheritance

Object

ExportOptionsBase

PageByPageExportOptionsBase

XlExportOptionsBase

XlsExportOptions

XlsExportOptionsEx

PivotXlsExportOptionsBase

PivotXlsExportOptions

PivotXlsExportOptions