public DefinedName AddRange(String name, Range range, Sheet sheet)
{
DefinedName dn = new DefinedName
{
Name = name,
Value = QuoteSheetName(sheet) + "!" + Range.Format(range, true)
};
definedNames.Add(name, dn);
return(dn);
}
public void AddRange(Range range)
{
Ranges.Add(Range.Format(range));
}