How to link a keyframe to an excel spreadsheet

I want someone to make a script to link keyframe info to a database cell like excel, so if you can the cell it updates the keyframe in max. I will pay if needed.

Comments

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.
br0t's picture

Hello Budi, I am quite

Hello Budi,

I am quite interested in how you have connected MAXScript with any external program like Excel. Is this possible with pure MAXScript or did you use another programming language like Python maybe?

Regards

Never get low & slow & out of ideas

Budi G's picture

hi brot in this case I just

hi brot
in this case I just combine MAXScript, dotnet and excel language.
for connecting to excel that's we just need a lot of excel library methods that can be read by max.

Anubis's picture

see ref post

Hi Budi,

a week ago in other post Andy describe better what he need.

my recent MAXScripts RSS (archive here)

Budi G's picture

thanks anubis Nice link. mm

thanks anubis
Nice link. mm but I just need feedback from budursky first about my example scripts.

Budi G's picture

Hi burdurky I have tried

Hi burdurky

I have tried something on your request.
a script on the attachment below. you can run it first in the max.

usage:
select an object that has the PRS keys, then run the scripts / .mse files ... then later will appear the excel dialog with keyframes information from previously selected object. for now you can only save the excel manually.

did you mean like what I make ?

AttachmentSize
copy_keyframe_to_excel_test01.mse.zip 1.76 KB
Anubis's picture

error on 1st line

Hi Budi,
I trying your script but the .mse return an error at the beginning and nothing happens. Also I had to kill Max after that with the task manager. I'm on Max 2009 if this can help.

Woops... skip above comment, i think i see whats up.
I get this error:
-- Runtime error: createOLEObject: can't find server Excel.Sheet
You said using dotNet but this come from OLE Automation (ActiveX):
xl = createOLEObject "Excel.Sheet"

AttachmentSize
mse-error.png 8.5 KB
ole-error.png 2.86 KB

my recent MAXScripts RSS (archive here)

Budi G's picture

Thanks already tried

hi Anubis... sorry for late reply, I'm busy out there and has been trying to find info about the Excel method in MAXScript.

yes, the script I use OLE Automation (ActiveX) and work correctly on a 32-bit.
The script above it is a part of my script which I store in here.
and what I meant by using dotnet, earlier if I have tested the combine for the purpose of UI at the max.

Script below I use a dotnet without ActiveX methods , almost the same way as the script that works on top but I made the UI display when in use.
I hope this will work correctly. :)

cheers

AttachmentSize
prskeys_to_excel_demo.zip 349.23 KB
exampleui-prs_keystoexcel.jpg 384.95 KB

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.