思路:
1.获取报表数据
2.构造Excel
3.完成下载
步骤分析:
1.构造表格数据
2.创建爱你工作簿
3.创建sheet
4.创建行对象
5.创建单元格对象
6.填充数据,设置样式
7.下载
下载模板图:
代码实现:
controller层
@RequestMapping(value = "/export/{month}", method = RequestMethod.GET)
public void export(@PathVariable(name = "month") String month) throws Exception {
//1.构造数据
List<EmployeeReportResult> list =
userCompanyPersonalService.findByReport(companyId,month+"%");
//2.创建工作簿
XSSFWorkbook workbook = new XSSFWorkbook();
//3.构造sheet
String[] titles = {"编号", "姓名", "手机","最高学历", "国家地区", "护照号", "籍贯",
"生日", "属相","入职时间","离职类型","离职原因","离职时间"};
Sheet sheet = workbook.createSheet();
Row row