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

Programming AutoCAD to Excel using VB.NET – Hands On!, available at $54.99, has an average rating of 4.75, with 100 lectures, based on 34 reviews, and has 340 subscribers.

You will learn about 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 This course is ideal for individuals who are AutoCAD Users who want to learn how to interact Excel and AutoCAD using VB .NET or AutoCAD Developers (AutoLISP, VBA, C#, VB .NET) or Quantity Surveyors or Cost Estimators It is particularly useful for AutoCAD Users who want to learn how to interact Excel and AutoCAD using VB .NET or AutoCAD Developers (AutoLISP, VBA, C#, VB .NET) or Quantity Surveyors or Cost Estimators.

Enroll now: Programming AutoCAD to Excel using VB.NET – Hands On!

Summary

Title: Programming AutoCAD to Excel using VB.NET – Hands On!

Price: $54.99

Average Rating: 4.75

Number of Lectures: 100

Number of Published Lectures: 100

Number of Curriculum Items: 100

Number of Published Curriculum Objects: 100

Original Price: $34.99

Quality Status: approved

Status: Live

What You Will Learn

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

Who Should Attend

AutoCAD Users who want to learn how to interact Excel and AutoCAD using VB .NET
AutoCAD Developers (AutoLISP, VBA, C#, VB .NET)
Quantity Surveyors
Cost Estimators

Target Audiences

AutoCAD Users who want to learn how to interact Excel and AutoCAD using VB .NET
AutoCAD Developers (AutoLISP, VBA, C#, VB .NET)
Quantity Surveyors
Cost Estimators

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 Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Lecture 2: Who is this course for?

Lecture 3: What will you learn from this course?

Lecture 4: Tools needed

Lecture 5: Course Prerequisites

Chapter 2: Section 2 – Exporting AutoCAD Objects to Excel

Lecture 1: Section Overview – Export AutoCAD Objects to Excel

Lecture 2: Exporting Lines to Excel – Overview

Lecture 3: Creating the VB.NET-Excel Project

Lecture 4: Design of User Interface to Export Lines

Lecture 5: Creating the Common Utility Class

Lecture 6: Creating the ExportLines Method

Lecture 7: Running and Testing ExportLines Method

Lecture 8: Exporting MTexts to Excel – Overview

Lecture 9: Creating the ExportMTexts Method

Lecture 10: Export Polylines to Excel – Overview

Lecture 11: Creating the ExportPolylines Method

Lecture 12: Running and Testing ExportPoylines Method

Lecture 13: Export Blocks (Without Attributes) to Excel – Overview

Lecture 14: Creating the ExportBlocks Method

Lecture 15: Creating Export Blocks UI and Running the Code

Lecture 16: Exporting Blocks (With Attributes) to Excel – Overview

Lecture 17: Creating the User Interface for exporting Blocks to Excel

Lecture 18: Creation of BlocksForm UI

Lecture 19: Coding the BlocksForm Load Event

Lecture 20: Testing the BlocksForm UI

Lecture 21: Coding the BlocksForm to populate the Listboxes

Lecture 22: Coding the BlocksForm Export Button

Lecture 23: Coding the ExportBlocksWithAttributes Method

Lecture 24: Running and Testing ExportBlocksWithAttributes Method.

Chapter 3: Section 3 – Importing Excel File into AutoCAD

Lecture 1: Section Overview – Import Excel File into AutoCAD

Lecture 2: Importing Lines from Excel File into AutoCAD – Overview

Lecture 3: Creating ImportExcelUtil Class

Lecture 4: Creating the ImportLines Method

Lecture 5: Creating the UI for the ImportLines Method

Lecture 6: Coding the ImportLines UI code behind.

Lecture 7: Running and Testing ImportLines Method

Lecture 8: Importing MTexts into AutoCAD – Overview

Lecture 9: Creating the ImportMTexts Method

Lecture 10: Creating ImportMTexts User Interface

Lecture 11: Running and Testing ImportMTexts Method

Lecture 12: Importing Polylines from Excel File into AutoCAD – Overview

Lecture 13: Creating the ImportPolylines Method

Lecture 14: Creating ImportPolylines User Interface

Lecture 15: Running and Testing ImportPolylines Method

Lecture 16: Importing Blocks (without Attributes) from Excel File into AutoCAD – Overview

Lecture 17: Creating the ImportBlocks Method

Lecture 18: Creating the ImportBlocks User Interface

Lecture 19: Running and Testing ImportBlocks Method

Lecture 20: Importing Blocks (with Attirubtes) from Excel File into AutoCAD – Overview

Lecture 21: Creating the ImportBlocksWithAttributes Method

Lecture 22: Creating the UI for ImportBlocksWithAttributes Method

Lecture 23: Running and Testing ImportBlocksWithAttributes Method

Chapter 4: Section 4 – Exporting AutoCAD Objects to a File

Lecture 1: Exporting Lines to a File – Overview

Lecture 2: Creating the ExportToFile Utility Class

Lecture 3: Creating ExportLinesToFile Method

Lecture 4: Creating the UI for ExportLinesToFile Method

Lecture 5: Running and Testing ExportLinesToFile Method

Lecture 6: Exporting MTexts To File – Overview

Lecture 7: Creating the MTextToFile Method

Lecture 8: Creating the UI for the ExportMTextToFile Method

Lecture 9: Running and Testing ExportMTextToFile Method.

Lecture 10: Exporting Polylines to File – Overview

Lecture 11: Creating ExportPolylinesToFile Method

Lecture 12: Exporting Polylines to File – User Interface

Lecture 13: Running and Testing ExportPolylinesToFile Method

Lecture 14: Exporting Blocks (without Attributes) to File – Overview

Lecture 15: Creating the ExportBlocksToFile Method

Lecture 16: Creating ExportBlocksToFile User Interface

Lecture 17: Running and Testing ExportBlocksToFile Method

Lecture 18: Exporting Blocks (With Attributes) to a File – Overview

Lecture 19: Creating the EXportBlocksWithAttributesToFile Method

Lecture 20: Creating the UI for ExportBlocksWithAttributesToFile Method

Lecture 21: Coding the BlocksForm for ExportBlocksWithAttributeToFile Method

Lecture 22: Running and Testing ExportBlocksWithAttributesToFile Method

Chapter 5: Section 5 – Importing Text File into AutoCAD

Lecture 1: Importing Text File into AutoCAD – Overview

Lecture 2: Importing Lines from a Text File into AutoCAD – Overview

Lecture 3: Creating the ImportFileUtil Class

Lecture 4: Creating the ImportLinesMethod

Lecture 5: Creation of ImportLines User Interface

Lecture 6: Coding the ImportLines UI button

Lecture 7: Running and Testing the ImportLines Method

Lecture 8: Importing MTexts from Text File into AutoCAD – Overview

Lecture 9: Creating the ImportMTexts Method

Lecture 10: Creating the TextStyle Manipulation Code

Lecture 11: Creating the UI for the ImportMTexts Method

Lecture 12: Running and Testing the ImportMTexts Method

Lecture 13: Importing Polylines from a Text File into AutoCAD – Overview

Lecture 14: Creating the ImportPolylines Method

Lecture 15: Creating the ImportPolylines UI

Lecture 16: Running and Testing ImportPolylines (from a File) Method

Lecture 17: Importing BLocks (without Attributes) from a Text File into AutoCAD – Overview

Lecture 18: Creating the ImportBlocks (without Attributes) Method

Lecture 19: Creating the ImportBlocks UI

Lecture 20: Running and Testing ImportBlocks (without Attributes) Method

Lecture 21: Importing Blocks (with Attributes) from a Text File into AutoCAD – Overview

Instructors

Arnold Higuit
Sr. Software Developer

Rating Distribution

1 stars: 0 votes
2 stars: 0 votes
3 stars: 2 votes
4 stars: 10 votes
5 stars: 22 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu