#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;
}