|
I’m using Viz 2006 or dot.net would probably be the way forward here…
I know how to insert an exel file into a dialogue as in this example:
rollout rExcel “Excel”
(
activeXControl ax “c:\\test.xls” height:300 width:300
)
fExcel = newRolloutFloater “Excel” 390 270
addRollout rExcel fExcel
But can anyone give me a practical example of how I can get or set cell information? I’ve seen all the help files out there, but I’m stumped!
I know I can do this using OLE automation but I wanted to avoid that because you can’t integrate the excel document into a dialogue like you can with axtivex.
Thanks
--
PS I’ve tried show propeties and show methods etc, and still none the wiser!
|
|
|
|
I tried your example, and the Excel document is opening in a web browser; this would be why none of the Excel methods are working. Can you explicitly create an Excel AX control and then load the page into that?
David “Stokes” Stokes
Senior Technical Artist, Blue Fang Games
|
|
|
|
Thanks for replying! I’ve had a go but I think the excel activex control needs to be created in a rollout, so I don’t think I can define it, and then add it to a different control (unless I don’t fully understand how activex works, which is very likely lol)
|
|
|
|
Are you still in Max 8? Sorry if this has already been answered but you should be using dotNet if
you are in Max 9 or above.
kungmongied wrote:
> Thanks for replying! I’ve had a go but I think the excel activex control needs to be created in a rollout, so I don’t think I can define it, and then add it to a different control (unless I don’t fully understand how activex works, which is very likely lol)
Paul Neale
PEN Productions Inc.
penproductions.ca / paulneale.com
Master Classes for Max, Mudbox and Composite
DotNet Tutorials
MX Driver Car and Trailer Rig On Sale!
|
|
|
penn 21 January 2009 12:45 PM
Are you still in Max 8? Sorry if this has already been answered but you should be using dotNet if
you are in Max 9 or above.
Nope, I’m using Viz 2006 and there’s no .net. I’m trying to convince the boss we need to upgrade but no luck so far!
|
|
|
