PDA

View Full Version : 2012 Link between Excel and CAD


iangold
2017-03-28, 11:26 AM
Dear Experts,

I am looking for a way to extract my block attributes, that once I click the attribute value in Excel, I want that block to be highlighted in autocad to identify where it is located. Basically, I want a relationship that in one program one instance is selected and it shows in other, or at least I select in excel and it highlights in autocad.

Any help from 'the experts' will be greatly appreciated.
--AuBe--
2017-03-28, 05:43 PM
You are aware that this is a huge request that requires a coding a plug-in or third party patch in excel, right?

Is there a reason why you need to select the value in Excel and not in an AutoCAD table in the drawing also created from extracting attributes?
iangold
2017-03-29, 05:37 AM
Yes AuBe, I know it needs special efforts, and this will help so many Users, as i explored and didn't find anything.

The purpose behind this is we have some non CAD Users in asset management and they only use Excel and this possibility will help them big time.
cadtag
2017-03-29, 01:04 PM
You could look into datalinks, or hyperlinks, or custom drawing automation programming -- it's doable, but not widely needed and what ever you come up with will be specific to your situation. (If it's general enough to be broadly applicable -- well it's just duplicating the programming interfaces that _already_ exist in Acad)
Jmurphy
2017-03-29, 11:22 PM
Yes AuBe, I know it needs special efforts, and this will help so many Users, as i explored and didn't find anything.

The purpose behind this is we have some non CAD Users in asset management and they only use Excel and this possibility will help them big time.

What you are needing is a GIS, Geospatial Information System such as AutoCAD Map3D. Years ago I used Excel with Map 3D to drive blocks in a dwg of a hospital for a demo.
iangold
2017-03-30, 09:10 AM
I am aware of that, but purchasing GIS license is a big deal considering already having AutoCAD licenses. So, looking forward for a lisp or add-in, and that will be very helpful.
Jmurphy
2017-03-30, 10:39 PM
I am aware of that, but purchasing GIS license is a big deal considering already having AutoCAD licenses. So, looking forward for a lisp or add-in, and that will be very helpful.

An upgrade to Autocad Map3D from standard Autocad is not that much. All the other options that I know of have been posted about above and will cost $$$ as well, unless you know how to program. Might try asking in the programming forums if anyone can help. http://forums.augi.com/forumdisplay.php?88-Programming