C# (CSharp) ClosedXML.Excel XLWorkbook.SetValue Examples

Example #1

File: FunctionsTests.cs Project: hal1932/ClosedXML

        public void Sum()
        {
            IXLCell cell = new XLWorkbook().AddWorksheet("Sheet1").FirstCell();
            IXLCell fCell = cell.SetValue(1).CellBelow().SetValue(2).CellBelow();
            fCell.FormulaA1 = "sum(A1:A2)";

            Assert.AreEqual(3.0, fCell.Value);
        }