Back to Devexpress

ExportGridToTextStream(TStream,TcxGrid,Boolean,Boolean,string,string,string,TObject,TEncoding) Method

vcl-cxgridexportlink-dot-exportgridtotextstream-x28-0ab902b8-x29.md

latest5.0 KB
Original Source

ExportGridToTextStream(TStream,TcxGrid,Boolean,Boolean,string,string,string,TObject,TEncoding) Method

Exports content of a data grid control to a stream in plain text format.

Declaration

delphi
procedure ExportGridToTextStream(AStream: TStream; AGrid: TcxGrid; AExpand: Boolean; ASaveAll: Boolean; const ASeparator: string; const ABeginString: string; const AEndString: string; AHandler: TObject = nil; AEncoding: TEncoding = nil);

Parameters

NameTypeDescription
AStreamTStream

The target stream.

| | AGrid | TcxGrid |

The source data grid control.

| | AExpand | Boolean |

If True, the procedure exports all rows, including the rows hidden within collapsed group rows and master rows. If False, the procedure exports only visible rows.

| | ASaveAll | Boolean |

Optional. Specifies if the procedure exports all available rows:

True Default. The procedure exports all or only visible rows depending on the AExpand parameter value.FalseThe procedure exports only selected rows.

The ASaveAll parameter value is ignored in grid mode.

| | ASeparator | string |

Specifies the string used to delimit exported values in the resulting plain text stream.

| | ABeginString | string |

Specifies the prefix string for every cell value.

| | AEndString | string |

Specifies the postfix string for every cell value.

| | 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:

How to: Track Data Export Progress

| | AEncoding | TEncoding |

Optional. Specifies the character encoding format of the resulting CSV stream.

If nil (in Delphi) or nullptr (in C++Builder) is passed as the AEncoding parameter ( default ), the procedure uses the TEncoding.Default encoding.

|

Remarks

Call the ExportGridToTextStream procedure to export the data grid control’s content to a stream in plain text format. This format stores data without formatting, style, or print layout information. Compared to CSV, the plain text format is more human-readable.

Code Example: Export Grid Content to a TXT Stream

The following code example exports grid content to a stream in plain text format when the ABeginString parameter is set to '|':

delphi
uses cxGridExportLink;
// ...
var
  AStream: TMemoryStream;
begin
  AStream := TMemoryStream.Create;
  ExportGridToTextStream(AStream, cxGrid1, False, True, '', '|', '', 'txt');
  AStream.SaveToFile('Employees.txt');
  AStream.Free;
end;
cpp
#include "cxGridExportLink.hpp"
// ...
  TMemoryStream *AStream = nullptr;
  // ...
  AStream = new TMemoryStream();
  ExportGridToTextStream(AStream, cxGrid1, false, true, "", "|", "", "txt");
  AStream->SaveToFile("Employees.txt");
  delete AStream;

The following image demonstrates the exported content of a memory stream when it is saved to a TXT file:

See Also

VCL Data Grid: Data Export

ExportGridToText(string,TcxGrid,Boolean,Boolean,string,string,string,string,TObject,TEncoding)

ExportGridToText(string,TcxGrid,Boolean,Boolean,string,TObject,TEncoding)

ExportGridToTextStream(TStream,TcxGrid,Boolean,Boolean,TObject,TEncoding)

cxGridExportLink Unit