TAdvGridExcelImport.Import Method

Overloads

TAdvGridExcelImport.Import(TExcelFile)

Imports an existing TXlsFile object into the grid. Use this method for maximum flexibility, as you can use any of the methods in TXlsFile to open a file from anywhere and modify it before importing it. You can also set the ActiveSheet you want to import before calling this method.

Syntax

Unit: UAdvGridExcelImport

procedure TAdvGridExcelImport.Import(const Xls: TExcelFile); overload;

Parameters

<-> Parameter Type Description
const Xls TExcelFile ExcelFile with the file you want to import.

See also

TAdvGridExcelImport.Import(TFileName, string)

Imports a file from disk.

Syntax

Unit: UAdvGridExcelImport

procedure TAdvGridExcelImport.Import(const FileName: TFileName; const SheetName: string); overload;

Parameters

<-> Parameter Type Description
const FileName TFileName Name of the file to import.
const SheetName string Sheet name to import. If you set this to '', the active sheet in the file will be used.

See also

TAdvGridExcelImport.Import(TStream, string)

Imports a file from a stream.

Syntax

Unit: UAdvGridExcelImport

procedure TAdvGridExcelImport.Import(const aStream: TStream; const SheetName: string); overload;

Parameters

<-> Parameter Type Description
const aStream TStream Stream with the data to import.
const SheetName string Sheet name to import. If you set this to '', the active sheet in the file will be used.

See also