title: Get formula result from Excel cell using Spire.xls
body: <p>I'm trying to read data in a xlsx file (in C# WPF with spire xls) but when the cell contains a formula I can only get the formula and I don't know how to get the result</p>
  
  <p>I've tried this :</p>
  
  <pre><code>    wb.LoadFromFile("...");
      wb.CalculateAllValue();
      colsheet = wb.Worksheets[6];
      SwitchName = colsheet.Range["B1"].Value;
  </code></pre>
  
  <p>and with that I get : <code>"=IF(OR(I215=0,J215=0),"",I215+J215-1)"</code> but I want the result and not the formula. How can I do that?</p>