OpenDocument Spreadsheet (.ods) File Format - Maple Programming Help

Online Help

All Products    Maple    MapleSim


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

OpenDocument Spreadsheet (.ods) File Format

ODS file format

 

Description

Notes

Examples

Compatibility

Description

• 

ODS (OpenDocument Spreadsheet) is an XML-based spreadsheet file format used by OpenOffice.

• 

The commands ImportMatrix and ExportMatrix can read and write to the ODS format.

• 

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

• 

The default output from Import for this format is a DataSeries, the individual elements of which are DataFrames corresponding to worksheets within the ODS spreadsheet.

Notes

• 

Content-Type: application/vnd.oasis.opendocument.spreadsheet

Examples

Import an ODS spreadsheet listing the highest mountain peaks in the world.

Importexample/HighestPeaks.ods,base=datadir

Maple DataHeight (m)LocationFirst ascentMount Everest88482759'17"N 8655'31"E1953K286113552'53"N 7630'48"E1954Kangchenjunga85862742'12"N 8808'51"E1955Lhotse85162757'42"N 8655'59"E1956Makalu84852753'23"N 875'20"E1955Cho Oyu81882805'39"N 8639'39"E1954Dhaulagiri I81672841'48"N 8329'35"E1960Manaslu81632833'00"N 8433'35"E1956Nanga Parbat81263514'14"N 7435'21"E1953Annapurna I80912835'44"N 8349'13"E1950

(1)

Import the same data as above but returned as a table of Matrices.

Importexample/HighestPeaks.ods,base=datadir,output=table

(2)

Export a random matrix to an ODS spreadsheet in the home directory of the current user.

MLinearAlgebra:-RandomMatrix100,2:

Exportexample.ods,M,base=homedir

24639

(3)

Compatibility

• 

With Maple 2016, the Import command applied to ODS files now produces DataSeries objects by default. To produce a table, use Import(...,output=table).

See Also

ExportMatrix

Formats

ImportMatrix