PivotGridExtension.OLAPExportToXls(PivotGridSettings, String, String, Boolean, XlsExportOptions) Method
Exports the pivot grid’s data to XLS format, based on the provided settings. Used only in an OLAP mode.
Namespace: DevExpress.Web.Mvc
Assembly: DevExpress.Web.Mvc5.v19.2.dll
Declaration
public static ActionResult OLAPExportToXls(
PivotGridSettings settings,
string connectionString,
string fileName,
bool saveAsFile,
XlsExportOptions exportOptions
)
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. |
fileName | String | A String value that specifies the target file name. |
saveAsFile | Boolean | true to display the File Download dialog; false to display the file with exported data within a page. |
exportOptions | XlsExportOptions | An XlsExportOptions object that provides export options. |
Returns
Type | Description |
---|---|
ActionResult | A ActionResult encapsulating the result of the PivotGrid data export operation. |
See Also