获得EXCEL列坐标的方法

  private static string getColumnName(int columnIndex)        {            int dividend = columnIndex;            string columnName = String.Empty;            int modifier;            while (dividend > 0)            {                modifier = (dividend - 1) % 26;                columnName =                    Convert.ToChar(65 + modifier).ToString() + columnName;                dividend = (int)((dividend - modifier) / 26);            }            return columnName;        }

另外的一种获得excel的列坐标的方法，引用自http://lateral8.com/articles/2010/3/5/openxml-sdk-20-export-a-datatable-to-excel.aspx