GridViewExtension.ExportToXlsx(GridViewSettings, Object, XlsxExportOptionsEx) Method

Exports the grid’s data to XLSX format, based on the provided settings.

Namespace: DevExpress.Web.Mvc

Assembly: DevExpress.Web.Mvc5.v24.1.dll

NuGet Package: DevExpress.Web.Mvc5

Declaration

C#

public static ActionResult ExportToXlsx(
    GridViewSettings settings,
    object dataObject,
    XlsxExportOptionsEx exportOptions
)

VB.NET

Public Shared Function ExportToXlsx(
    settings As GridViewSettings,
    dataObject As Object,
    exportOptions As XlsxExportOptionsEx
) As ActionResult

Parameters

Name	Type	Description
settings	GridViewSettings	A GridViewSettings object that contains GridView settings.
dataObject	Object	An object representing the GridView’s data source.
exportOptions	XlsxExportOptionsEx	A XlsxExportOptionsEx object that provides export options.

Returns

Type	Description
ActionResult	A ActionResult encapsulating the result of the grid data export operation.

Related GitHub Examples

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

asp-net-mvc-grid-export-colored-grid-in-wysiwyg-mode/CS/Controllers/HomeController.cs#L24

    exportOptions.ExportType = DevExpress.Export.ExportType.WYSIWYG;
    return GridViewExtension.ExportToXlsx(GridViewHelper.ExportGridViewSettings, MyModel.GetProducts(), exportOptions);
}

asp-net-mvc-grid-export-colored-grid-in-data-aware-mode/CS/Controllers/HomeController.cs#L25

    exportOptions.CustomizeCell += new DevExpress.Export.CustomizeCellEventHandler(exportOptions_CustomizeCell);
    return GridViewExtension.ExportToXlsx(GridViewHelper.ExportGridViewSettings, MyModel.GetProducts(), exportOptions);
}

VB.NET

asp-net-mvc-grid-export-colored-grid-in-wysiwyg-mode/VB/Controllers/HomeController.vb#L26

    exportOptions.ExportType = DevExpress.Export.ExportType.WYSIWYG
    Return GridViewExtension.ExportToXlsx(GridViewHelper.ExportGridViewSettings, MyModel.GetProducts(), exportOptions)
End Function

asp-net-mvc-grid-export-colored-grid-in-data-aware-mode/VB/Controllers/HomeController.vb#L26

    AddHandler exportOptions.CustomizeCell, AddressOf exportOptions_CustomizeCell
    Return GridViewExtension.ExportToXlsx(GridViewHelper.ExportGridViewSettings, MyModel.GetProducts(), exportOptions)
End Function