Feed

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

Tutorial by Amin Kashef
Small

the macro below used for exporting points from sketch to excel !

  1. Step 1:

    For example we have these points in the 3Dsketch Below to export to excel

  2. Step 2:

    go to tool --> macro --> new
    choose a name for macro and click save

  3. Step 3:

    In the programming window write code below ( download the .swp I attached, the whole code didn't fit in picture!)

  4. Step 4:

    Choose the sketch you want to export points from!

  5. Step 5:

    tool--> macro--> run

  6. Step 6:

    select the macro you write (or I uploaded) and click open

  7. Step 7:

    the points will be write in a excel file as below

Comments

Please log in to add comments
  • Missing feed
    himanshu khandelwal

    is it necessary that all the points must be only in one sketch?
    how can we export the coordinate from a single SLDPRT file but from different sketches .

    May 11th, 2017 06:03