Import Component Data PropertyManager
In the Import Component Data
PropertyManager, you import an Excel file into an .xml
file to create a component
library.
You can also use the Routing Electrical Library Wizard
to create, edit, and import electrical cable and component data.
The PropertyManager controls the following:
Import Component Library
Import library. Specify the
Excel file to import.
Component library file. Specify
the target .xml file. Be sure
to store the .xml file in the
location you specify in Routing
File Locations.
Merge
library data. Select to add the data from the Excel file to the
data in an existing library. Clear to replace all the data in the existing
library.
Overwrite
existing components. Select to overwrite existing library components
with data from the Excel file. Clear to add only new components from the
Excel file.
Header Definitions (Excel)
Type the header text from the Excel file into the corresponding header
definition field. For example, if you use PartNo
as the header for the part number column in the Excel file, then type
PartNo in Part
number.
You can type multiple Excel headers, separated
by semi-colons (no spaces), in a header definition field. For example,
if you sometimes import an Excel file with a header PartNo,
and at other times an Excel file with a header PN,
then type PartNo;PN in Part
number. The next time you import an Excel file, both entries appear
and are recognized by the software.