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.

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.