ExcelTools - Maple Programming Help

Online Help

All Products    Maple    MapleSim


Home : Support : Online Help : Programming : Input and Output : File Manipulation : ExcelTools : ExcelTools/WorkbookData

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]

 


Download Help Document

Was this information helpful?



Please add your Comment (Optional)
E-mail Address (Optional)
What is ? This question helps us to combat spam