Description
Learn to combine the power of Microsoft® Excel® with the power of AutoCAD software. This class will explore several ways you can use AutoCAD and Microsoft Excel in tandem without programming. You'll be able to apply everything learned in this class using an out-of-the-box installation of AutoCAD and Microsoft Excel. Conventional concepts will include working with Data Links to display, update, and manage Excel data from AutoCAD. Lesser-known concepts will include updating Update Block Attributes from Excel tables, combining Data Extraction tables with Excel (Data Link) tables, and writing AutoCAD script files using Excel.
Key Learnings
- Combine data from a data extraction table with data from an Excel spreadsheet
- Automate tasks with AutoCAD script files that are created with Excel
- Create data links to display, manage, and update Excel tables from AutoCAD
- Update AutoCAD block attributes using data from an Excel spreadsheet