Update AUTOCAD Drawing Using EXCEL formulas - Part 4

 

Excel_ing CAD - HYPERLINK, HATCH, ENCIRCLE

We can add HYPERLINK in AutoCAD drawing in a predefined way using Excel. 

1. HYPERLINK ADDRESS TO AREA OR OBJECT
2. HATCHING UNDER BOUNDARY WITH CONDITIONAL COLORS
3. ENCIRCLE THE TEXT AND MASK

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)
• The area can be defined with 4 coordinates in a CAD file.

HYPERLINK ADDRESS TO AREA/OBJECT

Hyperlink Formula: ="(command ""-hyperlink"""&" "&""""&"I"&""""&" "&""""&"A"&""""&" "&""""&[@X]&""""&""""&[@Y]&""""&""""&[@LINK]&""""&""""&""""&""""&[@LO]&""""&")"

RESULT: (command "-hyperlink" "I" "A" "2718683.6831,-1817319.5005""2719233.6831,-1816819.5005""https://www.google.com/doodles""""1")

HATCHING UNDER BOUNDARY WITH CONDITIONAL COLOURS

HATCH Formula: =[@[HATCH-HELPER]]&[@[X,Y-1]]&" "&[@[X,Y-2]]&" "&[@[X,Y-3]]&" "&[@[X,Y-4]]&" "&[@CLOSE]&" "&" "

RESULT: -HATCH CO 30  W N 2718683.6831,-1816319.5005 2719233.6831,-1816319.5005 2719233.6831,-1815819.5005 2718683.6831,-1815819.5005 C  

ENCIRCLE THE TEXT AND MASK

ENCIRCLE Formula: ="-TCIRCLE"&" "&[@[X-T]]&","&[@[Y-T]]&" "&" "&0.35&" "&"S"&" "&"V"

RESULT: -TCIRCLE 2719763.3475,-1816063.3271  0.35 S V

SIMILARLY FOR MASKING AND UNMASKING

MASK Formula: ="-TEXTMASK"&" "&[@[X-T]]&","&[@[Y-T]]&" "

UNMASK Formula: ="TEXTUNMASK"&" "&[@[X-T]]&","&[@[Y-T]]&" "

SAMPLE FILE: EXCEL_CAD

IF WE CAN TWEAK THE INSIDE EXCEL FUNCTION, WE WILL BE ABLE TO GET THE DESIRED RESULT AS PER OUR NEEDS.

KINDLY LET ME KNOW FOR FURTHER CLARIFICATION