compund widget question [message #45257] |
Fri, 26 August 2005 02:03  |
rlayberry
Messages: 33 Registered: November 2004
|
Member |
|
|
Hi All
Does anybody have any code or know where I can get a compound widget
which, on selecting a file, will open it up in an editable spreadsheet
which can then be saved?
Thanks
russ
|
|
|
Re: compund widget question [message #45342 is a reply to message #45257] |
Fri, 26 August 2005 15:27  |
Rick Towler
Messages: 821 Registered: August 1998
|
Senior Member |
|
|
David wrote:
> 2) If you're on Windows, you could embed an ActiveX control in your
> widget app. for a standard excel-like spreadsheet. There's an example
> of this in the examples directory:
>
> C:\RSI\IDL62\examples\doc\bridges\COM\ActiveXExcel.pro
>
> You'd have to manage saving to a file yourself, though.
You can definitely save programmatically in IDL with the Excel COM
object, you'll just have to track down the appropriate method in the
appropriate interface and that object is pretty complex. You can use
the OLE/COM viewer to explore the objects interfaces and methods.
-Rick
|
|
|
Re: compund widget question [message #45343 is a reply to message #45257] |
Fri, 26 August 2005 15:02  |
David
Messages: 24 Registered: April 1997
|
Junior Member |
|
|
Here are two possibilities:
1) Use SPAWN to start up an external spreadsheet app. On Windows this
might look something like:
SPAWN,'start excel "'+ filename +'"' ,/HIDE
(where 'filename' is the value returned from a call to
DIALOG_PICKFILE), on unix it would look the same but without 'start' in
your command argument string, and without the HIDE keyword, and
obviously replacing 'excel' with the full path of the spreadsheet app
you want to open.
2) If you're on Windows, you could embed an ActiveX control in your
widget app. for a standard excel-like spreadsheet. There's an example
of this in the examples directory:
C:\RSI\IDL62\examples\doc\bridges\COM\ActiveXExcel.pro
You'd have to manage saving to a file yourself, though.
|
|
|