Draw Polylines using Multiple Co-ordinates

[acad1985]

Hello Everyone, 

I have list of co-ordinates in excel workbook. I need to place a small Block (as image) to that co ordinates and connect those blocks using Poly line.

      

 

 

Could you please help me,Is that possible to do that through Lisp.

Thanks in advance 

[Lee Mac]

If you save your Excel worksheet as a CSV file or tab-delimited Text file, you can then use my old Point Manager program (twice: once with file input & block output, then with file input & polyline output) to obtain the result you require.

Edited December 2, 2019 by Lee Mac

[acad1985]

Hi Lee,

Thanks for your reply,

Your code is working perfectly.

It's connect all the block with single line also it's connected the first and last point of the co ordinates.

instead of that  can we connect separate line as per below image.

 

Thanks

 

 

[Lee Mac]

26 minutes ago, acad1985 said:

instead of that  can we connect separate line as per below image.

 

 

Certainly - simply process these as separate files through the program (else, how would the program know where to split the points?)

[BIGAL]

There are  alternatives one is that you must have a delimeter in your csv file say a blank line to separate the plines, a custom lisp is required. you can add a code like p1 on end x,y,code when code changes that means a new pline. Can do x,y,z where z is not a level but pline number.

 

If your using excel it is possible to do this directly by making a excel column of the autocad points with a break and copying and pasting that column to the command line.

 

Copy this to command line as a example, note double blank line is finish pline and 2nd blank is start new pline. You use =concatenate(a1,",",b1) to make the x,y it has a blank line on end to finish last pline.

pline
0,0
1,1
1,3
4,5


0,0
10,3
12,34
99,99

Insert blocks done in a similar way

-insert blk 0,0 1 1 0
-insert blk 10,10 1 1 0
-insert blk 14,12 1 1 0

Lastly in civil design field survey its x,y,z,code and the data is strung and correct block inserted.

Edited December 3, 2019 by BIGAL

[acad1985]

Thank you very much Lee and Bigal,

I'll try with Script as well as Separate csv files.