将A, B, C , D ... Z, AA, AB...AZ, BA转换为对应的数字

最新推荐文章于 2020-07-24 20:32:10 发布

leo524891010

最新推荐文章于 2020-07-24 20:32:10 发布

阅读量4k

点赞数

文章标签： c excel output input header wap

本文链接：https://blog.csdn.net/algorithmengine/article/details/7779134

版权

/*
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;
}