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