topic Re: Export xdata with area sq meters for pline items attached the xdata in Visual LISP, AutoLISP and General Customization Forum

Export xdata with area sq meters for pline items attached the xdata

tech3design — Thu, 25 Aug 2016 17:36:45 GMT

Do anyone have a lisp that they can share that would produce;

export to Excel

The Xdata

and the

area in square meters that is attached to the polyline that is attached to the Xdata.

This would be highly appreciated .

Re: Export xdata with area sq meters for pline items attached the xdata

Ranjit_Singh — Sat, 27 Aug 2016 04:32:36 GMT

Can you post a sample drawing with the polylines and the attached xdata?

Re: Export xdata with area sq meters for pline items attached the xdata

Anonymous — Sat, 27 Aug 2016 20:53:46 GMT

I have attached the following lisp programs. Feel free to massage, take snippets etc.

IPQ.lsp - extracts Xdata from the centerline of a drawing block that wqe ghet from our conveyor manufacturer, and with the program, searches through the xdata and displays certain conveyor data in an alert box

GETEXCEL.lsp - program created by Terry Miller which allows readin and writing data to/from an excel spreadsheet

PLCDATA.lsp - program which extracts data from AutoCAD and fills an Excel Spreadsheet

If I receive a same drawing from you with a list of what information you wish to extract and write to Excel, I can create a simple starting Lisp program for you.

Re: Export xdata with area sq meters for pline items attached the xdata

tech3design — Wed, 31 Aug 2016 19:04:16 GMT

square meters for each Xdata and each item/object related to their respective layer and respective object