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

[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 12:35:04 PDT 2025

Total time taken to generate the page: 1.99625 seconds