Re: Mathematica 5.0 and Excel
- To: mathgroup at smc.vnet.net
- Subject: [mg60619] Re: Mathematica 5.0 and Excel
- From: Peter Pein <petsie at dordos.net>
- Date: Thu, 22 Sep 2005 02:08:13 -0400 (EDT)
- References: <dgr33d$8df$1@smc.vnet.net>
- Sender: owner-wri-mathgroup at wolfram.com
Steeve Brechmann (schumi) schrieb:
> Hi everyone,
>
> I need to import some matrix in excel to mathematica. I have try to save my excel files in CSV but the result, when i import this file to mathematica isn't what i want.
>
> How can i import some data from Excel to Mathematica ?
>
> Thanks for your help.
>
> Steeve Brechmann
>
>
Hi Steeve,
don't know much about Excel, but OpenOffice saves .csv files as a list
comma seperated list of *strings*. Additionally we use in Germany the
"," as decimal point. So I have to convert the imported file-contents:
In[1]:= zufall = Import["temp.csv", "CSV",
ConversionOptions -> {"NumberPoint" -> ","}];
and now I can use the 8x8 array as usual:
In[2]:= Plus @@ Flatten @ zufall] / Times @@ Dimensions @ zufall
Out[2]=
0.49825710699789416
Hope, this hint helps,
Peter
--
Peter Pein, Berlin
GnuPG Key ID: 0xA34C5A82
http://people.freenet.de/Peter_Berlin/