How to read a cell value from Excel that contains a function in C#

Question

I am writing a C# application that reads data from an Excel file. Everything was running smoothly until I attempted to read from a cell that used a formula.

I am pulling data from the sheet and trying to add the cumulative quantity, so in a loop, I'm using:

cntr = Cell(row, column); 

NOTE: I'm paraphrasing rather than copy my actual code.

Anyways, if the actual cell value contains a number, this works, but if the cell contains a function, it returns the string

"=SUM(A1:A5)"

and I'm not sure how I can execute this in my C# code to retrieve the actual value of that cell.

Answer 1

Try

Cell(a,b).Value

instead of just Cell(a,b).

---

Also, the following approach should work

Excel.Range objRange = (Excel.Range)objSheet.Cells[rowN,colN];
variableName = objRange.get_Value(System.Missing.Type).ToString();

You may modify it for your datatype