TTMSFNCDataGridExcelIO.XLSImport Method
Imports the first sheet of the specified XLS/XLSX/CSV file into the DataGrid.
API unit family: TMSFNCDataGridExcelIO
Declaring type: TTMSFNCDataGridExcelIO
Overloads
Overload 1
Imports the first sheet of the specified XLS/XLSX/CSV file into the DataGrid.
procedure XLSImport(const FileName: TFileName); overload;
Parameters
| Name | Description |
|---|---|
FileName |
Path of the XLS, XLSX, or CSV file to import. |
Overload 2
Imports the sheet identified by SheetNumber (1-based) from the specified file into the DataGrid.
procedure XLSImport(const FileName: TFileName; const SheetNumber: integer); overload;
Parameters
| Name | Description |
|---|---|
FileName |
Path of the XLS or XLSX file to import. |
SheetNumber |
One-based worksheet index to import. |
Overload 3
Imports the sheet identified by SheetName from the specified file into the DataGrid.
procedure XLSImport(const FileName: TFileName; const SheetName: UTF16String); overload;
Parameters
| Name | Description |
|---|---|
FileName |
Path of the XLS or XLSX file to import. |
SheetName |
Worksheet name to import. |