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
---------------------------------- thinking -----------------------------------------
Too simple. Just learn how to use iterator!!
---------------------------------- codes --------------------------------------------
class Solution { public: int titleToNumber(string s) { int result = 0; std::string::iterator it; for (it = s.begin(); it != s.end(); ++it) { char cur = *it; result = 26 * result + cur - 'A' + 1; } return result; } };
No comments:
Post a Comment