Tutorialspoint
Subscription Includes
$ 144.99   9.99

Programming AutoCAD to Excel using VB.NET - Hands On!

Created by Arnold Higuit, Last Updated 02-Apr-2021, Language:English

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.

Created by Arnold Higuit, Last Updated 02-Apr-2021, Language:English

What Will I Get ?

  • 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

Requirements

  • 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)

Description

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.

Course Content

Arnold Higuit

Sr. 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).