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.