让查个数据库汇总个信息导出到excel,于是准备使用老早以前了解过的poi来完成这个需求,先本地写个小demo,结果启动之后竟然各种报错。。。**了狗了。
工具类代码如下:
package com.unicom.importExcel;
import org.apache.poi.ss.usermodel.*;
import org.apache.poi.xssf.streaming.SXSSFWorkbook;
import java.io.FileOutputStream;
import java.util.List;
public class ExcelUtils {
public static void ExportExcel(List list) {
SXSSFWorkbook wb = new SXSSFWorkbook(100);
Sheet sheet = wb.createSheet();
Row row = sheet.createRow(0);
//单元格样式
CellStyle cellStyle = wb.createCellStyle();
Font font = wb.createFont();
//设置字体大小
font.setFontHeightInPoints((short) 12);
//设置字体加粗
font.setBold(true);
//给字体设置样式
cellStyle.setFont(font);
String[] titles = {"用户名", "帐号", "所属部门", "性别", "电子邮箱"};
for (int i = 0; i < titles.length; i++) {
Cell cell2 = row.createCell(i);
//加载单元格样式
cell2.setCellStyle(cellStyle);
cell2.setCellValue(titles[i]);
}
//test
if (list != null) {
for (int j = 0; j < list.size(); j++) {
Row rowData = sheet.createRow(j + 2);
Cell cell11 = row.createCell(0);
//cell11.setCellValue(userList.get(j).getName());
cell11.setCellValue("id");
Cell cell12 = row.createCell(1);
cell12.setCellValue("name");
}
}
String fileName = "D:/test/b.xlsx";
try {
FileOutputStream out = new FileOutputStream(fileName);
wb.write(out);
wb.close();
} catch (Exception e) {
e.printStackTrace();
}
}
}
报了各种classnotfound 错误。。。我只想问为啥poi jar里没把这些依赖的jar包汇总到一起啊,先后分别下了 (百度即可下载),所以强烈推荐maven项目,加了依赖之后自动解决!!!
commons-collections4-4.4-bin.zip
commons-compress-1.21-bin.zip
xmlbeans-bin-5.0.1-20210710.zip
全部导入之后终于可以实现了demo 的功能。。。