JTB Excel2TextField Trial
Win32 and 64, EnglishGeneral Usage Instructions
1. Run the ExcelTextFieldCreateOrEdit command.
2. Select an Autodesk® AutoCAD® text, mtext, or attribute.
3. A dialog pop up for you to select an Excel workbook file path, enter the worksheet name and then enter the reference cell address.
4. Hit enter and a new field formula will be created, and appended to the selected text, mtext, or attribute. The field value is the selected cell value specified in step 3.
Usage Instructions
- There are 5 commands you can run from the command line or from the ribbon button on Add-ins (or Plug-ins) tab
- To create your first field reference to an Excel cell value, run the ExcelTextFieldCreateOrEdit command and select a text, mtext, or attribute. Let's call this type of field ExcelTextField.
- To edit it, rerun the ExcelTextFieldCreateOrEdit command and select the text, mtext, or attribute again.
- You can have many fields refer to many Excel workbooks cell addresses in one drawing.
- If the reference Excel workbooks change, run the ExcelTextFieldUpd command and select texts, mtexts, and/or blocks to update the reference values. Run ExcelTextFieldUpdAll to scan all the texts, mtexts, and blocks in the current drawing and update all ExcelTextFields.
- Run the InsertExcelTextField command to insert a new Mtext to the drawing with ExcelTextField content.
- If you want to change the source file and/or source worksheet of all ExcelTextFields in the drawing, run FixExcelTextFields. The command will collect all pairs of Excel file path - worksheet names and put them into an Editor for you to edit. Normally you can have hundreds of ExcelTextFields, but just a dozen of pairs of Excel file paths - worksheet names. Edit them and you will have all hundred fields got their source updated.
Notes
- ExcelTextFields are unique and can't be updated by AutoCAD native UpdateField routine.
- A test drawing can be found in the app installation folder: C:\ProgramData\Autodesk\ApplicationPlugins\JTB-Excel2TextField.bundle\Contents\Test ExcelTextFields.dwg.
Commands
Ribbon/Toolbar Icon | Command | Command Description |
---|---|---|
|
ExcelTextFieldCreateOrEdit |
Select text, mtext, or attribute. If there is no ExcelTextField yet, a new one will be created and added to the text. If there is an existing ExcelTextField, the command will show its properties for you to edit. |
|
ExcelTextFieldUpd |
Select texts, mtexts, or blocks to update ExcelTextFields if found in their text contents. |
|
ExcelTextFieldUpdAll |
Update all found ExcelTextFields in all text, mtext, and blocks in the current drawing. |
|
JTBW_Activate_Apps |
Use this command to activate the app. |
|
FixExcelTextFields |
Collect all source excel files and source worksheets, then show them all in an edit window. |
|
InsertExcelTextField |
Insert a new MTEXT to the drawing with ExcelTextField content. |
Installation/Uninstallation
The installer that ran when you downloaded this app from Autodesk App Store will start installing the app. Or, double-click the downloaded installer to install the app. You may need to restart the Autodesk product to be able to run the app.
To uninstall this app, exit the Autodesk product if you are currently running it.
On Windows 11 and 10 version 1703 or later press Windows+I on the keyboard to access Settings or click or right-click the Windows Start button and then select Settings. Click on Apps (optionally followed by Apps & features). On older Windows versions click Control Panel > Programs > Programs and Features or Control Panel > Add.
Additional Information
Known Issues
Contact
Author/Company Information
Support Information
For support visit our Contact page.
Version History
Version Number | Version Description |
---|---|
2.5.0 |
Added support for AutoCAD 2024 |
2.4.0 |
Fixed bug if cell's name ends with a number. |
2.3.0 |
Fixed an error when excel filename contains comma. |
2.2.0 |
Added support for named cells. Fixed a bug in FixExcelTextFields command. |
2.1.0 |
Upgrade of ExcelTextFieldUpdAll and FixExcelTextFields commands, option to include fields in Xrefs. |
2.0.0 |
InsertExcelTextField and FixExcelTextFields commands added. Better error messages in the editor window. |
1.5.0 |
Added option to save excel workbook's file path as relative path. |
1.4.0 |
Added AutoCAD 2023 support. Minor change in error report. |
1.2.1 |
Fixed error if cell contain quotation mark character (") |