Services & Resources / Wolfram Forums
MathGroup Archive
*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
  • Subject: [mg60619] Re: Mathematica 5.0 and Excel
  • From: Peter Pein <petsie at>
  • Date: Thu, 22 Sep 2005 02:08:13 -0400 (EDT)
  • References: <dgr33d$8df$>
  • Sender: owner-wri-mathgroup at

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

Hope, this hint helps,

Peter Pein, Berlin
GnuPG Key ID: 0xA34C5A82

  • 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