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 >> Import Excel Spreadsheet -- Range Import

Range Import gives users the flexibility to import part of an Excel sheet. Users can specify a range in Excel sheet for importing.

Step 1
Inside AutoCAD, Click on CADTool >> Import Excel Data 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 instructions below to get import range's top left cell.

Step 5

Drag the dialog box to left so that you can view the import range's bottom right cell.
Step 6
Follow instructions below to get import range's bottom right cell.

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 or MicroStation.

Users may have to Zoom Extent in AutoCAD to view the whole table.

 

Please check out next tutorial  Before importing your own spreadsheet ...

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