CADTool
Import Excel spreadsheet and Word text into AutoCAD and MicroStation
New Release
Fast Facts
Order
Tutorial
| Tutorial >> Linking Excel to Text -- Import |
|
Users already tried Sheet Import and Range Import in previous tutorials. In these two import modes, AutoCAD table links to Excel as a whole block. It's an intended feature when Excel sheet is imported as a schedule and users want to manipulate it as one entity. There are some other cases when users want the link to be set at single AutoCAD text level, rather than the block level which groups all texts. For example, GIS and road drainage design data, users want to move imported texts around in the drawing, yet they still want these texts linking to Excel and getting real time updated. In this tutorial we introduce the third import mode: Linking Excel to Text mode. All imported texts are linking to Excel as single text. Users can move, scale or rotate these texts in AutoCAD and they are still linking to Excel. |
| Step 1 |
| Inside AutoCAD, Click on CADTool >> Import Excel Linking To Text from pull down menu |
| Step 2 |
| On next dialog box click on Browse button |
|
| Step 3 |
|
Browse to C:\CADTool\tutorial\office and select tut01.xls
Click Open button |
|
| Step 4 |
| Follow instruction below to get top left cell of import range |
|
|
Step 5 |
| Drag the dialog box to left so that you can view the bottom right cell of import range |
|
| Step 6 |
| Follow instruction below to get bottom right cell of import range |
Step 7 |
|
Click View Selection button, the import range will be highlighted. Click Start button to continue |
|
| Step 8 |
|
As shown below, change text height from 10 to 2, width from 10 to 2. Click OK button to continue |
|
| Step 9 |
|
A rubber band box will show the imported table outline ( this feature is not available in AutoCAD 2000 version ) Place the table on your desired location in AutoCAD. Users may have to Zoom Extent in AutoCAD to view the whole table. |
|
|
|
Please check out next tutorial Linking Excel to Text -- Update |
Copyright © 2003 CADTool.net