Thank you John:
 
I have exported the excel file in csv format and imported as you showed me. When I try to create a plot with the command: plot(a[isfinite(b)],b[isfinite(b)]), I get an error message: index should be int. When I look at the second column from the csv file I see that the values are imported like '23.5' and not like 23.5 and this causes that error. How can I imported the values from all columns without ''
 
Ionut
 
----- Original Message ----
From: John Hunter <jdh2358@gmail.com>
To: sandric ionut <sandricionut@yahoo.com>
Cc: Darren Dale <dsdale24@gmail.com>; Matplotlib <matplotlib-users@lists.sourceforge.net>
Sent: Saturday, June 28, 2008 5:19:42 PM
Subject: Re: [Matplotlib-users] plot xy data with missing values

On Sat, Jun 28, 2008 at 9:16 AM, sandric ionut <sandricionut@yahoo.com> wrote:
> Thank you Darren:
>
> The second example is what I need. I have made some test and it looks OK
> I have my data in excel. How can I read from excel files? Is it a special
> tool?

If you save as csv, you can use matplotlib.mlab.csv2rec to get your
data back as a record array.  See

http://matplotlib.sourceforge.net/examples/pylab_examples/loadrec.py

JDH