2008

Table Of Contents
This utility copies the selected data category to a comma-delimited, Excel XLS,
or Access MDB file format for editing.
Access:
Click the drop-down arrow on the Schematic Reports tool to access the Export
to Spreadsheet tool.
From the Projects menu, select Export to Spreadsheet Export to Spreadsheet.
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.
Access:
Click the arrow on the Schematic Reports tool to access the Export to Spread-
sheet tool. Select Component from the list.
From the Projects menu, select Export to Spreadsheet Export to Spreadsheet.
Select Component from the list.
Data export for
Specifies to export the data for the active drawing or the entire project.
Output format
Specifies the format for outputting the spreadsheet.
Location Codes to extract
Extracts only the information for components with specific location values.
After you pick Named Location, type the location code in the box or click
List: Drawing or List: Project to select from a list of used location codes. You
can also create a report from multiple location codes. AutoCAD Electrical
automatically creates a comma-delimited list for the named location search.
General data export
Modify spreadsheet data | 999