TTMSFMXGridExcelImport.Import Method
Overloads
- TTMSFMXGridExcelImport.Import(TExcelFile)
- TTMSFMXGridExcelImport.Import(TFileName, string)
- TTMSFMXGridExcelImport.Import(TStream, string)
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. |