Example #1
0
        public void WorksheetContainsNamedRange()
        {
            IXLWorksheet ws = new XLWorkbook().AddWorksheet("Sheet1");
            ws.FirstCell().AddToNamed("Name", XLScope.Worksheet);

            Assert.IsTrue(ws.NamedRanges.Contains("Name"));
            Assert.IsFalse(ws.NamedRanges.Contains("NameX"));

            Assert.IsNotNull(ws.NamedRange("Name"));
            Assert.IsNull(ws.NamedRange("NameX"));

            IXLNamedRange range1;
            Boolean result1 = ws.NamedRanges.TryGetValue("Name", out range1);
            Assert.IsTrue(result1);
            Assert.IsNotNull(range1);

            IXLNamedRange range2;
            Boolean result2 = ws.NamedRanges.TryGetValue("NameX", out range2);
            Assert.IsFalse(result2);
            Assert.IsNull(range2);
        }