C# .NET - Calculate Excel formula using c# - Asked By abinav shankar on 19-Feb-13 02:46 AM

hi
 
I have converted a datata table to excel using closed xml and I have a column for calculating percentage and I did something like this 

dt["Percentage"]="p2/f2 *100"; and the resultant is that instead of calculating the formula the text (p2/f2 * 100) is displayed 
on the cells what should I do to calculate the percentage formula


I guess you need to add formula not caculating formula in Excel, yuou can see below article:

http://www.e-iceblue.com/Knowledgebase/Spire.XLS/Program-Guide/How-to-Add-a-Formula-for-Excel.html