parent directory.. | ||||
View all files | ||||
These samples demonstrates the formula calculation capabilities of EPPlus.
This sample opens an Excel workbook (FormulaCalcSample.xlsx) and recalculates the formulas in it. Functions used: SUM, SUMIFS, and nested VLOOKUP
It also shows the three different contexts where Calculate can be called: workbook, worksheet and range.
This sample demonstrates how to create a workbook with EPPlus, add formulas to it and calculate them.
This sample demonstrates how to add custom functions to the EPPlus formula engine.