public void IsValidName()
{
Assert.IsFalse(ExcelAddressUtil.IsValidName("123sa")); //invalid start char
Assert.IsFalse(ExcelAddressUtil.IsValidName("*d")); //invalid start char
Assert.IsFalse(ExcelAddressUtil.IsValidName("\t")); //invalid start char
Assert.IsFalse(ExcelAddressUtil.IsValidName("\\t")); //Backslash at least three chars
Assert.IsFalse(ExcelAddressUtil.IsValidName("A+1")); //invalid char
Assert.IsFalse(ExcelAddressUtil.IsValidName("A%we")); //Address invalid
Assert.IsFalse(ExcelAddressUtil.IsValidName("BB73")); //Address invalid
Assert.IsTrue(ExcelAddressUtil.IsValidName("BBBB75")); //Valid
Assert.IsTrue(ExcelAddressUtil.IsValidName("BB1500005")); //Valid
}
private void ValidateName(string name)
{
if (string.IsNullOrEmpty(name.Trim()))
{
throw new ArgumentException("Tablename is blank", "Name");
}
var c = name[0];
if (char.IsLetter(c) == false && c != '\\' && c != '_')
{
throw new ArgumentException("Tablename start with invalid character", "Name");
}
if (!ExcelAddressUtil.IsValidName(name))
{
throw (new ArgumentException("Tablename is not valid", "Name"));
}
}
/// <summary>
/// Add a new named range
/// </summary>
/// <param name="Name">The name</param>
/// <param name="Range">The range</param>
/// <returns></returns>
public ExcelNamedRange Add(string Name, ExcelRangeBase Range)
{
ExcelNamedRange item;
if (!ExcelAddressUtil.IsValidName(Name))
{
throw (new ArgumentException("Name contains invalid characters"));
}
if (Range.IsName)
{
item = new ExcelNamedRange(Name, _wb, _ws, _dic.Count);
}
else
{
item = new ExcelNamedRange(Name, _ws, Range.Worksheet, Range.Address, _dic.Count);
}
AddName(Name, item);
return(item);
}
private void ValidateTableName(string Name)
{
if (string.IsNullOrEmpty(Name))
{
throw new ArgumentException("Tablename is null or empty");
}
char firstLetterOfName = Name[0];
if (Char.IsLetter(firstLetterOfName) == false && firstLetterOfName != '_' && firstLetterOfName != '\\')
{
throw new ArgumentException("Tablename start with invalid character");
}
if (Name.Contains(" "))
{
throw new ArgumentException("Tablename has spaces");
}
if (!ExcelAddressUtil.IsValidName(Name))
{
throw (new ArgumentException("Tablename is not valid"));
}
}
