Comments

5 responses to “Convert given excel column name to column Index, ex ‘A=0’, ‘AA=26’”

1. 

   September 20, 2012

   Simon

   Actually your code is incorrect, I believe it at most works for length 2.
   It is as simple as converting from index to column name.
   See the modified version below.

   public static int convert2ColumnIndex(String columnName) {
   columnName = columnName.toUpperCase();
   int value = 0;
   for (int i = 0; i < columnName.length(); i++) {
   int delta = ( columnName.charAt(i)) – 64;
   value = value*26+ delta;
   }
   return value-1;
   }

   Reply
   1. 

      September 24, 2012

      Greg

      Thanks, I checked the code works as expected for more than 2 columns, not really sure why I did it that way.

      Reply
2. 

   October 15, 2012

   Seyal

   Or you can count with base 26.

   Reply
3. 

   February 15, 2016

   chethan

   int columnIndex = 0;
   Regex regex = new Regex(“[A-Za-z]”);
   foreach (char eachCharaterIndex in regex.Match(columnNameIndex).Value.ToLower().ToCharArray())
   {
   columnIndex = (eachCharaterIndex % 32) + columnIndex;
   }
   return columnIndex;

   Reply
4. 

   February 15, 2016

   chethan

   private int ExcelColumnIndex(string columnNameIndex)
   {
   int columnIndex = 0;
   Regex regex = new Regex(“[A-Za-z]”);
   foreach (char eachCharaterIndex in regex.Match(columnNameIndex).Value.ToLower().ToCharArray())
   {
   columnIndex = (eachCharaterIndex % 32) + columnIndex;
   }
   return columnIndex;
   }

   Reply