WorkbookData - Maple Help

ExcelTools

 WorkbookData
 Retrieve sheet and named range data from an Excel spreadsheet

 Calling Sequence WorkbookData(file)

Parameters

 file - string ; the name of the Excel file from which workbook data will be retrieved.

Description

 • 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.

Examples

 > $\mathrm{with}\left(\mathrm{ExcelTools}\right):$
 > $L≔\mathrm{WorkbookData}\left("Employees.xls"\right)$

Compatibility

 • The ExcelTools[WorkbookData] command was introduced in Maple 15.