将Excel列的字母索引值转换成整数索引值

#region ExcelHelper Kit
  /// <summary>
  /// 将Excel列的字母索引值转换成整数索引值
  /// </summary>
  /// <param name="letter"></param>
  /// <returns></returns>
  public int LetterToInt(string letter)
  {
   int n = 0;
   
   if(letter.Trim().Length == 0)
    throw new Exception("不接受空字符串！");

   if(letter.Length >= 2)
   {
    char c1 = letter.ToCharArray(0,2)[0];
    char c2 = letter.ToCharArray(0,2)[1];

    if(!char.IsLetter(c1) || !char.IsLetter(c2))
    {
     throw new Exception("格式不正确，必须是字母！");
    }

    c1 = char.ToUpper(c1);
    c2 = char.ToUpper(c2);

    int i = Convert.ToInt32(c1) - 64;
    int j = Convert.ToInt32(c2) - 64;

    n = i * 26 + j;
   }
   
   if(letter.Length == 1)
   {
    char c1 = letter.ToCharArray()[0];

    if(!char.IsLetter(c1))
    {
     throw new Exception("格式不正确，必须是字母！");
    }

    c1 = char.ToUpper(c1);

    n = Convert.ToInt32(c1) - 64;
   }

   if(n > 256)
    throw new Exception("索引超出范围，Excel的列索引不能超过256！");
   
   return n;
  }