Re: Please add me to this group
- To: mathgroup at smc.vnet.net
- Subject: [mg117056] Re: Please add me to this group
- 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
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
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