SXC (.sxc)

MIME type: application/nd.sun.xml.calc
OpenOffice 1.0 spreadsheet file.
Stores spreadsheet data and formulas.
SXC is an acronym for Sun XML Calc.
Native spreadsheet format of 1.0 and StarOffice 6.0.
ZIP-compressed XML format.
Supports multiple sheets in one file.
  • Import fully supports the SXC format.

Import and ExportImport and Export

  • Import["file.sxc"] imports all sheets of an SXC file, returning the result as a list of arrays.
  • Import["file.sxc"] returns the sheets of an SXC file as an expression of the form , where the are full arrays containing numerical and textual data, Boolean values, and date specifications.
  • Import["file.sxc", elem] imports the specified element from an SXC file.
  • Import["file.sxc", {elem, suba, subb, ...}] imports a subelement.
  • Import["file.sxc", {{elem1, elem2, ...}}] imports multiple elements.
  • The import format can be specified with Import["file", "SXC"] or Import["file", {"SXC", elem, ...}].
  • See the reference pages for full general information on Import.
  • ImportString supports the SXC format.


  • General Import elements:
  • "Elements"list of elements and options available in this file
    "Rules"full list of rules for each element and option
    "Options"list of rules for options, properties, and settings
  • Data representation elements:
  • "Data"list of full arrays, representing all sheets
    "Formulas"all SXC formulas as text
  • Import by default uses the element.
  • SXC data is represented in Mathematica by real or integer numbers, strings, Boolean values True and False, and DateList specifications.
  • SXC error cells are imported as $Failed.
  • Import["file.sxc", "Formulas"] gives spreadsheet formulas for each cell in the form , where the are arrays corresponding to the sheets of an SXC file.
  • Importing parts of a data sheet:
  • "Data",kthe k^(th) sheet, given as an array
    "Data",k,mrow m of the k^(th) sheet
    "Data",k,m,ncell of the k^(th) sheet
  • Import["file.sxc", {"Data", 1}]returns the first sheet as an array.
  • The following can be used to select or specify individual sheets by name:
  • "Sheets"list of sheet names
    "Sheets",namesheet name as an array
    "Sheets",name,mrow m of sheet name
    "Sheets",name,m,ncell in sheet name
  • Import["file.sxc", {"Sheets", All}] is equivalent to Import["file.sxc", "Data"].
  • Import yields spreadsheets as full rectangular arrays.


  • Import option:
  • "EmptyField"""how empty cells are represented in Mathematica
New in 6
New to Mathematica? Find your learning path »
Have a question? Ask support »