Sun XML Calc (.sxc) File Format - Maple Programming Help

Online Help

All Products    Maple    MapleSim


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

Sun XML Calc (.sxc) File Format

SXC file format

 

Description

Notes

Examples

Compatibility

Description

• 

SXC (Sun XML Calc) is an XML-based spreadsheet file format used by OpenOffice and StarOffice.

• 

The commands ImportMatrix and ExportMatrix can read and write to the SXC 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 SXC spreadsheet.

Notes

• 

Content-Type: application/vnd.sun.xml.calc

Examples

Import an ODS spreadsheet with demographic data on Central America.

Importexample/CentralAmerica.sxc,base=datadir

Maple DataArea (km^2)CapitalCapital LocationBelize22966.0Belmopan1715'N 8846'WCosta Rica51100.0San Jos956'N 845'WEl Salvador21044.8San Salvador1340'N 8910'WGuatemala108889.0Guatemala City1438'N 9030'WHonduras112492.0Tegucigalpa146'N 8713'WNicaragua130375.0Managua129'N 8616'W

(1)

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

Importexample/CentralAmerica.sxc,base=datadir,output=table

tableMaple Data=CountryArea (km^2)CapitalCapital LocationBelize22966.0Belmopan1715'N 8846'WCosta Rica51100.0San Jos956'N 845'WEl Salvador21044.8San Salvador1340'N 8910'WGuatemala108889.0Guatemala City1438'N 9030'WHonduras112492.0Tegucigalpa146'N 8713'WNicaragua130375.0Managua129'N 8616'W

(2)

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

MLinearAlgebra:-RandomMatrix100,2:

Exportexample.sxc,M,base=homedir

24560

(3)

Compatibility

• 

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

See Also

ExportMatrix

Formats

ImportMatrix