Export/Import Text, Attribute data, tags etc from drawings and Excel

[Subramanyam.Perivenkata]

Hi,
I am looking for a Program which can export the general text, attribute data, tags etc from drawings to excel and back from excel to autocad drawings. The key things are I want to export the data from single or by selecting multiple drawings. after the data is exported, basically looking at one drawing data in one sheet i.e. 10 drawings data in 10 sheets of one single excel file. Then i will be doing some changes in the values and want to import back the changed values in the same fashion as Export. The export attribute function when selected from the Drop menu exports only in .txt fashion and when I use EATTEXT option it does not arrange in the order i want which is creating problems, and still after I change the values in .xls file and import back it does not work properly.

Looking for a early response.


Regards

[jwanstaett]

See: http://forums.augi.com/showthread.php?p=43872#post43872

try this http://forums.augi.com/attachment.php?attachmentid=3465

[ivan_sosa_b]

The thread "Atribute Extraction Routine" in this forum might get you started. The program listed there lets you select a list of blocks and a list of tags to extract info from.
The "excell to Autocad" part I don't know how to do. :)

[03xtreme]

the quickest way i have found to do this is with "paste special"
copy the items you want from excel to the clipboard, and "paste special" in cad using %product as your method, it'll bring the grid text, everything in.

however it is not dynamically updated and i don't believe there is a way to do that except with ole objects.