Need AutoLISP to Export TEXT/MTEXT to Excel (Advance Steel 2023)

[Neelamegam]

Hi everyone,

 

I need an AutoLISP routine for Advance Steel 2023.

 

Requirements:

 

- Read all TEXT and MTEXT.
- All my drawings have the same format.
- Preserve the table layout exactly as shown in the drawing.
- Export to CSV or Excel.
- Columns are:
  1. Name of Assemblies
  2. Drawing No.
  3. Qty
  4. Total Weight

 

Sample DXF is attached.

 

Any help would be greatly appreciated.

1111 1.dxf

[rbshsnkar]

If your table layout is always the same, you don't need a very complicated AutoLISP.

A simple approach is:

* Read all TEXT and MTEXT entities.

* Sort them by Y coordinate (rows) and then X coordinate (columns).

* Group nearby text into the same row using a small Y tolerance.

* Map the four columns to Assembly Name, Drawing No., Qty, and Total Weight.

* Write the data to a CSV file (Excel opens CSV directly).

The biggest challenge isn't exporting—it's correctly identifying which text belongs to each row. Once the row grouping is reliable, CSV export is straightforward.

If you can share the sample DXF, someone can write a routine tailored to that table format, making it much more reliable than a generic text export.

[Neelamegam]

The table format is standard and never changes.

[SLW210]

Why don't use have it as a Table Object in AutoCAD?