GridControl.ExportToXls(String) Method

Exports the data the GridControl.DefaultView (GridControl.MainView or the currently maximized detail View) displays to a file in XLS format.

Namespace: DevExpress.XtraGrid

Assembly: DevExpress.XtraGrid.v24.1.dll

NuGet Packages: DevExpress.Win.Grid, DevExpress.Win.Navigation

Declaration

C#

public void ExportToXls(
    string filePath
)

VB.NET

Public Sub ExportToXls(
    filePath As String
)

Parameters

Name	Type	Description
filePath	String	A string that specifies the full path to the file to which the View’s data will be 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 ExportToXls(String) 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#

winforms-grid-print-group-summary-under-columns/CS/Q250602/Form1.cs#L21

private void OnExportToXlsButtonClick(object sender, EventArgs e) {
    orderDetailsGrid.ExportToXls(@"..\..\order_details.xls");
    //orderDetailsGrid.ExportToHtml(@"..\..\order_details.html");

VB.NET

winforms-grid-print-group-summary-under-columns/VB/Q250602/Form1.vb#L23

Private Sub OnExportToXlsButtonClick(ByVal sender As Object, ByVal e As EventArgs) Handles simpleButton2.Click
    orderDetailsGrid.ExportToXls("..\..\order_details.xls")
    'orderDetailsGrid.ExportToHtml(@"..\..\order_details.html");