Creating a Part from a Spreadsheet

You can use the New Part Creation Spreadsheet dialog box to create new parts (multi-section/single-section). This dialog box has an interface similar to a spreadsheet. It allows you to paste contents copied from a part data sheet to the spreadsheet.
Each row in New Part Creation Spreadsheet corresponds to a pin while each column corresponds to properties associated with the pin. The property names are listed as the column header.

To create a new part from spreadsheet

1. Select a library (.OLB) file that will contain the new part in the project manager.
2. Select the Design menu and choose the New Part from Spreadsheet command.
   OR
   Right-click the library file and select New Part From Spreadsheet from the pop-up menu.
   

   The New Part Creation Spreadsheet is displayed.

3. Specify a name for the new part in the Part Name text field.

4. If you want to create a multi-section part, specify the number of sections you want to have in your new part in the No. of Sections text field. The New Part Creation Spreadsheet creates single-section parts, by default.

   The Section property column changes to a list box displaying the number of sections you specified in the No. of Sections text field.

   Number of sections cannot be less than one.

5. Specify a part reference prefix for the part in the Part Ref Prefix text box.

6. Select Numeric or Alphabetic in the Part Numbering group box.
   If you select Alphabetic, an alphabet (between A to Z) will be added as a suffix to the current part reference for each of the new parts. If you select Numeric, a number (between 1 and 1024) will be added as a suffix to the current part reference for each of the new parts.
   The Section property column changes based on your selection in the Part Numbering group. For example, if Alphabetic is selected, the Section property column displays A.

7. Specify a pin number in the Number property column.
   To sort on any property, double-click its name in the column header.
8. Specify a name for the pin in the Name property column.
9. Select the type of pin from the Type property drop-down list.
   You can select the Type cells for multiple pins simultaneously using the Shift+down arrow keys and then enter the pin type. The selected Type cells get populated with the pin type of your choice.
   Alternatively, you can:
   
   1. Select the Type cells for multiple pins simultaneously using the Shift+click, then press the Ctrl key, and then select a pin type of your choice from the list box.
      The selected Type cells get populated with the pin type of your choice.
   2. Click the first cell of the range, and then drag to the last cell, and then enter the pin type of your choice.
      The selected Type cells get populated with the pin type of your choice.
      (You can use these methods to make selections in the Shape, Position, and Section property drop-down lists also).
10. Select a shape for the pin from the Shape property drop-down list.
    You can hide or unhide a property column in the New Part Creation Spreadsheet. To do this, right-click the property column header you want to hide and select Hide from the pop-up menu. The selected property column will now not appear. To unhide a property column, right-click the property column header next on the right-hand side of the hidden property column and select Unhide from the pop-up menu. The hidden property column appears in the New Part Creation Spreadsheet.
     Alternatively, you can unhide a property column by:
    
    • Double-clicking the column handle ( ) of the property column header.
    • Dragging the column handle of the property column header.
    (only the last two methods can be used to unhide a property column, which is the last column in the New Part Creation Spreadsheet)
    You can change the order in which the property columns and rows appear in the New Part Creation Spreadsheet. To do this, select the property column/row header you want to move and drag and drop it to the location where you want it in the New Part Creation Spreadsheet.
11. Specify a value for a swappable (input) pin of the part in PinGroup text field.
12. Select the position where you want this pin to appear in the part for the Position property drop-down list.
13. Select a section number you want to associate with the pin from the Section property drop-down list.
    You can select Section cells for multiple pins simultaneously using the Shift+down arrow keys and enter the section number. Alternatively, you can:
    
    • Select the Section cells for multiple pins simultaneously using the Shift+click, then press the Ctrl key, and then select a section number of your choice from the list box. The selected Section cells get populated with the section number of your choice.
    • Click the first cell of the range, and then drag to the last cell, and then enter the section number of your choice. The selected Section cells get populated with the section number of your choice.

    You can select alternate Section cells for multiple pins simultaneously using the Ctrl+Left mouse button click and enter the section number.

    The pins will be added in the same order in the new part as the order in which the pins appear in the spreadsheet.

14. Click the Save button to save the new part.
    If any warnings are generated during the save operation, a message appears asking you whether you want to view the warnings.
    To view the warnings, click the View Warnings button. The New Part Creation Spreadsheet expands and displays a grid showing warnings messages. If you select the Continue button, the part is saved as is.

    Click the Hide Warnings button to hide the warning messages or the Show Warnings button to display the warning messages again.

To add a pin

1. In the New Part Creation Spreadsheet dialog box, click the Add Pins button.
   The Add Pins dialog box appears.
2. Specify the number of pins you want to add in the Number of Pins text field.
3. Click OK.
   The desired number of blank rows gets added at the end of the current row set in the New Part Creation Spreadsheet dialog box.

To delete a pin

1. Select a row in the New Part Creation Spreadsheet dialog box.
2. Click the Delete Pins button.
   A message appears asking you to confirm the deletion.
3. Click OK to confirm deletion.
   The selected row is deleted from the New Part Creation Spreadsheet dialog box.