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


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

Re: How to make Excel import symbolically

From Sseziwa Mukasa <mukasa@gmail.com>
Newsgroups comp.soft-sys.math.mathematica
Subject Re: How to make Excel import symbolically
Date 2012-06-23 08:21 +0000
Organization Steven M. Christensen and Associates, Inc and MathTensor, Inc.
Message-ID <js3u9h$ug$1@smc.vnet.net> (permalink)
References <201206220702.DAA20965@smc.vnet.net>

Show all headers | View raw


Two options:

mat = Import[...][[1]]

or

mat = Flatten[Import[...],1]

Regards,
	Sseziwa

On Jun 22, 2012, at 3:02 AM, Matti wrote:

> 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 Sseziwa Mukasa <mukasa@gmail.com> - 2012-06-23 08:21 +0000

csiph-web