Hide Table of Contents

Creating Cable Wire, Component, or Covering Excel Files

  • Create an Excel spreadsheet with appropriate column headers. For cable libraries, you can create column names for cable libraries and core libraries. Use the following rules when creating the spreadsheet:

    All column headers are required. The column headers vary depending on the type of library file you want to create. You can use different header names for the fields in the Excel file and map the names to the library header fields when you import the Excel file.

    A cable library needs one row to define the cable, plus a row to define each core. A piping and tubing covering library can have column names for covering libraries and materials libraries. Other libraries need only one row

    The following tables list the column headers for each file type.

    Column Header for Cable Library   Column Header for Core Library
    Cable Name Outer Diameter   Cable Name Color
    Part Number Number of Cores   Wire Name Disp Color
    Description Minimum Bend Radius   Size Minimum Bend Radius
          Outer Diameter Seal

    Column Header for Wire Library
    Wire Name Disp Color
    Part Number Minimum Bend Radius
    Description Size
    Outer Diameter Seal
    Color  

    Column Header for Component Library
    Part Number Pin List
    Library Name Terminals
    Configuration Name Component Outer Diameter
    Description Gauge
    Column Header for Ribbon Cable Library
    Cable Name Color
    Part Number Disp Color
    Description Number of Conductors
    Thickness Minimum Bend Radius
    Width  
    Column Header for Piping & Tubing Covering Library   Column Header for Piping & Tubing Material Library
    Covering ID Packing   Covering ID Melting Point
    Covering Name Part Number   SolidWorks Material Library Reinforcement Insert
    Covering Type Application   SolidWorks Material Insert
    Width Voltage Breakdown   SolidWorks Material ID Composition
    Thickness Shape   Material Loss on Ignition
          Color Elongation
          Construction Peel Adhesion
          Service Temperature  
    Column Header for Electrical
    Covering ID Outer Diameter
    Covering Name Color
    Application Part Number
    Cost Description

Here is an example of an Excel file for one 4-core cable, part number C1, and four individual wires, part numbers 9982 through 9985.

ImportCables.gif

Contents



Provide feedback on this topic

SOLIDWORKS welcomes your feedback concerning the presentation, accuracy, and thoroughness of the documentation. Use the form below to send your comments and suggestions about this topic directly to our documentation team. The documentation team cannot answer technical support questions. Click here for information about technical support.

* Required

 
*Email:  
Subject:   Feedback on Help Topics
Page:   Creating Cable Wire, Component, or Covering Excel Files
*Comment:  
*   I acknowledge I have read and I hereby accept the privacy policy under which my Personal Data will be used by Dassault Systèmes

Print Topic

Select the scope of content to print:

x

We have detected you are using a browser version older than Internet Explorer 7. For optimized display, we suggest upgrading your browser to Internet Explorer 7 or newer.

 Never show this message again
x

Web Help Content Version: SOLIDWORKS 2014 SP05

To disable Web help from within SOLIDWORKS and use local help instead, click Help > Use SOLIDWORKS Web Help.

To report problems encountered with the Web help interface and search, contact your local support representative. To provide feedback on individual help topics, use the “Feedback on this topic” link on the individual topic page.

0.20.46