今天遇到一个有趣的问题,不报任何异常, 程序跑完了,居然没往excel里写数据
后来 将SXSSFWorkbook改为XSSFWorkbook才成功!!!
public static Boolean addExcel(String absolutePath, String sheetName, List dataList) throws IOException {
XSSFWorkbook wb = null;
FileOutputStream out = null;
FileInputStream fileInputStream = null;
try{
int columnsNum = dataList.get(0).length;
fileInputStream = new FileInputStream(absolutePath);
wb = new XSSFWorkbook();
wb = (XSSFWorkbook) WorkbookFactory.create(fileInputStream);
Sheet sheet =wb.getSheet(sheetName);
out = new FileOutputStream(absolutePath);
Row row;
int lastRowNum = sheet.getLastRowNum();
for (int i = 0; i < dataList.size(); i++) {
//row = sheet.createRow(++lastRowNum);
row = sheet.getRow(++lastRowNum);
if (row == null) {
row = sheet.createRow(lastRowNum);
}
String[] addOneRowData = dataList.get(i);
for (int j = 0; j < addOneRowData.length; j++) {
String str = addOneRowData[j];
row.createCell(j).setCellValue(str);
}
}
out.flush();
wb.write(out);
}catch (Exception e) {
e.printStackTrace();
} finally {
if (fileInputStream != null) {
fileInputStream.close();
}
if (wb != null) {
//wb.dispose();// 删除临时文件,很重要,否则磁盘可能会被写满
}
try {
if(out != null) {
out.close();
}
} catch (IOException e) {
e.printStackTrace();
}
try {
if(wb != null) {
wb.close();
}
} catch (IOException e) {
e.printStackTrace();
}
}
return true;
}
那他们的区别
HSSFworkbook,XSSFworkbook,SXSSFworkbook区别总结_千百元的博客-CSDN博客用JavaPOI导出Excel时,我们需要考虑到Excel版本及数据量的问题。针对不同的Excel版本,要采用不同的工具类,如果使用错了,会出现错误信息。JavaPOI导出Excel有三种形式,他们分别是1.HSSFWorkbook 2.XSSFWorkbook3.SXSSFWorkbook。HSSFWorkbook:是操作Excel2003以前(包括2003)的版本,扩展名是.xls;XSSFWorkbook:是操作Excel2007后的版本,扩展名是.xlsx;SXSSFWorkboo...https://blog.csdn.net/liuming690452074/article/details/125056360?csdn_share_tail=%7B%22type%22%3A%22blog%22%2C%22rType%22%3A%22article%22%2C%22rId%22%3A%22125056360%22%2C%22source%22%3A%22liuming690452074%22%7D&ctrtid=x8TUz



