GridControl.ExportToXlsx(Stream) Method

Exports the data displayed by the GridControl.DefaultView (the GridControl.MainView or the currently maximized detail View) to the specified stream in XLSX (MS Excel 2007) format

Namespace: DevExpress.XtraGrid

Assembly: DevExpress.XtraGrid.v19.2.dll

Declaration

C#

public void ExportToXlsx(
    Stream stream
)

VB.NET

Public Sub ExportToXlsx(
    stream As Stream
)

Parameters

Name	Type	Description
stream	Stream	A Stream object to which data is exported.

Remarks

See Export to XLS and XLSX Formats to learn more.

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the ExportToXlsx(Stream) method.

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#L66

BeforeExport();
grid.ExportToXlsx(stream);
AfterExport();

VB.NET

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

BeforeExport()
grid.ExportToXlsx(stream)
AfterExport()