cxExportPivotGridDataToExcel(string,TcxCustomPivotGrid,TObject,Boolean,Boolean,Boolean,Boolean) Method
Exports unformatted data from a pivot grid to a file in XLS or XLSX format.
#Declaration
#Parameters
Name | Type | Description |
---|---|---|
AFile |
string | The full path to the resulting XLSX or XLS file. The specified file name extension determines the target data export format – Office Open XML (XLSX) or Microsoft Excel® binary format (XLS). |
APivot |
Tcx |
The source pivot grid control. |
AHandler | TObject | Optional. Specifies a handler object that should implement the Icx Tip Refer to the following topic for detailed information on how to create and use handler objects: |
AAuto |
Boolean | Optional. If |
AHighlight |
Boolean | Optional. If |
ACell |
Boolean | Optional. If |
AField |
Boolean | Optional. If |
#Remarks
Call the cxExportPivotGridDataToExcel
procedure to export pivot grid data in XLS or XLSX format. Unlike the cxExportPivotGridToExcel and cxExportPivotGridToXLSX procedures, cxExportPivotGridDataToExcel
exports only data in a simplified layout, without style information. The resulting file includes outlined groups and frozen panes to simplify data browsing and analysis in the Spreadsheet control or a third-party spreadsheet application.
#Code Example: Export Pivot Grid Content as XLSX
The following code example exports pivot grid data to a file in XLSX format:
uses cxExportPivotGridLink;
// ...
cxExportPivotGridDataToExcel('Payments.xlsx', UnboundPivotGrid);