How to import cable schedule in Excel to existing wiring schematic DWG

[Anonymous]

It pretty much says it in the title. I have a wiring schematic drawing and have an Excel sheet with all the cable lengths, connectors, cable type, rating etc. and I would like to import them into the drawing so they show up as attributes.

The wires in the drawing are simply named with floating notes/textboxes. So firstly I need to find the names of the wires somehow. However once done, how can I import the attributes from the Excel document to each wire in the drawing?

[rhesusminus · Accepted solution]

You'll just have to make a macro that does this.

[Anonymous]

I haven't got any experience in writing macros. Could you direct me to where I could learn how to do this? Or could I just pay someone to do it?

[rhesusminus]

You might be better of paying someone.

Do you have an example excel sheet and acorresponding drawing, so that I could have a look, and estimate the amount of work?