topic help export lines coordinates to excel or txt files in AutoCAD Forum

help export lines coordinates to excel or txt files

Anonymous — Sat, 22 Oct 2016 20:29:28 GMT

Hello everyone,

I am trying to export lines (or polilines) to an excel spreadsheet for further manipulation.

what i basically need is having in the same row the following five (or 7 in case Zaxis is shown by default) cells with the following information:

1.index 2.Xvalue(1st point) 3.Yvalue(1st point) 4.Xvalue(2nd point) 5.Yvalue(2nd point)

there is no "Z" (or rather I dont need the Z values as the images I have to work with are 2D so Z=0 for all points)

I have checked the forum for help/hints but so far nothing seems direct/automated enough... most posts were regarding the use of _LIST (then copy/paste) and Click2Xls. These were helpful but not good enough since I have to do that for files with hundreds (if not thousands) of lines/polilines. To give you a better idea: imagine a huge masonry wall with lots of squares and rectangles and the information i need are the contact surfaces/lines.

Any idea on how to do that with a faster, and safer aswell, method? meaning that while clicking vertexes for coordinates I sometimes ended up forgetting to click all lines and was left with an imcomplete model.

Thank you all in advance,

Adrian

Re: help export lines coordinates to excel or txt files

Alfred.NESWADBA — Sat, 22 Oct 2016 21:20:15 GMT

Hi,

lines can be handled using command _DATAEXTRACTION, there you have the chance to export startXY and endXY.

Polylines can't be handled this way as they can have many vertices, you might explode the polylines (as long as they only have straight segments and are not curved/splined), then run _DATAEXTRACTION and then do _UNDO to get your polylines back.

At least you can search for tools/apps that might handle this.

- alfred -

Re: help export lines coordinates to excel or txt files

Anonymous — Sat, 22 Oct 2016 21:36:48 GMT

hi there,

I did try the _dataextraction (found the EATTEXT quick command here on the forum) with the whole drawing selected and i run exactly in the problem you described: the lines i could deal with fine, but i couldnt get the polilines' vertex values, im going to try to explode them.

by the way, do you know if there is a way to "straighten" possible curves/splines? as far as i know there should NOT be curve parts, and if there are, then that is a problem with the drawing.

edit:

It works!!! thank you so very much!

now i just need to manage to get rid of possible "flaws" (curves and segments that end/begin where they are not supposed to) with the initial files i've been given.

Re: help export lines coordinates to excel or txt files

arshadmirza786 — Thu, 06 Sep 2018 10:18:48 GMT

Dataextraction distrub the sequence of pline drawn and it is difficult to sort accordingly