Transfer Drawing from CAD to Excel [Rectangles only in CAD -> Cells with borders maiñtaning distance]

[Anonymous]

Good evening everyone, 

I'll do my best to explain my question:

I have a AutoCAD drawing (dwg) with ONLY rectangles. 

I want to develop a script (would be forever grateful if someone linked me to a solution like this since I urgently need something like this).

I need to pass the drawn rectangles to excel, by filling the borders of the specific cells regarding the "same location" as the cad rectangles. I'm leaving an example in the end so I can clarify my question a little bit.

Any help is extremely appreciated.

So basicaly I've drawn two rectangles (imagining I'm setting my reference as the top left corner of the top rectangle)

The excel would process the line properties to put a border on Cell A1 (then, after setting the Cell equivalent distance to the drawing as 500 "cadunits") would leave B1, C1 unchanged, as well as Row 2, as well as C1 and C2, highlighting the border  of Cell C3 only.

I'm sorry for such a confusing question, the example is pretty straightforward tho.

Cheers,

Francisco

[Anonymous]

Good evening everyone, 

I'll do my best to explain my question:

I have a AutoCAD drawing (dwg) with ONLY rectangles. 

I want to develop a script (would be forever grateful if someone linked me to a solution like this since I urgently need something like this).

I need to pass the drawn rectangles to excel, by filling the borders of the specific cells regarding the "same location" as the cad rectangles. I'm leaving an example in the end so I can clarify my question a little bit.

Any help is extremely appreciated.

So basicaly I've drawn two rectangles (imagining I'm setting my reference as the top left corner of the top rectangle)

The excel would process the line properties to put a border on Cell A1 (then, after setting the Cell equivalent distance to the drawing as 500 "cadunits") would leave B1, C1 unchanged, as well as Row 2, as well as C1 and C2, highlighting the border  of Cell C3 only.

I'm sorry for such a confusing question, the example is pretty straightforward tho.

Cheers,

Francisco

[pendean]

That's not how it works if I understood your post correctly: explore here for how to draw in AutoCAD from content in Excel https://birchlerarroyo.com/autocad/how-draw-data-from-excel-to-autocad.html

Or are you just wanting to connect an Excel Table to an OLE link of it in AutoCAD? Explore here https://knowledge.autodesk.com/support/autocad/troubleshooting/caas/sfdcarticles/sfdcarticles/Insert...

[pendean]

That's not how it works if I understood your post correctly: explore here for how to draw in AutoCAD from content in Excel https://birchlerarroyo.com/autocad/how-draw-data-from-excel-to-autocad.html

Or are you just wanting to connect an Excel Table to an OLE link of it in AutoCAD? Explore here https://knowledge.autodesk.com/support/autocad/troubleshooting/caas/sfdcarticles/sfdcarticles/Insert...