MathGroup Archive 2008

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

Search the Archive

Re: How to solve this simple equation?

On Fri, Apr 18, 2008 at 9:04 AM, Dino de Blasio <dinodeblasio at> 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.}


  • Prev by Date: Re: Indefinite numbers of arguments in a function
  • Next by Date: Re: Defining derivatives
  • Previous by thread: Re: How to solve this simple equation?
  • Next by thread: Re: How to solve this simple equation?