Export Point Cloud

Out of category
1

Hello

I want to export a point cloud from Solidworks 2020 to Excel.

How can I do this? when I open the Solidworks file in text I can't find any coordinates 


2021-01-20_15_29_52-solidworks_premium_2020_sp2.0_-_distanceconstante__.png
2

The simplest is a DXF export but there will still be work behind it.
To be seen according to the number of points to make a mep with a table of coordinates (like a table of holes) which must be exportable in xls.

1 Like
3

This kind of macro should work (without having tried:

https://forum.solidworks.com/thread/21219#86372

 

https://grabcad.com/questions/tutorial-how-to-export-points-from-solidworks-to-a-excel-file (Macro:https://d2t1xqejof9utc.cloudfront.net/files/15922/PointToExcel.swp?1352909180)

2 Likes
4

Even simpler I just saw that you have access to Mycad tools:

https://help.visiativ.com/mycadtools/2020/fr/GetCoordinates3D.html

And no need for macro knowledge

 

2 Likes
5

I succeeded simply by doing a save-under .igs and then opening in file .txt we find the coordinates of the points.

Be careful to check "export sketch entities" in the system options.