C# .NET - How to convert an excel column data to a formula using C#

Asked By Ajay on 26-Sep-18 01:38 AM
Hi Team,

I do have an excel file exported from a dataset using C#, on which i do have column which has to determined from two other columns. my excel file is generated with  text "=ROUND((TODAY()-J5)/30,1)" on the specific cells.

What i would like to see is the result of this formula instead of that text. is there any possible way to convert all cells with the result of this formula without manipulating each cell.

Presently my excel file shows this text.
=ROUND((TODAY()-J8)/30,1)
=ROUND((TODAY()-J9)/30,1)
=ROUND((TODAY()-J10)/30,1)
=ROUND((TODAY()-J11)/30,1)
=ROUND((TODAY()-J12)/30,1)
=ROUND((TODAY()-J13)/30,1)
=ROUND((TODAY()-J14)/30,1)
=ROUND((TODAY()-J15)/30,1)
=ROUND((TODAY()-J16)/30,1)
=ROUND((TODAY()-J17)/30,1)


Can any one help me on this?

Thanks and regards
Ajay