In this article, I am going to show you how you can take advantage of parametric design and spreadsheets to control your model parameters and Link excel spreadsheet to solid Edge.
First of all, Let me explain why this is important. Imagine that you have a very complicated assembly and you want to slightly change an aspect of a part. It would be a hassle to find that part and find that dimension to change. You will need more time to select the proper feature from the features tree and change it. But if you use variables and spreadsheet connections, you have basically a collection of all important dimensions in which you can easily change and the model will change in real-time.
It is also important to know that for real-time visualization of changes you need to first open Solid Edge and then open and edit the spreadsheet.
Linking Excel spread sheet to Solid Edge
- Create a model with dimensions in Solid Edge
- Prepare an excel spreadsheet with dimension values
- copy the desired value from spreadsheet
- Click variables button on the tools bar or from right-click menu on Solid Edge
- Right-click desired value row from variables window and select Paste link
Possible issues when you want to link the spread sheet to variables
1- Dimensions are not shown in the variables window? like the image
Answer: You need to specify dimensions after creating the 3D part. Sketching dimensions are not shown in the variables window.
2- Paste link option is grayed out in solid edge variables window ?
Answer: Your dimension is not locked, try locking the dimension and the paste link option will be active.
after linking you should see the Excel file location on the formula column.
I hope this article helps you to design parts efficiently.
If you have any questions or suggestions you’re most welcome to write in comments.