Convert text table to excel

Convert text table to excel

ishaq03
Advocate Advocate
5,603 Views
5 Replies
Message 1 of 6

Convert text table to excel

ishaq03
Advocate
Advocate

Please anybody provide me a lisp for convert text table to excel without any discrepancy. For more understanding check my attached dwg.

Accepted solutions (1)
5,604 Views
5 Replies
Replies (5)
Message 2 of 6

Sea-Haven
Mentor
Mentor

1st up its not a Table as known by Autocad its text and lines. I am pretty sure this has been done before . It works by sorting the text X & Y then make a csv file is easiest. But you have lots of individual text in a box. So multiple answers required. Do a google found something instantly having a look.

 

Doing multi page excel direct from Autocad is possible select text and put on a new page. Is this needed  or all on 1 page. 

0 Likes
Message 3 of 6

hosneyalaa
Advisor
Advisor
Accepted solution

t.gif

Message 4 of 6

3wood
Advisor
Advisor

You can try TEXT2CSV.

  • You need get a free registration to convert the whole table.
  • Explode all Mtexts into Texts.
  • Explode all Polylines into Lines.
  • Replace Unicode with special symbol in Excel. (for example replace \U+00D8 with Ø)

Attached here is the result of the first table.

Capture3.PNG

0 Likes
Message 5 of 6

ishaq03
Advocate
Advocate
Message 6 of 6

yaxgaustria
Explorer
Explorer

Knew that this topic was old, but wow! What a smooth and fast LSP to export/convert AutoCAD table to Excel worksheet. Had just used it while ago with the tables i had to be submitted asap to my bosses :). Am grateful to all whom all the credits due. Kudus to you, masters. 

0 Likes