|
I think this is a popular case we need to export data from max to excel. I can only find very few help in maxscript help doc(ole automation). and looks like maxscript 9 don’t support excel 2007 object model, maybe only support excel 2003 or earlier. anybody know where to find more doc or examples about how to control excel in max? or you use other easier dababase format (.csv ?) instead of excel to write data in max? or I have to check max2010 script doc to find more info?
like : xl.listobjects(1) I can get <OLEObject:listobjects> as return
but xl.listobjects(1).ListRows I got -- Unknown property: “ListRows” in 1
|
|
|
|
I use csv. For example ....
filename = "C:\data.csv"
FP = openfile filename
while eof(FP) == false do
(
data1 = (readDelimitedString FP ",") as string
data2 = (readDelimitedString FP ",") as float
data3 = (readDelimitedString FP "\n") as integer
)
Edit - Oops. From Max to Excel. Sorry, I haven’t done that before.
|
|
|
|
I prefer to use excel table, it is more organized and powerful function, but hard to get involved,
|
|
|
