Re: Please add me to this group

• To: mathgroup at smc.vnet.net
• Subject: [mg117115] Re: Please add me to this group
• From: "Kevin J. McCann" <Kevin.McCann at umbc.edu>
• Date: Thu, 10 Mar 2011 06:08:37 -0500 (EST)
• References: <il7qbb\$duc\$1@smc.vnet.net>

```A bit more transparent is

column1 = allData[[All,1]];
column2 = allData[[All,2]];

etc.

Kevin

On 3/9/2011 7:03 AM, Michael Stern wrote:
> You will probably get a lot of answers to this. In the simplest case,
> save your mathematica notebook into the same directory where your excel
>
> You can then use something like the following to load the entire workbook:
>
> allData = Import[NotebookDirectory[]<>  "data.xlsx", "Data"]
>
> And can extract each column with something like
>
> column1 = Transpose[allData[[1]]][[1]]
>
> column2 = Transpose[allData[[1]]][[2]]
>
> Cheers,
>
> Michael
>
>
>
> On 3/8/2011 5:32 AM, 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: Gotcha?
• Next by Date: Re: How to kill slave kernel securely?
• Previous by thread: Re: Please add me to this group
• Next by thread: two figures on same axes with different scales