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

Formulas in EPPLUS

Feb 4, 2014 at 7: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.

Thanks
Praveen
Feb 5, 2014 at 10:21 PM
Hi,

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.

/Mats