Mathematica 9 is now available
Services & Resources / Wolfram Forums / MathGroup Archive
-----

MathGroup Archive 2012

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

Search the Archive

Re: How to make Excel import symbolically

  • To: mathgroup at smc.vnet.net
  • Subject: [mg127003] Re: How to make Excel import symbolically
  • From: Tomas Garza <tgarza10 at msn.com>
  • Date: Sat, 23 Jun 2012 04:15:04 -0400 (EDT)
  • Delivered-to: l-mathgroup@mail-archive0.wolfram.com
  • References: <201206220702.DAA20965@smc.vnet.net>

Quick inspection of the output from Import reveals it is a list with only one element, namely the matrix you want.
Try
{{{aa,bb},{cc,dd}}}[[1]]
to obtain the matrix.
-Tomas

> Date: Fri, 22 Jun 2012 03:02:36 -0400
> From: matti_overmark at yahoo.se
> Subject: How to make Excel import symbolically
> To: mathgroup at smc.vnet.net
>
> Hi!
> I am new to Mathematica 8 Home (Win 7 64) so I would be grateful for some help.
>
> I am trying to import a matrix symbolically from Excel 2010 so that I can manipulate it further on.
>
> I.e in Excel
> aa  bb
> cc  dd
>
> When I use the Import command I get
>
> {{{aa, bb},{cc, dd}}}
>
> This is not an matrix, it's something else (I don't know what).
>
> 1. Can I import the symbolic matrix in one operation? or
> 2. Can I transform the {{{...}}} to a {{...}}?
>
> TIA Matti
>



  • Prev by Date: Re: How to make Excel import symbolically
  • Next by Date: Error estimates in the Gauss-Kronrod rule
  • Previous by thread: Re: How to make Excel import symbolically
  • Next by thread: Re: How to make Excel import symbolically