public static string BuildExcelColumnName(int columnnumber)
{
//目前只支持702列以内的列标题
string strColumnName = "";
char strColumnNamePre;
char calTitleItem;
int roundCount = 0;
int modCount = 0;
int acsA = 65;
roundCount = columnnumber / 26;
if (roundCount == 0)
{
strColumnNamePre = char.MinValue;
}
else
{
strColumnNamePre = Convert.ToChar(acsA + roundCount - 1);
}
modCount = columnnumber % 26;
calTitleItem = Convert.ToChar(acsA + modCount);
strColumnName = Convert.ToString(strColumnNamePre) + Convert.ToString(calTitleItem);
return strColumnName;
}
模拟Excel列头的简单方法
于 2023-10-02 17:16:43 首次发布