Get a new tip every Wednesday for working faster and more efficiently in SOLIDWORKS.
- [Instructor] For this weeks' tip and trick, we are going to be continuing on from last week's tip. For this week's tip, we're going to be looking at Treehouse again and showing you what you can do to export these files out to Excel and showing you how you can export these tree documents out to Excel. Now if you didn't, now if, now if you haven't look at Treehouse, Treehouse is a great way to build a design tree ahead of time or continue on an existing design tree.
I can drop and drop individual parts, different assemblies and so on even drawings out in to this work environment here, create a tree document and then save them out to individual SOLIDWORKS files like parts, assemblies and drawings or I can save the tree that I've already created or that's already there out to my, and then I can save the tree that's already there or that I've created out to a Microsoft Excel document. Let's go ahead and try that out. Go up here and click on open in Excel. Click on that. I can either open the entire structure or just the parts.
I'm going to go ahead and choose the structure. Click OK and you can see here in Excel that opens up and you can see here indented in is so that's here my top level of assembly and then indented under that are the individual parts themselves, the configurations that might be active, how many are involved in this assembly, any descriptions you might have in here and then some part number notes and all these are, and then some part numbers, materials, notes and so on that are associated with that file. This is a great way to take a bunch of data that's already been existing inside of SOLIDWORKS, export it to a nice bill of materials like this that we can then work on and see how things are related together in that design tree.
Thanks for watching. Definitely check out. Thanks for watching and definitely check out Treehouse and some of the associated things you can do like saving it out to Excel. It'll definitely save you some time if you're working with large complicated bills of materials.