Link External Data set up link and select Excel spreadsheet from the Data Link Manager.Select the object property (ID in this example) you want to extract.Select the object (block/multileader) you want to extract from the current drawing(s).Create a new Data Extraction data extraction file, select drawings to extract from, etc.Use the Extract Data tool found on the Linking & Extraction panel of the Insert tab. This method will still work if you chose to key in on a block you inserted into your drawing. To remain true to the concept of a parts list, I chose to use multileaders to help illustrate some of this methods versatility. Create a new Multileader style (optional).I kept it simple with just one field, but your Attributed Block could have any number of fields (attributes). Create a new drawing (you can also use existing drawings).Here’s a basic outline of how all of this magic comes together to help you follow along with the video: The process is rather involved, so rather than attempting to write things out, I chose to make a video that allows you to see everything (not just what I choose to grab screenshots of). That’s exactly what I’m going to show you today. While Excel table linking and Data Extraction tables are certainly powerful features by their self, what if we could combine them into one super table? The idea is that you can get AutoCAD to create a dynamic table from the information contained inside your drawing or drawings (yes Data Extraction tables can work with multiple drawings – very cool). Another one of my personal favorite features inside AutoCAD are Data Extraction Tables. Likewise, it seems I’m not alone with that notion, as my posts discussing AutoCAD and Excel interoperability are consistently some of my post popular posts here at The CAD Geek. Ever since its introduction in 2008, Excel table linking has been one of my favorite features inside AutoCAD. Anyone who follows me on twitter got a heads up about this post yesterday.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |