leetcode_num168&171_excel title&number
来源:互联网 发布:网络执法官3.56破解版 编辑:程序博客网 时间:2024/05/29 14:43
Given a positive integer, return its corresponding column title as appear in an Excel sheet.
class Solution {public: string convertToTitle(int n) { string s; while(n){ s.insert(s.begin(),(n-1)%26+'A');//在字符串起始位插入 n=(n-1)/26; } return s; }};由于没有0,所以需要先减1
Given a column title as appear in an Excel sheet, return its corresponding column number.
class Solution {public: int titleToNumber(string s) { int rs=0,j,a; for(int i=0;i<s.length();i++){ j=s.length()-i-1; a=s[j]-'A'+1; rs+=(a*pow(26,i)); } return rs; }};
0 0
- leetcode_num168&171_excel title&number
- #168 Excel Sheet Column Title &« Excel Sheet Column Number
- LeetCode 171/168 Excel Sheet Column Number/Title
- <LeetCode OJ> 171 / 168 Excel Sheet Column Number & Title
- #leetcode#168 171 Excel Sheet Column Title 与 Excel Sheet Column Number
- LeetCode.158(171) Excel Sheet Column Title&Excel Sheet Column Number
- [Leetcode]Excel Sheet Column Title/Number
- LeetCode-Excel Sheet Column Number/Title
- 项目管理_EXCEL
- C#_Excel操作方法汇总
- 批量提取文件_excel
- JAVA开发_EXCEL文件解析
- 909422229_Excel导入导出实现
- Excel Sheet Column Title,Excel Sheet Column Number
- [LeetCode] Excel Sheet Column Title、Excel Sheet Column Number
- 【leetcode】Excel Sheet Column Title & Excel Sheet Column Number
- Excel Sheet Column Number/Excel Sheet Column Title
- LeetCode[Math]----Excel Sheet Column Title----Excel Sheet Column Number
- 省
- 【Sql Server学习】Sql Server数据查询(二)
- 阿里云防火墙
- BroadcastReceiver
- 数学之美 (胡军)
- leetcode_num168&171_excel title&number
- Simple_Wallet 在服务器端通过RPC操纵钱包
- 函数对象
- Linux系统cpuinfo详解
- Google Hosts
- 【Python】科学计算(一)——Mandelbrot集合
- Configuration(AnnotationConfiguration)
- 深入浅出的讲解傅里叶变换(2)
- pow函数总结