ExcelMetaData
The ExcelMetaData() function returns an array containing the names of the worksheets in an Excel workbook.
Syntax
ExcelMetaData (Filepath, Information)
| Filepath | The full file path |
| Information | The required information to return. Currently the only option is “worksheets”. |
Examples
| ExcelMetaData(“C:workinvoices.xlsx”,”worksheets”) |
| Output |
| List |
| Addresses |
| History |