public class TestEasyExcel {
public static void main(String[] args) throws Exception {
String filepath = "D:/LDT/测试easyExcel.xlsx";
Sheet sheet = new Sheet(1, 0);
sheet.setSheetName("xxxx");
List<List<String>> header = new ArrayList<List<String>>();
header.add(Lists.newArrayList("编号"));
header.add(Lists.newArrayList("姓名"));
header.add(Lists.newArrayList("年龄"));
sheet.setHead(header);
List<List<Object>> data = new ArrayList<List<Object>>();
data.add(Lists.newArrayList("1001","张三",13));
data.add(Lists.newArrayList("1002","李四",23));
data.add(Lists.newArrayList("1003","王五",33));
OutputStream out = new FileOutputStream(new File(filepath));
ExcelWriter writer = EasyExcelFactory.getWriter(out, ExcelTypeEnum.XLSX, true);
System.out.println(writer);
writer.write1(data, sheet);
writer.finish();
}
}
报错信息:org.apache.poi.ss.usermodel.Font.setBold(Z)V
原因:maven版本和poi jar包有冲突,以下是maven版本,poi版本如果是3.8或者3.9会出现此异常信息。
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>easyexcel</artifactId>
<version>1.1.2-beta4</version>
</dependency>
解决办法:3.17及以上版本不会出现此异常。
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi</artifactId>
<version>4.1.1</version>
</dependency>
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi-ooxml</artifactId>
<version>4.1.1</version>
</dependency>