WorkbookData - Maple Help
For the best experience, we recommend viewing online help using Google Chrome or Microsoft Edge.

Online Help

All Products    Maple    MapleSim


ExcelTools

  

WorkbookData

  

Retrieve sheet and named range data from an Excel spreadsheet

 

Calling Sequence

Parameters

Description

Examples

Compatibility

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

withExcelTools:

LWorkbookDataEmployees.xls

Compatibility

• 

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

• 

For more information on Maple 15 changes, see Updates in Maple 15.

See Also

ExcelTools

ExcelTools[Export]

ExcelTools[Import]