The sample demonstrates how to read formulas from spreadsheet.
private void btnRun_Click(object sender, System.EventArgs e)
{
Workbook workbook = new Workbook();
workbook.LoadFromFile(@"..\..\..\..\..\..\Data\ReadFormulasSmple.xls");
Worksheet sheet = workbook.Worksheets[0];
textBox1.Text = sheet.Range["C5"].Formula;
textBox2.Text = sheet.Range["C5"].FormulaNumberValue.ToString();
}
Private Sub btnRun_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnRun.Click
Dim workbook As Workbook = New Workbook()
workbook.LoadFromFile("..\..\..\..\..\..\Data\ReadFormulasSmple.xls")
Dim sheet As Worksheet = workbook.Worksheets(0)
textBox1.Text = sheet.Range("C5").Formula
textBox2.Text = sheet.Range("C5").FormulaNumberValue.ToString()
End Sub