This project has moved and is read-only. For the latest updates, please go here.

Read From Excel

Mar 3, 2015 at 7:07 AM
Hi.
I use asp.net and I want to read from excel and insert into Database.
My .xlsx file has several sheets and I want to read from an special sheet.
All of cells in this sheet contains Formula.
When I read from This, some cells return #VALUE! instead of value.(ex: #VALUE! instead of 0.456)
What is the problem? What should I do?
Thanks
Mar 6, 2015 at 9:13 AM
did you try to invoke Calculate() function on sheet?
Mar 7, 2015 at 4:57 AM
Edited Mar 7, 2015 at 8:10 AM
yes.
I found an Error.
I think it may be a bug.
it can not calculate some formula for example COUNTIF()
I change this formula to SUM() and it worked correctly
Mar 8, 2015 at 3:44 PM
please check documentation for the formulas which are implemented. it will help you.