TTMSFMXGridExcelImport.Import Method

Overloads

TTMSFMXGridExcelImport.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: FMX.TMSGridExcelImport

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

Parameters

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

See also

TTMSFMXGridExcelImport.Import(TFileName, string)

Imports a file from disk.

Syntax

Unit: FMX.TMSGridExcelImport

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

TTMSFMXGridExcelImport.Import(TStream, string)

Imports a file from a stream.

Syntax

Unit: FMX.TMSGridExcelImport

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