Retrieve sheet and named range data from an Excel spreadsheet
string ; the name of the Excel file from which workbook data will be retrieved.
The WorkbookData(file) function retrieves the sheet and named range data from the workbook saved in the Excel file. This data is returned in the form of a list consisting of two sublists:
The first sublist gives the names of the sheets in the workbook, as strings.
The second sublist gives all the named ranges in the workbook, as strings.
L ≔ WorkbookData⁡Employees.xls
The ExcelTools[WorkbookData] command was introduced in Maple 15.
For more information on Maple 15 changes, see Updates in Maple 15.
Download Help Document