<!-- POI工具依赖-->
<dependency>
<groupId>e-iceblue</groupId>
<artifactId>spire.xls.free</artifactId>
<version>2.2.0</version>
</dependency>
import com.spire.xls.*;
//摸底登记表
public static String OrgUserExcel(String filePath, String orgName,String title) {
//从本地读取Excel文件
Workbook wb = new Workbook();
wb.loadFromFile(filePath + "组织成员资格摸底登记表.xlsx");
//声明Workbook变量
Workbook newWb = new Workbook();
newWb.setVersion(wb.getVersion());
Worksheet newSheet = newWb.getWorksheets().get("sheet1");
//复制
Worksheet orderSheet = wb.getWorksheets().get("sheet1");
newSheet.copyFrom(orderSheet);
String s = title.replaceAll("\\$zname", orgName);
newSheet.setValue(4,1,s);
String file = filePath+s+".xlsx";
String path = "/excel/"+s+".xlsx";
newWb.saveToFile(file, ExcelVersion.Version2016);
return path;
}
编辑方法参加帮助文档
https://www.e-iceblue.cn/spirexls_java_cells/add-borders-to-cells-in-excel-in-java.html