Formulas in EPPLUS

Feb 4, 2014 at 6:39 AM
I have a formula like '=RC[-5]+RC[-4]+RC[-2]' in my stored procedure. I am using LoadFromDataTable helper method to fill data in excel. But the formula which is in my stored procedure is dumping as it is into excel? How to resolve this issue, any help appreciated.

Feb 5, 2014 at 9:21 PM

LoadFromDataTable does not recognice formulas, it just set values on cells. To achieve this you have to iterate over your collection or datatable and explicitly set the Value or Formula property on the cells.