Lisp help - areas from multiple closed polylines

Liam Callaghan
Liam Callaghan
in Programming and customization
 Hey guys,

I have a lisp routine for selecting all closed polylines within a drawing and exporting out all the lengths and areas including the layer name.  Unfortunately its been modified to just show the lengths and I dont know enough yet to switch it back.

The application I need it for is to provide the total areas (the individual ones are handy but not important - yet) for planting areas for each zone of planting.  Each has its own layer and all the polylines are in each layer.  The polylines are closed but I see if some of the other lisp routines that you can program it to check if polylines are closed and report back if they are not, which would be handy.  I can dig that lisp file out if anyone is handy in lisp and has the time to help.

EG
L_PLANTING_ZONE_01 - 10m2
L_PLANTING_ZONE_02 - 32m2
L_PLANTING_ZONE_03 - 46m2
etc.

I want to link the area data from cad to the planting schedule excel sheet to auto update the plant numbers.  To do this the total area has to be in a set location in the excel sheet.  So the data would need to be arranged in the rows of the excel output rather then the columns I think.

I just want to make a few minor modifications to the lisp file and wondering if anyone could help?
I've attached the lisp routine, drawing file with the layers and the exported excel which includes the current output along with what I'd like it to report (these are highlighted in green and pink).

What I'd like from it:
  • Metric - its currently Imperial but the code
  • Report total Areas of closed polylines per layer
  • Report sub areas in subsequent columns in the same row (see attached excel sheet highlighted in pink)
  • Report total length of closed polylines (the perimeter might be useful)
  • Save as a specific name and overwrite previous file if it can

Comments

This discussion has been closed.