Please help me to export directly the area values of area string to Excel file

[minh.dxuan]

Hi all,

Before https://forums.autodesk.com/t5/user/viewprofilepage/user-id/6591997 helped me to export drawing texts to Excel as attached lisp (D2E).

Now I need the lisp that exports directly from string of areas (drawing unit is mm) to Excel column (unit is 0.00 m2). Please help me with this case.

Many thanks you in advance.

[minh.dxuan]

I would like to thank Admin who moved my thread into this proper group. Before, I also posted this topic on lisp group and Mr https://forums.autodesk.com/t5/user/viewprofilepage/user-id/6591997 helped me to solve it as attached lisp. His lisp runs very well.

Best regards.

[Sea-Haven · Accepted solution]

The forum is a volunteer thing so you get more help if you have a go yourself, take what you have try to learn it, where it reads Text change to hatch and you can get the area of a hatch its a property. 

look at ssget "X" '(0 . "HATCH") as a start and (vla-get-area obj) google get area lisp.

If it doesnt work post what you have tried. 

Ps whilst Lee does excelent code dont actually need in this case the make a list as can just look into the hatch selection set and get each area.

Do ss
repeat (sslength ss)
get area
write to csv
close csv
all done.

[minh.dxuan]

Many thanks for the helps of @Sea-Haven . Best wishes for you.