Advertisement
hungcoder92

Code Chuyển ngược lại

Apr 16th, 2022
1,593
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C# 0.36 KB | None | 0 0
  1. public static int NumberFromExcelColumn(string column)
  2. {
  3.     int retVal = 0;
  4.     string col = column.ToUpper();
  5.     for (int iChar = col.Length - 1; iChar >= 0; iChar--)
  6.     {
  7.         char colPiece = col[iChar];
  8.         int colNum = colPiece - 64;
  9.         retVal = retVal + colNum * (int)Math.Pow(26, col.Length - (iChar + 1));
  10.     }
  11.     return retVal;
  12. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement