cxExportPivotGridToCSV(string,TcxCustomPivotGrid,Boolean,Char,string,TObject,TEncoding) Method
Exports content of a pivot grid to a file in CSV (comma-separated values) format.
Declaration
procedure cxExportPivotGridToCSV(const AFileName: string; APivotGrid: TcxCustomPivotGrid; AExpand: Boolean = True; const ASeparator: Char = ','; const AFileExt: string = 'csv'; AHandler: TObject = nil; AEncoding: TEncoding = nil);
Parameters
Name | Type | Description |
---|---|---|
AFileName | string | The full path to the resulting CSV file. You can omit the file name extension because it is automatically updated from the |
APivotGrid | TcxCustomPivotGrid | The source pivot grid control. |
AExpand | Boolean | Optional. If |
ASeparator | Char | Optional. Specifies the character used to delimit exported values in the resulting CSV file. The default separator character is a comma. |
AFileExt | string | Optional. Specifies the file name extension for the resulting CSV 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 IcxExportBeforeSave and/or IcxExportProgress interfaces to allow you to perform specific actions before the beginning of an export operation and track its progress. 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 CSV stream. If |
Remarks
Call the cxExportPivotGridToCSV
procedure to export pivot grid content to a file in CSV format. In the resulting file, every plain text line of values separated by commas corresponds to a data record.
Code Example
uses cxExportPivotGridLink;
// ...
cxExportPivotGridToCSV('Payments.csv', UnboundPivotGrid);