You can now import and export Hole Wizard data with Excel files in the Configuration tool with SOLIDWORKS 2018. 

You can import and export data from Microsoft Excel files for Hole Wizard holes. This is helpful when you edit an entire standard or create several new sizes of holes.

Do one of the following:

  • In SOLIDWORKS, click Tools > Options > System Options > Hole Wizard/Toolbox > Configure.
  • From the Windows Start menu, click All Programs > SOLIDWORKS version > SOLIDWORKS Tools > Toolbox Settings version > Configure.


Hole Wizard-LeninSW

Click Hole Wizard

DIN Standards-LeninSW

Browse to the type of hole to import or export data for, such as DIN

Export Hole Data Tables LeniSW

Export Hole Data Tables

Exporting LeninSW

Exporting

Import the resulting file back into the Solidworks Toolbox

Importing-LeninSW.com

Importing


Error importing

Open the file and delete the "Sheet1", save it.
Delete "Sheet1"=LeninSW.com

Delete "Sheet1"


Import the resulting file back into the Solidworks Toolbox



An Excel file can be exported first to obtain the proper setup and existing sizes. This Excel file has 3 tabs at the bottom, corresponding to the Standard Properties of each Hole Wizard type:
  • Sizes
  • Thread Data (except for Straight Holes)
  • Screw Clearances (except for Tapped Holes)

Once you have customized the exported Excel file, save as a separate filename (so you have a copy of the original Excel setup) and then use Import Hole Data Tables.


Hole-Wizard–Sizes-LeninSW

SOLIDWORKS 2018 Hole Wizard Export – Sizes

Hole-Wizard Export–Thread Data-LeninSw

SOLIDWORKS 2018 Hole Wizard Export – Thread Data

Hole-Wizard-Export–Screw Clearances-LeninSW

SOLIDWORKS 2018 Hole Wizard Export – Screw Clearances

For Thread Data, be sure to have a matching “full-size” to the “size” in the Sizes tab.

Sometimes when you launch SOLIDWORKS and try to load SOLIDWORKS Toolbox Library or Utilities add-in, SOLIDWORKS delivers a message stating “You appear to have experienced problems the last time you loaded the SOLIDWORKS Toolbox add-in”. This issue is only experienced in SOLIDWORKS 2017 SP3.0
SOLIDWORKS Error

Error loading Toolbox Library 




  • If you pick yes, continue to load Toolbox, SOLIDWORKS possibly stops responding!
  • However, if you pick No, disabling Toolbox, everything seems to work fine.
To fix this error you should delete the ‘tb_default.sldedb’ from ‘<C:\Users\<user>\AppData\Roaming\SOLIDWORKS\SOLIDWORKS 2017\Toolbox\data’.
In Windows 7/Vista a  user can open his/her application data folder by running the command ‘appdata’ from Run window.


Navigate to the specified path and delete ‘tb_default.sldedb’.


Then launch SOLIDWORKS, you should have no issues adding the Toolbox Library or Utilities add-in.
This issue has been fixed in SOLIDWORKS 2017SP4.



SolidWorks help
You can view models through one, two, or four viewports.
To open four viewports:

  • Click Four View   (Standard Views toolbar) or Window > Viewport > Four View.
SolidWorks Viewports -Other Display Style
Viewports


You can choose the following viewport arrangements from the Window menu or the Standard Views toolbar:


Tooltip
Views Displayed
Single View
User-specified
Two View - Horizontal
Front and Top
Two View - Vertical
Front and Right
Four View
Front, Right, Top, and Trimetric (Third Angle), or Front, Left, Top, and Trimetric (First Angle). Specify First Angle or Third Angle in Tools > Options > System Options > Display .

The lower left corner of each viewport displays the current orientation.
To choose a different orientation, click the View Orientation   (Heads-up View toolbar).
When you switch from multiple viewports back to a single viewport, the model displays the orientation of the active viewport. If you then switch back to multiple viewports, the orientations are the defaults again.
You can change the orientation or rotation of a model in any viewport independently as long as the viewports are not linked.

These requirements apply to all SOLIDWORKS products except where noted. Use this information to ensure you are always working with a SOLIDWORKS supported and optimized system for hardware, operating system and Microsoft products.

Operating Systems
SOLIDWORKS 2013
SOLIDWORKS 2014
SOLIDWORKS 2015
SOLIDWORKS 2016
SOLIDWORKS 2017
SOLIDWORKS 2018
Windows Vista>
Windows 7 64-bit (SP1 required for
SOLIDWORKS 2014)
Windows 7 32-bit (SP1 required for
SOLIDWORKS 2014)
Windows 8.1 (64-bit only)
(2014 SP1)
Windows 8 (64-bit only)
Windows 10, 64-bit
(2015 SP5)
Hardware
RAM
8GB or more recommended<
Video Card
Processor
Intel or AMD with SSE2 support. 64-bit operating system required
Install Media
DVD drive or broadband internet connection
Microsoft Products
Internet Explorer
IE 8, 9, 10
IE 8, 9, 10 ,11
IE 9, 10 ,11
IE 10,11
IE 11
IE 11
Excel and Word
2007, 2010,
2007, 2010, 2013
2010, 2013
2010, 2013,
2016 (SW2016 SP3)
2010, 2013,
2016
2010, 2013,
2016


Effective work in Solidworks

Search This Blog

Избранное сообщение

How Import and Export Hole Wizard Data with Excel

You can now import and export Hole Wizard data with Excel files in the Configuration tool with SOLIDWORKS 2018.  You can import and expor...

Popular posts