Excel 数字转列序号

最新推荐文章于 2023-01-19 21:42:09 发布

weixin_34130389

最新推荐文章于 2023-01-19 21:42:09 发布

阅读量323

点赞数

CC 4.0 BY-SA版权

原文链接：https://my.oschina.net/wjgood/blog/30122

/**
	 * 将数字转Excel列编号序列已测试1-
	 * 如 [index,1] = A
	 *    [index,26] = Z
	 *    [index,27] = AA 
	 * @param index
	 * @return
	 */
	private static String excelColumn(int index){
		int value = index;
		int A = 65;
		int Z = 90;
		int C = 26;
		char[] column;
		if(value > C){
			//余数
			int remainder = value % C;
			//倍数
			int b = value / C;
			
			if(remainder!=0){
				b ++;
			}
			column = new char[2];
			column[0] = (char) (b-2 + A);
			column[1] = (char) ((remainder != 0 ? remainder - 1 : C-1) + A);
		}else{
			return (char)(A + value-1)+"";
		}
		return new String(column);
	}

转载于:https://my.oschina.net/wjgood/blog/30122