cxExportPivotGridToFile(string,TcxCustomPivotGrid,Integer,Boolean,Boolean,string[],string,TObject,TEncoding) Method
Exports content of a pivot grid to a file in a specified format.
#Declaration
#Parameters
Name | Type | Description |
---|---|---|
AFile |
string | The full path to the resulting file. You can omit the file name extension because it is automatically updated from the |
APivot |
Tcx |
The source pivot grid control. |
AExport |
Integer | Specifies the target export format. You can pass one of the following public constants as this parameter: cx |
AExpand | Boolean | If |
AUse |
Boolean | If |
ASeparators | string | Specifies the value separator character as well as the prefix and postfix strings. The |
AFile |
string | Specifies the file name extension of the resulting file. This parameter value always replaces the file name extension passed as a part of the |
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: |
AEncoding | TEncoding | Optional. Specifies the character encoding format of the resulting file. If |
#Remarks
Call the cxExportPivotGridToFile
procedure to export content of a pivot grid control to a file in any supported format.
#Code Example: Export Pivot Grid Content as XLSX
The following code example exports content of an unbound pivot grid control to a file in XLSX format:
uses cxExportPivotGridLink;
// ...
cxExportPivotGridToFile('Payments.xlsx', UnboundPivotGrid, cxExportToXLSX, True, True, [], 'xlsx');