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):
| Out[1]= |  |
To view your data as it will appear in a spreadsheet, display it in
TableForm:
Out[2]//TableForm= |
| |  |
Use
Export to export the data to Excel format (
"XLS") with the file name you specify:
| Out[3]= |  |
You can leave out the format if you specify the file extension:
| Out[4]= |  |
To make the rows of the spreadsheet appear in columns, and vice versa, use
Transpose.
| 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:
| Out[6]= |  |
Out[7]//TableForm= |
| |  |
Place the datasets in a list to export them to separate spreadsheets in a single Excel file:
| Out[8]= |  |
The sheets are by default named Sheet1 and Sheet2. You can also specify the names of the sheets:
| Out[9]= |  |
Use
Export to move transposed data to separate, named sheets:
| Out[10]= |  |
