Jump to content
Developer Wiki and Function Reference Links ×

Pull input from worksheet


DianaK

Recommended Posts

  • Marionette Maven

Hi Diana,

Are you asking if you can use Marionette to locate an excel file to import from?

I'm going to guess that no matter what you're actually asking for, it can be done. Worksheet nodes just haven't been implemented in any of our release versions. I'm working on a worksheet node library now, but if you give me a good description of what you'd like done, I can try to put something together for you to use!

Thanks,

Marissa

Link to comment

I'll usually be bringing the excel data into a worksheet, but if it is easier to pull from an external excel, than an internal worksheet I can do that happily.

What I do now is, take a set of data, columns I am given by the show's TD:

1- Name of lineset number, like 2 or 21a

2- +Y Distance from 0, known as distance from Plaster Line

3- thickness of that piece, in other words, the y height of that piece with the +Y distance being center

4- and the mane of that set piece, like "Bob's Portal"

I use that info to make a scale graphical depiction of the excel data in space. Some shows have 80 Linesets. It is TEDIOUS!

I'm aiming to use Marrionette to make me something that...

will take those 4 columns of data and make

a box with the height from column 3,

the y of that box's center from column 2,

and read out column 1, then 4, then 2 within that box

then repeat using the next row number indefinitely until the end of the worksheet (worksheets have end rows, excels have continuous rows, so maybe from a worksheet is better than from an excel)

does that make sense?

Link to comment
  • 3 months later...

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...