Calculate Expression : Excel « Windows « VB.Net Tutorial

Home
VB.Net Tutorial
1.Language Basics
2.Data Type
3.Operator
4.Statements
5.Date Time
6.Class Module
7.Development
8.Collections
9.Generics
10.Attributes
11.Event
12.LINQ
13.Stream File
14.GUI
15.GUI Applications
16.Windows Presentation Foundation
17.2D Graphics
18.I18N Internationlization
19.Reflection
20.Regular Expressions
21.Security
22.Socket Network
23.Thread
24.Windows
25.XML
26.Database ADO.net
27.Design Patterns
VB.Net
VB.Net by API
VB.Net Tutorial » Windows » Excel 
24.21.5.Calculate Expression
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
www.java2java.com | Contact Us
Copyright 2009 - 12 Demo Source and Support. All rights reserved.
All other trademarks are property of their respective owners.