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




 


 

 

Back to FAQ index

Using Office2CAD / AutoBlock

  1. FAQ 3-1: Why my own spreadsheet cannot be imported 

  2. FAQ 3-2: AutoCAD locks up when open multiple drawings

  3. FAQ 3-3: How to import a table matching current table size

  4. FAQ 3-4: When import a table, some cell texts run out of cell border

  5. FAQ 3-5: How to reformat a table once it has been imported, say change the colors of the borders or text

  6. FAQ 3-6: Get a  Macro name: PlaceTable.PlaceTable Execution error

  7. FAQ 3-7: The progress bar keep flashing and won't stop

  8. FAQ 3-8: How big can an excel sheet be (rows and columns) for Office2CAD to handle

  9. FAQ 3-9: Open a previous import drawing and everything disappears

  10. FAQ 3-10: Manage Excel link dialog box doesn't show my previous import link

  11. FAQ 3-11: I get *CT_E* inserted by the importing operation

  12. FAQ 3-12: Get a run-time error ‘429’: ActiveX component can’t create object

  13. FAQ 3-13: Get run-time error 5 when I used AutoCAD Batch Plot Utility

  14. FAQ 3-14: MicroStation V8.1 crash when using Office2CAD

  15. FAQ 3-15: Get a FATAL ERROR when click on Browse button

  16. FAQ 3-16: Table updated as other scale and color, which is different from original one

  17. FAQ 3-17: Table updated as other font, which is different from original one

  18. FAQ 3-18: Why the change of Excel border is not updated in AutoCAD

  19. FAQ 3-19: After import, the Excel file can only be opened as Read-Only

  20. FAQ 3-20: Incorporating CADTool menu into user's own menu causes error 

  21. FAQ 3-21: Install Office2CAD in both AutoCAD2002 and AutoCAD2005 on the same PC

  22. FAQ 3-22: Some Excel formula cells imported as #### in AutoCAD

  23. FAQ 3-23: How to import a barcode from Excel into AutoCAD

  24. FAQ 3-24: Word Import each page's first line shifts to previous page


FAQ 3-1: Why my own spreadsheet cannot be imported

 

Excel's sheet size limit is 65,536 rows by 256 columns. 

Office2CAD's comfortable importing sheet size limit is 900 rows by 50 columns. This limit is big enough for most engineering spreadsheet use.

There is one important thing users have to take note when they prepare spreadsheet in Excel

For a 10 rows by 10 columns spreadsheet, if users format the cell in an improper way, the actual sheet size might turn out to be 65,536 rows by 256 columns and causes trouble when it's imported.

 

Wrong way to do cell formatting

User formats the whole column B, 65536 rows, even if he only has 10 rows of data.

Right way to do cell formatting

User only highlights the part which he actually needs and formats these cells.

 

How to rectify the existing spreadsheet if it's formatted by whole row or column? It's easy. 

Simply highlight those unwanted rows or columns and delete them.

 

 

Back to Top


FAQ 3-2: AutoCAD locks up when open multiple drawings

 

In AutoCAD, click on CADTool >> Turn Auto-Update On/Off to disable the auto-update feature. This change will resolve above problem.

When this feature is disabled, the drawing will not be automatically updated when it is open, user can click on CADTool >> Update Selected Table to force an update

 

Back to Top


FAQ 3-3: How to import a table matching current table size

 

User will use the four scale factors shown in symbology dialog box to achieve this

1. Try a new import, leave all settings to be default as it shows you, place the table on the drawing where contains your table which will be used as a reference for the same table size.


2. Use AutoCAD command to measure the table outline width between the new placed table and your reference table
Say your reference table width is 100 units and your new placed table is 1000 units, you will apply a revised scale 100/1000=0.1 in the next import.

 

3. Try a new import right the way, this time, change the first 2 scale factors, Font Height and Font Width factors in this way:
10 change to 10x0.1=1
8 change to 8x0.1=0.8
0.1 above is what you got by 100/1000 in step 2, the actual value may vary as this is only an example
Place the table and now you shall see the new placed table is in same width as the reference table, but the height may still be different


4. Use AutoCAD command to measure the table outline height between the new placed and your reference table
Say, new one height is 125, the old one height is 100, next time you shall apply a  factor 100/125=0.8

5. Try a new import right the way, this time change the last factor, Cell Height Factor, to 1.3X0.8=1.04 and place the table


6. The new place table shall be in the same size as your reference table now.

 

Back to Top


FAQ 3-4: When import a table, some cell texts run out of cell border

 

The won't happen if you map Windows true type font, Arial and Courier etc, to the same font in AutoCAD or MicroStation. When you map Windows true type font to other engineering fonts in CAD, this may happen as shown below left.

 

User can adjust the Cell Width Factor in symbology dialog box to widen all cells' width and resolve this problem

 

Back to Top


FAQ 3-5: How to reformat a table once it has been imported, say change the colors of the borders or text

 

Erase the old one and import a new one, do whatever changes you want in the symbology dialog box when you try a new import.

 

Back to Top


FAQ 3-6: Get a Macro name: PlaceTable.PlaceTable Execution error

 

This problem probably caused by the program's failing to be auto loaded when AutoCAD starts.
For some reasons, the program is not loaded as it should be when AutoCAD starts.
User can load it manually
In AutoCAD, go to menu Tools >> Macro >> VBA Manager ...
Click on Load button and browse to C:\CADTool\acad\  folder
There is only one file Excel0X.dvb showing up, open this file and click on Enable Macro if you are prompted a message box
Click on Close button to quit the dialog box
User shall be able to use the tools now.
For trial time, user can manually load Office2CAD as above stated, if user decides to purchase a license, we can go further and fix that auto-load program for user.

 

Back to Top


FAQ 3-7: The progress bar keep flashing and won't stop

 

There may be four causes to this problem

Excel file name contains non English letter

One of our clients from Iceland try an Excel file named tækjalisti.xls  which contains non English letter "æ"

Renaming the file name to any name without "æ" solves this problem.

Excel file and sheet name must be in any character in US keyboard while Excel sheet contents can be in any character
There is no limitation to your sheet content , only Excel file and sheet name.

 

Excel sheet name contains quotation mark

For example, one of our clients uses sheet name PNL "UD", which causes above problem. Renaming the sheet name to anything else without the quotation mark, such as PNL UD, will resolve this problem.

 

There is a startup message box when Excel file is open

When user open Excel file, there is always a message box prompted and wait for user's action, something like click OK to continue etc. This will cause above problem.

Disabling the startup macro in Excel file and save the file again. The problem should be resolved.

 

Excel file is protected

This is similar to above startup macro problem. It need user's action (protected password) to open the Excel file. Removing Excel file's password protection will solve the problem.

 

Back to Top


 FAQ 3-8: How big can an Excel sheet be (rows and columns) for Office2CAD to handle

 

900 rows X 50 columns.

For Office2CAD's superior performance when handling large spreadsheet, please refer to this fast facts
 

Back to Top


FAQ 3-9: Open a previous import drawing and everything disappears

 

The cause of this problem is user imports and places tables in Model Space but updates it in Paper Space, or vice versa. User should import/update tables in the same space, either Paper or Model.
Office2CAD is capable of placing table on both Paper and Model space, so use can import/update in the same space to avoid this problem.

 

Back to Top


FAQ 3-10: Manage Excel link dialog box doesn't show my previous import link

 

The cause of this problem is user imports and places tables in Model Space but manages link in Paper Space, or vice versa. User should import/manage tables in the same space, either Paper or Model.
Office2CAD is capable of placing table on both Paper and Model space, so use can import/manage in the same space to avoid this problem.

 

Back to Top

FAQ 3-11: I get *CT_E* inserted by the importing operation

 

This happens only when you import Excel using Import Excel Linking To Text  import.  *CT_E* is place holder text for empty cells in Excel and always placed on CT_Empty layer. The CT_Empty layer is always turned off by Office2CAD.

*CT_E* is there so that next time you add some text to Excel empty cell, *CT_E* will update to the new value.
To avoid this, User can use Sheet Import  or Range Import instead.

Back to Top


FAQ 3-12: Get a run-time error ‘429’: ActiveX component can’t create object 

 

User installed CADTool under a login account which doesn't have local admin right on the PC.

When installing CADTool, the installer needs to register a DLL  C:\CADTool\DLL\o2cad.dll. It will fail if the login account used doesn't have local admin right and cause above error message.

Solution:

Contact your company's network admin or IT support  and ask them to grant you local admin right on the PC. After  that run the Setup-XXX.exe again to re-install CADTool.

User also can get the network admin to login using Administrator account and run the installer for him/her.

Back to Top


FAQ 3-13: Get run-time error 5 when I used AutoCAD Batch Plot Utility

 

In AutoCAD, click on CADTool >> Turn Auto-update On/Off  to disable auto-update feature.

Disabling auto-update feature will fix this problem.

Back to Top


FAQ 3-14: MicroStation V8.1 crash when using Office2CAD

 

Our customer in Orlando, Florida reported a bug when using Office2CAD on MicroStation Ver 8.1.2.15.  It is a bug in MicroStation Ver 8.1.2.15 and not in Office2CAD. Bentley has sent CADTool Software confirmation for this bug with tracking number TR # 108567.

Symptom: MicroStation Ver 8.1.2.15 crashes when running Office2CAD

Solution:  Bentley has released a new version 8.1.2.21 that contains the fix to this problem. It is available from Bentley support group.  User can use any MicroStation Ver 8.1.X.X version other than MicroStation Ver 8.1.2.15.

 

Back to Top


FAQ 3-15: Get a FATAL ERROR when click on Browse button

 

This is caused by a bug in pre V7.10 version.

Please upgrade to V7.20 or later version and this problem will be resolved.

 

Back to Top


FAQ 3-16: Table updated as other scale and color, which is different from original one

 

This is caused by a bug in pre V7.10 version.

Please upgrade to V7.20 or later version and this problem will be resolved.

 

Back to Top


FAQ 3-17: Table updated as other font, which is different from original one

 

For each import, font mapping info is written to C:\CADTool\acad\mapfont.ini file. It's a plain text file and user can edit it using any text editor.

If users have ever mapped a Excel font to different CAD fonts, say Arial mapped to Standard in 1st import, and mapped to Romans in the 2nd import, when update 1st import table, the Standard font may be updated as Romans as the original mapping in mapfont.ini file was overwritten during the 2nd import.

Normally the font mapping (CAD standard) is not changed so frequently in a corporate environment. If users want to implement different mapping schemes, they can backup several versions of mapfont.ini file and copy it back into C:\CADTool\acad\ folder when they need different mapping schemes.

 

1. Users can edit mapfont.ini file directly to achieve desired font mapping

2. Users can also import an unwanted Excel table to map the font through the dialog box, which will write the mapping to mapfont.ini file, and delete the table after complete the mapping

In either way, new created mapfont.ini file will encode the desired font mapping scheme and users can update the table properly after that.

 

Back to Top


FAQ 3-18: Why the change of Excel border is not updated in AutoCAD

 

It's because users used Import Excel Linking To Text  Import mode, and they should use Sheet Import  or Range Import  mode to capture the border changes.

Please refer to Comparison of Three Import Modes for details.

 

Back to Top


FAQ 3-19: After import, the Excel file can only be opened as Read-Only

 

Please upgrade to V7.20 or later version and this problem can be resolved using CADTool command.

1. Please save all your changes in all current opened Excel file, then close these Excel files

2. Click on CADTool >> Excel Clean Up  command and it will clear up all hidden Excel processes

3. After that opening the Excel file again will not cause any Read-Only problem

 

 

Back to Top


FAQ 3-20: Incorporating CADTool menu into user's own menu causes error

 

If user wants to incorporate CADTool menu into his own one, there is one thing user needs to take note otherwise there will be some errors coming out.
When CADTool menu is presented as a separate one, it will load a lisp file CADTool.mnl inside C:\CADTool\acad\ folder when AutoCAD starts.
When user takes away C:\CADTool\acad\CADTool.mns and add it to other menu, this lisp file, CADTool.mnl, won't be auto loaded any more when AutoCAD starts, which causes the problem.
Solution ?
Pick any of your own startup routine and add a line to load CADTool.mnl, or copy all its content and paste it to your own startup routine, make sure it's loaded when you start AutoCAD.

 

Back to Top


FAQ 3-21: Install Office2CAD in both AutoCAD2002 and AutoCAD2005 on the same PC

 

Users can use Office2CAD in different versions of AutoCAD (AutoCAD 2000i, 2002, 2004, 2005) on the same PC.

Here we take AutoCAD 2002 and AutoCAD 2005 as an example to show how it works.

1. Run AutoCAD 2002 version Office2CAD installer.

2. Run AutoCAD 2005 version Office2CAD installer.

3. In C:\CADTool\acad\ folder, make a copy of CADTool.mnl and CADTool.mns as shown below

4. Start AutoCAD 2002, use AutoCAD command menuload to unload existing CADTool menu, then load Copy of CADTool.mns to load the new CADTool menu.

For details on how to use menuload to load a menu, see Step1~Step 5 of FAQ2-1

5. Quit AutoCAD 2002

6. Now users shall be able to use Office2CAD inside both AutoCAD 2002 and AutoCAD 2005 on the same PC.

The concept here is that AutoCAD 2002 uses Copy of CADTool.mns menu file, while AutoCAD 2005 uses CADTool.mns menu file.

Back to Top


FAQ 3-22: Some Excel formula cells imported as #### in AutoCAD

 

This happens when users work on Excel sheets with less than 100% zoom factor. For example, below image shows the sheet is viewed at 25% zoom factor.

 

 

 

The solution is fairly simple: change above zoom factor from 25% to 100% and save the Excel file. This problem won't happen again if the Excel file is saved with 100% zoom factor.

Back to Top


FAQ 3-23: How to import a barcode from Excel into AutoCAD

 

Office2CAD is the only tool which can import barcode and other complex fonts from Excel into AutoCAD.

Below is a sample spreadsheet which contains a barcode using barcode font MRV Code39SA

We will take this barcode font as an example to illustrate how to import a barcode. Users may use other barcode fonts with a different name and they can change the font name MRV Code39SA in this tutorial accordingly.

 

Follow these steps to import barcode from Excel into AutoCAD

1. Start or open an AutoCAD drawing which you want to import barcode.

2. In AutoCAD, go to pull down menu Format > Text Style ...

    Click on New button to create a new text style. User can give any name, MyBarcodeFont  here, and pick 

    font MRV Code39SA from the Font Name list.

3. Click on Apply then Close button to dismiss the dialog box

4. Click on CADTool > Import Excel Data to start a new import

5. Map Excel font XLS MRV Code39SA to ACAD text style DWG MyBarcodeFont

 

6. The barcode is imported into AutoCAD !

 

 

Back to Top


FAQ 3-24: Word Import each page's first line shifts to previous page

 

When importing multiple pages of Word file, if users find every page's first line goes to last page, or every page's last line goes to next page, they can check/uncheck the switch in Word Import dialog box to fix it. 
Users have to start a new import to fix it. Update Selected Word File command won't turn the switch on/off.

 

 

 

Back to Top

 

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