XLS (.xls)

• Import supports XLS files created by Excel 95, 97, 2000, XP, and 2003.

• Export creates files compatible with the Excel 2000 standard.

IMPORT 与 EXPORT

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

• Export exports an array or a list of arrays to XLS.

• Import and Export also handle embedded images.

• Import["file.xls"] returns the sheets of an XLS file as an expression of the form where the are full arrays containing numerical and textual data, Boolean values, and date specifications.

• Export["file.xls", expr] creates an XLS 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 XLS file.

• Import imports a subelement.

• Import imports multiple elements.

• The import format can be specified with Import["file", "XLS"] or Import.

• Export creates an XLS 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 XLS 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 XLS formulas as text
	"Images"	embedded images as a list

• Advanced data elements:

"FormattedData"

data with some styling elements applied

• See the reference page for "XLSX" for full documentation.

参见

• "XLSX"  "MDB"  "CSV"  "TSV"

更多关于

• Basic Formats

• Date & Time

• Importing & Exporting

• Importing & Exporting Database Formats

• Listing of All Formats

• Numerical Data

• Statistics

• Tabular & Spreadsheet Formats

范例

关闭所有单元

例   (2)

Import the first sheet of an Excel file:

Export a table to XLS:

Show the Import elements in a file:

Excel stores all numbers using machine precision:

Import the first sheet of the generated file:

Embed graphics in an XLS file:

Export data and formulas:

Export data and formulas using rule syntax:

Import the first sheet of an Excel file: In[1]:= Out[1]//TableForm=   Export a table to XLS: In[1]:= Out[1]= Show the Import elements in a file: In[1]:= Out[1]=   Excel stores all numbers using machine precision: In[1]:= Out[1]= Import the first sheet of the generated file: In[2]:= Out[2]=   Embed graphics in an XLS file: In[1]:= Out[1]= In[2]:= Out[2]= In[3]:= Out[3]=   Export data and formulas: In[1]:= In[2]:= In[3]:= Out[3]= Export data and formulas using rule syntax: In[4]:= Out[4]=