PivotGridExtension.ExportToXls(PivotGridSettings, Object, XlsExportOptions) Method

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

Namespace: DevExpress.Web.Mvc

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

Declaration

C#

public static ActionResult ExportToXls(
    PivotGridSettings settings,
    object dataObject,
    XlsExportOptions exportOptions
)

VB.NET

Public Shared Function ExportToXls(
    settings As PivotGridSettings,
    dataObject As Object,
    exportOptions As XlsExportOptions
) As ActionResult

Parameters

Name	Type	Description
settings	PivotGridSettings	A PivotGridSettings object that contains PivotGrid settings.
dataObject	Object	A PivotGrid data source.
exportOptions	XlsExportOptions	An XlsExportOptions 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 ExportToXls(PivotGridSettings, Object, XlsExportOptions) 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#

Add-a-custom-menu-to-export-the-MVCxPivotGrid-control/CS/MPG_ExportMenu/Controllers/HomeController.cs#L31

case "XlsWysiwyg":
    return PivotGridExtension.ExportToXls(settings,data,
        new DevExpress.Web.ASPxPivotGrid.PivotXlsExportOptions() { ExportType = DevExpress.Export.ExportType.WYSIWYG } );