MathGroup Archive 2005

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

Search the Archive

Re: Re: Mathematica 5.0 and Excel


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


  • Prev by Date: Re: A Su Doku solver
  • Next by Date: Re: Beginner: Importing files, maintaining file format.
  • Previous by thread: Re: Mathematica 5.0 and Excel
  • Next by thread: Re: Mathematica 5.0 and Excel