/**
* 导出离职记录
* @param request
* @param response
*/
public void outputLeave(HttpServletRequest request, HttpServletResponse response) {
try{
HSSFWorkbook workbook = new HSSFWorkbook();
HSSFSheet sheet = workbook.createSheet();
HSSFRow row = sheet.createRow((short)0);
//在索引0的位置创建单元格(左上端)
HSSFCell cell[] = new HSSFCell[10];
for (int i = 0; i < 10; i++) {
cell[i] = row.createCell(i);
}
cell[0].setCellValue("员工编号");
cell[1].setCellValue("姓名");
cell[2].setCellValue("部门");
cell[3].setCellValue("岗位");
cell[4].setCellValue("离职日期");
cell[5].setCellValue("审批人");
cell[6].setCellValue("离职种类");
cell[7].setCellValue("离职原因");
cell[8].setCellValue("备注");
cell[9].setCellValue("状态");
sheet.setColumnWidth(0, 10*256);
sheet.setColumnWidth(1, 10*256);
sheet.setColumnWidth(2, 15*256);
sheet.setColumnWidth(3, 15*256);
sheet.setColumnWidth(4, 18*256);
sheet.setColumnWidth(5, 15*256);
sheet.setColumnWidth(6, 18*256);
sheet.setColumnWidth(7, 18*256);
sheet.setColumnWidth(8, 12*256);
sheet.setColumnWidth(9, 8*256);
ConditionModel conditionModel =new ConditionModel();
JSONObject json = leaveQueryParamService.searchData(conditionModel,"leaveEmp");
JSONArray jsonArray1;
try {
jsonArray1 = (JSONArray) json.get("rows");
for (int i = 0; i < jsonArray1.length(); i++) {
JSONObject js1 = jsonArray1.getJSONObject(i);
js1.put("leaveReason",InitSystemCtrl.sysCodeData.get(js1.get("leaveType")+","+js1.get("leaveReason")));
js1.put("leaveType",InitSystemCtrl.sysCodeData.get("leaveType,"+js1.get("leaveType")));
js1.put("status",InitSystemCtrl.sysCodeData.get("leaveStatus,"+js1.get("status")));
HSSFRow dataRow = sheet.createRow(i + 1);
HSSFCell data[] = new HSSFCell[10];
for (int j = 0; j < 10; j++) {
data[j] = dataRow.createCell(j);
}
data[0].setCellValue(js1.get("empCode").toString());
data[1].setCellValue(js1.get("empName").toString());
data[2].setCellValue(js1.get("depName").toString());
data[3].setCellValue(js1.get("posiName").toString());
data[4].setCellValue(js1.get("leaveDate").toString());
data[5].setCellValue(js1.get("approver").toString());
data[6].setCellValue(js1.get("leaveType").toString());
data[7].setCellValue(js1.get("leaveReason").toString());
data[8].setCellValue(js1.get("note").toString());
data[9].setCellValue(js1.get("status").toString());
}
} catch (JSONException e) {
e.printStackTrace();
}
String fn=new String(("离职员工表"+".xls").getBytes("gb2312"),"ISO8859_1");//new String("mobile鏂囦欢".getBytes(),"GB2312");
response.reset();
response.setContentType("application/vnd.ms-excel");
response.setHeader("Content-disposition", "attachment; filename=\"" +fn + "\"");
OutputStream os = response.getOutputStream();
workbook.write(os);
os.close();
System.out.println("文件生成...");
}catch(Exception e) {
System.out.println("已运行 xlCreate() : " + e );
}
}
POI导出excel并弹出另存为窗口
最新推荐文章于 2021-02-12 09:07:11 发布