Excel Sheet Column Number
来源:互联网 发布:淘宝能在1688 编辑:程序博客网 时间:2024/06/05 05:35
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
26进制转10进制,注意以'A'而不是0开头,因此要“+1”,跟二进制转换成十进制一样。
class Solution {public: int titleToNumber(string s) { int n=s.size(); int result=0; int temp=1; for(int i=n-1;i>=0;i--) { result=result+(s[i]-'A'+1)*temp; temp=temp*26; } return result; }};
0 0
- Excel Sheet Column Number
- Excel Sheet Column Number
- Excel Sheet Column Number
- Excel Sheet Column Number
- Excel Sheet Column Number
- Excel Sheet Column Number
- Excel Sheet Column Number
- Excel Sheet Column Number
- Excel Sheet Column Number
- Excel Sheet Column Number
- Excel Sheet Column Number
- Excel Sheet Column Number
- Excel Sheet Column Number
- Excel Sheet Column Number
- excel Sheet Column Number
- Excel Sheet Column Number
- Excel Sheet Column Number
- Excel Sheet Column Number
- 0前端大转载---------------ajax
- Discriminative Learned Dictionaries for Local Image Analysis学习笔记
- Android使用SimpleAdapter
- 总结CSS3变形transform属性
- AFNetworking《二》理解NSOperation (Demo笔记)
- Excel Sheet Column Number
- UVALive 6835 - Space Golf
- 10min programming
- openjudge集合问题
- Sublime Text 全程指南
- 第一个Android用例
- [Javascript Data Structures] 二分查找 Binary Search
- HTML5 Cookie总结
- 黑马程序员——java基础---集合--迭代