CADTool
Import Excel spreadsheet and Word text into AutoCAD and MicroStation
New Release
Fast Facts
Order
Tutorial
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.
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.
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
FAQ 3-3: How to import a table matching current table size
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.
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:
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
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
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.
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.
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
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.
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 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.
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. 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. 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. 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. 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.
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.
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.
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.
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.
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
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.
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. 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. 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 !
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.
|
||||||||||
Copyright © 2003 CADTool.net