Re: How to solve this simple equation?
- To: mathgroup at smc.vnet.net
- Subject: [mg87891] Re: How to solve this simple equation?
- From: "Jean-Marc Gulliet" <jeanmarc.gulliet at gmail.com>
- Date: Sat, 19 Apr 2008 03:36:52 -0400 (EDT)
- References: <fu1tvq$oi8$1@smc.vnet.net> <4804BF81.7000405@gmail.com>
On Fri, Apr 18, 2008 at 9:04 AM, Dino de Blasio <dinodeblasio at gmail.com> wrote:
> I have also an other question for you:
As a rule of thumb, it is usually better to ask questions directly to
the newsgroup MathGroup.
> How to import a column from excel 2007 in data format for mathematica?
> For example if I have:
> column1 = a b c d e f g h
>
> how I can obtain:
> data = {a,b,c,d,e,f,g,h}
> in mathematica?
AFAIK, Mathematica does not handle Microsoft Excel 2007 file format
yet. So use an XLS or CSV file format, for instance.
Assuming a file saved in XLS format that contains one sheet of 3 rows
by 4 columns, you can use Inport[] as follow:
In[145]:= imp = Import["Workbook1.xls"]
Out[145]= {{{11., 21., 31.}, {12., 22., 32.}, {13., 23., 33.}, {14.,
24., 34.}}}
In[155]:= data = Transpose[Sequence @@ imp][[1]]
Out[155]= {11., 12., 13., 14.}
Regards,
--
Jean-Marc