Re: import table in mathematica

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

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