The ImportExcel attribute function imports the records from an Excel workbook in the format specified by the ExportExcel function.
Syntax | ||||
ImportExcel(FileName [, SheetIndex][, FirstRow][, FirstCol]) | ||||
Return value | ||||
None | ||||
Parameter | ||||
Use |
Name |
Type |
Passing |
Description |
Required |
FileName |
String |
ByVal |
Name of the Excel file. |
Optional |
SheetIndex |
Long |
ByVal |
Index of the sheet into the
workbook |
Optional |
FirstRow |
Long |
ByVal |
The line number from which the data was
entered into the sheet. |
Optional |
FirstCol |
Long |
ByVal |
The column number from which the data was
entered into the sheet. |