Excel Sheet Column Number
来源:互联网 发布:淘宝卖家关闭订单付款 编辑:程序博客网 时间:2024/05/17 06:46
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
#include<stdio.h>int titleToNumber(char *s) { int i,j; int res = 0; for(i = 0; s[i] != '\0'; i++){ j = s[i] - 'A' + 1; res = 26 * res + j; //printf("%d,%d\n", j, res); } return res;}void main(){ char *s = "CAB"; printf("%d\n", titleToNumber(s));}
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
- Lua 语言 15 分钟快速入门
- ***POJ2479 Maximum sum ACM解题报告(DP难题)
- mate拆机换屏教程
- log4j 2.1使用
- windows2003记录远程桌面连接登录日志的方法及注意事项
- Excel Sheet Column Number
- LuaJavaBridge - Lua 与 Java 互操作的简单解决方案
- pro-- 通讯录4--正向逆向数据传递总结
- Android不规则点击区域详解
- java实现数组逆序
- <iframe>标签自适应高度和宽度
- java之发送mail
- Oracle EXP/IMP参数详解
- 管理Activity的生命周期(3)暂停和重启一个Activity