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));
}