首页 > 代码库 > 【leetcode】Excel Sheet Column Number

【leetcode】Excel Sheet Column Number

Excel Sheet Column Number

Related to question Excel Sheet Column Title

Given a column title as appear in an Excel sheet, return its corresponding column number.

For example:

    A -> 1    B -> 2    C -> 3    ...    Z -> 26    AA -> 27    AB -> 28 
 
 1 class Solution { 2 public: 3     int titleToNumber(string s) { 4         5         int n=s.length(); 6         int result=0; 7         for(int i=0;i<n;i++) 8         { 9             int num=s[i]-A+1;10             result=result*26+num;11         }12        13         return result;14     }15 };

 

【leetcode】Excel Sheet Column Number