SXC (.sxc)

Background & Context

    • 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

  • 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 following reference pages for full general information:
  • Importimport from a file
    CloudImportimport from a cloud object
    ImportStringimport from a string
    ImportByteArrayimport from a byte array

Import Elements

  • General Import elements:
  • "Elements" list of elements and options available in this file
    "Summary"summary of the file
    "Rules"list of rules for all available elements
  • Data representation elements:
  • "Data"list of full arrays, representing all sheets
    "Formulas"all SXC formulas as text
    "Tabular"list of Tabular objects, representing all sheets
    "TabularAssociation"association of sheet names and Tabular objects
  • 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

open allclose all

Basic Examples  (2)

Import an SXC sheet and format it as a table:

Summary of an SXC file:

Scope  (1)

List all available elements:

Import Elements  (8)

"Data"  (4)

Import an SXC file as a list of values:

This is also the default element:

Import the first sheet:

Import a single row:

Import a single column:

"Sheets"  (1)

Import the names of the sheets in an SXC file:

"Tabular"  (2)

Import the first sheet of an ODS file as a Tabular object:

Import all sheets as a list of Tabular objects:

"TabularAssociation"  (1)

Import all sheets as an association of sheet names and Tabular objects: