This is documentation for Mathematica 6, which was
based on an earlier version of the Wolfram Language.
View current documentation (Version 11.1)
Mathematica Import/Export Format

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 OpenOffice.org 1.0 and StarOffice 6.0.
ZIP-compressed XML format.
Supports multiple sheets in one file.
  • Import fully supports the SXC format.
  • 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 {s1, s2, ...} where the si 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.
"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 "Data" 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 {f1, f2, ...} where the fi 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 {m, n} 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 {m, n} in sheet name
  • Import["file.sxc", {"Sheets", All}] is equivalent to Import["file.sxc", "Data"].
  • Import yields spreadsheets as full rectangular arrays.
"EmptyField"""how empty cells are represented in Mathematica