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 >> Excel to AutoCAD cell shading/pattern mapping

In this tutorial we will show users how to map Excel cell shading/pattern to AutoCAD's hatch pattern.

Original imported as cell color fill After mapping imported as ACAD hatch pattern

Open C:\CADTool\acad\pattern.ini  using any text editor, like Notepad.

 

The XLS Pattern Name corresponds to Excel cell pattern name as shown on the right.

User can map an Excel cell pattern to any available ACAD hatch pattern by editing the 2nd column.

The XLS Color Name corresponds to last two rows of Excel fill color as shown on the right.

User can map an Excel cell fill color to any available ACAD hatch pattern by editing the 2nd column.

Step 1
Continuing from last tutorial, we already imported tut05.xls into AutoCAD.
Step 2

Open C:\CADTool\acad\pattern.ini  file using any text editor, like Notepad.

Edit this file, set Light Yellow mapping to ACAD hatch pattern BRICK, Light Green to GRAVEL, set the Hatch Density to 0.5.

Note:

Since users may try the import in different scale of drawing, setting Hatch Density to 0.5 may not produce the same result as this tutorial. Users can try different values such as 5, 10 or 0.1 to get a better hatching output.

Step 3

Save the pattern.ini file we just edited.

Click on CADTool >> Update Selected Table  to pick the the table for update.

If user cannot get the same hatch fill as shown or it's empty, go to Step 2 to adjust the Hatch Density, save and update again.

We already show users how to import image, graphic shape, and cell fill color/pattern from Excel into AutoCAD.

Users can uncheck/check three switches below to disable/enable importing of these elements from Excel. These switches give users more flexibilities to control the output of import.

 

Please check out next tutorial  How to update Excel link

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