2011

Table Of Contents
Drawing Information for Table Output
Specifies a starting drawing file location and filename, and the drawing
template file to use for the automatic creation of the drawing files. You can
select a template drawing file to use for the automatic creation of drawing
files. Type in a template filename or use the Browse button to search for and
select a template file. It is advised to start the first drawing filename with a
numeric suffix.
NOTE If you enter just a filename, the drawing files will be created and saved in
the active project path.
Export/Import spreadsheet data
Update drawings from spreadsheet data
Use this to edit component tags, descriptions, catalog assignments, wire
numbers, or PLC I/O descriptions from a spreadsheet and then have your edits
update your drawings. Your spreadsheet/database 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.
1 Click Import/Export Data tab Export panel To Spreadsheet.
2 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 available when writing out to multiple
categories.
3 Click OK.
4 In the Data Export dialog box, specify to export the spreadsheet data for
the current drawing or the entire project.
5 Specify the output format (Microsoft Excel, Access file, Tab-delimited
ASCII, or Comma-delimited ASCII) and the location codes to extract, and
click OK.
Export/Import spreadsheet data | 1499