or




/// <summary>/// Get a Named Range from the given workbook./// </summary>/// <param name="workbook"></param>/// <param name="rangeName"></param>/// <returns></returns>public Range GetNamedRange( Workbook workbook, string rangeName){ ExceptionHelper.TestNull(workbook, "workbook parameter"); ExceptionHelper.TestStringValue(rangeName, "rangeName parameter"); Range result = null; Names names = workbook.Names; foreach (Name name in names) { string[] nme = name.NameLocal.Split("!".ToCharArray()); if (nme[nme.Length-1] == rangeName) { result = name.RefersToRange; break; } } return result;}