2011

Table Of Contents
Exports project data to a comma-delimited, Excel spreadsheet, or Access
database file so you can examine and edit the data.
Ribbon: Import/Export Data tab Export panel To Spreadsheet.
Toolbar: Schematic Reports
Menu: Projects Export to Spreadsheet Export to Spreadsheet
Command entry: AEEXPORT2SS
You can edit component tags, descriptions, catalog assignments, wire numbers,
and PLC I/O descriptions in the spreadsheet. Import the changes from the
spreadsheet using Update from Spreadsheet. 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
drawings.
Limitation: Your spreadsheet edits can update existing or blank values on
existing components, terminals, PLC I/O modules, and wire numbers but it
cannot insert new items into the drawings. It only changes existing values.
Component data export
This utility copies components to a comma-delimited, Excel XLS, or Access
MDB file format for editing.
NOTE The User-defined attributes list on page 1508 can be used to add fields to the
spreadsheet if an attribute from a component is not exported by default.
Ribbon: Import/Export Data tab Export panel To Spreadsheet.
Toolbar: Schematic Reports
Menu: Projects Export to Spreadsheet Export to Spreadsheet
Command entry: AEEXPORT2SS
Select Component from the list.
Export/Import spreadsheet data | 1501