TheSwamp

CAD Forums => CAD General => Topic started by: MSTG007 on September 28, 2023, 08:04:59 AM

Title: Linking Excel Cell Values
Post by: MSTG007 on September 28, 2023, 08:04:59 AM

I found this video and was wondering if there could be a way to link excel "cell values" to dwgs or dst files?

https://www.youtube.com/watch?v=MtL386gjYjc (https://www.youtube.com/watch?v=MtL386gjYjc)

Would it be possible to have a master excel file, that would dynamically link up to a Word Doc, Plan Sheet dwg, and or a AutoCad Sheet Set Manager dst file?

Thanks for any tips.

Title: Re: Linking Excel Cell Values
Post by: Rod on October 31, 2023, 05:49:14 PM

I haven't tried Daniels XLSX Field evaluator, but it looks impressive. https://www.theswamp.org/index.php?topic=56095.0 (https://www.theswamp.org/index.php?topic=56095.0)

Title: Re: Linking Excel Cell Values
Post by: danAllen on October 31, 2023, 11:27:05 PM

I use Dotsoft's XL2CAD which also has feature to link Excel cells to DWG information, see Property Expressions.
https://www.dotsoft.com/xl2cad.htm

Title: Re: Linking Excel Cell Values
Post by: David Hall on November 01, 2023, 07:41:23 AM

MSTG007 what are you trying to do?  I have examples where I take data from Autocad and put it in Excel, and from Excel back to Autocad

Title: Re: Linking Excel Cell Values
Post by: MSTG007 on November 01, 2023, 11:58:30 AM

Having a Master Excel File which would have a project number, location and other information. Then linking the values inside the excel file to an autocad dst file field. Word Documents for reporting and other excel worksheets.
Again, just to be able to change the value in one place, and it updates all the others on the fly.

I hope that makes sense.