public void Ranges3() { var wb = new XLWorkbook(); IXLWorksheet ws = wb.AddWorksheet("Sheet1"); ws.FirstCell().SetValue(1).AddToNamed("Result"); IXLRanges ranges = wb.Ranges("Sheet1!Result, ABC"); Assert.IsNotNull(ranges); Assert.AreEqual(1, ranges.Cells().Count()); Assert.AreEqual(1, ranges.First().FirstCell().GetValue<Int32>()); }
public void WbNamedRanges() { var wb = new XLWorkbook(); IXLWorksheet ws = wb.Worksheets.Add("Sheet1"); ws.Cell(1, 1).SetValue("A"); ws.Cell(2, 1).SetValue("B"); ws.Cell(3, 1).SetValue("C").AddToNamed("Test2"); IXLRange original = ws.Range("A1:A2"); original.AddToNamed("TestRange"); IXLRanges wbRanges = wb.Ranges("TestRange, Test2"); Assert.AreEqual(original.RangeAddress.ToStringFixed(), wbRanges.First().RangeAddress.ToString()); Assert.AreEqual("$A$3:$A$3", wbRanges.Last().RangeAddress.ToStringFixed()); IXLRanges wsRanges = wb.Ranges("TestRange, Test2"); Assert.AreEqual(original.RangeAddress.ToStringFixed(), wsRanges.First().RangeAddress.ToString()); Assert.AreEqual("$A$3:$A$3", wsRanges.Last().RangeAddress.ToStringFixed()); }
public void Ranges1() { var wb = new XLWorkbook(); IXLRanges ranges = wb.Ranges("ABC"); Assert.IsNotNull(ranges); Assert.AreEqual(0, ranges.Count()); }