java分批分量写入excel,java利用poi技术导入批量excel数据，并且分段存入数...-poi写入excel,poi向excel中写入数据...

作者：乔山办公网日期：2020-06-05 15:23:46

jxl，可以实现，开源的jar包很多，目前我使用的是jxl

SimpleDateFormat sdf=new SimpleDateFormat("yyyy-MM-dd");

e799bee5baa6e79fa5e98193e78988e69d83338String id =req.getParameter("id");

String fileName =req.getParameter("fileName");

File f = new File(req.getSession().getServletContext().getRealPath("/printTemplateExcel/"+fileName));

WritableWorkbook wwb=null;

WritableSheet wws=null;

FileOutputStream out =null;

Label label = null;

Workbook wb=null;

try {

FesOrders fesOrders =new FesOrders();

fesOrders.setId(Long.parseLong(id));

List fesOrdersList = fesOrderService.findList(fesOrders, (SysUser)req.getSession().getAttribute(SESSION_USER));

for(FesOrders a : fesOrdersList){

System.out.println(a.getId());

}

WritableFont headerFont =new WritableFont(WritableFont.createFont("新宋体"), 10, WritableFont.BOLD, false,UnderlineStyle.NO_UNDERLINE, Colour.BLACK);

WritableCellFormat dataFormat=new WritableCellFormat (headerFont);

dataFormat.setBorder(Border.ALL,BorderLineStyle.THIN,Colour.BLACK);//设置边框

WritableCellFormat wf = new WritableCellFormat(dataFormat);

wb = Workbook.getWorkbook(f);

out = new FileOutputStream(new File(req.getSession().getServletContext().getRealPath("/printExcel/"+fileName)));

wwb = Workbook.createWorkbook(out, wb);

wws = wwb.getSheet("出货单");

String date=sdf.format(new Date());

for(int i=0;i

for(int j=0;j

Cell cell = wws.getCell(j, i);

if(cell.getContents().trim().indexOf("${year}")>0){

label = (Label)cell;

label.setString(cell.getContents().replace("${year}