MathGroup Archive 2011

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

Search the Archive

Re: Please add me to this group

  • To: mathgroup at
  • Subject: [mg117056] Re: Please add me to this group
  • From: David Annetts <david.annetts at>
  • Date: Wed, 9 Mar 2011 06:55:20 -0500 (EST)

Hi Len,

One way is as follows.

1    Open a new Mathematica notebook
2    Go to where the spreadsheet lives on the file system.  In Explorer, 
you can left-click in the location bar at the top.  Ctrl-A to select 
everything, then Ctrl-C to copy it.
3    In your Mathematica notebook, type SetDirectory[].  Paste the location 
between the square brackets.  You'll be asked if you want to convert 
text.  Answer yes.
4    Execute the Mathematica command by typing either Shift-Enter or using the 
enter key on the numeric keypad

You should now be able to read in your Excel data after entering, then 
executing the line

     excelData = Import["My Excel stuff.xls"];

Part of the help can be found at guide/DirectoriesAndDirectoryOperations 
in Mathematica's help centre.

Another way is to
1    create new Mathematica notebook  where the Excel file lives by 
right-clicking in Explorer.
2     open this file by double clicking its icon
3    enter the following
         excelData = Import["My Excel stuff.xls"];


On 8/03/2011 18:32, Len Horton wrote:
> As a new user of Mathematica and as a purchaser of the Home Edition,
> which does not include any support, I am trying to figure out how to
> take data from an Excel spreadsheet into Mathematica to analyze and
> graph.
> I have taken a couple of free seminars on line, but I have not been able
> to figure out how to do just a few basic statistical things.  Each
> column in my spreadsheet is a variable.  In order to produce a histogram
> of one of those variables, I had to open the spreadsheet in Excel, copy
> the column, then paste it into the curly braces inside the Histogram
> function, then eliminate the carriage returns manually while inserting
> commas manually in order to produce the Histogram.  Surely there must be
> a faster way.
> In the first place, I cannot tell where to place the Excel file so that
> Mathematica knows where it is.  Anything you could do to get me started
> would be much appreciated.
> Sincerely,
> Len Horton
> Atlanta

  • Prev by Date: Re: random line in a very large file
  • Next by Date: Re: Weird Position[list,form] behavior when used inside of Module.
  • Previous by thread: Re: Please add me to this group
  • Next by thread: Re: Please add me to this group