Name: Programming AutoCAD to Excel using VB.NET - Hands On!
Rating: 4.7 (42 reviews)

Udemy Business

Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Created byArnold Higuit

Last updated 2/2021

English

What you'll 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

Course content

6 sections • 100 lectures • 9h 17m total length

Introduction3:31
This video discusses the Topics in this course.
Who is this course for?1:52
This topic mentions who is this course meant for.
What will you learn from this course?4:50
This video discusses what will you learn from this course.
Tools needed1:23
This video lists out the tools that you will be needing for this course.
Course Prerequisites3:58
This video mentions the prerequisites of this course.

Section Overview - Export AutoCAD Objects to Excel1:54
This video discusses the topics covered in this section.
Exporting Lines to Excel - Overview2:06
This video gives a high level information of exporting AutoCAD Line Objects to Excel spreadsheet.
Creating the VB.NET-Excel Project5:55
This video walks you through creating the VB.NET Project.
Design of User Interface to Export Lines10:11
This video shows you how to design the User Interface for exporting the Line objects.
Creating the Common Utility Class18:42
This video guides you to create a common utility class that will store all the common methods used in the project.
Creating the ExportLines Method12:04
This video will show you how to develop the ExportLines method to export AutoCAD Line objects to Excel spreadsheet.
Running and Testing ExportLines Method5:48
This video walk you through the testing/running of the ExportLines Method.
Exporting MTexts to Excel - Overview2:25
This video gives you a high level overview of exporting MTexts to Excel spreadsheet.
Creating the ExportMTexts Method11:24
This video show you how to create the method to export MTexts to Excel.
Export Polylines to Excel - Overview1:12
This video gives you a high level information of exporting Polylines to Excel.
Creating the ExportPolylines Method12:19
This video guides you how to develop the ExportPolylines method.
Running and Testing ExportPoylines Method2:14
This video shows you the result of running the ExportPolylines Method.
Export Blocks (Without Attributes) to Excel - Overview1:28
This video gives an overview of exporting Blocks (without attributes) to Excel.
Creating the ExportBlocks Method11:51
This video walks you through creation of ExportBlocks method.
Creating Export Blocks UI and Running the Code5:30
This video creates the UI for exporting the Blocks (without attributes) and running the code.
Exporting Blocks (With Attributes) to Excel - Overview1:59
This videos gives you information about exporting Blocks (with attributes) to Excel.
Creating the User Interface for exporting Blocks to Excel4:53
This video shows you the creation of User Interface to export blocks to Excel.
Creation of BlocksForm UI4:07
This video walks you through creation of BlocksForm UI.
Coding the BlocksForm Load Event8:14
This video shows you how to code the BlocksForm Load Event.
Testing the BlocksForm UI2:36
This video shows you the results of running the BlocksForm UI.
Coding the BlocksForm to populate the Listboxes15:17
This video walks you through developing the methods to manipulate attributes.
Coding the BlocksForm Export Button4:20
This video walks you through the code behind of the Export Button.
Coding the ExportBlocksWithAttributes Method20:34
This video walks you through developing the ExportBlocksWithAttributes method.
Running and Testing ExportBlocksWithAttributes Method.2:16
This video shows the result of exporting blocks with attributes to Excel.

Section Overview - Import Excel File into AutoCAD0:46
This video gives you overview of importing Excel File into AutoCAD.
Importing Lines from Excel File into AutoCAD - Overview1:25
This video gives you high level overview of importing Lines from Excel Spreadsheet file.
Creating ImportExcelUtil Class2:00
This video shows how to develop the ImportExcelUtil Class starting from importing Lines into AutoCAD.
Creating the ImportLines Method18:52
This video shows how to develop the ImportLines method.
Creating the UI for the ImportLines Method1:44
This video shows adding the button for the ImportLines Method.
Coding the ImportLines UI code behind.6:39
This video shows how to develop the code behind the Import Lines button.
Running and Testing ImportLines Method8:21
This video shows the result of testing/running the ImportLines method.
Importing MTexts into AutoCAD - Overview1:26
This video gives you high level overview of importing MTexts from Excel File into AutoCAD.
Creating the ImportMTexts Method10:44
This video walks through developing the ImportMTexts Method.
Creating ImportMTexts User Interface1:37
This video shows how to create the User Interface for the ImportMTexts Method.
Running and Testing ImportMTexts Method1:48
This video shows the result of running/testing of ImportMTexts Method.
Importing Polylines from Excel File into AutoCAD - Overview1:27
This video provides high level overview of importing Polylines into AutoCAD.
Creating the ImportPolylines Method13:35
This video shows how to develop the ImportPolylines Method.
Creating ImportPolylines User Interface1:36
This video shows how to create the UI and code behind to import Polylines from Excel File.
Running and Testing ImportPolylines Method3:05
This video tests and runs the ImportPolylines method.
Importing Blocks (without Attributes) from Excel File into AutoCAD - Overview1:19
This video gives you high level overview of importin blocks (without attributes) from Excel File into AutoCAD.
Creating the ImportBlocks Method9:15
This video shows how to develop the ImportBlocks (without attributes) Method.
Creating the ImportBlocks User Interface1:50
This video shows creating the UI for ImportBlocks Method.
Running and Testing ImportBlocks Method2:52
This video shows running/testing the ImportBlocks Method.
Importing Blocks (with Attirubtes) from Excel File into AutoCAD - Overview1:36
This video provides high level overview of importing Blocks with attributes from Excel File into AutoCAD.
Creating the ImportBlocksWithAttributes Method24:31
This video shows how to develop the ImportBlocksWithAttributes Method.
Creating the UI for ImportBlocksWithAttributes Method4:19
This video shows how to create the UI for the ImportBlocksWithAttributes Method.
Running and Testing ImportBlocksWithAttributes Method3:08
This video shows the result of running and testing the ImportBlocksWithAttributes Method.

Exporting Lines to a File - Overview1:53
This video gives you a high level overview of exporting Lines to a File.
Creating the ExportToFile Utility Class4:01
This video shows the creation of ExportFileUtil Class.
Creating ExportLinesToFile Method14:15
This video shows how to develop the ExportLinesToFile Method.
Creating the UI for ExportLinesToFile Method7:40
This video shows how to create the UI for the ExportLinesToFile Method.
Running and Testing ExportLinesToFile Method1:52
This video shows the result of running and testing of ExportLinesToFile Method.
Exporting MTexts To File - Overview1:24
This video provides overview about exporting MTexts to File.
Creating the MTextToFile Method6:05
This video shows how to develop the EXportMTextToFile Method.
Creating the UI for the ExportMTextToFile Method1:20
This video shows the creation of UI for the ExportMTextsToFile Method.
Running and Testing ExportMTextToFile Method.7:50
This video shows the result of running and testing the ExportMTextToFile Method.
Exporting Polylines to File - Overview1:48
This video gives a high level overview of exporting Polylines to a File.
Creating ExportPolylinesToFile Method10:35
This video shows how to develop the ExportPolylinesToFile Method.
Exporting Polylines to File - User Interface1:26
This video shows the creation of UI for the ExportPolylinesToFile Method.
Running and Testing ExportPolylinesToFile Method1:37
This video shows running and testing the ExportPolylinesToFile Method.
Exporting Blocks (without Attributes) to File - Overview2:08
This video shows how to export Blocks (without attributes) to a file.
Creating the ExportBlocksToFile Method10:24
This video shows how to create ExportBlocksToFile Method.
Creating ExportBlocksToFile User Interface1:58
This video shows how to create the ExportBlocksToFile User Interface.
Running and Testing ExportBlocksToFile Method1:55
This video shows the result of running and testing ExportBlocksToFile Method.
Exporting Blocks (With Attributes) to a File - Overview2:10
This video gives high level overview of Exporting Blocks (With Attributes) to a File.
Creating the EXportBlocksWithAttributesToFile Method18:32
This video shows how to develop the ExportBlocksWithAttributes Method.
Creating the UI for ExportBlocksWithAttributesToFile Method6:14
This video shows the creation of UI for the ExportBlocksWithAttributesToFile Method.
Coding the BlocksForm for ExportBlocksWithAttributeToFile Method3:42
This video shows the coding of BlocksForm for the ExportBlocksWithAttributesToFile Method.
Running and Testing ExportBlocksWithAttributesToFile Method2:50
This video shows the result of running and testing the ExportBlocksWithAttributesToFile Method.

Importing Text File into AutoCAD - Overview1:13
This video provides high level overview of importing Text File into AutoCAD.
Importing Lines from a Text File into AutoCAD - Overview1:51
Creating the ImportFileUtil Class1:22
This video shows the creation of FileUtilClass.
Creating the ImportLinesMethod16:49
This video shows how to create the ImportLines Method.
Creation of ImportLines User Interface2:32
This video shows how the creation of ImportLines UI.
Coding the ImportLines UI button4:51
This video shows the coding of ImportLines UI button.
Running and Testing the ImportLines Method3:50
This video shows the result of running/testing of ImportLines Method.
Importing MTexts from Text File into AutoCAD - Overview1:53
This video provides a high level overview of importing MTexts from a Text File into AutoCAD.
Creating the ImportMTexts Method8:57
This video shows how to create the ImportMTexts Method.
Creating the TextStyle Manipulation Code2:25
This video shows how to code the TextStyle to be assigned to MText object.
Creating the UI for the ImportMTexts Method1:27
This video shows creating the button and coding it to call the ImportMText Method.
Running and Testing the ImportMTexts Method3:45
This video shows the result of running/testing of importing MTexts from a File into AutoCAD.
Importing Polylines from a Text File into AutoCAD - Overview1:49
This video provides a high level overview of importing Polylines from a Text File into AutoCAD.
Creating the ImportPolylines Method18:12
This video shows how to develop the ImportPolylines from a File Method.
Creating the ImportPolylines UI1:36
This video shows how to create the UI button and the code behind it.
Running and Testing ImportPolylines (from a File) Method2:14
This video shows the result of running/testing the ImportPolylines Method.
Importing BLocks (without Attributes) from a Text File into AutoCAD - Overview1:34
This video shows provides a high level overview of importing Blocks (without Attributes) from a Text File into AutoCAD.
Creating the ImportBlocks (without Attributes) Method14:29
This videos shows how to create the ImportBlocks (Without Attributes) Method.
Creating the ImportBlocks UI4:39
This videos shows the creationg of Button UI and code behind it to call the ImportBlocks Method.
Running and Testing ImportBlocks (without Attributes) Method3:38
This video shows the result of running/testing of ImportBlocks (without attributes) Method.
Importing Blocks (with Attributes) from a Text File into AutoCAD - Overview1:39
This video provides high level overview of importing Blocks (With Attributes) from a File into AutoCAD.
Creating the ImportBlocksWithAttributes From a File Method23:34
This video shows the creation on ImportBlocksWithAttributes Method.
Creating the ImportBlocksWithAttributes (from a File) UI (Part 1)5:34
This video shows the creation of ImportBlocksWithAttributes UI (Part 1).
Creating the ImportBlocksWithAttributes (from a File) UI (Part 2)4:04
This video shows the coding part of the BlocksForm to handle the importing of Blocks with Attributes.
Running and Testing ImportBlocksWithAttributes (from a File) Method3:03
This video shows the result of running/testing of ImportBlocksWithAttributes Method.

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.

Who this course is for:

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

What you'll learn

Explore related topics

Course content

Introduction5 lectures • 16min

Section 2 - Exporting AutoCAD Objects to Excel24 lectures • 2hr 49min

Section 3 - Importing Excel File into AutoCAD23 lectures • 2hr 4min

Section 4 - Exporting AutoCAD Objects to a File22 lectures • 1hr 52min

Section 5 - Importing Text File into AutoCAD25 lectures • 2hr 17min

Section 6 - Conclusion1 lecture • 1min

Requirements

Description

Who this course is for: