Integrating Microsoft Excel to manage design tables


show more When using SOLIDWORKS, you can take advantage of the power of Microsoft Excel to create and manage a design table. An embedded design table allows you to drive your parts in a variety of configurations of the same part. This video tutorial explains the basics of integrating Microsoft Excel to manage design tables. show less
please wait ...

Integrating Microsoft Excel to manage design tables

Within SolidWorks, we can use all the power of Microsoft Excel to drive our parts in various configurations of the same part. To get started, we need a base part that we're going to drive. Let's go ahead and get started with 16.3 dash 1. It's just a simple block with a hole in the center. We're then going to link the values to derive the size within a design table. To get started, let's go ahead and take a look at the sketch that underlies this part. And open up sketch one. Take a look and you can see we've got a couple of values in here. We've got 5 inches wide, 4 inches tall, 3 inch hole in there with a quarter inch radius.

And those are the values we're going to be overriding and using within the design table. Let's exit out of that and come up here to insert, tables, design table. And use the auto create function, which is great. Click on OK, and what it does now is it actually asks us which of the values that we want to bring into the table to be driven. So, I nee...

Integrating Microsoft Excel to manage design tables
Video duration: 7m 10s 6h 20m Beginner

Viewers:

When using SOLIDWORKS, you can take advantage of the power of Microsoft Excel to create and manage a design table. An embedded design table allows you to drive your parts in a variety of configurations of the same part. This video tutorial explains the basics of integrating Microsoft Excel to manage design tables.

Subject:
CAD
Software:
SOLIDWORKS
Author:
please wait ...