MathGroup Archive 2005

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

Search the Archive

Re: Mathematica 5.0 and Excel

  • To: mathgroup at
  • Subject: [mg60625] Re: Mathematica 5.0 and Excel
  • From: Bill Rowe <readnewsciv at>
  • Date: Thu, 22 Sep 2005 02:08:20 -0400 (EDT)
  • Sender: owner-wri-mathgroup at

On 9/21/05 at 3:20 AM, steevebrechmann at (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


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

  • Prev by Date: Re: 5.2 Install issues
  • Next by Date: Re: Mathemaica 5.2 are the 64 Bit an illusion !!!....?
  • Previous by thread: Re: Mathematica 5.0 and Excel
  • Next by thread: Re: Re: Mathematica 5.0 and Excel