Update AUTOCAD Drawing Using EXCEL formulas - Part 2
Excel_ing CAD - TEXT/MTEXT We can add text in AutoCAD drawing in a predefined way using Excel. NORMAL TEXT IN THE SELECTED LAYER TEXT AS PER CONDITIONAL COLORS TEXT ON SPECIFIED LAYERS TEXT AT A PARTICULAR DISTANCE Prerequisite to apply our formula in the specified drawing : Get the Coordinates where we want to define the values as text/object. ( Explained in Part-1 ) Set the style of text as per requirement. ( COMMAND: "ST" ) NORMAL TEXT IN THE SELECTED LAYER Fx ="-TEXT "&[@[X-COORDINATE]]&","&[@[Y-COORDINATE]]&" "&[@ROTATION]&" "&[@TEXT] RESULT = -TEXT 2717612.8821,-1817752.3676 0 MH-1