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


  • 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