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); }