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