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

Cell(1).Value throws exception - cell with formula

Jun 23, 2015 at 9:56 AM
Edited Jun 23, 2015 at 10:00 AM
When I reading cell(with formula) using .value() , it throws an exception. So i used .valueCached. But when using valueCached it returns null . Below is ma code
var array = new object[colCont];
for (int y = 1; y <= colCont; y++)
{
      try
       {
                if (item.Cell(y).FormulaA1 == "")
                      array[y - 1] = item.Cell(y).Value;
                 else
                       array[y - 1] = item.Cell(y).ValueCached;
        }
        catch
         {
         }
 }        
Please advise.