Object value = expr.Eval() // return 3132 Expression expr = new Expression('DATEDIF(DATEVALUE(''),DATEVALUE(''),'MD')') Object value = expr.Eval() // return 102 Expression expr = new Expression('DATEDIF(DATEVALUE(''),DATEVALUE(''),'D')') Object value = expr.Eval() // return 8 Expression expr = new Expression('DATEDIF(DATEVALUE(''),DATEVALUE(''),'M')') Expression expr = new Expression('DATEDIF(DATEVALUE(''),DATEVALUE(''),'Y')')

Object value = expr.Eval() // return 39 Example 2: Calculates the number of days, months, or years between two dates.

$math property evaluator$

Int value = expr.Eval() // return 295 Expression expr = new Expression('NETWORKDAYS(startdate,enddate)') Įxpr.Bind('startdate', new DateTime(2021, 08, 11)) Įxpr.Bind('enddate', new DateTime(2021, 10, 4)) , Saturday = 6Įxpr.Bind('B5', new DateTime(2017, 1, 15)) Įxpr.Bind('C5', new DateTime(2018, 1, 21)) ĭecimal value = expr.Eval() //return 212 Example 1: Calculate networkday Expression expr = new Expression('NETWORKDAYS(DATEVALUE(''),DATEVALUE(''))') Or Expression expression = new Expression() Įxpression.DisableFunction(new string ) //Sunday = 0. Disable functions Expression expression = new Expression() List variables = expression.getVariables() Ĭonsole.WriteLine(variable) // will print x, a Get variables that appear in the expression Expression expression = new Expression('sin(pi/2+x)-cos(x) = a') Validate expression before evaluate Expression expression = new Expression('SUM(1,2,3) + true') String value = expr.Eval() //return 'mango' SWITCH/CASE condition: Expression expr = new Expression('SWITCH(name,1,'apple',2,'mango',3,'banana','N/A')') IF/ELSE condition: Expression expression = new Expression('IF(time>8, (HOUR_SALARY*8) + (HOUR_SALARY*1.25*(time-8)), HOUR_SALARY*time)') ĭecimal salary = expression.Eval() // will return 92.5 Multiple methods just in one line (method chaining) Object value = new Expression('(a + b) / 2 ').Bind('a', 3).Bind('b', 5).Eval() 5. Object value = expression.Eval() // will return 4 Eval expression c# Expression expression = new Expression('(a + b) / 2 ') Or using default constructor + SetFomular() method: Expression expression = new Expression() Įxpression.SetFomular('(a + b) / 2 ') 2.Bind variable Expression expression = new Expression('(a + b) / 2 ') Įxpression.Bind('a', 3).Bind('b',5) 3. In this page, we show some usage examples and lists all supported operators, constants and functions to give you an overview of using and implementation this C# eval library 1.Object initialization Expression expression = new Expression('(a + b) / 2 ') This library allows to evaluate mathematical expression, logical expression, string expression and datetime expression. Matheval is a simple, fast and highly flexible math expression eval library for C#.

Math property evaluator