Implements Excel-like formulas, supporting dynamic calculations with variable parameter mapping.
Get Started
$ dotnet add package FunctionXReadme
FunctionX
The FunctionX library implements Excel-like formula functionality in C#. It allows users to manipulate data in a similar way to Excel formulas. The library runs scripts in the Roslyn compiler to evaluate expressions.
Features
The FunctionX library offers the following features:
Usage
To use the FunctionX library:
- Call the
Fx.Evaluatemethod to evaluate a formula. - Pass the formula string and a dictionary of parameters.
Examples
Here are some examples of using the FunctionX library:
// Basic mathematical operation
var result = await Fx.EvaluateAsync("1 + 2 + 3");
// Calculate the average value in an array
var parameters = new Dictionary<string, object?>
{
{ "myArray", new object[] {1, 2, 3, 4, 5} }
};
var average = await Fx.EvaluateAsync("AVERAGE(@myArray)", parameters);
// Conditional logic
var parameters = new Dictionary<string, object?>
{
{ "value1", 10 },
{ "value2", 20 }
};
var ifResult = await Fx.EvaluateAsync("IF(@value1 > @value2, \"Yes\", \"No\")", parameters);
Implemented Functions
| Function Name | Description |
|---|---|
SUM | Calculates the sum of numeric values. |
AVERAGE | Calculates the average of numeric values. |
MAX | Finds the maximum value among numeric values. |
MIN | Finds the minimum value among numeric values. |
COUNT | Counts the number of numeric values. |
COUNTA | Counts the number of non-empty values. |
AND | Returns true if all values are true. |