Jump to content
acad1985

Draw Polylines using Multiple Co-ordinates

Recommended Posts

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.

image.png.7b1ea7e20c9b7a916670bcc3ab5ca8d8.png      

 

image.png.1013655b137299c683c092fed0993a99.png

 

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

Thanks in advance 

image.png

Share this post


Link to post
Share on other sites
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 by Lee Mac

Share this post


Link to post
Share on other sites
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.

image.png.783b40b13375d31243f9acca9a614a34.png

 

Thanks

 

 

Share this post


Link to post
Share on other sites
Lee Mac
26 minutes ago, acad1985 said:

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

image.png.783b40b13375d31243f9acca9a614a34.png

 

 

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

Share this post


Link to post
Share on other sites
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 by BIGAL

Share this post


Link to post
Share on other sites
acad1985

Thank you very much Lee and Bigal,

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

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...