This project has moved and is read-only. For the latest updates, please go here.

EPPLUS : Is it possible to get calculated values from macro enabled excel file(.xlsm)??

May 6, 2017 at 10:51 AM
I am trying to get the calculated value of the particular cell which has not simple formula like this Cell C =(1+A1+B1), It has easily calculated to call Calculate(). But if cell has reference of another sheet in the place of simple fomula, this one not calculating, i am using Calculate() to calculate this but the result is 0.

I have provided the excel which has lot's sheet. I need to care about only one MainSheet. In this sheet i need to put the value get the corresponding output. Some where cell has simple formula which is working fine , but somewhere cell has reference another worksheet this one getting problem for me. i am not getting exact result.. Please help me . Is there any solution ??
Jul 1, 2017 at 8:47 PM
The formula parser should be able to resolve references to other worksheets. Have a look at the documentation and see if the logging functionality can help you.