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

Home » Public Forums » archive » Re: how2 read excel (XLS) file to IDL
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: how2 read excel (XLS) file to IDL [message #68321] Wed, 21 October 2009 06:07
d.poreh is currently offline  d.poreh
Messages: 406
Registered: October 2007
Senior Member
On 20 Okt., 07:39, Haje Korth <hajeko...@gmail.com> wrote:
> Go to User Community -> Code Library and search for Excel. Fourth item
> from the top is IDL64_Read_Excel11.zip. Not that hard...
>
> On Oct 20, 9:37 am, Dav_Poreh <d.po...@gmail.com> wrote:
>
>
>
>> Thanks
>> Will you please give the routine's name? I could not find in ITTVIS
>> web site.
>> Cheers
>
>> On 20 Okt., 05:24, Haje Korth <hajeko...@gmail.com> wrote:
>
>>> There is a routine at the IDL codebank for this. I have used it and it
>>> works well. Check the ITTVIS web site.
>
>>> Haje
>
>>> On Oct 20, 2:40 am, Dav_Poreh <d.po...@gmail.com> wrote:
>
>>>> Folks
>>>> i want to read excel file to some IDL Widgets. is there any way to
>>>> read XLS files, exactly like TXT file to Widgets?
>>>> any help higly apriciated.
>>>> Cheers

Thanks Guys
Re: how2 read excel (XLS) file to IDL [message #68332 is a reply to message #68321] Tue, 20 October 2009 07:39 Go to previous message
Haje Korth is currently offline  Haje Korth
Messages: 651
Registered: May 1997
Senior Member
Go to User Community -> Code Library and search for Excel. Fourth item
from the top is IDL64_Read_Excel11.zip. Not that hard...


On Oct 20, 9:37 am, Dav_Poreh <d.po...@gmail.com> wrote:
> Thanks
> Will you please give the routine's name? I could not find in ITTVIS
> web site.
> Cheers
>
> On 20 Okt., 05:24, Haje Korth <hajeko...@gmail.com> wrote:
>
>> There is a routine at the IDL codebank for this. I have used it and it
>> works well. Check the ITTVIS web site.
>
>> Haje
>
>> On Oct 20, 2:40 am, Dav_Poreh <d.po...@gmail.com> wrote:
>
>>> Folks
>>> i want to read excel file to some IDL Widgets. is there any way to
>>> read XLS files, exactly like TXT file to Widgets?
>>> any help higly apriciated.
>>> Cheers
>
>
Re: how2 read excel (XLS) file to IDL [message #68336 is a reply to message #68332] Tue, 20 October 2009 07:08 Go to previous message
penteado is currently offline  penteado
Messages: 866
Registered: February 2018
Senior Member
Administrator
On Oct 20, 7:23 am, maurya <ramaury...@gmail.com> wrote:
> On 20 Oct, 11:40, Dav_Poreh <d.po...@gmail.com> wrote:
>
>> Folks
>> i want to read excel file to some IDL Widgets. is there any way to
>> read XLS files, exactly like TXT file to Widgets?
>> any help higly apriciated.
>> Cheers
>
> I don't know any function/routine to read an excel file like a text
> file. However, you can read the excel data from excel file by
> converting your excel file to a text file. You can read the same text
> file using read_ascii.pro (or rd_ascii.pro). There are many options to
> read different fields in your text file.
>
> Cheers

There are also read_csv and query_csv, starting in IDL 7.1.
Re: how2 read excel (XLS) file to IDL [message #68341 is a reply to message #68336] Tue, 20 October 2009 06:37 Go to previous message
d.poreh is currently offline  d.poreh
Messages: 406
Registered: October 2007
Senior Member
Thanks
Will you please give the routine's name? I could not find in ITTVIS
web site.
Cheers



On 20 Okt., 05:24, Haje Korth <hajeko...@gmail.com> wrote:
> There is a routine at the IDL codebank for this. I have used it and it
> works well. Check the ITTVIS web site.
>
> Haje
>
> On Oct 20, 2:40 am, Dav_Poreh <d.po...@gmail.com> wrote:
>
>
>
>> Folks
>> i want to read excel file to some IDL Widgets. is there any way to
>> read XLS files, exactly like TXT file to Widgets?
>> any help higly apriciated.
>> Cheers
Re: how2 read excel (XLS) file to IDL [message #68345 is a reply to message #68341] Tue, 20 October 2009 05:24 Go to previous message
Haje Korth is currently offline  Haje Korth
Messages: 651
Registered: May 1997
Senior Member
There is a routine at the IDL codebank for this. I have used it and it
works well. Check the ITTVIS web site.

Haje

On Oct 20, 2:40 am, Dav_Poreh <d.po...@gmail.com> wrote:
> Folks
> i want to read excel file to some IDL Widgets. is there any way to
> read XLS files, exactly like TXT file to Widgets?
> any help higly apriciated.
> Cheers
Re: how2 read excel (XLS) file to IDL [message #68347 is a reply to message #68345] Tue, 20 October 2009 02:23 Go to previous message
maurya is currently offline  maurya
Messages: 16
Registered: February 2009
Junior Member
On 20 Oct, 11:40, Dav_Poreh <d.po...@gmail.com> wrote:
> Folks
> i want to read excel file to some IDL Widgets. is there any way to
> read XLS files, exactly like TXT file to Widgets?
> any help higly apriciated.
> Cheers

I don't know any function/routine to read an excel file like a text
file. However, you can read the excel data from excel file by
converting your excel file to a text file. You can read the same text
file using read_ascii.pro (or rd_ascii.pro). There are many options to
read different fields in your text file.

Cheers
  Switch to threaded view of this topic Create a new topic Submit Reply
Previous Topic: log plot
Next Topic: Database of World's Administrative Areas

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

Current Time: Wed Oct 08 19:24:41 PDT 2025

Total time taken to generate the page: 0.00596 seconds