Retrieve a list of ordinal dimensions on a plane

2D plans Layout
1

Hi all

I want to extract an excel table with the list of points to which my ordinal dimensions are attached. On the attached example, output a table with the different points 0 - 293 - 436 - 476 - 619 - 659.

Is this possible? Do you have a tip?

Thank you all

Cote en chaine
Chain Odds878×163 2.75 KB

2

Hello :slight_smile:

To burn doublet, like that, I would say no!

Now, subsidiary question: what is the final goal of your manipulation? Maybe we can guide you on another path to do it?

1 Like
3

Hi, thank you for your answer.

It is about stringing and you would like to develop a machine capable of counting and marking the stringing at the different points indicated on an excel file (or other).

Thank you

4

And make a sketch with points that will be recalled in a table of points, is it possible? Because suddenly, the export of the table in Excel must be possible afterwards

1 Like
5

Point table? Can you explain to me please?

6

With this kind of macro you can import points from an excel table to SW:

It is also possible to do the opposite:

For the search, here are the keywords used
Solidworks macro coordinate excel.
All that's left to do is to test and take what suits you best and possibly improve it.
Edit:
There are also these 2 utilities at Visiativ if you have the Mycadservice subscription:

2 Likes
7

I don't think that's what he's asking for:
Make an excel file to model in SW to redo an excel table for the machine, you might as well not go through the SW box and use the excel file directly.
There I think the process is to model under SW to deduce an excel file (and not the other way around)
Or the way of conceiving is not the right one.
After all, it also depends on the number of dimensions to be transferred in a table, if it's a small 10n it can be done "manually" by creating a table in a drawing (Table / General Table) and clicking on each dimension in each box and saving the table in excel format.

2 Likes
8

If you have myCADtools, GetCoordinates should be able to help you do that

GetCoordinates3D: Automatic extraction of XYZ annotations or coordinate files - YouTube

Edit: damn, I hadn't seen that @sbadenis had already mentioned it

9

Hello;
Why not use a drilling table? (Tables and Bill of Materials tab).
To then save it in Excel?

Kind regards.

1 Like
10

Hello everyone, thank you very much for your answers, so I have the mycad tools and I tried GETCoordinates3D with export in a file and it's exactly what I was looking for, it works very well.
Thank you all.

4 Likes