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.
Asked
Active
Viewed 1,083 times
2
-
1Maybe you could re-calculate the cell in c#? – BjarkeCK Sep 25 '13 at 10:06
-
its not that actually. Is it possible read the formula for the cell? i'm importing data from user mentioned excel sheet mate. – user1811801 Sep 25 '13 at 10:11
1 Answers
1
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.
Raz Harush
- 739
- 1
- 6
- 21
-
Is there any other way around to read those calculated values other than linqtoexcel? – user1811801 Sep 25 '13 at 10:13