MathGroup Archive 2005

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

Search the Archive

Re: Re: Mathematica 5.0 and Excel

  • To: mathgroup at
  • Subject: [mg60672] Re: [mg60625] Re: Mathematica 5.0 and Excel
  • From: Chris Chiasson <chris.chiasson at>
  • Date: Fri, 23 Sep 2005 04:20:42 -0400 (EDT)
  • References: <>
  • Reply-to: Chris Chiasson <chris.chiasson at>
  • Sender: owner-wri-mathgroup at

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> wrote:
> 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
> 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

  • 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