3ds Max Script to Export List of Group Names to Excel File
Hi All,
I've only really got very limited knowledge of Scripting so I'm currently really struggling with this.
Basically we need a script that will export a list of items in a scene, specifically the Grouped items, to an Excel sheet.
I've managed to find the Script, but the problem is if we have 4 chairs in the scene it changes the end digit incrementally and we need the names the same as the Group name.
Is there a way to add in something that will count up the same named Groups and put this number in a separate column in Excel?
Thanks in advance for any help. And by all means if anyone needs any help with something more in our remit then just let us know.
fn printAllGroups txtFile =
(
helper = for node in helpers where isGroupHead node collect node.name
if helper.count == 0 then messageBox "No Groups in the scene!" title:"INFO" beep:off else
(
(dotnetclass "System.IO.File").WriteAllLines txtFile helper ; free helper
)
)
printAllGroups @"c:\temp\SceneGroups.xls"
Comments
`
Hi, try this:
When you import to Excel use "|" to separate columns.
Hope it helps.
So close
Hi Pixamoon,
Thanks for taking a look, really appreciate the help.
Sorry it's taken me a long time to get back to this portion of my project.
It all exports ok and imports like you said with "|".
However, instead of listing how many items of the same name it is coming out like the attached snippet image.
Basically if there's x number of groups with the same name I need it to add them all up and put how many there are in the first column (if this is possible)and the group name in the second column
Any further help would be greatly appreciated.
Many Thanks