Help with getting data into a table in mass from a XY point in cad

[Anonymous]

I have a project and I'm stuck, I need a solution to add points to a table and add the X and Y position into a table from there position in model space without manually copy pasta and lots of screen panning and zoom.

Does anyone have any idea how I could automate this in CAD? 

Image attached for more of an idea of what I'm talking about.

Cheers

Mike

[ChicagoLooper · Accepted solution]

You can tabulate the coordinates in a spreadsheet.

1. Isolate the points. If all the points are on same layer, select a point=>right-click=>select similar from shortcut menu. (When this entire data extraction operation is completed, right-click a blank area in modelspace and select 'End isolation.')
2. Run DATAEXTRACTION  command. Go to Annotate Tab=>Tables Panel=>Dataextraction Icon. Image-1.
3. The extraction process with consists of pages 1 thru 8 (you will skip page 7). Images 2 to 8.
4. Open the spreadsheet. Copy all extracted data to your clipboard including the column headings on row 1. Image-9
5. To paste the contents of the clipboard, use the TRANSPOSE option of the paste command. Image-10.
6. In the same spreadsheet, paste the contents of the clipboard in cell D1. The cells to the right and below D1 will 'fill' automatically when you perform the paste. Image-11

Image-1. 

Image-2.

Image-3.

Image-4.Image-5.Image-6.Image-7.Image-8.

Image-9.

Image-10.Image-11.

You can edit your spreadsheet, e.g. add (or delete) rows or columns as needed. 

[Anonymous]

Cheers!