Anuncios

The Autodesk Community Forums has a new look. Read more about what's changed on the Community Announcements board.

Mesh Geometry Export to a Spreadsheet

ata
Community Visitor

Mesh Geometry Export to a Spreadsheet

ata
Community Visitor
Community Visitor

I have a zero thickness 3d mesh with 49 verticies. I want  to export the Vertex X, Y, and Z data into a spreadsheet for analysis. I can manually copy the data for all 49 but was hoping for a better solution.  Any ideas?

0 Me gusta
Responder
213 Vistas
1 Respuesta
Respuesta (1)

leeminardi
Mentor
Mentor

There's probably some program available to so this but using just AutoCAD I would explode the mesh then give the LIST command and copy the output to Excel.  This would result in something like this:

leeminardi_0-1649208706900.png

 

After using Excel's Text to Columns with "space" specified as the delimiter it would look like this:

leeminardi_1-1649208802426.png

Delete the extraneous columns and rows and you are all set except that you will have duplicate vertices. I have a procedure that can identify duplicate points while maintaining the order of the data.  Let me know if you are interested and I will write it up.,

leeminardi_2-1649211075821.png

 

 

 

lee.minardi
0 Me gusta