Marionette - get values/strings or formulas from a existing worksheet

[HebHeb]

Hello,

am I missing something?
I kind of don't get values/strings or formulas from a existing worksheet...

I tried different rows and columns but I don't get the expected values.

I can't figure out how I get the right "Handle to the Worksheet = hWorksheet
I can search with obj by crit (=worksheet) and get i.e. type #56 - is this the correct one?
Can I access a Worksheet inside the Resource-Manager? (by name?)
 

 

 

Cheers.

[Pat Stanford]

Item type 56 is the image of the worksheet on the drawing. You need an object type 18 which is the actual worksheet with the data.

 

I don't know how to get a handle to the worksheet based on the handle to the worksheet image in Marionette.  In Vectorscript there is a function GetWSFromImage(Handle_to_Image).

 

HTH

[HebHeb]

@Marissa Farrell @DomC

Maybe one of you can sort this out?
How do I get the correct handle to work with an existing worksheet?

(best case: without placing the ws inside the drawing/ layer - just inside resource manager)

Cheers.

[Pat Stanford]

If you know the Name of the worksheet you want and can hard code it you should be able to use the Name node.

Otherwise I don't see an existing node to get the Worksheet from the Worksheet image.

 

It should be a very simple node to create is you want to take a crack at scripting.

[Marissa Farrell]

@HebHeb

You can use the Name node using the name of the worksheet in the Resource Manager, does that help or is there a different way you're hoping to query for it?