POI复制excel表格问题
使用poi复制本地excel,在导入数据时遇到某个单元格是null,这个null单元格,前面和后面的单元格都不为null,
//复制并创建excel
String path="E:/person/program/MyTest/admin/src/main/resources/static/file/sss.xls";
File file = new File(path);
POIFSFileSystem fs = new POIFSFileSystem(new FileInputStream(file));
HSSFWorkbook wb = new HSSFWorkbook(fs);
// 获得第一个sheet(页)
Sheet sheet = wb.getSheetAt(0);
//给单元格赋值
BigDecimal allMoney=BigDecimal.ZERO;
for (int i=1;i<list.size();i++){
allMoney = allMoney.add(new BigDecimal(list.get(i).get("name10").toString().replace(",","")));
}
sheet.getRow(1).getCell(1).setCellValue(allMoney.toString()