|
|
|
method LoadFromExcel(Filename: String, Sheet: Variant[, StartFromCol: String, StartFromRow: Number, LastCol: String, LastRow: Number])
LoadFromExcal method populates a Memory Table from an Excel file.
LoadFromExcel method syntax has these named arguments:
Parameter |
Description |
|---|---|
File Name |
Required. Name of the Excel file to load from. |
Sheet |
Required. The Excel worksheet name or number to load from. Note: Do not use apostrophes (') in worksheet names, as this can cause problems. |
Start From Col |
Optional. The column to start load from. Defaults to column "A". |
Start From Row |
Optional. The row to start load from. Defaults to Row 1. |
Last Col |
Optional. The last column in the Excel file to import. |
Last Row |
Optional. The last row in the Excel file to import. |
For example:
MemTable.LoadFromExcel(FileName: String, Sheet: Variant[, StartFromCol: String, StartFromRow: Number, LastCol: String, LastRow: Number])
|
|
|
