Hide Table of Contents

Settings Dialog Box

Use this dialog box to import an Excel spreadsheet for a library. You can also map the Excel column names to the column names used in Routing.
This dialog box appears only if you selected Import a library in Excel format.
To display this dialog box, do one of the following:
  • Click Routing > Routing Tools > Routing Library Manager , and click Covering Library Wizard .
  • From the Windows Start menu, click All Programs > SolidWorks version > SolidWorks Tools > SolidWorks version Routing Library Manager > Covering Library Wizard .
  Excel File path Lets you browse to the Excel file to import.
  Library type Sets the type of library: Piping & Tubing or Electrical. The libraries have different sets of attributes, so you need to select the Library type that corresponds with your data.
  Covering Column List
Covering Library Column Name
Displays the column names that are used in the library you are creating or editing:
  • Covering ID: Unique identifying number for the covering type
  • Covering Name: Name that appears in the Coverings PropertyManager and the FeatureManager design tree
  • Covering Type: Used to categorize the coverings into different subtypes and filter items in the Coverings PropertyManager
  • Width: Outer diameter or range of diameters that are valid for this part
  • Thickness: Cross-sectional thickness of the covering
  • Packing: Form in which the covering is supplied
  • Part Number: Unique value for each covering
  • Application: Where the covering can be used
  • Voltage Breakdown: Minimum allowable voltage to cause the covering to become electrically conductive
  • Shape: Cross-sectional profile of the covering
Excel Column Name
Displays the column names that are used in the Excel file. You can double-click any item in this column to map it to the appropriate item in Covering Library Column Name.
  Material Column List This appears if you set Library type to Piping & Tubing.
Material Library Column Name
Displays the material column names that are used in the library you are creating or editing.
Excel Column Name
Displays the column names that are used in the Excel file. You can double-click any item in this column to map it to the appropriate item in Material Library Column Name.


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:   Settings Dialog Box
*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 2012 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.