TTMSFNCGridExcelImport.Import Method

Overloads

TTMSFNCGridExcelImport.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: VCL.TMSFNCGridExcelImport / FMX.TMSFNCGridExcelImport

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

Parameters

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

See also

TTMSFNCGridExcelImport.Import(TFileName, string)

Imports a file from disk.

Syntax

Unit: VCL.TMSFNCGridExcelImport / FMX.TMSFNCGridExcelImport

procedure TTMSFNCGridExcelImport.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

TTMSFNCGridExcelImport.Import(TStream, string)

Imports a file from a stream.

Syntax

Unit: VCL.TMSFNCGridExcelImport / FMX.TMSFNCGridExcelImport

procedure TTMSFNCGridExcelImport.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