static void Main(string[] args) { // Class derived from ICalcData. CalcData calcData = new CalcData(); CalcEngine engine = new CalcEngine(calcData); // To set the data value of a specified row and column. calcData.SetValueRowCol(90, 1, 1); calcData.SetValueRowCol(50, 1, 2); calcData.SetValueRowCol(100, 1, 3); // Adding the name to the named range collection, engine.AddNamedRange("GROUPCELLS", "A1:C1"); // Using the name for computing formulas, string formula = "SUM(GROUPCELLS)"; string result = engine.ParseAndComputeFormula(formula); Console.WriteLine("The calculated result of name range is : " + result); Console.ReadKey(); }