PivotGridExtension.ExportToXlsx(PivotGridSettings, Object, String, XlsxExportOptions) Method

Exports the pivot 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(
    PivotGridSettings settings,
    object dataObject,
    string fileName,
    XlsxExportOptions exportOptions
)

VB.NET

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

Parameters

Name	Type	Description
settings	PivotGridSettings	A PivotGridSettings object that contains PivotGrid settings.
dataObject	Object	A PivotGrid data source.
fileName	String	A String value that specifies the target file name.
exportOptions	XlsxExportOptions	An XlsxExportOptions object that provides export options.

Returns

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