Mathematica 9 is now available

THIS IS DOCUMENTATION FOR AN OBSOLETE PRODUCT.
SEE THE DOCUMENTATION CENTER FOR THE LATEST INFORMATION.

DOCUMENTATION CENTER SEARCH

New to Mathematica? Find your learning path »

Mathematica > Data Manipulation > Importing and Exporting > XLSX (.xlsx) >

MATHEMATICA IMPORT/EXPORT FORMAT

See Also »|More About »

XLSX (.xlsx)

Registered MIME type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Microsoft Excel spreadsheet file.
Standard format of Excel 2007 and higher.
Also known as Office Open XML.
XLSX is an acronym derived from Excel Spreadsheet.
XML-based file bundle.
Stores data, formulas, and graphics.

Import and Export are fully compatible with the Excel 2007 standard.

IMPORT AND EXPORT

Import imports all sheets of an XLSX file, returning the result as a list of arrays.

Export exports an array or a list of arrays to XLSX.

Import and Export also handle embedded images.

Import returns the sheets of an XLSX file as an expression of the form , where the are full arrays containing numerical and textual data, Boolean values, and date specifications.

Export creates an XLSX file from array data.

The following expression types are supported by Export: Column, Grid, List, MatrixForm, Row, SparseArray, and TableForm.

Import imports the specified element from an XLSX file.

Import imports a subelement.

Import imports multiple elements.

The import format can be specified with Import or Import.

Export creates an XLSX file by treating expr as specifying element elem.

Export treats each as specifying the corresponding .

Export exports expr with the specified option elements taken to have the specified values.

Export uses rules to specify the elements to be exported.

See the reference pages for full general information on Import and Export.

ImportString and ExportString support the XLSX format.

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 formulas as text
	"Images"	embedded images as a list

Advanced data elements:

"FormattedData"

data with some styling elements applied

Import and Export by default use the element.

XLSX data is represented in Mathematica by real or integer numbers, strings, Boolean values True and False, and DateList specifications.

XLSX error cells are imported as $Failed.

Import gives the Excel formulas for each cell in the form , where the are arrays corresponding to the sheets of an XLSX file.

Importing parts of a data sheet:

	"Data",k	the k sheet, given as an array
	"Data",k,m	row m of the k sheet
	"Data",k,m,n	cell of the k sheet

Import 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",name	sheet name as an array
	"Sheets",name,m	row m of sheet name
	"Sheets",name,m,n	cell in sheet name

Import yields spreadsheets as full rectangular arrays.

Export supports full and ragged arrays.

Import and Export option:

"EmptyField"

""

how empty cells are represented in Mathematica

Export option:

"ImageFormat"

"JPEG"

format used for exporting images

"XLS" "MDB" "CSV" "TSV"

Basic Formats

Date & Time

Importing & Exporting

Importing & Exporting Database Formats

Listing of All Formats

Numerical Data

Statistics

Tabular & Spreadsheet Formats

Basic Examples (4)

Import the first sheet of an XLSX file:

Import an embedded image from an XLSX file:

Export the first 12 prime numbers to a spreadsheet:

Export data again with a header row:

Export two datasets to different sheets:

Show the Import elements in a file:

Specify sheet names:

Import the cell at row 1, column 4, for a given sheet:

Import the second sheet:

Export and import hyperlinks:

Export date and date-time stamps:

Import converts the dates into the DateList form:

Export raster images to XLSX (automatically rasterizing vector graphics):

Import returns a list of images:

Raw bytes representing common image file formats can also be exported as images to XLSX:

Import the first sheet of an XLSX file:

Out[1]=

Import an embedded image from an XLSX file:

Out[1]=

Export the first 12 prime numbers to a spreadsheet:

Out[1]=

Export data again with a header row:

Out[2]=

Export two datasets to different sheets:

Out[2]=

Show the Import elements in a file:

Out[1]=

Specify sheet names:

Out[1]=

Import the cell at row 1, column 4, for a given sheet:

Out[2]=

Import the second sheet:

Out[3]=

Export and import hyperlinks:

Out[1]=

Out[2]=

Export date and date-time stamps:

Out[1]=

Import converts the dates into the DateList form:

Out[2]=

Export raster images to XLSX (automatically rasterizing vector graphics):

Click for copyable input

Out[1]=

Import returns a list of images:

Out[2]=

Raw bytes representing common image file formats can also be exported as images to XLSX:

Out[1]=

How to: Export a Spreadsheet

Ask a question about this page | Suggest an improvement | Leave a message for the team

Format: HTML | CDF