Mathematica 9 is now available
Services & Resources / Wolfram Forums
-----
 /
MathGroup Archive
2005
*January
*February
*March
*April
*May
*June
*July
*August
*September
*October
*November
*December
*Archive Index
*Ask about this page
*Print this page
*Give us feedback
*Sign up for the Wolfram Insider

MathGroup Archive 2005

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

Search the Archive

Re: Mathematica 5.0 and Excel

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

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


  • 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