Excel列名変換問題回答 JS版

ExcelColConv.js

#!/usr/bin/js

var mode = arguments[0];


if ( mode == 0 ) {

	var string = arguments[1];
	var number = 0;

	for (var i = 0, iMax = string.length; i < iMax; i ++) {

		var chr = string.slice(i, i + 1);
		var num = chr.charCodeAt(0) - 64;

		number += Math.pow(26, (iMax - i - 1)) * num; 

	}

	print(number);

} else if ( mode == 1) {

	var number = Number(arguments[1]);
	var string = [];

	while (number > 26) {
	
		if (number % 26) {	
			var n = number % 26;
			number = parseInt(number / 26);
		} else {
			var n = 26;
			number = parseInt(number / 26) - 1;
		}

		string.push(String.fromCharCode(n + 64));

	}

	if (number > 0) string.push(String.fromCharCode(number + 64));
	string.reverse();

	print(string.join(""));
}