Re: IDL data to Excel sheets? [message #28490 is a reply to message #28407] |
Mon, 10 December 2001 08:17  |
Martin Downing
Messages: 136 Registered: September 1998
|
Senior Member |
|
|
Ted, are you using dataminer, or just optimistic? [not sure if you can even
do it in dataminer!]
honestly do you *really* need to output all the data to a single workbook,
and wouldnt you be better finnishing off your analysis in IDL anyway!
I output trivial CSV text output when I want EXCEL to process data, and
since this is almost always so that I can use the pivot table facility, in
which
you want all your data in one massive sheet I add appropiate identification
fields ie:
MovieNo, FrameNo, data1, data2,
If you really need to do the other I would use a MS-Macro
cheers
Martin
"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.
>
|
|
|