comp.lang.idl-pvwave archive
Messages from Usenet group comp.lang.idl-pvwave, compiled by Paulo Penteado

Home » Public Forums » archive » Re: Reading excel file in IDL and plotting data on a continent.
Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend 
Switch to threaded view of this topic Create a new topic Submit Reply
Re: Reading excel file in IDL and plotting data on a continent. [message #79026] Tue, 24 January 2012 07:07
Russell[1] is currently offline  Russell[1]
Messages: 101
Registered: August 2011
Senior Member
First thing --- someone has written an excel reader for IDL. I've
never used it, but you can download it from ITT's code bank. Go to
http://www.exelisvis.com/UserCommunity/CodeLibrary.aspx
and put into the name of the file in the search box. It's called:
IDL64_Read_Excel11.zip.

Second thing --- I'm not sure about isurface (I rarely use anything
with an i prefix), but I do know that contour expects you to give it a
two dimensional image, not two one-dimensional vectors. So what to do
next depends on what data you're reading in from excel (not that place
you read it from makes any difference whatsoever). If you're reading
something like lat and lon, then there must be some other quantity
that is the 'Z-dimension', such as elevation or average temperature.
Or if it's a series of counts, then you might consider making it a two-
dimensional histogram (see hist_2d.pro).

Russell


On Jan 24, 5:01 am, shambhu <shambhu.mc...@gmail.com> wrote:
> I read data, by converting excel file to CSV, using READ_ASCII macros.
> But when i used isurface or contour to plot on a earth's surface,
> showing error " Must be of two dimensions ". Is there any other way to
> plot and read the excel files directly...?
Re: Reading excel file in IDL and plotting data on a continent. [message #79027 is a reply to message #79026] Tue, 24 January 2012 02:01 Go to previous message
shambhu is currently offline  shambhu
Messages: 41
Registered: December 2011
Member
I read data, by converting excel file to CSV, using READ_ASCII macros.
But when i used isurface or contour to plot on a earth's surface,
showing error " Must be of two dimensions ". Is there any other way to
plot and read the excel files directly...?
  Switch to threaded view of this topic Create a new topic Submit Reply
Previous Topic: Reading excel file in IDL and plotting data on a continent.
Next Topic: mapping/interpolation from one irregular grid to another (different) irregular grid.

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ] [ PDF ]

Current Time: Wed Oct 08 13:40:26 PDT 2025

Total time taken to generate the page: 0.00566 seconds