Reading formula calculated value from excel cell in c#

2
votes

I am using linqtoexcel for reading from a excel sheet. the problem i face is that i can't read the formula calculated value from a cell, instead i get the actual value of the cell. Is there any way to read the end value of the cell from the excel sheet using linqtoexcel or by some other means.

1
c#excellinq-to-excel
Maybe you could re-calculate the cell in c#? - BjarkeCK
its not that actually. Is it possible read the formula for the cell? i'm importing data from user mentioned excel sheet mate. - user1811801

1 Answers

1
votes

linqtoexcel uses OleDB to access the sheet's data, and since OleDB does not allow the formulas to be accessed, you can't read the formula from the excel cell. You can only view the value for the cell.