CADTool
Import Excel spreadsheet and Word text into AutoCAD and MicroStation
New Release
Fast Facts
Order
Tutorial
| 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. | ||||
| ||||
|
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 |
Copyright © 2003 CADTool.net