Join Gabriel Corbett for an in-depth discussion in this video Exporting out of Treehouse, part of SOLIDWORKS: Tips & Tricks.
- [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.
Author
Updated
9/29/2020Released
5/4/2016Note: This series is taking a short break and will be back in a few months.
Because this is an ongoing series, viewers will not receive a certificate of completion.
Skill Level Intermediate
Duration
Views
Related Courses
-
SOLIDWORKS: Mold Design
with Tam Black1h 50m Beginner -
SOLIDWORKS: Sheet Metal Design
with Gabriel Corbett2h 51m Intermediate -
Learning SOLIDWORKS
with Gabriel Corbett2h 29m Beginner
-
New This Week
-
Introduction
-
Welcome58s
-
-
Tips and Tricks
-
Switching sketch planes1m 52s
-
Custom property links3m 33s
-
Plane mates1m 26s
-
Convert and offset entities7m 17s
-
Dissolve sketch text tool2m 18s
-
Create a flat pattern6m 22s
-
Use the Combine command3m 6s
-
Checking out virtual sharps5m 16s
-
Looking at normal cuts2m 14s
-
Understanding mouse gestures1m 44s
-
Renaming files4m 16s
-
Checking out Treehouse1m 42s
-
Exporting out of Treehouse1m 25s
-
Mouse gesture tips1m 45s
-
Treehouse1m 42s
-
Selection set1m 53s
-
Exclude from BOM1m 57s
-
Wrap feature2m 24s
-
Split line tricks3m 38s
-
Link to thickness2m 56s
-
FeatureManager search1m 48s
-
Selection tricks1m 33s
-
Power trim tricks1m 58s
-
Recover the popup bar2m 31s
-
Quick reference planes1m 15s
-
Command search1m 39s
-
Export to DXF/DWG 1:16m 53s
-
Breadcrumb tricks3m 11s
-
Sketch Ink Ruler1m 28s
-
Sketch Ink Protractor1m 40s
-
Touch with Sketch Ink1m 29s
-
Freehand markup3m 59s
-
Bounding Box in assemblies2m 39s
-
eDrawings webpage creation2m 11s
-
Defeature Silhouette5m 21s
-
Exploded View improvements1m 36s
-
Save an assembly as a part2m 35s
-
3D textures3m 22s
-
SOLIDWORKS open times1m 35s
-
Arc length2m 35s
-
Reference length3m 11s
-
Zoom to fit tricks1m 1s
-
Trim tool enhancements1m 40s
-
Weldment corners3m 6s
-
Smart patterns8m 49s
-
Sensors2m 1s
-
Shell only one section3m 28s
-
Square spring4m 47s
-
Using equal curvature1m 57s
-
Fun with magnetic mates4m 6s
-
Direct editing: Delete Hole2m 22s
-
Using the reload command2m 4s
-
Using the Biad to sketch1m 21s
-
Fun with intersections3m 36s
-
Previous Selection1m 5s
-
Select Other1m 28s
-
Select Tangency1m 49s
-
Selection Filters: F5 and F63m 41s
-
Save SOLIDWORKS settings2m 10s
-
Flat Tree View1m 14s
-
Collapse a tree55s
-
Folders in the tree2m 17s
-
Custom views1m 41s
-
Custom views in drawings1m 43s
-
Rotate about an entity1m 27s
-
Normal To1m 3s
-
Zoom to Selection1m 16s
-
Rotate about the scene floor1m 27s
-
Reference triad1m 9s
-
Lasso Selection1m 52s
-
Zoom to Selection1m 20s
-
Save As with References2m 46s
-
Viewing a part in wireframe1m 25s
-
Close sketch to model1m 23s
-
SketchXpert1m 50s
-
Invert Selection55s
-
Single command per pick1m 21s
-
Derived Sketch2m 28s
-
Pierce vs. coincident1m 31s
-
Reset Dragging59s
-
Feature Freeze1m 27s
-
Importing a mesh body3m 30s
-
Converting to a mesh body3m 45s
-
Mesh Prep Wizard5m 5s
-
ScanTo3D and Curve Wizard6m 18s
-
Decimate Mesh Body4m 10s
-
ScanTo3D: Mesh Edit1m 55s
-
Surface From Mesh tool2m 44s
-
ScanTo3D: Surface Wizard3m 31s
-
Using MeshLab3m 21s
-
3D textures3m 16s
-
Add hardware to assemblies1m 51s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.
CancelTake notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Exporting out of Treehouse