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

In this tutorial, the Excel data is imported as the range of whole sheet. Office2CAD can automatically detect the last used cell in the specified sheet and import cells ranging from cell A1 to the last used cell.

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 folder and select tut01.xls

Click Open button

Step 4

In this tutorial we will try Sheet Import , not Range Import, so we leave Top Left Cell and Bot. Right Cell fields empty. 

Go ahead to click on Start button to continue.

Step 5

As shown below, change text height from 10 to 2, width from 10 to 2

Click OK button to continue

Step 6

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

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