Services & Resources / Wolfram Forums
-----
 /
MathGroup Archive
2005
*January
*February
*March
*April
*May
*June
*July
*August
*September
*October
*November
*December
*Archive Index
*Ask about this page
*Print this page
*Give us feedback
*Sign up for the Wolfram Insider

MathGroup Archive 2005

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

Search the Archive

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/


  • Prev by Date: Re: Mathematica 5.0 and Excel
  • Next by Date: Re: 5.2 Install issues
  • Previous by thread: Re: Mathematica 5.0 and Excel
  • Next by thread: Re: Mathematica 5.0 and Excel