MathGroup Archive 2004

[Date Index] [Thread Index] [Author Index]

Search the Archive

Re: import table in mathematica

  • To: mathgroup at
  • Subject: [mg46035] Re: import table in mathematica
  • From: Bill Rowe <readnewsciv at>
  • Date: Tue, 3 Feb 2004 03:21:12 -0500 (EST)
  • Sender: owner-wri-mathgroup at

On 2/2/04 at 5:20 AM, sabrinacasagrande at (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

  • Prev by Date: RE: Simple Differentiation?
  • Next by Date: Re: Simplifying a second order eq. system
  • Previous by thread: RE: import table in mathematica
  • Next by thread: Re: import table in mathematica