Excel to AutoCAD

[conveyor1]

Has anyone done any code for sending data in Excel to AutoCAD?  I found example of AutoCAD to Excel but I am looking for a VB.net solution to go from Excel to AutoCAD.

Any example would be helpful on how it should be initially set-up.

Please let me know your thoughts.

[Anonymous]

---

@conveyor1 wrote:

Has anyone done any code for sending data in Excel to AutoCAD?  I found example of AutoCAD to Excel but I am looking for a VB.net solution to go from Excel to AutoCAD.

Any example would be helpful on how it should be initially set-up.

Please let me know your thoughts.

---

I have a fair few examples of this, but are you talking about showing all the gridlines etc, or just inserting blocks with information? I think you need to be a bit more specific. What are you trying to achieve?

For option 1, rather than write it yourself, there is an excellent program called XL2CAD, from Dotsoft. It does tend to draw too many lines for the grids, but for you to get up and running, it is very good.

[conveyor1]

Two different steps.

First would be to pull some block information (name, attributes, position)
from the open active autocad drawing into Excel.

Second would be to push back any attribute updates from modification others
did in excel back into the same drawing.

[dgorsman · Accepted solution]

My preference is to treat AutoCAD as the "driving" application and the Excel file as a data source.  AutoCAD is customized to both create the Excel file based on the DWG contents, and to read the Excel file and modify the DWG contents appropriately.  Otherwise you end up having to "drive" AutoCAD from an external application which gets more complicated than it needs to be.

[conveyor1]

Afternoon,

This is what I eventually did.

Thank You