Retrieve sheet and named range data from an Excel spreadsheet - Maple 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

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:

L:=WorkbookDataEmployees.xls

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