JTB Excel2TextField

JTB Excel2TextField

Win32 and 64, English

JTB World Inc.
Connect fields to Excel cell values. You can have Excel as the main source and when it is updated your drawings will be updated too. You can place fields in texts, mtexts, tables, attributes.

General Usage Instructions

1. Run 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, append to the selected text, mtext, or attribute. The field value is the selected cell value specified in step 3.

Usage Instructions

+ There are 3 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, run the ExcelTextFieldCreateOrEdit command again 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.

Notes

+ ExcelTextFields are special and can't be updated by AutoCAD native UpdateField routine.

Screenshots

Commands

Ribbon/Toolbar Icon Command Command Description

ExcelTextFieldCreateOrEdit

Select text, mtext or attrbute. 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.

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 Window versions click Control Panel > Programs > Programs and Features or Control Panel > Add.

Additional Information

Known Issues

Contact

Company Name: JTB World Inc.
Support Contact: info@jtbworld.com

Author/Company Information

JTB World Inc.

Support Information

For support visit our Contact page.

Version History

Version Number Version Description

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 (")
Go top