easyexcel 无模板写入_给位，问个问题，用easyExcel无模板导出数据时，怎么在指定单元格添加计算公式呢?...

该楼层疑似违规已被系统折叠 隐藏此楼查看此楼

easyExcel没用过，spire.xls.jar可以给指定单元格添加各种公式

import com.spire.xls.*;

public class InsertFormulas {

public static void main(String[] args) {

//创建Workbook对象

Workbook workbook = new Workbook();

//获取第一个工作表

Worksheet sheet = workbook.getWorksheets().get(0);

//声明两个变量

int currentRow = 1;

String currentFormula = null;

//设置列宽

sheet.setColumnWidth(1, 32);

sheet.setColumnWidth(2, 16);

//写入测试数据到单元格

sheet.getCellRange(currentRow,1).setValue("测试数据：");

sheet.getCellRange(currentRow,2).setNumberValue(1);

sheet.getCellRange(currentRow,3).setNumberValue(2);

sheet.getCellRange(currentRow,4).setNumberValue(3);

sheet.getCellRange(currentRow,5).setNumberValue(4);

sheet.getCellRange(currentRow,6).setNumberValue(5);

//写入文本

currentRow += 2;

sh