Re: TableForm
- To: mathgroup at smc.vnet.net
- Subject: [mg24179] Re: TableForm
- From: Brian Higgins <bghiggins at ucdavis.edu>
- Date: Wed, 28 Jun 2000 22:50:59 -0400 (EDT)
- References: <8jc7cu$djv@smc.vnet.net>
- Sender: owner-wri-mathgroup at wolfram.com
Jose,
Instead of cut and paste, consider using the Export command.
Here are some steps:
SetDirectory["the path to a suitable directory"]
(A simple way to find the path is to evaluate
Experimental`FileBrowse[False]
This brings up a dialog window. Pick a particular file in a directory
you want to export to and click on the Open button. The path to that
file will be pasted in the notebook at the insertion point. Strip of the
file name and paste the path into SetDirectory, and evaluate)
Suppose your table is
In[89]:=myTable = TableForm[Table[{x, Sin[x]}, {x, 0, 4, 0.2}]];
In[90]:=Export["myTable.txt", myTable, "Table"]
Out[90]="myTable.txt"
The file myTable.txt will be pasted into the directory you selected
above. Fire up Excel and open up the file myTable.txt. A text import
wizard dialog box will appear . Click on the Fixed width radio
button. The dialog box will show the data separated in columns.
You now have the option to adjust the field width if you desire.
Otherwise, click on the Next button and the next option allows you
to modify the format of your data if you so desire. Finally click on
Finish and vola you data is in an Excel spread sheet.
Cheers,
Brian
In article <8jc7cu$djv at smc.vnet.net>,
"Jose D. Flores" <jflores at usd.edu> wrote:
> When using the command Table followed by TableForm, is there
any way to
> do cut and paste to other document like Excel?
>
> Jose D. Flores
> jflores at usd.edu
>
>
Sent via Deja.com http://www.deja.com/
Before you buy.