How can I update Text in AutoCAD from an Excel file?

How can I update Text in AutoCAD from an Excel file?

megan.sauterMEQHE
Participant Participant
1,183 Views
3 Replies
Message 1 of 4

How can I update Text in AutoCAD from an Excel file?

megan.sauterMEQHE
Participant
Participant

I have a drawing file with room numbers saved as lines of text. The room numbers are incorrect and need to be updated. Is there any way to export the lines of text to an excel file, make the changes in excel and then import them back into the drawing for an automatic update?

This works for me when I use a block with attributes as a room tag, but I can't seem to get data to import back into the drawing with lines of text.

0 Likes
1,184 Views
3 Replies
Replies (3)
Message 2 of 4

Valentin_CAD
Mentor
Mentor

@megan.sauterMEQHE ,

 

Welcome to the AutoCAD Community Forum.

 

Here are some useful links from Autodesk Support:

1. Use the Insert menu or right click to choose Insert ->Field.

2. Select “AF Excel Cell” in the left panel of the Field dialog.

3. Open an Excel file and select the cell you want to import.

4. Click “Get Active Cell” to get the active cell address.

 

valentin_2-1628119456465.png

 

5. If you want to use the relative path, please choose “Relative Path”.

 

valentin_3-1628119496215.png

 

6. Click OK to insert a field.



Select the "Mark as Solution" if my post solves your issue or answers your question.

Seleccione "Marcar como solución" si mi publicación resuelve o responde a su pregunta.


Emilio Valentin

0 Likes
Message 3 of 4

megan.sauterMEQHE
Participant
Participant

Thank you. None of the "AF" options show in my Field menu. How can I get that option? 

0 Likes
Message 4 of 4

Valentin_CAD
Mentor
Mentor

@megan.sauterMEQHE ,

 

This is a third party software by http://www.cadig.com/

 

Review the suggestion on these link as work around: 

 



Select the "Mark as Solution" if my post solves your issue or answers your question.

Seleccione "Marcar como solución" si mi publicación resuelve o responde a su pregunta.


Emilio Valentin

0 Likes