Is it possible to link an Excel sheet to a 3D sketch for plotting points? Any change in the excel sheet should automatically update the existing points in the 3D sketch.
The 3D sketch will not update automatically, but you can use the Insert > Curve > Curve through XYZ points function and reference a .txt or .sldcrv format file.
Thanks Kelvin, but unfortunately that wasn't what i was lookign for. I tried a few macro's, but the only problem is when I want to update my points, I would have to delete the previous sketch first. That becomes a problem when the sketch is absorbed in certain features. I know there is a cumbersome way around too, but just wanted to know whether any shortcuts were available.
Not sure but check if design table can be helpful here.
Thank you Deepak, but this idea already occurred to me.
i have requested from the solidworks guys a points by table command. i like the curve through xyz points...but sometimes i'd rather use a spline.
but currently there is no way to see the points. the curve just shows the curve and not the points.
If you have SW Premium you would have the ScanTo3D module, which has that function.
If not, some macros can be downloade from
can you use that in the scan to 3d without actually scanning?
i've never tried it
No, the macro will import the 3d points (excel or txt file) into SolidWorks.
Welcome to the forum. Deepak mentioned a Design Table in an earlier post. Would that work? What I was thinking of was to dimension your 3d sketch points from existing planes, geometry, sketch entities, etc., and then setting up an Excel design table to control those dimensions. And if this won't work, please accept my apologies. I'm not an engineer, just a former carpenter turned draftsman.
Thank you for the warm welcome Glenn. The same idea occured to me, but since a lot of 3d points are involved (roughly around 100), dimensioning each point would be a lot of work. But I haven't tried it, should possibly work. Thanks a lot!
P.S. There is no need for you to apologise to a novince such as myself.
Retrieving data ...