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 >> Before importing your own spreadsheet ...

Office2CAD is capable of processing Excel sheet up to size of 900 rows X 50 columns. This size is big enough to suit most users' needs. However, sometimes users may experience troubles when importing their own spreadsheet even they only have 10 rows of Excel data. Let's see an example.

In Excel open tut_bad_example.xls  inside C:\CADTool\tutorial\office\  folder.

Press Ctrl + End at the same time, it will point you to the last used cell and it is on row 4000 !

Pressing Ctrl + End  to check your sheet's last used cell before importing. Make sure it's not out of 900 rows X 50 columns boundary.

Office2CAD provides a command to trim Excel sheet and reset its last used cell.
Step 1
Click on CADTool >> Reset Excel Last Used Cell
Step 2

Browse to C:\CADTool\tutorial\office\  folder and open tut_bad_example.xls 

Point your mouse to cell J8 and click on Reset button. It will reset the sheet's last used cell to cell J8.

 

Make sure to press Ctrl + End  to verify that the last used cell has been reset.

When users encounter any problem on using Office2CAD, the first point to check is CADTool FAQ page. Most of the time they can find solutions there.

 

Please check out next tutorial  Import Excel drawing and symbol components

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