Add a standard part from active Microsoft Excel worksheet

  1. On the Solid Edge Standard Parts Administrator dialog box, click Database →Add Parts.

  2. On the Add Standard Parts dialog box, click the Add New User Part(s) (Family of Parts, XLS Tables, Extending Existing Parts) option.

  3. On the Add Standard Parts dialog box, click Next.

  4. On the Add New Standard Parts: Step 1: Specify the Method for Adding User Parts dialog box, click the Add from Active Microsoft Excel Worksheet option, and click Next.

    Note:

    The Excel document you are using must be open.

  5. On the Add New Standard Parts: Step 2: Select Options for Import From Active Excel Worksheet dialog box, in the First Part Row field, enter the row in the worksheet that contains information for the first part.

  6. In the Last Part Row field, enter the row in the worksheet that contains information for the last part.

    Note:

    You can click the Import Property Names From the Row Above the First Row option if you want to use the row for the names of part properties. This makes them easier to identify in the next steps.

  7. On the Step 2: Select Options for Import From Active Excel Worksheet dialog box, click the Next button.

  8. On the Add New Standard Parts: Step 3: Select Features for Your Part dialog box, select the extra features you want to include for the parts.

    For piping, you must specify the number of coordinate system pairs. For fastener systems, you must specify the fastener type for the part. This step is optional so you do not have to select any extra features.

  9. On the Step 3: Select Features for Your Part dialog box, click the Next button.

  10. On the Add New Standard Parts: Step 4: Select Category and Properties dialog box, specify a category. You can select an existing category from the database or create a new category. If you want to add the part to an existing category, follow step 11. If you want to add a new category for the part, skip step 11, and follow steps 12— 14.

  11. In the Category section of the dialog box, select a category.

  12. In the Category section of the dialog box, select a category, and click the Add Node button.

    A New Category field is added to the Category list.

  13. In the New Category field, type a name for the new category, and hit <ENTER>.

  14. In the Specification field, type a specification for the new category.

  15. Use the Add Characteristic and Add Custom Property buttons to add the necessary characteristics and custom properties to the Properties area of the dialog box.

  16. On the Step 4: Select Category and Properties dialog box, click the Next button.

  17. On the Add New Standard Parts: Step 5: Enter the Values for Parts and Properties dialog box, enter information for the requested property values and click the Next button.

  18. On the Add New Standard Parts: Step 6: Select the Visual Navigation Category dialog box, select a visual navigation category for easier selection of the standard parts and click the Next button. This step is optional.

  19. On the Add New Standard Parts: Step 7: Write Part Information dialog box, click Finish to add the parts to the database.

What are you looking for?
Look up more details