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 >> Comparison of Three Import Modes

Users had tried three import tutorials

Import Excel Spreadsheet -- Sheet Import

Import Excel Spreadsheet -- Range Import

Linking Excel to Text -- Import

 

Now we give a comparison of these three import modes

Import Mode

Sheet Import

Range Import

Link To Text Import

   CADTool

   command

Import Excel Data Import Excel Data Import Excel Linking To Text

   When to use

* Whole Excel sheet needs to be imported

* Users may insert/delete col/row inside the import range when updating the table

* Only part of Excel sheet needs to be imported

* Users won't insert/delete col/row inside the import range when updating the table

* Imported texts need to be manipulated separately

   Pros

* All changes, including adding/deleting rows/cols, in Excel sheet will be captured when updating in ACAD

* All changes, except adding/deleting rows/cols, in Excel sheet will be captured when updating in ACAD

* Flexibility to control which part of Excel sheet needs to be imported

* Imported data can be manipulated separately. User can move the data to anywhere in the drawing while these data still  linking to Excel.

* Update report for revision tracking 

   Cons

* Imported data linking to Excel as a group. Link is broken when exploding the group.

* Unable to import part of Excel sheet

 

* Imported data linking to Excel as a group. Link is broken when exploding the group.

* Changes of adding/deleting rows/cols inside import range will not be captured.

* Only change of Excel text will be captured when updating.  Changes such as adding/deleting row/col, changes of borders etc, will not be captured.

Please check out next tutorial  How to import Word text into AutoCAD or MicroStation

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