/// <summary>
/// Returns the row number from the cellAddress
/// e.g. D5 would return 5
/// </summary>
/// <param name="cellAddress">An Excel format cell addresss (e.g. D5)</param>
/// <returns>The row number</returns>
public static int GetRowNumber(string cellAddress)
{
// find out position where characters stop and numbers begin
int iPos = 0;
bool found = false;
foreach (char chr in cellAddress.ToCharArray())
{
iPos++;
if (char.IsNumber(chr))
{
found = true;
break;
}
}
if (found)
{
string NumberPart = cellAddress.Substring(iPos - 1, cellAddress.Length - (iPos - 1));
if (ExcelCell.IsNumericValue(NumberPart))
{
return(int.Parse(NumberPart));
}
}
return(0);
}