public void WorkbookContainsNamedRange() { var wb = new XLWorkbook(); IXLWorksheet ws = wb.AddWorksheet("Sheet1"); ws.FirstCell().AddToNamed("Name"); Assert.IsTrue(wb.NamedRanges.Contains("Name")); Assert.IsFalse(wb.NamedRanges.Contains("NameX")); Assert.IsNotNull(wb.NamedRange("Name")); Assert.IsNull(wb.NamedRange("NameX")); IXLNamedRange range1; Boolean result1 = wb.NamedRanges.TryGetValue("Name", out range1); Assert.IsTrue(result1); Assert.IsNotNull(range1); IXLNamedRange range2; Boolean result2 = wb.NamedRanges.TryGetValue("NameX", out range2); Assert.IsFalse(result2); Assert.IsNull(range2); }
public void NamedRange1() { var wb = new XLWorkbook(); IXLNamedRange range = wb.NamedRange("ABC"); Assert.IsNull(range); }
public void NamedRange2() { var wb = new XLWorkbook(); IXLWorksheet ws = wb.AddWorksheet("Sheet1"); ws.FirstCell().SetValue(1).AddToNamed("Result", XLScope.Worksheet); IXLNamedRange range = wb.NamedRange("Sheet1!Result"); Assert.IsNotNull(range); Assert.AreEqual(1, range.Ranges.Count); Assert.AreEqual(1, range.Ranges.Cells().Count()); Assert.AreEqual(1, range.Ranges.First().FirstCell().GetValue<Int32>()); }
public void NamedRange3() { var wb = new XLWorkbook(); IXLWorksheet ws = wb.AddWorksheet("Sheet1"); IXLNamedRange range = wb.NamedRange("Sheet1!Result"); Assert.IsNull(range); }