Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public static int NumberFromExcelColumn(string column)
- {
- int retVal = 0;
- string col = column.ToUpper();
- for (int iChar = col.Length - 1; iChar >= 0; iChar--)
- {
- char colPiece = col[iChar];
- int colNum = colPiece - 64;
- retVal = retVal + colNum * (int)Math.Pow(26, col.Length - (iChar + 1));
- }
- return retVal;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement