title: How to parse formula values as text in Excel via C#
body: <p>I have to parse out some data from a MS Excel file.</p>
  
  <p>The cells that I need to grab data out of have formula text as its value.</p>
  
  <p>For example:</p>
  
  <pre><code>Sheet 2 [A1].Value = "$50"
  Sheet 1 [A1].Formula = "='Sheet2'!A1"
  </code></pre>
  
  <p>When I grab the value for <code>Sheet1 [A1]</code>, I get <code>='Sheet2'!A1</code>, not <code>$50</code>.</p>
  
  <p>Is there a way to get the text value after formula calculation from <code>Sheet1[A1]</code> using C#?</p>