Export polyline data (area, layer and crossed text) to excel

Export polyline data (area, layer and crossed text) to excel

chauthienqui
Contributor Contributor
790 Views
7 Replies
Message 1 of 8

Export polyline data (area, layer and crossed text) to excel

chauthienqui
Contributor
Contributor

Hello, everyone!

I am searching for a lisp that can find all polylines in a drawing and export to excel their following information:

-Area , Perimeter, Layer

-Text that crossed polyline

 

I am looking for a lisp that can export to excel a table like this:

chauthienqui_0-1701313236397.png

 

Form this drawing: 

chauthienqui_1-1701313290904.png

 

I am fairly new to lisp creation so any help you can provide me would be highly appreciated!

Thanks in advance!

 

I aslo attach the dwg and csv  files for better understanding

For more information: I attached the lisp "EPD" that was found on this forum but I cant modify the code to get right result as wish.

 

0 Likes
791 Views
7 Replies
Replies (7)
Message 3 of 8

Sea-Haven
Mentor
Mentor

Maybe confirm with real desired Excel output. 

 

SeaHaven_0-1701305769637.png

 

0 Likes
Message 4 of 8

daniel_cadext
Advisor
Advisor

I posted a sample in Python here, did it as a quick challenge using Pandas

https://www.theswamp.org/index.php?topic=58813.0

Python for AutoCAD, Python wrappers for ARX https://github.com/CEXT-Dan/PyRx
0 Likes
Message 5 of 8

chauthienqui
Contributor
Contributor
Thank for your helps.
I searched in those post already but still not find the solution.
I have just edited my post for better understanding

0 Likes
Message 6 of 8

chauthienqui
Contributor
Contributor
Can I get this lisp? I can test it by myself.

Thank for your helps
0 Likes
Message 7 of 8

Sea-Haven
Mentor
Mentor

I dont use python so as a complete solution what is required ? What needs to be installed ? Example Opendcl needs a file to be loaded from within CAD to work. Maybe post a ZIP with all the answers and some instructions about how to install the Python run time. Like wise what about Bricscad ?

 

Looks good though 10/10.

0 Likes
Message 8 of 8

daniel_cadext
Advisor
Advisor

It’s exactly like OpenDCL. In that the Python runtime in embedded in an ARX module, it's in process and fast

Everything is on GitHub , installers, instructions  all the source code,  samples.

 

https://github.com/CEXT-Dan/PyRx,  https://github.com/CEXT-Dan/PyRx/releases

 

Still a work in progress, I plan to make a better installer that installs python, wxPython and the arx

Now, you must install Python, then wxPython, then the arx bundle, hopefully the docs a clear enough

 

Unfortunately, BRX is too far out of date for this project, which is a bummer,

So, it’s compiled for ARX/GRX/ZRX, sans .bundles for the later

Python for AutoCAD, Python wrappers for ARX https://github.com/CEXT-Dan/PyRx
0 Likes