XlsxExportOptions Class

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

Namespace: DevExpress.XtraPrinting

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

Declaration

C#

public class XlsxExportOptions :
    XlExportOptionsBase

VB.NET

Public Class XlsxExportOptions
    Inherits XlExportOptionsBase

Related API Members

The following members accept/return XlsxExportOptions objects:

• ExportOptions.Xlsx

Remarks

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

• XlsxExportOptions.ExportMode;
• XlsxExportOptions.PageRange.

For more information, refer to Export to XLSX.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the XlsxExportOptions 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#

how-to-specify-visibility-of-rows-in-gridview-during-printing-export-e3174/CS/ExportToXlsx/ExportHelper.cs#L75

}
public void ExportToXlsx(Stream stream, XlsxExportOptions options)
{

Reporting_how-to-export-reports-to-different-sheets-in-an-xlsx-file-by-using-spreadsheet-e4892/CS/WindowsFormsApplication1/Form1.cs#L34

report2.CreateDocument(false);
report.ExportToXlsx("test1.xlsx", new DevExpress.XtraPrinting.XlsxExportOptions() { SheetName = "report1" });
report2.ExportToXlsx("test2.xlsx", new DevExpress.XtraPrinting.XlsxExportOptions() { SheetName = "report2" });

Reporting_how-to-export-a-report-to-xlsx-format-e1539/CS/ExportToXLSX/Form1.cs#L21

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

Reporting_how-to-customize-file-names-in-differentfiles-export-mode-when-exporting-to-ms-t424910/CS/WindowsFormsApplication1/Form1.cs#L56

XlsxExportOptions options = new XlsxExportOptions() { ExportMode = XlsxExportMode.DifferentFiles} ;

VB.NET

how-to-specify-visibility-of-rows-in-gridview-during-printing-export-e3174/VB/ExportToXlsx/ExportHelper.vb#L76

End Sub
Public Sub ExportToXlsx(ByVal stream As Stream, ByVal options As XlsxExportOptions)
    BeforeExport()

Reporting_how-to-export-reports-to-different-sheets-in-an-xlsx-file-by-using-spreadsheet-e4892/VB/WindowsFormsApplication1/Form1.vb#L36

report2.CreateDocument(False)
report.ExportToXlsx("test1.xlsx", New DevExpress.XtraPrinting.XlsxExportOptions() With {.SheetName = "report1"})
report2.ExportToXlsx("test2.xlsx", New DevExpress.XtraPrinting.XlsxExportOptions() With {.SheetName = "report2"})

Reporting_how-to-export-a-report-to-xlsx-format-e1539/VB/ExportToXLSX/Form1.vb#L23

' Get its XLS export options.
Dim xlsxOptions As XlsxExportOptions = report.ExportOptions.Xlsx

Reporting_how-to-customize-file-names-in-differentfiles-export-mode-when-exporting-to-ms-t424910/VB/WindowsFormsApplication1/Form1.vb#L52

Dim options As New XlsxExportOptions() With {.ExportMode = XlsxExportMode.DifferentFiles}

Inheritance

Object

ExportOptionsBase

PageByPageExportOptionsBase

XlExportOptionsBase

XlsxExportOptions

XlsxExportOptionsEx

PivotXlsxExportOptionsBase

PivotXlsxExportOptions

PivotXlsxExportOptions