internal static AddressType IsValid(string Address)
{
string ws = "";
if (Address.StartsWith("'"))
{
int ix = Address.IndexOf('\'', 1);
if (ix > -1)
{
ws = Address.Substring(1, ix - 1);
Address = Address.Substring(ix + 2);
}
}
if (Address.IndexOfAny(new char[] { '(', ')', '+', '-', '*', '/', '.', '=', '^', '&', '%', '\"' }) > -1)
{
return(AddressType.Invalid);
}
if (Address.IndexOf('!') > 0)
{
string[] split = Address.Split('!');
if (split.Length == 2)
{
ws = split[0];
Address = split[1];
}
else if (split.Length == 3 && split[1] == "#REF" && split[2] == "")
{
ws = split[0];
Address = "#REF!";
if (ws.StartsWith("[") && ws.IndexOf("]") > 1)
{
return(AddressType.ExternalAddress);
}
else
{
return(AddressType.InternalAddress);
}
}
else
{
return(AddressType.Invalid);
}
}
int row, col;
if (ExcelAddressBase.GetRowCol(Address, out row, out col, false))
{
if (row > 0 && col > 0 && row <= ExcelPackage.MaxRows && col <= ExcelPackage.MaxColumns)
{
if (ws.StartsWith("[") && ws.IndexOf("]") > 1)
{
return(AddressType.ExternalAddress);
}
else
{
return(AddressType.InternalAddress);
}
}
else
{
return(AddressType.Invalid);
}
}
else
{
if (IsValidName(Address))
{
if (ws.StartsWith("[") && ws.IndexOf("]") > 1)
{
return(AddressType.ExternalName);
}
else
{
return(AddressType.InternalName);
}
}
else
{
return(AddressType.Invalid);
}
}
}
