/*
WAP to return numbered index if input is excel sheet column header name.
e.g
excel sheet column headers are A, B, C , D ... Z, AA, AB...AZ, BA,, etc
if Input is D , output should be 4
and for AA output should be 27
*/
#include <cstdio>
#include <cstdlib>
#include <cstring>
int main()
{
char* str = "B";
char base = 'A' - 1;
int idx = strlen(str) - 1;
int num = 0;
int mulFactor = 1;
while(idx >= 0)
{
num += (str[idx] - base) * mulFactor;
mulFactor *= 26;
idx--;
}
printf("%s = %d", str, num);
return 0;
}
将A, B, C , D ... Z, AA, AB...AZ, BA转换为对应的数字
最新推荐文章于 2020-03-17 12:21:13 发布