Programming AutoCAD to Excel using VB.NET - Hands On!
This course will teach you how to develop AutoCAD Plugins that integrates with Excel (and Text Files) using VB.NET.
Updated on Sep, 2023
Language - English
In this course, you will learn how to develop AutoCAD Plugins using VB.NET with Windows Forms that will integrate with Excel and Text Files. You will develop a project that will have all the Export and Import functionalities for both Excel Spreadsheets and Text Files (.csv and .txt).
This will guide you step-by-step, from method creation to designing the UI with the code behind. You will learn how to export Lines, MTexts, Polylines, Blocks with and without Attributes into Excel Spreadsheet as wells as Comma Separated Values (csv files), and Pipe Delimited Files.
You will also learn how to design the User Interface by grouping related controls together using the Group Container control. You will also learn how to pass data from one form to another using Fields. Simple code validations are also used in the program.
Furthermore, for every section and individual tasks, it gives you a high level flow chart that serves as a guide in developing your methods.
The plugin source code will be available for you to follow along. You are free to modify and use the code for your respective needs.
By the time you finish this course, you will have the fully functional plugin complete with User Interfaces that you can use right away at work.
Join me and explore the world of AutoCAD, VB.NET, and Excel.
What will you learn in this course:
- Develop a program to select and read AutoCAD Objects then export Properties to Excel
- Develop a program to open and read Excel file and import into AutoCAD
- Develop a program to select and read AutoCAD Objects then export Properties into a Text File
- Develop a program to open and read a Text File and import into AutoCAD
What are the prerequisites for this course?
- Basic knowledge of AutoCAD
- Basic knowledge of Excel
- Basic knowledge of VB .NET (would be helpful but not required)
- Familiarity of AutoCAD .NET API (good to have)
Check out the detailed breakdown of what’s inside the course
- Introduction 03:31 03:31
- Who is this course for? 01:52 01:52
- What will you learn from this course? 04:50 04:50
- This video discusses what will you learn from this course. 01:23 01:23
- Course Prerequisites 03:58 03:58
Section 2 - Exporting AutoCAD Objects to Excel
Section 3 - Importing Excel File into AutoCAD
Section 4 - Exporting AutoCAD Objects to a File
Section 5 - Importing Text File into AutoCAD
Section 6 - Conclusion
Arnold HiguitSr. Software Developer
A Sr. Software Developer and a Microsoft Certified Solutions Developer (MCSD) and Microsoft Certified Applications Developer (MCAD) with extensive knowledge on different technology in different industries.
I have worked on several companies ranging from Architectural, Engineering & Construction, Utilities, Marketing, Telecommunications, and now in Financial Corporation.
I have been exposed to many different Technologies and Frameworks and Programming Languages. Developing applications using C#, Java, AutoLISP, VB/VBA, GIS and CAD Applications. I also worked on many different Enterprise Databases (e.g. SQL Server, Oracle, Sybase).
User your certification to make a career change or to advance in your current career. Salaries are among the highest in the world.
Our students work
with the Best
Related Video CoursesView More
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video CoursesSubscribe now
Master prominent technologies at full length and become a valued certified professional.Explore Now