...From Part 1
Workshop: Linking Excel and Solid Edge
Step 1 :
On the Windows Start menu click Start > Programs > Microsoft Office > Excel
![clip_image002 clip_image002](http://lh3.ggpht.com/-hYpnFw7okVY/U9Y6x3C1PTI/AAAAAAAAJkM/S3UC0Ps3t8E/clip_image002_thumb.gif?imgmax=800)
Step 2 :
This will start Excel with an empty spreadsheet open.
Step 3 :
Enter some values in the cells as shown below :
Save the Excel file.
Step 4 :
Start Solid Edge and create a simple box by extruding a rectangle.
When sketching, apply dimensions to the rectangle. Solid Edge will apply the height dimension for you.
Step 5 :
Save the Solid Edge file also, preferably in the same folder as the Excel file.
In Solid Edge, select Tools > Variables > Variables…
This will open a small window with a tabular format like Excel.
This is called the Variable Table for the model.
The Variable table maintains a list of all dimensions and other user-defined variables for the currently open file. Also it serves as a facility to link an Excel spreadsheet with the Solid Edge model.
Note that when you click a particular dimension in the Variable Table, the corresponding one is highlighted in the Graphics Area.
You can also change the name of a dimension variable in the Variable Table.
Step 6 :
Initially, Solid Edge would name the dimensions randomly, for eg. V411.
In the variable table, click on the name of a variable and type a new name Length.
Similarly, rename other variables to Width and Height.
Part 3...
Workshop: Linking Excel and Solid Edge
Step 1 :
On the Windows Start menu click Start > Programs > Microsoft Office > Excel
![clip_image002 clip_image002](http://lh3.ggpht.com/-hYpnFw7okVY/U9Y6x3C1PTI/AAAAAAAAJkM/S3UC0Ps3t8E/clip_image002_thumb.gif?imgmax=800)
Step 2 :
This will start Excel with an empty spreadsheet open.
![clip_image004 clip_image004](http://lh5.ggpht.com/-bjW4GQo-k08/U9Y6zT9JAHI/AAAAAAAAJkc/2546HFJAYRk/clip_image004_thumb.gif?imgmax=800)
Step 3 :
Enter some values in the cells as shown below :
![clip_image006 clip_image006](http://lh3.ggpht.com/-forXAlbzMhk/U9Y600OBciI/AAAAAAAAJks/ng-3q6KsEvo/clip_image006_thumb.jpg?imgmax=800)
Save the Excel file.
Step 4 :
Start Solid Edge and create a simple box by extruding a rectangle.
When sketching, apply dimensions to the rectangle. Solid Edge will apply the height dimension for you.
![clip_image008 clip_image008](http://lh6.ggpht.com/-dXANMTXucFI/U9Y62E0HcwI/AAAAAAAAJk8/201Fg_ZEV3Q/clip_image008_thumb.jpg?imgmax=800)
Step 5 :
Save the Solid Edge file also, preferably in the same folder as the Excel file.
In Solid Edge, select Tools > Variables > Variables…
This will open a small window with a tabular format like Excel.
This is called the Variable Table for the model.
The Variable table maintains a list of all dimensions and other user-defined variables for the currently open file. Also it serves as a facility to link an Excel spreadsheet with the Solid Edge model.
![clip_image010 clip_image010](http://lh6.ggpht.com/-GmsndekR8AY/U9Y63_aEIPI/AAAAAAAAJlM/rwhctSuvd5c/clip_image010_thumb.jpg?imgmax=800)
Note that when you click a particular dimension in the Variable Table, the corresponding one is highlighted in the Graphics Area.
You can also change the name of a dimension variable in the Variable Table.
Step 6 :
Initially, Solid Edge would name the dimensions randomly, for eg. V411.
In the variable table, click on the name of a variable and type a new name Length.
Similarly, rename other variables to Width and Height.
![clip_image012 clip_image012](http://lh5.ggpht.com/-uqmMYQVH3rA/U9Y65d5p-tI/AAAAAAAAJlc/Tsvk-ChzDGU/clip_image012_thumb.jpg?imgmax=800)
Part 3...
Solid Edge knowledge sharing, tutorials, videos, tips, CAD cartoons, SE crosswords, puzzles, games, SE events, SE job opportunities.
Keep yourself updated, contribute or just browse...
No comments:
Post a Comment