Hole Table

[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

[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.

[Frederick_Law]

You can program in Excel to copy required info to another table and save it as csv.

[Ömür Tokman]

There is a macro here maybe you want to review. possibly customizable.
https://www.codestack.net/solidworks-ap ... les-table/

[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.

[SolidMuse]

I am here wondering why you are not using a CAM package to program your parts?