exporting the coordinates of the autocad parcel to autocad excel

exporting the coordinates of the autocad parcel to autocad excel

mirqalib.m
Enthusiast Enthusiast
3,152 Views
30 Replies
Message 1 of 31

exporting the coordinates of the autocad parcel to autocad excel

mirqalib.m
Enthusiast
Enthusiast

Hello. I drew the parcel in Autocad and copy the coordinates in the list command, for example
at point X=670828.0000 Y=4433484.0000 Z= 0.0000
at point X=670915.0000 Y=4433441.0000 Z= 0.0000
at point X=670879.0000 Y=4433356.0000 Z= 0.0000
With the help of a macro in excel, I get the coordinates, point numbers and intermediate distances in the excel file. Then I add my header to this excel and paste it in autocada (next to my parcel).
Is there a lisp that I can do this action in autocad excel without the help of excel and macro. Thank you in advance.

0 Likes
Accepted solutions (1)
3,153 Views
30 Replies
Replies (30)
Message 21 of 31

komondormrex
Mentor
Mentor

sure, check update.

0 Likes
Message 22 of 31

mirqalib.m
Enthusiast
Enthusiast

You're great. Thank you.

0 Likes
Message 23 of 31

komondormrex
Mentor
Mentor

you are welcome)

0 Likes
Message 24 of 31

mirqalib.m
Enthusiast
Enthusiast

it gives this error on my home computer. is it possible to fix it?

 
 

 

 

0 Likes
Message 25 of 31

komondormrex
Mentor
Mentor

try to add (vl-load-com) at the very beginning of the code and reload lisp. has to help. 

0 Likes
Message 26 of 31

mirqalib.m
Enthusiast
Enthusiast

I'm having trouble rounding the dimensions. Autocad writes wrong on the table.

0 Likes
Message 27 of 31

komondormrex
Mentor
Mentor

check update in 13.

0 Likes
Message 28 of 31

komondormrex
Mentor
Mentor

fyi, distance between vertex 1 and vertex 2 is 95.94999999977408, which rtos-ed with (rtos 95.94999999977408 2 1) to "95.9", so there is no autocad mistake in that. other two were mine.

if you do not supposed to copy/paste cells' values there might be implemented internal formatting for cells' content.

0 Likes
Message 29 of 31

mirqalib.m
Enthusiast
Enthusiast

number of points 1-13. but it gives 1-17 on the table. It divides the distances

0 Likes
Message 30 of 31

komondormrex
Mentor
Mentor

very strange. can't simulate this error. i ran it 10 times on your dwg and every time got 13.

komondormrex_0-1690372923616.pngkomondormrex_1-1690372957693.png

 

0 Likes
Message 31 of 31

mirqalib.m
Enthusiast
Enthusiast

It may occur when the distances are long and the dots are large. The second time I run lisp, it gives correct results. interesting

0 Likes