comp.lang.idl-pvwave archive: archive » Re: IDL data to Excel sheets?

Home » Public Forums » archive » Re: IDL data to Excel sheets?

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

Re: IDL data to Excel sheets? [message #28371]

Thu, 06 December 2001 12:49

Paul van Delst
Messages: 364
Registered: March 1997

Senior Member

Ted Cary wrote:
>
> Reimar Bauer wrote:
>
>> I believe the only way is to write many ASCII files, but I am a bit
>> surprised
>> why you want to calculate the data by EXCEL if you are able to write Idl
>> functions.
>>
>> If it is because of seeing the data...
>>
>> If it is because of storing the data...
>
> Thanks Reimar,
>
> My employer wants the data in Excel format for both storage and visualization
> reasons. He and most of the students he employs here are already familiar with
> Excel, and he wants the data to be available in Excel workbooks so they can
> immediately start analyzing them without learning any new programs. It makes
> things more difficult for me as the programmer, but the logic is that the learning
> curve is not as steep for other students in the lab.

Heaven forbid that students encounter a steep learning curve.... :o\

I'm still confused tho' - your employer is using *Excel* to visualise/process images?? Is that
right?

paulv

--
Paul van Delst Religious and cultural
CIMSS @ NOAA/NCEP purity is a fundamentalist
Ph: (301)763-8000 x7274 fantasy
Fax:(301)763-8545 V.S.Naipaul

Report message to a moderator

Re: IDL data to Excel sheets? [message #28372 is a reply to message #28371]

Thu, 06 December 2001 11:15

Ted Cary
Messages: 53
Registered: October 2001

Member

Reimar Bauer wrote:

> I believe the only way is to write many ASCII files, but I am a bit
> surprised
> why you want to calculate the data by EXCEL if you are able to write Idl
> functions.
>
> If it is because of seeing the data...
>
> If it is because of storing the data...

Thanks Reimar,

My employer wants the data in Excel format for both storage and visualization
reasons. He and most of the students he employs here are already familiar with
Excel, and he wants the data to be available in Excel workbooks so they can
immediately start analyzing them without learning any new programs. It makes
things more difficult for me as the programmer, but the logic is that the learning
curve is not as steep for other students in the lab. I'd love to use an
IDL-supported format, but everyone likes their Excel.

>
>

Report message to a moderator

Re: IDL data to Excel sheets? [message #28386 is a reply to message #28372]

Thu, 06 December 2001 06:16

R.Bauer
Messages: 1424
Registered: November 1998

Senior Member

Ted Cary wrote:
>
> I am on a Mac, but I'm more familiar with PCs. Currently I am just writing
> text data files for each movie frame and importing them one by one into Excel.
> I was hoping it would be possible to write a multi-sheet.xls file directly.
> I'll look into Do_Apple_Script. Thanks.

I believe the only way is to write many ASCII files, but I am a bit
surprised
why you want to calculate the data by EXCEL if you are able to write Idl
functions.

If it is because of seeing the data in tabulars you can use

f=dist(400)
xvarshow,f
xvarshow,f,/edit (for editing)

If it is because of storing the data you should have a look at hdf or
netCDF.
If you are interested I can give you more examples.

regards

Reimar

>
> Rick Towler wrote:
>
>> I am fairly confident that this is not possible using IDL. There have been
>> a few posts regarding Excel and queries for routines to read/write .xls
>> files that have gone mostly unanswered. Since we have no idea how you are
>> writing data to Excel it is hard to say. If you are on a mac, you could
>> probably do it with "DO_APPLE_SCRIPT" but I have only used ActiveX/VBA on
>> the PC so that's a guess.
>>
>> I really think that it would be far easier and faster to write something in
>> VBA to do this (aka a macro). I'm not a big fan of The Man (tm) but Excel's
>> VBA interface is excellent. Just make sure you install the VBA help files,
>> they aren't installed by default.
>>
>> -Rick
>>
>> "Ted Cary" <tedcary@yahoo.com> wrote in message
>> news:3C0E47BA.E7478F55@yahoo.com...
>>> I wrote an IDL program to acquire data from different frames in an image
>>> sequence (QuickTime Movie). I would like to save the data from each
>>> frame to a different sheet in a a single Microsoft Excel file--one Excel
>>> Workbook for each movie instead of one for each frame. I don't want to
>>> resort to an Excel macro. Does anyone know how to do this from within
>>> IDL? In other words, how do I format data in a file so that Excel will
>>> divide it into sheets?
>>>
>>> Thanks.
>>>

--
Reimar Bauer

Institut fuer Stratosphaerische Chemie (ICG-1)
Forschungszentrum Juelich
email: R.Bauer@fz-juelich.de
http://www.fz-juelich.de/icg/icg1/
============================================================ ======
a IDL library at ForschungsZentrum Juelich
http://www.fz-juelich.de/icg/icg1/idl_icglib/idl_lib_intro.h tml

http://www.fz-juelich.de/zb/text/publikation/juel3786.html
============================================================ ======

read something about linux / windows
http://www.suse.de/de/news/hotnews/MS.html

Report message to a moderator

Re: IDL data to Excel sheets? [message #28404 is a reply to message #28386]

Wed, 05 December 2001 11:40

Ted Cary
Messages: 53
Registered: October 2001

Member

I am on a Mac, but I'm more familiar with PCs. Currently I am just writing
text data files for each movie frame and importing them one by one into Excel.
I was hoping it would be possible to write a multi-sheet.xls file directly.
I'll look into Do_Apple_Script. Thanks.

Rick Towler wrote:

> I am fairly confident that this is not possible using IDL. There have been
> a few posts regarding Excel and queries for routines to read/write .xls
> files that have gone mostly unanswered. Since we have no idea how you are
> writing data to Excel it is hard to say. If you are on a mac, you could
> probably do it with "DO_APPLE_SCRIPT" but I have only used ActiveX/VBA on
> the PC so that's a guess.
>
> I really think that it would be far easier and faster to write something in
> VBA to do this (aka a macro). I'm not a big fan of The Man (tm) but Excel's
> VBA interface is excellent. Just make sure you install the VBA help files,
> they aren't installed by default.
>
> -Rick
>
> "Ted Cary" <tedcary@yahoo.com> wrote in message
> news:3C0E47BA.E7478F55@yahoo.com...
>> I wrote an IDL program to acquire data from different frames in an image
>> sequence (QuickTime Movie). I would like to save the data from each
>> frame to a different sheet in a a single Microsoft Excel file--one Excel
>> Workbook for each movie instead of one for each frame. I don't want to
>> resort to an Excel macro. Does anyone know how to do this from within
>> IDL? In other words, how do I format data in a file so that Excel will
>> divide it into sheets?
>>
>> Thanks.
>>

Report message to a moderator

Re: IDL data to Excel sheets? [message #28405 is a reply to message #28404]

Wed, 05 December 2001 11:39

Rick Towler
Messages: 821
Registered: August 1998

Senior Member

I am fairly confident that this is not possible using IDL. There have been
a few posts regarding Excel and queries for routines to read/write .xls
files that have gone mostly unanswered. Since we have no idea how you are
writing data to Excel it is hard to say. If you are on a mac, you could
probably do it with "DO_APPLE_SCRIPT" but I have only used ActiveX/VBA on
the PC so that's a guess.

I really think that it would be far easier and faster to write something in
VBA to do this (aka a macro). I'm not a big fan of The Man (tm) but Excel's
VBA interface is excellent. Just make sure you install the VBA help files,
they aren't installed by default.

-Rick

"Ted Cary" <tedcary@yahoo.com> wrote in message
news:3C0E47BA.E7478F55@yahoo.com...
> I wrote an IDL program to acquire data from different frames in an image
> sequence (QuickTime Movie). I would like to save the data from each
> frame to a different sheet in a a single Microsoft Excel file--one Excel
> Workbook for each movie instead of one for each frame. I don't want to
> resort to an Excel macro. Does anyone know how to do this from within
> IDL? In other words, how do I format data in a file so that Excel will
> divide it into sheets?
>
> Thanks.
>

Report message to a moderator

Re: IDL data to Excel sheets? [message #28516 is a reply to message #28371]

Thu, 06 December 2001 12:58

jeyadev
Messages: 78
Registered: February 1995

Member

In article <3C0FD9EE.CC1DBCE0@noaa.gov>,
Paul van Delst <paul.vandelst@noaa.gov> wrote:
> Ted Cary wrote:
>>
>> My employer wants the data in Excel format for both storage and visualization
>> reasons. He and most of the students he employs here are already familiar with
>> Excel, and he wants the data to be available in Excel workbooks so they can
>> immediately start analyzing them without learning any new programs. It makes
>> things more difficult for me as the programmer, but the logic is that the learning
>> curve is not as steep for other students in the lab.
>
> Heaven forbid that students encounter a steep learning curve.... :o\
>
> I'm still confused tho' - your employer is using *Excel* to visualise/process images?? Is that
> right?

I think that I can safely conclude that you have not worked in an American
business :-)

> Paul van Delst Religious and cultural
> CIMSS @ NOAA/NCEP purity is a fundamentalist
> Ph: (301)763-8000 x7274 fantasy
> Fax:(301)763-8545 V.S.Naipaul
^^^^^^^^^^^^^^^^^^^^^^^^^

That may explain the above mentioned situation better than I can.

--

Surendar Jeyadev jeyadev@wrc.xerox.com

Report message to a moderator

Re: IDL data to Excel sheets? [message #28518 is a reply to message #28371]

Thu, 06 December 2001 14:23

Ted Cary
Messages: 53
Registered: October 2001

Member

>
>
> Heaven forbid that students encounter a steep learning curve.... :o\
>
> I'm still confused tho' - your employer is using *Excel* to visualise/process images?? Is that
> right?
>
> paulv
>

He's not using Excel to visualize or process images. An IDL program visualizes the images from
QuickTime movie frames, then acquires data from the images and does the important preliminary
processing. He wants to store the pre-processed data from all the frames in a multiple-sheet
format that Excel can read or import, so that he and others can graph/analyze the data using the
spreadsheet functions they know.

Report message to a moderator

Re: IDL data to Excel sheets? [message #28520 is a reply to message #28372]

Thu, 06 December 2001 13:21

Pavel A. Romashkin
Messages: 531
Registered: November 2000

Senior Member

Ted Cary wrote:

> My employer wants the data in Excel format for both storage and visualization
> reasons. He and most of the students he employs here are already familiar with
> Excel, and he wants the data to be available in Excel workbooks so they can
> immediately start analyzing them without learning any new programs.

That employer doen't happen to be RSI, does it? :)

Pavel

Report message to a moderator

Previous Topic:	Getting the widget id.
Next Topic:	Moving an ROI

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Wed Oct 08 14:53:32 PDT 2025

Total time taken to generate the page: 0.00628 seconds