CADTool
Import Excel spreadsheet and Word text into AutoCAD and MicroStation
New Release
Fast Facts
Order
Tutorial
| Tutorial >> Excel to AutoCAD font mapping |
|
In this tutorial, we will show users how Office2CAD can
|
|
Open Excel file C:\CADTool\tutorial\office\tut05.xls. This Excel sheet contains font Arial, Times New Roman, Impact, and Arial Black. We will show users how to map these fonts to the same fonts into AutoCAD. |
|
| Step 1 |
|
Inside AutoCAD, Click on Format >> Text Style ... Create a
new a text style named Impact, set its font to Click on Apply button to continue. |
|
| Step 2 |
| Similar to Step 1, create a new text style named Arial Black |
|
| Step 3 |
|
Click on CADTool >> Import Excel Data to sheet import C:\CADTool\tutorial\office\tut05.xls Map XLS Impact to DWG Impact.
|
|
| Step 4 |
|
Map XLS Arial Black to DWG Arial Black. Click on OK button to place table in AutoCAD. |
|
| Step 5 |
|
We can find that
|
|
|
User can create any text style in AutoCAD, not only using Windows true type fonts, but also AutoCAD fonts such as romans.shx or complex.shx. All Excel fonts can be mapped to AutoCAD fonts as well. For the reason that Excel cell size is set to accommodate true type font, when a true type font is imported as an ACAD font, it may run across the cell border. Office2CAD provides two scale factors to adjust this. Please refer to FAQ 3-4 for details.
In the next tutorial we will show users how to map Excel cell fill and pattern to any available AutoCAD hatch pattern. |
|
Please check out next tutorial Excel to AutoCAD cell shading/pattern mapping |
as shown below. Copyright © 2003 CADTool.net