How do I import excel data

I'm new to 3ds max entirely but do have experience w/ excel VBA so I'm hoping it won't be too much trouble to use the macro recorder to learn how to code. However I have no idea how I read in points from an excel file. I'm looking to have blocks build like legos w/ a crane moving around and assembling them then taking those assemblies and dropping them into a larger one. Another department has all of the scheduling data and size for the blocks laid out in an excel file. There's over 2000 blocks I need to move around so trying to do this by hand would be a pain. I'd like to be able to read in the excel file and wind up w/ the blocks size/position follow suit.

Comments

Comment viewing options

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

Well , I do not remember it

Well , I do not remember it clearly . If it is possilble to export your excel file into plain txt file with the data divided by space/enter/tab/, or something else . While I did remember excel has this function. If so , it is easy for someone read in points from the txt file which exported from excel.
Good Luck

Comment viewing options

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