You can import and export Hole Wizard data with help Excel files in the Configuration tool with SOLIDWORKS 2018.
Now you can import and export data to the Hole Wizard in the configurator tool SOLIDVORKS Toolbox 2018.
This is helpful when you edit an entire standard or create a few new sizes of holes. Do the following steps
In SOLIDWORKS, click Tools-Options-System Options-Hole Wizard/Toolbox-Configure.
From the Windows Start menu, click All Programs-SOLIDWORKS 2018-SOLIDWORKS Tools-Toolbox Settings 2018-Configure.
Click Hole Wizard
Browse to the type of hole to import (export) data for, such as DIN
Export Hole Data Tables
Exporting
Import the resulting file backward into the Solidworks Toolbox
Importing
Error importing
Open the file and delete the "Sheet1", save it.
Delete "Sheet1"
Import the resulting file backward into the Solidworks Toolbox
An Excel file can be exported first to obtain the proper setup and existing sizes. This Excel file has 3 sheets at the bottom, analogous to the Standard Properties of a Hole Wizard type:
Sizes
Thread Data (besides Straight Holes)
Screw Clearances (besides for Tapped Holes)
Once you have customized the exported Excel file, save as a exclusive filename (so you have a copy of the original Excel setup) and then use Import Hole Data Tables.
No comments:
Post a Comment