Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.soft-sys.math.mathematica > #10609

Re: How to make Excel import symbolically

From Tomas Garza <tgarza10@msn.com>
Newsgroups comp.soft-sys.math.mathematica
Subject Re: How to make Excel import symbolically
Date 2012-06-23 08:22 +0000
Organization Steven M. Christensen and Associates, Inc and MathTensor, Inc.
Message-ID <js3ube$ur$1@smc.vnet.net> (permalink)
References <201206220702.DAA20965@smc.vnet.net>

Show all headers | View raw


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@yahoo.se
> Subject: How to make Excel import symbolically
> To: mathgroup@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
>

Back to comp.soft-sys.math.mathematica | Previous | Next | Find similar | Unroll thread


Thread

Re: How to make Excel import symbolically Tomas Garza <tgarza10@msn.com> - 2012-06-23 08:22 +0000

csiph-web