小结：POI写Excel公式（函数）及从Excel中读取公式计算值

最新推荐文章于 2024-08-20 15:54:44 发布

rasarayuyu

最新推荐文章于 2024-08-20 15:54:44 发布

阅读量9.9k

点赞数 1

CC 4.0 BY-SA版权

分类专栏： Java poi 文章标签： poi Excel公式

本文链接：https://blog.youkuaiyun.com/rasarayuyu/article/details/42493795

Java poi 专栏收录该内容

1 篇文章

订阅专栏

本文介绍如何使用Java API在Excel中创建单元格并设置公式进行计算，同时还提供了将数字形式的列号转换为Excel标准列号（如1转为A, 27转为AA等）的方法。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

//写公式：

HSSFCEll newCell = row.createCell(newColIndex);

newCell.setCellFormula("A1+B1");

newCell.setCellType(Cell.CELL_TYPE_FORMULA);

读公式值：

HSSFFormuulaEvaluator eva = new HSSFFormuulaEvaluator(workbook);

double result = eva.evaluete(newCell).getNumberValue();

将1、2、3...列号转换为Excel列号（A/B/C...）

public static String toRadix(Integer num){
		String[] array = {"A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T","U","V","W","X","Y","Z"};
		int count = 26;
		String out = "";
		if(num/count != 0){
			out = array[num/count - 1];
			if(num%count == 0){
				out = out + array[num%count];
			}else{
				out = out + array[num%count - 1];
			}
		}else{
			out = array[num -1 ];
		}
		return out;
				
	}