Author Topic: Import Texts Area to Excel  (Read 1603 times)

0 Members and 1 Guest are viewing this topic.

Fabricio28

  • Swamp Rat
  • Posts: 670
Import Texts Area to Excel
« on: May 14, 2018, 04:40:51 PM »
Hi guys,

I have to create a excel table from all texts area into my drawing.

But I don't know how to do that.
I'm searching some code in the internet without success.

Anybody could help me please?

Thanks
Fabrício

BIGAL

  • Swamp Rat
  • Posts: 1409
  • 40 + years of using Autocad
Re: Import Texts Area to Excel
« Reply #1 on: May 15, 2018, 05:02:05 AM »
The simplest way is to just write out all the text to a CSV file then open in excel, just google "text to CSV" there are so many out there.
A man who never made a mistake never made anything

Fabricio28

  • Swamp Rat
  • Posts: 670
Re: Import Texts Area to Excel
« Reply #2 on: May 16, 2018, 06:54:00 AM »
The simplest way is to just write out all the text to a CSV file then open in excel, just google "text to CSV" there are so many out there.

Thanks BIGAL

I'm going to search for a code on google.

didier

  • Newt
  • Posts: 48
  • expatrié
Re: Import Texts Area to Excel
« Reply #3 on: May 17, 2018, 12:39:37 PM »
Coucou / Hello

it is possible but there are some problems
you use MTEXT, I do not like because there are formatting codes
but it is managed.

there are no numbers attached to the areas
this will not be readable in the excel file

my refexion:
make a block with two attributes (or three)
number of the island, number of the parcel, area

it's possible to write a lisp to do it automatically, keep me informed

amicalement / friendly
eternal beginner ...
my english is not fluent ...