Update AUTOCAD Drawing Using EXCEL formulas - Part 1
Excel_ing CAD - Layer Management Prerequisite to apply our formula in the specified drawing : Autocad drawing Coordinates Simple Excel Formulas Steps to get coordinates of Text/Object in AUTOCAD : Select Text/Object ⇒ Select Similar ⇒ Isolate objects (To get minimum items to be extracted) ⇒ DATAEXTRACTION ⇒ Create a new data extraction ⇒ next ⇒ save (with any name anywhere) ⇒ Select objects in the current drawing ⇒ Enter (After selecting Desired area) ⇒ Next ⇒ Select the objects to extract data from ⇒ Next ⇒ Select Properties needed (Must select Geometry also to get coordinates) ⇒ Next ⇒ Next ⇒ Output data to external files (.xls type) ⇒ Specify the path ⇒ Next ⇒ Finish