java读取excel模板并复制_java实现赋值Excel模板并写入后导出

();

for (int i = 0; i < 42; i++) {

map1.put("id" + i, i);

lst.add(map1);

}

for (int m = 0; m < lst.size(); m++) {

Mapmap = lst.get(m);

row = sheet.createRow((int) m + 3);

for (int i = 0; i < 42; i++) {

String value = map.get("id" + m) + "";

if (value.equals("null")) {

value = "0";

}

cell = row.createCell(i);

cell.setCellValue(value);

}

}

workbook.write(fos);

fos.flush();

fos.close();

// 下载

InputStream fis = new BufferedInputStream(new FileInputStream(

newFile));

HttpServletResponse response = ServletActionContext

.getResponse();

byte[] buffer = new byte[fis.available()