or blank values on existing components, terminals, PLC I/O modules, and
wire numbers but it cannot insert new items into the drawings.
1
Click the arrow on the Schematic Reports tool to access the
Export to Spreadsheet tool.
2
Click the Export to Spreadsheet tool.
3
Select the data category to export.
If you select General, information for the categories marked
with an asterisk (*) is extracted. Each category is saved to a
separate sheet (spreadsheet format) or table (database format).
The tab-delimited or comma-delimited formats are not avail-
able when writing out to multiple categories.
4
Click OK.
5
In the Data Export dialog box, specify to export the spreadsheet
data for the current drawing or the entire project.
6
Specify the output format (Microsoft Excel, Access file, Tab-
delimited ASCII, or Comma-delimited ASCII) and the location
codes to extract, and click OK.
AutoCAD Electrical creates a file of the data pulled from your
wiring diagram drawings.
7
Open this file in any spreadsheet or database program for view
and edit.
Caution:
If you selected a Tab or Comma-delimited ASCII
format, import all fields as text. Some spreadsheet programs
may try to convert some fields into numeric or scientific
notation values. You may need to save the AutoCAD Electrical
extracted data to a file with a .txt extension and then use the
spreadsheet's import wizard to force all fields to be classified
as text.
8
After editing, save the spreadsheet data back out to its original
format.
9
(Optional) Before importing the spreadsheet data back into
the drawing or project, add additional columns to the spread-
sheet data. Label each column with a target ATTRIBUTE name.
Modify spreadsheet data | 997
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 ...