Re: how2 read excel (XLS) file to IDL [message #68321] |
Wed, 21 October 2009 06:07 |
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  |
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  |
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  |
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  |
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  |
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
|
|
|