import table in mathematica

[sabbri]

suppose that i have a table in excel where i hed stored a matrix of
observations. how can I import it in Mathematica ???

[John C. Erb, Ph.D.]

You can buy Mathlink for Excel from Wolfram which will
allow you to cut & paste data between Excel and Mathematica.
I have it and it works fairly well.

You can save the data to a CSV (or other format) file in Excel
and import it into Mathematica.

I have written my own package to facilitate transferring 2D table
data which uses a space delimited format for saving and importing
data files between Excel and Mathematica.

John C. Erb
Email: John_...@prodigy.net

[Bill Rowe]

On 2/2/04 at 5:20 AM, sabrinac...@hotmail.com (sabbri) wrote:

>suppose that i have a table in excel where i hed stored a matrix of
>observations. how can I import it in Mathematica ???

There are a number of ways to achieve this

If all of the observations are numeric a very efficient way would be to save the observations to a tab delimited file then use ReadList[filename, Number, RecordLists->True] to read the data into Mathematica.

Alternatively, you could use Import[filename. "Table"] to read the data file. Import works slower than ReadList but is more convienent if the observations are not all numeric.

Another approach would be to use CopyPasteTools palatte created by Ken Kikuchi available on Wolfram's math resource web site. Using this palette, all you need do is highlight the desired data in Excel, copy it to the clipboard then click on the appropriate palette button in Mathematica. This solution is pretty convienent for reasonable amounts of data.

Finally, I've also seen a Mathematica package that enabled you to work directly with an Excel file in Mathematica. I don't recall where I saw this package, but doing a Google search on Excel coupled with Mathematica ought to find it.
--
To reply via email subtract one hundred and four

[Bobby R. Treat]

>>Mathlink for Excel from Wolfram ... works fairly well

>>I have written my own package to facilitate transferring 2D table data

That's not a ringing endorsement for the Wolfram package, folks.

Bobby

"John C. Erb, Ph.D." <John_...@prodigy.net> wrote in message news:<bvnm1i$h58$1...@smc.vnet.net>...