WOLFRAM

Wolfram Language & System Documentation Center

SXC (.sxc)

  • Import fully supports the SXC format.

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
  • Basic information element:
  • "Dimensions"association of sheet names and sheet dimensions
    "SheetCount"number of sheets
    "Sheets"list of sheet names
  • Data representation elements:
  • "Data"list of full arrays, representing all sheets
    "EventSeries"table data as an EventSeries
    "Formulas"all SXC formulas as text
    "Tabular"list of Tabular objects, representing all sheets
    "TabularAssociation"association of sheet names and Tabular objects
    "TimeSeries"table data as a TimeSeries
  • 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",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
    "HeaderLines"Automaticnumber of lines to assume as headers
    "SkipLines"Automaticnumber of lines to skip at the beginning of the file
    "TimeColumn"Automaticcolumn to use for times in "EventSeries" and "TimeSeries" elements

Examples

open all close all

Basic Examples  (2)

Import an SXC sheet and format it as a table:

Wolfram Language code: First@Import["ExampleData/mountains.sxc"]//TableForm

Summary of an SXC file:

Wolfram Language code: Import["ExampleData/mountains.sxc", "Summary"]

Scope  (1)

List all available elements:

Wolfram Language code: Import["ExampleData/mountains.sxc", "Elements"]

Import Elements  (10)

"Data"  (4)

Import an SXC file as a list of values:

Wolfram Language code: Import["ExampleData/mountains.sxc", "Data"]

This is also the default element:

Wolfram Language code: Import["ExampleData/mountains.sxc"]

Import the first sheet:

Wolfram Language code: Import["ExampleData/mountains.sxc", {"Data", 1}]

Import a single row:

Wolfram Language code: Import["ExampleData/mountains.sxc", {"Data", 1, 2}]

Import a single column:

Wolfram Language code: Import["ExampleData/mountains.sxc", {"Data", 1, All, 2}]

"EventSeries"  (1)

Import the first sheet of an SXC file as an EventSeries:

Wolfram Language code: Import["ExampleData/mountains.sxc", {"EventSeries", 1}]

"Sheets"  (1)

Import the names of the sheets in an SXC file:

Wolfram Language code: Import["ExampleData/mountains.sxc", "Sheets"]

"Tabular"  (2)

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

Wolfram Language code: Import["ExampleData/mountains.sxc", {"Tabular", 1}]

Import all sheets as a list of Tabular objects:

Wolfram Language code: Import["ExampleData/mountains.sxc", "Tabular"]

"TabularAssociation"  (1)

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

Wolfram Language code: Import["ExampleData/mountains.sxc", "TabularAssociation"]

"TimeSeries"  (1)

Import the first sheet of an SXC file as a TimeSeries:

Wolfram Language code: Import["ExampleData/mountains.sxc", {"TimeSeries", 1}]

Import Options  (3)

"HeaderLines"  (1)

The header line is automatically detected by default:

Wolfram Language code: Import["ExampleData/mountains.sxc", {"Tabular", 2}]

Use "HeaderLines" option when automatic header detection is incorrect:

Wolfram Language code: Import["ExampleData/mountains.sxc", {"Tabular", 2}, "HeaderLines" -> 1 ]

Specify row and column headers:

Wolfram Language code: Import["ExampleData/mountains.sxc", {"Tabular", 1}, "HeaderLines" -> {1, 1}]

"SkipLines"  (1)

By default, all lines are imported:

Wolfram Language code: Import["ExampleData/mountains.sxc", {"Tabular", 2}]

Skip the first line:

Wolfram Language code: Import["ExampleData/mountains.sxc", {"Tabular", 2}, "SkipLines" -> 1]

"TimeColumn"  (1)

By default, the time column is selected automatically for "TimeSeries" and "EventSeries" elements:

Wolfram Language code: Import["ExampleData/mountains.sxc", {"TimeSeries", 1}]

Use the "TimeColumn" option to specify the time column:

Wolfram Language code: Import["ExampleData/mountains.sxc", {"TimeSeries", 1}, "TimeColumn" -> "Height"]