SXC (.sxc)

  • Import fully supports the SXC format.

BackgroundBackground

    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 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.

ElementsElements

  • 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 the Wolfram Language 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.

OptionsOptions

  • Import option:
  • "EmptyField"""how empty cells are represented in the Wolfram Language
Introduced in 2007
(6.0)