3 ms·
The kind of API I was looking for but couldn’t find (in 2014) was “when I change the value of cell A1 to 17, what’s the value of cell C5?” And get the answer wi
by blowski 9y ago
The kind of API I was looking for but couldn’t find (in 2014) was “when I change the value of cell A1 to 17, what’s the value of cell C5?” And get the answer within a couple of seconds. There was no supported way to programmatically change the value of a cell and get the calculated result of a different cell, at least not that I could find.
- WalterGR 9y ago(in 2014) Is the situation different in 2017?
- igitur 9y agohttp://github.com/ClosedXML/ClosedXML http://github.com/ClosedXML/ClosedXML is a wrapper around OpenXML and attempts to fill that gap. It has partial support of Excel formula evaluation. Disclaimer: I'm a current ClosedXML contributor.