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 #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

[Message index]

		Re: IDL data to Excel sheets? By: Paul van Delst on Thu, 06 December 2001 12:49
		Re: IDL data to Excel sheets? By: Ted Cary on Thu, 06 December 2001 11:15
		Re: IDL data to Excel sheets? By: R.Bauer on Thu, 06 December 2001 06:16
		Re: IDL data to Excel sheets? By: Ted Cary on Wed, 05 December 2001 11:40
		Re: IDL data to Excel sheets? By: Rick Towler on Wed, 05 December 2001 11:39
		Re: IDL data to Excel sheets? By: Pavel A. Romashkin on Thu, 06 December 2001 13:21
		Re: IDL data to Excel sheets? By: jeyadev on Thu, 06 December 2001 12:58
		Re: IDL data to Excel sheets? By: Ted Cary on Thu, 06 December 2001 14:23

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

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sun Oct 12 02:51:13 PDT 2025

Total time taken to generate the page: 1.59628 seconds