/// <summary>
/// Define named range from an address.
/// </summary>
/// <param name="name">Name to identify a range in spreadsheet</param>
/// <param name="address">Address reference to a range</param>
/// <param name="scope">The valid scope of this named range</param>
/// <returns>Instance of named range added into spreadsheet</returns>
/// <exception cref="InvalidAddressException">throw if specified address or name is illegal</exception>
public NamedRange DefineNamedRange(string name, string address, NamedRangeScope scope)
{
if (!RangePosition.IsValidAddress(address))
{
throw new InvalidAddressException(address);
}
return(DefineNamedRange(name, new RangePosition(address), scope));
}
/// <summary>
/// Define named range registered into spreadsheet
/// </summary>
/// <param name="name">Name to identify a range in spreadsheet</param>
/// <param name="range">Range to be added into spreadsheet</param>
/// <param name="scope">The valid scope of this named range</param>
/// <returns>Instance of named range added into spreadsheet</returns>
public NamedRange DefineNamedRange(string name, RangePosition range, NamedRangeScope scope = NamedRangeScope.Workbook)
{
var namedRange = new NamedRange(this, name, FixRange(range))
{
Scope = scope,
};
AddNamedRange(namedRange);
return(namedRange);
}
/// <summary>
/// Define named range to specify region
/// </summary>
/// <param name="name">name to be defined to the range</param>
/// <param name="row">number of row start to the range</param>
/// <param name="col">number of column start to the range</param>
/// <param name="rows">number of rows contained in the range</param>
/// <param name="cols">number of columns contained in the range</param>
/// <param name="scope">The valid scope of this named range</param>
/// <returns>Instance of named range</returns>
public NamedRange DefineNamedRange(string name, int row, int col, int rows, int cols, NamedRangeScope scope)
{
return(DefineNamedRange(name, new RangePosition(row, col, rows, cols), scope));
}
