/// <summary>
/// 从 A1 形式字符串得到行号列号
/// 注意：不支持ZZ以后的列
/// </summary>
/// <param name="aReference"></param>
/// <param name="rowIndex"></param>
/// <param name="columnIndex"></param>
public static void GetIndexByReference(string aReference, out int rowIndex, out int columnIndex)
{
string columnName = I3ReferenceUtil.GetColumnName(aReference);
rowIndex = (int)I3ReferenceUtil.GetRowIndex(aReference);
int div, mod;
if (columnName.Length == 1)
{
div = 0;
}
else
{
div = I3MathUtil.Asc(I3StringUtil.SubString(columnName, 0, 1)) - 64;
}
mod = I3MathUtil.Asc(I3StringUtil.SubString(columnName, columnName.Length - 1, 1)) - 64;
columnIndex = div * 26 + mod;
}
/// <summary>
/// 将列号从数字转换成字母
/// </summary>
/// <param name="index"></param>
/// <returns></returns>
public static string GetColumnName(int index)
{
string reference = I3ReferenceUtil.GetReferenceByIndex(1, index);
return(I3ReferenceUtil.GetColumnName(reference));
}
