Calculate Expression : Excel « Windows « VB.Net Tutorial






public class Test
   public Shared Sub Main
        Dim objExcel As Excel.Application
        objExcel = New Excel.Application


    
        Dim strMath As String

        strMath = "cos(3.673/4)/exp(-3.333)"
        If strMath <> "" Then
            Try
                Console.WriteLine(objExcel.Evaluate(strMath).ToString)
            Catch exc As Exception
                Console.WriteLine(exc.Message)
            End Try
        End If

        objExcel.Workbooks.Close()
        objExcel.Quit()
        objExcel = Nothing
   End Sub
End class








24.21.Excel
24.21.1.Create function in Excel
24.21.2.Create a Spreadsheet
24.21.3.Import data
24.21.4.Sort imported data
24.21.5.Calculate Expression