Click here to Skip to main content
14,980,646 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
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?

thanks.
Posted
Comments
krumia 8-Jun-12 6:54am
   
Watch for answers in this StackOverflow thread: http://stackoverflow.com/questions/10946707/evaluate-excel-formula-via-com-api[^]
Just kidding
Fred D. 8-Jun-12 7:00am
   
thanks, that's my thread! I thought I would post on CP to get more attention..

1 solution

See this article[^] on MSDN. Office automation from C++ is not the easiest thing in the world if you are not comfortable with COM, but it can be done.
   

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900