Excel file format - Maple Help

Online Help

All Products    Maple    MapleSim


Home : Support : Online Help : Programming : Input and Output : File Formats : Formats/Excel

Excel (.xlsx, .xls) File Format - Excel file format

Description

• 

The Excel spreadsheet format is the native file format of Microsoft® Excel.

• 

The name refers both to the Excel Binary File Format (.xls) in use until Excel 2007, and to the Office Open XML spreadsheet format (.xlsx) in use by Excel 2007 and later revisions.

• 

The ExcelTools package allow detailed control over import and export of Excel spreadsheets.

• 

The general-purpose commands Import and Export also support this format.

Examples

Import data from an Excel spreadsheet.

data:=FileTools:-JoinPathExcel,ExperimentalData.xls,base=datadir

C:\Program Files\Maple 2015\data\Excel\ExperimentalData.xls

(1)

M:=Importdata

M:= 12 x 7 MatrixData Type: anythingStorage: rectangularOrder: Fortran_order

(2)

To perform the following example, you should create an Excel spreadsheet named Employees.xlsx with the necessary sheets and cells.

Q:=ExcelTools:-ImportEmployees.xlsx,Payroll,B2:C9:

See Also

ExcelTools, ExportMatrix, Formats, ImportMatrix


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