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
Summary of Contents for 22505-051400-9000 - AutoCAD Electrical 2008
Page 1: ...AutoCAD Electrical 2008 User s Guide February 20 2007 ...
Page 4: ...1 2 3 4 5 6 7 8 9 10 ...
Page 106: ...94 ...
Page 228: ...216 ...
Page 242: ...HP W TERM_ VDC SPECIAL SPACINGFACTOR 0 5 HP WA D TERM_ 02 230 Chapter 5 PLC ...
Page 294: ...282 ...
Page 564: ...552 ...
Page 698: ...686 ...
Page 740: ...728 ...
Page 814: ...802 ...
Page 1032: ...1020 ...
Page 1134: ...1122 ...
Page 1168: ...1156 ...
Page 1177: ...Insert P ID Component Overview of pneumatic tools 1165 ...
Page 1198: ...1186 ...
Page 1269: ...AutoCAD Electrical Command In this chapter AutoCAD Electrical Commands 20 1257 ...
Page 1304: ...Z zip utility 82 1292 Index ...