Construction of object from vertices point

[Anonymous]

Hi all,

I am new to 3ds Max. Currently, I have to construct a 3D model of urban area (with buildings only). Now, I have all the vertices, (i.e. just the corner points of a solid) of the building stored in *.xyz format. Is it possible to construct a 3D object just from this data file?

Any help or advice is appreciated.

Many Thanks.

Dominic

[Anonymous]

You are so nice!

Thank you so much!

Safe Flight and Have a Nice Trip~

[Anonymous]

Thank you very much for such a good implementation/script, I have the same problem as taingancheung4444 

I got a headache reading online manuals and forums. Eventually, for fortune, I've found your script,

But Excel doesn't create .scr output file. I've tried to find something in VBA script but after the whole day still don't understand your code. I gave all permission to Excel like macros  and vba as well.

If you are not busy, is it possible for you to help? 

Originally I just needed to create dots/points in 3ds max from txt file whith consist from xyz coordinates.

thx

[leeminardi]

Here's a simple solution that you can use to create a Maxscript from coordinate data in Excel.

Just use the Excel concatenate function to build the Max command to create a point.  For example, assume you have the following in Excel and want to create a Maxscript to create points withthe noted coordinates.

In cell D2 write the following expression:

=CONCATENATE("Point pos:[",A2,",",B2,",",C2,"]")

then fill it down for all the rows of data that you have.

Now select column D from D2 down to the last row of data (D7 in my example).  Copy the selected cells to the clipboard (Ctrl-C) then paste it into a text editor (e.g., Notepad, I prefer Notepas++)  with Ctrl-V and save the file with the extension .ms (max script).

In Max execute the script (Scripting, Run Script).

I could make a VBA/Excel macro to create the .ms file from column D if you think that is necessary.

Good luck.

[Anonymous]

Hello  @leeminardi and Happy new year to you. And please sorry for such a late reply, I was sick all that time thereby couldn't find the energy to check the forum. everything worked out excellent and clear, for now, I'm experimenting with results.
and despite it's already 14th January I still want to congrats you on the happy new year and sincerely wish you a lot of new knowledge, career growth, energy, and the most important ше is health in this year. Thanks to you people continue to work and develop in their crafts.
Thank you and Happy 2021.