Excel Sheet Column Title
来源:互联网 发布:什么是ai设计软件 编辑:程序博客网 时间:2024/06/09 16:37
public class Solution { public static String reverse(String string){ String newString = ""; for(int i = string.length() - 1; i>= 0; i--){ newString += string.charAt(i); } return newString; } public static String convertToTitle(int n) { String excelSheet = ""; int base = 27; while(n > 0){ if (n % (base - 1) == 0) {excelSheet += 'Z';n /= base; } else{ excelSheet += (char)(n %(base - 1) - 1 + 'A'); n /= (base - 1); } } excelSheet = reverse(excelSheet); return excelSheet; }}
貌似与26进制的差别就是在26进制数上加1,所以需要每位先减掉,很神奇的规律!!!
public class Solution { public static String reverse(String string){ String newString = ""; for(int i = string.length() - 1; i>= 0; i--){ newString += string.charAt(i); } return newString; } public static String convertToTitle(int n) { String excelSheet = ""; int base = 26; while(n > 0){ n--; char ch = (char)(n % base + 'A'); excelSheet += ch; n /= base; } excelSheet = reverse(excelSheet); return excelSheet; }}
0 0
- Excel Sheet Column Title
- Excel Sheet Column Title
- Excel Sheet Column Title
- Excel Sheet Column Title
- Excel Sheet Column Title
- Excel Sheet Column Title
- Excel Sheet Column Title
- Excel Sheet Column Title
- Excel Sheet Column Title
- Excel Sheet Column Title
- Excel Sheet Column Title
- Excel Sheet Column Title
- Excel Sheet Column Title
- Excel Sheet Column Title
- Excel Sheet Column Title
- Excel Sheet Column Title
- Excel Sheet Column Title
- Excel Sheet Column Title
- WPF 学习资源收集
- java InputStream读取数据问题
- C# Lambda表达式
- 查询表空间以及删除表空间
- Android中Context详解 ---- 你所不知道的Context
- Excel Sheet Column Title
- C#结构体和字节数组的转换函数
- 【深入JAVA】正则匹配
- android 禁止屏幕转向
- Markdown 学习资源整理
- 116:Populating Next Right Pointers in Each Node【树】【DFS】
- 复制构造函数和析构函数经典例子
- Json-fastjson
- 第五课:创建多窗体程序