此为 Mathematica 7 文档,内容基于更早版本的 Wolfram 语言
查看最新文档(版本11.1)
Mathematica HowTo
How to | Export a Spreadsheet
You may want to export data from Mathematica to a spreadsheet. Excel is one example of a common spreadsheet format that Mathematica supports.
This is a selection of examples from the complete 'How to' screencast »
Use Table with two variables to set up a table of values (stored as m):
In[1]:=
Click for copyable input
Out[1]=
To view your data as it will appear in a spreadsheet, display it in TableForm:
In[2]:=
Click for copyable input
Out[2]//TableForm=
Use Export to export the data to Excel format ("XLS") with the file name you specify:
In[3]:=
Click for copyable input
Out[3]=
You can leave out the format if you specify the file extension:
In[4]:=
Click for copyable input
Out[4]=
To make the rows of the spreadsheet appear in columns, and vice versa, use Transpose.
In[5]:=
Click for copyable input
Out[5]=
    
Mathematica also allows you to export data to multiple individual spreadsheets in a single Excel file.
Set up some more data to export and display it in TableForm:
In[6]:=
Click for copyable input
Out[6]=
In[7]:=
Click for copyable input
Out[7]//TableForm=
Place the datasets in a list to export them to separate spreadsheets in a single Excel file:
In[8]:=
Click for copyable input
Out[8]=
The sheets are by default named Sheet1 and Sheet2. You can also specify the names of the sheets:
In[9]:=
Click for copyable input
Out[9]=
Use Export to move transposed data to separate, named sheets:
In[10]:=
Click for copyable input
Out[10]=