PivotGridExtension.OLAPExportToXlsx(PivotGridSettings, String, Boolean, XlsxExportOptions) Method

Exports the pivot grid’s data to XLSX format, based on the provided settings. Used only in an OLAP mode.

Namespace: DevExpress.Web.Mvc

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

Declaration

C#

public static ActionResult OLAPExportToXlsx(
    PivotGridSettings settings,
    string connectionString,
    bool saveAsFile,
    XlsxExportOptions exportOptions
)

VB.NET

Public Shared Function OLAPExportToXlsx(
    settings As PivotGridSettings,
    connectionString As String,
    saveAsFile As Boolean,
    exportOptions As XlsxExportOptions
) As ActionResult

Parameters

Name	Type	Description
settings	PivotGridSettings	A PivotGridSettings object that contains PivotGrid settings.
connectionString	String	A String that specifies the connection string to an OLAP cube.
saveAsFile	Boolean	true to display the File Download dialog; false to display the file with exported data within a page.
exportOptions	XlsxExportOptions	An XlsxExportOptions object that provides export options.

Returns

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