Beispiel #1
0
        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();
        }