Import Excel spreadsheet and Word text into AutoCAD and MicroStation

Home

Free Trial

New Release

Fast Facts

Order

Tutorial

Support Forum

FAQ

Contact

Partner Links




 


 

Tutorial >> How to batch insert blocks with blocks' attributes linking to Excel

This tutorial allow users to batch insert blocks in AutoCAD with block's attribute values linking to Excel.

You may find it's powerful if you have 100 drawings to insert blocks meanwhile need these blocks' attribute values linking to Excel with the capability of real-time update.

Before trying this tutorial, please make sure you have tried tutorial How to hot link AutoCAD block attributes to Excel

In this tutorial we will show you how to 

  • Create a template drawing containing multiple blocks with their attributes hot-linking to values in Excel

  • Populate attribute values in Excel into multiple drawings based on the template drawing you created

Step 1

Open drawing C:\CADTool\tutorial\acad\PopulateBlock.dwg 

This drawing contains 3 blocks. Block01 and Block02 have 2 attributes, Block03 has 1 attributes.

Step 2

Follow step 1~7 in How to hot link AutoCAD block attributes to Excel to link Block 01 to sheet Sheet 3 in C:\CADTool\tutorial\office\tut02.xls

Step 3

Follow step 1~7 in How to hot link AutoCAD block attributes to Excel to link Block 02 to sheet Sheet 3 in C:\CADTool\tutorial\office\tut02.xls

Step 4

Follow step 1~7 in How to hot link AutoCAD block attributes to Excel to link Block 03 to sheet Sheet 3 in C:\CADTool\tutorial\office\tut02.xls

Step 5

Follow step 8~10 in How to hot link AutoCAD block attributes to Excel to insert Block 01

Step 6

Follow step 8~10 in How to hot link AutoCAD block attributes to Excel to insert Block 02

Step 7

Follow step 8~10 in How to hot link AutoCAD block attributes to Excel to insert Block 03

Step 8

Now we have 3 block insertions with their attribute values pulling from Excel sheet. In AutoCAD, erase the top 3 block definitions and remain bottom 3 new insertions. Save the drawing as PopulateBlock.dwg 

Step 9

Click on CADTool >> Populate Block menu

  • Select the template drawing PopulateBlock.dwg  you have just saved

  • Select the output directory where you want to dump the populated drawings

  • Browse to Excel file C:\CADTool\tutorial\office\tut02.xls, which contains all the attribute values

  • Click on Excel cell A3, then click on 1st Update button

  • Click on Excel cell A7, then click on 2nd Update button

  • Click on Excel cell A15, then click on 3rd Update button

  • Click on Start button to finish

Step 10

You will find 3 new drawings CT-PopBlk-001~003.dwg are created in C:\CADTool\tutorial\output\  directory, with their attributes linking to Excel sheet. Any changes user made in Excel sheet will be updated in AutoCAD when the drawing is open or user click on CADTool >> Update Block menu

Go Top

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

autocad excel  excel autocad  autocad excel link  autocad office  autocad table  table autocad  office cad  autocad vba  cad excel  excel cad  excel to autocad

autocad excel  excel autocad  autocad excel link  autocad office  autocad table  table autocad  office cad  autocad vba  cad excel  excel cad  excel to autocad

autocad excel  excel autocad  autocad excel link  autocad office  autocad table  table autocad  office cad  autocad vba  cad excel  excel cad  excel to autocad

autocad excel  excel autocad  autocad excel link  autocad office  autocad table  table autocad  office cad  autocad vba  cad excel  excel cad  excel to autocad