Auto list to Draw a poly line using X,Y coordinates

[vinayak]

I want to draw a poly line (x,y- straight line) in auto cad by using below data its in xl.

i have ATTE text block in autocad which name is (R1M03 & 1TBINT),

my intention is to cross check the length of line (LG:mm),

I need Lisp to draw a line by using this XL data in Autocad,

please help

 

 

 

[Steven P]

Excel to AutoCAD lisps are out there to find.

 

Looking at your data I can't identify a coordinate for the start and end points of the line

[BIGAL]

Post a dwg, like Steven no idea can see column "I" has something.

[vinayak]

On 12/13/2023 at 4:01 PM, vinayak said:

I want to draw a poly line (x,y- straight line) in auto cad by using below data its in xl.

i have ATTE text block in autocad which name is (R1M03 & 1TBINT),

my intention is to cross check the length of line (LG:mm),

I need Lisp to draw a line by using this XL data in Autocad,

please help

 

 

 

Sorry for late replay,

i edited the name of 1tbn, sample enclosed, i want to automate the line to draw, presently manually drawing the line and measuring the length and adding extra length making it to round up and i have many different name points like 1TBN . please help if any lisp. 

Thanks in advance - vinayak

test.dwg

[fuccaro]

With some basic Excel skills, you could get a row with the coords like this:

X1,Y1
X2,Y2
....
Xn,Yn

Copy that row in the clipboard and start AutoCAD. Turn off the OSNAP. In the command line type PLINE<enter> and when you are prompted for the points, paste the clipboard content in the command line, It should draw the polyline you are after...

[Steven P]

Will this help to start with?

 

http://www.lee-mac.com/totallengthandarea.html

 

Returns into the command line a selected lie length - can be adjusted to add on a little bit and round up 

 

[BIGAL]

Like fuccaro, put PLINE as 1st row, you can use a formula to work out the X & Y values then use Concatenate to make the X,Y in Excel.

 

[fuccaro]

@BIGAL

Congrats, I see you are good in excel too!