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 >> 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

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