Today I take a look at linking excel to your Inventor part models. I show how create your excel sheet and link the parameters inside of your models to the spreadsheet itself. I also have a little bonus material for your part list descriptions. Take a look.
Inventor Part Files – Linking to Excel
Tags: excel, Link, parameters
One of the more advanced Parts List capabilities in Inventor is the ability to roll-up total quantities of common items in a parts list. This is accomplished through the “Group Settings” button in the Parts List dialog box. An example might be to get a total length of a particular material used in a design. This can be particularly useful when used in conjuction with the new Filter (search the blog for Dave’s post) tool in Inventor’s parts list.
For an example of parts list roll-up check out this video:
Contributed by Ben of the INCAT CAD Geeks
Life is only getting easier with the newest release of Inventor. With the addition of Parts list filters you now have the ability to control which items are displayed in your parts list. Choices you have for filters are: Assembly View Representation, Ballooned Items Only, Item Number Range, Purchased Items and Standard Content. These filters are used in combinations and are available either globally in the Parts List Style, or locally in the Parts List itself. Check out the video to see these items in action.
Check out my video of how to do this.
Submitted by Dave of the INCAT CAD Geeks