5 POI报表导出
5.1 需求分析
完成当月人事报表的导出:包含当月入职员工信息,离职员工信息
5.2 人事报表导出
5.2.1 步骤分析
构造Excel表格数据
创建工作簿
创建sheet
创建行对象...//3.构造sheet
String[] titles = {"编号", "姓名", "手机","最高学历", "国家地区", "护照号", "籍贯",
"生日", "属相","入职时间...","离职类型","离职原因","离职时间"};
Sheet sheet = workbook.createSheet();
Row row = sheet.createRow...());
//入职时间
cell = dataRow.createCell(9);
cell.setCellValue(report.getTimeOfEntry...());
//离职时间
cell = dataRow.createCell(12);
cell.setCellValue(report.getResignationTime