• To: mathgroup at smc.vnet.net
• From: David Annetts <david.annetts at iinet.net.au>
• 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
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
SetDirectory@NotebookDirectory[];
excelData = Import["My Excel stuff.xls"];

D.

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.