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