PivotGridExtension.ExportToXlsx(PivotGridSettings, Object, XlsxExportOptions) Method

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

Namespace: DevExpress.Web.Mvc

Assembly: DevExpress.Web.Mvc5.v23.2.dll

NuGet Package: DevExpress.Web.Mvc5

Declaration

C#

public static ActionResult ExportToXlsx(
    PivotGridSettings settings,
    object dataObject,
    XlsxExportOptions exportOptions
)

VB.NET

Public Shared Function ExportToXlsx(
    settings As PivotGridSettings,
    dataObject As Object,
    exportOptions As XlsxExportOptions
) As ActionResult

Parameters

Name	Type	Description
settings	PivotGridSettings	A PivotGridSettings object that contains PivotGrid settings.
dataObject	Object	A PivotGrid data source.
exportOptions	XlsxExportOptions	An XlsxExportOptions object that provides export options.

Returns

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

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the ExportToXlsx(PivotGridSettings, Object, XlsxExportOptions) 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#

mvc-pivot-grid-custom-export/CS/MVCxPivotGrid_CustomExport/Controllers/HomeController.cs#L24

{
    return PivotGridExtension.ExportToXlsx(PivotGridHelper.Settings, Models.NwindModel.GetData(), PivotGridHelper.XlsxOptions);
}