Driving an attribute from an .XLS file?

[zqw]

Can someone please give me some tips here?

I want to drive a translation channel with a list of data that I have in a Microsoft Excel speradsheet. How do I pull a list of numbers into Maya in a way that I can use it to do this?

Thanks for any help,

-Greg

[ame]

In reply to:
Can someone please give me some tips here?

I want to drive a translation channel with a list of data that I have in a Microsoft Excel speradsheet. How do I pull a list of numbers into Maya in a way that I can use it to do this?

Thanks for any help,

-Greg

save the excel file in ascii format with a special character to separetes the differnt columns. Using a MEL script read the file in maya and tokenize to that particular character so you'll be able to use it as input. If you are looking for a one to onw connections I'm not sure how to make Maya and Excel talk, in unix/irix you can open pipes between applications.

Hope this give you some clues,

-a

[joojaa]

Create a plugin that uses ole to fetch the data from your spreadsheet and then output the value into your modell. This is shomwhere around 30-50 lines of code with minimal functionality.

You could however use the attribute spreadsheet in maya to do the exact same thing... Inside maya without a hustle.

[ata]

In reply to:
Can someone please give me some tips here?

I want to drive a translation channel with a list of data that I have in a Microsoft Excel speradsheet. How do I pull a list of numbers into Maya in a way that I can use it to do this?

Thanks for any help,

-Greg

Hi Greg

Save the Excel doc in ASCII (dunno which one is the best format)
Maya can import series of numeric data as MOVE format.

In the options menu of the ImportFile select MOVE.
You must define which attributes you want to fill with the Datas. Each collumn in your text file will be assigned to the specified attributes. Simply select your object, pick the Attributess in ChannelBox and click on the FromChannelBox button in the OptionsMenu.

You can use this method, for example, to import Camera Motion Control datas into Maya.

Attila

[zqw]

Thanks Attila. Importing as a MOVE file was very simple and did exactly what I needed.

-Greg