Question

java怎么从页面导出excel

Answer 1

分享一个写过的例子,网上应该找的到的
response.setHeader("Content-disposition",
"attachment;filename="+ URLEncoder.encode("表名", "utf-8")+".xls");
response.setContentType("application/msexcel;charset=GBK");
ServletOutputStream writer = response.getOutputStream();
ExcelUtil excel = new ExcelUtil(ExcelUtil.ExcelType.XLS, "表名" );

String[] excelHeadRow1 = new String[] {"序号","人员编号", "姓名", "1", "2","3","4","5","6","7","8","备注"};
int uiCount;
for(uiCount=0;uiCount<userInfoList.size();uiCount++){
UserInfo ui=userInfoList.get(uiCount);
excel.addCell(0, uiCount + 3, ""+(uiCount+1), cesHeader);//序号
excel.addCell(1, uiCount + 3, ui.getPersonNo(), cesHeader);//人员编号
excel.addCell(2, uiCount + 3, ui.getName(), cesHeader);//名字
excel.addCell(3, uiCount + 3, ui.getJobLevel(), cesHeader);//1
excel.addCell(4, uiCount + 3, money, cesHeader);// 2
excel.addCell(5, uiCount + 3, "1", cesHeader);//3
excel.addCell(6, uiCount + 3, money1, cesHeader);//4
excel.addCell(7, uiCount + 3, "1", cesHeader);//5
excel.addCell(8, uiCount + 3, "", cesHeader);//6
excel.addCell(9, uiCount + 3, "", cesHeader); //7
excel.addCell(10, uiCount + 3, String.valueOf(total), cesHeader);//8
excel.addCell(11, uiCount + 3, "", cesHeader); //备注
}