I have a C++ application that interacts with an XLS file which contains some formulas. To retrieve fixed cell data from that XLS, I use the ExcelFormat lib which works fine. Now I need to get the values of cells which are set via a formula.
That lib doesn't handle the formula evaluation function. Another way would be to use the COM API of EXCEL 2010 but I dont know:
1. if it is possible to do so via a COM call?
2. which methode do I need to call?