SXC (.sxc)

  • Import fully supports the SXC format.
  • Background

      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 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 {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.
    • ImportString supports the SXC format.

    Elements

    • 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 "Data" 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 {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.

    Options

    • Import option:
    • "EmptyField"""how empty cells are represented in the Wolfram Language

    Examples

    Basic Examples  (1)

    In[1]:=
    Click for copyable input
    Out[1]//TableForm=
    In[2]:=
    Click for copyable input
    Out[2]=
    Introduced in 2007
    (6.0)