View Full Version : Extracting Attributes to Excel
22oakdene
07-08-2004, 10:09 AM
Can anyone help me extract attributes into excel ?
I am trying to re create the 'Block Count' command into excel so i can have a spreadsheet version of this.
Everytime i read up on it i take a mental block !! :(
windowsxp5
07-08-2004, 12:04 PM
Tools menu: Attribute Extraction
Command line: eattext
follow the wizard..
csiarch
08-08-2004, 02:58 AM
Basically, AutoCad needs to have a list of what to extract and a template to write the list to, formatted for text or numbers. The type of output that usually works best with spreadsheets is comma delimited where each element written to the output file is separated by a comma. Sucking the list into a spreadsheet puts each data element in it's own cell, if that's any help.
The instructions are a little cryptic but once you learn, it's a great tool for things like creating schedules or lists of things.
Attached are a couple of examples I wrote up because I also got brain lock from trying to decipher the user's manual. You will still have to refer to the manual for allowable types but these should help.
Happy extracting (Sounds like a dentist, doesn't it?)
vBulletin® v3.7.3, Copyright ©2000-2009, Jelsoft Enterprises Ltd.