TheSwamp

Code Red => AutoLISP (Vanilla / Visual) => Topic started by: Fabricio28 on May 14, 2018, 04:40:51 PM

Title: Import Texts Area to Excel
Post by: Fabricio28 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

Title: Re: Import Texts Area to Excel
Post by: BIGAL 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.

Title: Re: Import Texts Area to Excel
Post by: Fabricio28 on May 16, 2018, 06:54:00 AM

Quote from: BIGAL 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.

Thanks BIGAL

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

Title: Re: Import Texts Area to Excel
Post by: didier 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