Author Topic: Linking Excel Cell Values  (Read 4600 times)

0 Members and 1 Guest are viewing this topic.

MSTG007

  • Gator
  • Posts: 2601
  • I can't remeber what I already asked! I need help!
Linking Excel Cell Values
« 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

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.
Civil3D 2020

Rod

  • Newt
  • Posts: 185
Re: Linking Excel Cell Values
« Reply #1 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
"All models are wrong, some models are useful" - George Box

danAllen

  • Newt
  • Posts: 133
Re: Linking Excel Cell Values
« Reply #2 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

David Hall

  • Automatic Duh Generator
  • King Gator
  • Posts: 4075
Re: Linking Excel Cell Values
« Reply #3 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
Everyone has a photographic memory, Some just don't have film.
They say money can't buy happiness, but it can buy Bacon and that's a close second.
Sometimes the question is more important than the answer. (Thanks Kerry for reminding me)

MSTG007

  • Gator
  • Posts: 2601
  • I can't remeber what I already asked! I need help!
Re: Linking Excel Cell Values
« Reply #4 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.
Civil3D 2020