Member Avatar for ChaseRLewis

So I've programmed using Excel Interop before, but I can't figure out something.

I have a spreadsheet with thousands of material properties listed in them. In the excel spreadsheet if I change that enum I can recalculate the sheet retrieving the values I need.

I want to form a repository of info so I can retrieve it for another program I'm planning, but I don't know how to change that enum programmatically.

Included a pic of the spreadsheet the enum is the one that says Benzene if that helps at all.

Capture.PNG 70.8 KB
  • 2 Contributors
  • 1 Reply
  • 104 Views
  • 13 Hours Discussion Span
  • Latest Post Latest Post by thines01
Member Avatar for thines01

So, you need to change the selection of a dropdown list ao the sheet will recalculate?
Wondering: if you had a VBA macro that could do that, could you call the macro from C#, then pick-up the values from the sheet?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.