Tutorial-How to export points from solidworks to a excel file!

In this tutorial we learn how to export points from sketches in solidworks to a spreadsheet (excel) file.

Answer
 
Comments 0

9 Answers

Hi, Its not writing points in excel file. Can you please tell me how can I fix it.
Thanks

 
Comments 0

add
Dim exApp As Object
Dim sheet As Object
below the existing dim call out before the first set and it works like a charm

 
Comments 0

I added
Dim exApp As Object
Dim sheet As Object
Doesn't work. Is there something new needed for it to work in SW 2015?

Thanks!

 
Comments 0

I used the above macro to export nodal points of an fsae frame to Ansys Workbench. For some reason, the orientation of the points relative to each other is correct , however the distances between them a grealy reduced. The overall plot of the frame has been scaled down. Can anyone tell me why this has happened? It will be a great help.

 
Comments 0

I had to make some additional modifications to the file to get it work. You can also see how you can keep dimensions at their original size. Other notes: ensure that the sketch is selected before you run the macro.

 
Comments 1

My problem is in exporting X,Y and Z data of a helix sketch from solidworks to Excel. I checked the above macro, but it doesn't work for helix sketch. anybody can tell me how to fix it?

 
Comments 0