You can create cable/wire, component, or covering library data in an Excel spreadsheet and import it into SOLIDWORKS to create a library.
-
Under Excel File path, click Browse (...) and open the Excel file to import.
-
For a cable/wire or covering library, select the type of library you are going to create from the list.
A table that corresponds to the type of library you selected appears. (There are two tables for Cable Library and for Piping & Tubing.)
-
In the table, under Excel Column Name, double-click each row and select the column name in the Excel spreadsheet to map to the library column.
For covering libraries only, Excel Column Name is under Covering Column List.
- If you selected Piping & Tubing in step 2, under Material Column List, under Excel Column Name, double-click each row and select the column name in the Excel spreadsheet to map to items in Material Library Column Name.
- Click Next.
- Set options in the dialog box.