Re: Re: Mathematica 5.0 and Excel
- To: mathgroup at smc.vnet.net
- Subject: [mg60672] Re: [mg60625] Re: Mathematica 5.0 and Excel
- From: Chris Chiasson <chris.chiasson at gmail.com>
- Date: Fri, 23 Sep 2005 04:20:42 -0400 (EDT)
- References: <200509220608.CAA01900@smc.vnet.net>
- Reply-to: Chris Chiasson <chris.chiasson at gmail.com>
- Sender: owner-wri-mathgroup at wolfram.com
Is it just me, or did one of the older 4.x versions have an Import command that worked with xls files? On 9/22/05, Bill Rowe <readnewsciv at earthlink.net> wrote: > On 9/21/05 at 3:20 AM, steevebrechmann at yahoo.ca (Steeve Brechmann > (schumi)) wrote: > > > >I need to import some matrix in excel to mathematica. I have try to > >save my excel files in CSV but the result, when i import this file > >to mathematica isn't what i want. > > >How can i import some data from Excel to Mathematica ? > > What are you doing when you say you don't get what you want when you import the CSV files? What do you get? What are you expecting? > > You should be able to import CSV files created by Excel using > > Import[filename,"CSV"] > > Alternatively, with the current version of Mathematica you could import the Excel file directly by doing > > Import[filename, "XLS"] > > Finally, if there is only numeric data in the file, saving the file from Excel as a tab delimited file rather than comma delimited would allow usage of > > ReadList[filename, Number, RecordLists->True] > > Which will be faster than usage of Import. > -- > To reply via email subtract one hundred and four > > -- Chris Chiasson http://chrischiasson.com/contact/chris_chiasson
- References:
- Re: Mathematica 5.0 and Excel
- From: Bill Rowe <readnewsciv@earthlink.net>
- Re: Mathematica 5.0 and Excel