Hi,
Does anyone know how to import points from a table in excel into solidworks. I heard theres a way do do it with macros.
Rob
Hi,
Does anyone know how to import points from a table in excel into solidworks. I heard theres a way do do it with macros.
Rob
This spreadsheet is not only awsome, it is totally awsome & just saved a ton of time not having to enter the points manually. The only thing I can see that would make it better would be the ability to create a spline thru the 3d or 2d points. I know you can do that with insert curve thru XYZ points but to use it you then have to convert the entity into a new sketch. Thanks again Pete
Welcome to SolidWorks forums Ganesh.
What exactly is hurting you to use the curve??
You might also find this post helpful for your future reference
Hi,
I am new to this forum and I was hoping someone could help me with a problem. I start using the macro in the excel sheet. And it worked perfectly.
We are a engineering company and my main job atm is to build a sound barrier next to a highway. We work in x,y,z ( thats why the excel sheet is a perfect macro to set the center points in the part.)
However... at some point when iam almost done, a client call's me and telling me that the, for example, the first 10 x,y,z, are different because of .... whatever...
In what way is it easy to set those points to new x,y,z, without destroying my assembly. My idea was to get the points that were created with the excel sheet, to a design table. But the design table doesn't recognize the points. I could use auto dimension to set the points from the origin point. But i have a minimum of 150 points. To much to use the auto dimension manually.
I also could use table driven pattern..but that's only in x,y....and i need the z-coord for my work.
Summery: I would like the points created from the excel sheets in a way that i can control the points from a excel.
Hope i made my story clear!
Best Regards,
Bernd
Just found this thread and yes the macro is awesome and works great for the 3D options, but I believe there is a line of code that is missing from the VBA macro for the 2D point and line options. If you edit the excel macro and add the line it will work.
For the Create 2D Points macro "Private Sub btnTest_Click()" and the missing line below
......
Part.ClearSelection2 True
Part.Extension.SelectByID2 "Front Plane", "PLANE", 0, 0, 0, False, 0, Nothing, 0 '****** MISSING IN ORIGINAL MACRO ****
Part.InsertSketch
Part.SetAddToDB True
.....
Then for the Create 2D Lines
"Private Sub CommandButton1_Click()" Add the same line
Part.Extension.SelectByID2 "Front Plane", "PLANE", 0, 0, 0, False, 0, Nothing, 0 '****** MISSING IN ORIGINAL MACRO ****
Before the Part InsertSketch line and everything should work great. Thanks again to the original post by Peter
Hello,
This macro still works great but if your using Windows 10, I believe the trick is to create a design table and select this file instead and it'll work. Tried doing it outside of SWX and kept getting an error where it didn't know a part was opened up, but inserting it as a design table did the trick.
I have an awesome excel spreadsheet with options to import points or lines to 2d or 3d sketches.
I will attatch it.
2 points to note.
You need a part open before you use it, and do a fit to screen / zoom extents before assuming it hasnt worked!
Rgds
Pete