CODEWITHSUNDEEP
c#excelvisual-studioio
AdamMc331
AdamMc331

Reputation: 16691

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

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.

Upvotes: 0

Views: 5774

Answers (1)

hnk
hnk

Reputation: 2214

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

Upvotes: 2

Related Questions