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, and attributes.

General 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.

Screenshots

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

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

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