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. »
with two variables to set up a table of values (stored as
To view your data as it will appear in a spreadsheet, display it in TableForm
to export the data to Excel format ("XLS"
) with the file name you specify:
You can leave out the format if you specify the file extension:
To view your spreadsheet, open the file with Excel or any other compatible spreadsheet program.
To make the rows of the spreadsheet appear in columns, and vice versa, use Transpose
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
Place the datasets in a list to export them to separate spreadsheets in a single Excel file:
The sheets are by default named Sheet1 and Sheet2. You can also specify the names of the sheets:
to move transposed data to separate, named sheets: