public string Getzm(int Index)
{
var dividend = Index;
string columnName = string.Empty;
while (dividend > 0)
{
var modulo = (dividend - 1) % 26;
columnName = Convert.ToChar(65 + modulo) + columnName;
dividend = (dividend - modulo) / 26;
}
return columnName;
}
c# 将excel 数字列转换为字母列:如把1变成A ,27变为AA
最新推荐文章于 2023-09-26 11:13:33 发布