Page 1 of 1

Hole Table

Posted: Thu Sep 23, 2021 1:19 pm
by Prolixity
I tried searching through the forum, and on the internet I wasn't able to find what I was looking for so sorry if this has been answered before.

Part-A could have anywhere from 100 holes but out of the 100 holes maybe there is 5 different hole/thread sizes, when I take the part and create a drawing of the part I would create a Hole Table to call out the information I would need. I would then combine same tags, and save the Hole Table as an excel file. I then would manipulate the excel file by removing everything that I did not need, then save as a .csv file open in notepad and replace , etc and save as text file so I could import directly to the CNC machine. Would I be able to make a custom hole table to give me the format I would like? Or would I need to make a script to convert my excel file into the format I would need?
1/4-20
x0.5 y0.5
x1.0 y1.0

3/8-16
x2.0 y2.0
x4.0 y4.0

Thanks in advance

Re: Hole Table

Posted: Thu Sep 23, 2021 2:42 pm
by DanPihlaja
Not sure that you can do what you want with the vanilla hole table.

However, I am pretty sure that you can (or have someone) create a macro that will do all the dirty work for you directly from Solidworks.

Re: Hole Table

Posted: Thu Sep 23, 2021 3:41 pm
by Frederick_Law
You can program in Excel to copy required info to another table and save it as csv.

Re: Hole Table

Posted: Fri Sep 24, 2021 3:49 am
by Ömür Tokman
There is a macro here maybe you want to review. possibly customizable.
https://www.codestack.net/solidworks-ap ... les-table/
image.png

Re: Hole Table

Posted: Fri Sep 24, 2021 9:13 am
by Prolixity
I was thinking of just being able to modify the existing hole table template. But there isn't really much information on this such as how linking the cells to the property. This would be the format I would want. Since, I could just save as a txt file at this point directly from solidworks.



Re: Hole Table

Posted: Tue Sep 28, 2021 4:33 pm
by SolidMuse
I am here wondering why you are not using a CAM package to program your parts?