2011

Table Of Contents
Menu: Projects Export to Spreadsheet Update from Spreadsheet
Command entry: AEIMPORTSS
Select the spreadsheet and click Open.
Export project data using Export to Spreadsheet. Edit the data and import
changes to update the project drawings. The spreadsheet can update existing
components and wire numbers with your edits. If the block name is modified,
it can swap one block for another. It cannot insert new items into the drawings.
Process
Specifies to import the spreadsheet data for the current drawing or the entire
project.
Force spreadsheet new values to uppercase
Forces all new spreadsheet values to be displayed in uppercase.
Flip any updated tag/wire number values to fixed
Fixes all updated tag or wire number values. A fixed component tag does not
update when the retag command is run. The tag name keeps its fixed value.
Create user-defined attributes
You can define your own attributes onto AutoCAD Electrical block files and
modify user-defined attributes using the AutoCAD Attribute Edit command
or the Show/Edit Miscellaneous option on the AutoCAD Electrical Insert/Edit
Component dialog box. The maximum allowable entries for reading or
exporting any *.wda file is 150.
Use the User Defined Attribute List tool to add these non-AutoCAD Electrical
attributes in the AutoCAD Electrical report generators. Otherwise only those
attributes defined inside of AutoCAD Electrical for each component category
are processed in the project database and subsequent reports.
NOTE If the User Defined Attribute list contains AutoCAD Electrical attributes,
they are added to the report if not already included.
The attributes listed in the User Defined Attribute list are also added to the
fields exported in the Export to Spreadsheet feature for
Components on page
1501,
Components (parents only) on page 1501, Terminals (stand alone) on page
1506,
Panel components on page 1505, or Panel terminals on page 1506.
1508 | Chapter 18 Reports