Excel 列索引 转 列英文序号



  /// <summary> 
        /// 列从1开始,转换得到excel列中的英文序号 
        ///   调用示例：string s = TransferExcelColumnIndex(5);//得到E 
        /// </summary> 
        /// <param name="iColIndex"></param> 
        /// <returns></returns>
        public string TransferExcelColumnIndex(int iColIndex)
        {
            string sResult = "";
            int iHead = (iColIndex-1) / 26;
            int iLeftOver = (iColIndex-1) % 26;
            if (iHead >= 26)
            {
                sResult = TransferExcelColumnIndex(iHead);
            }
            else if (iHead > 0)
            {

                sResult += (char)(64 + iHead);
            }

            sResult += (char)(65 + iLeftOver);

            return sResult;
        }