@Autowired
private HttpServletResponse response;
private void export(List<User> userList) {
OutputStream stream = null;Workbook workbook = null;
try {
SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
String data = df.format(new Date());
String xlsName = "AddCredit-" + data + ".xls";
stream = response.getOutputStream();
response.setHeader("Content-disposition", "attachment; filename=" + xlsName);
workbook = new XSSFWorkbook();
constructExportWork(workbook, userList);
workbook.write(stream);
} catch (Exception e) {
e.printStackTrace();
} finally {
try {
workbook.close();
stream.flush();
stream.close();
} catch (IOException e) {
e.printStackTrace();
}
}
}
/**
* 导出构造数据(Y)
*
* @param workbook
* @param completeLists
*/
private void constructExportWork(Workbook workbook, List<User> userList) {
String[] listResultHead = { "用户名", "密码",“电话”, "状态" };
Sheet sheet = workbook.createSheet();
sheet.autoSizeColumn(1, true);
// 第一行:表头
Row row = sheet.createRow(0);
for (int i = 0; i < listResultHead.length; i++) {
Cell cell = row.createCell(i);
cell.setCellValue(listResultHead[i]);
}
for (int i = 0; i < userList.size(); i++) {
User user = userList.get(i);
// 创建数据行
Row dataRow = sheet.createRow(i + 1);
Cell cell = dataRow.createCell(0);
cell.setCellValue(user.getUserName());
cell = dataRow.createCell(1);
cell.setCellValue(user.getPassword());
cell = dataRow.createCell(2);
cell.setCellValue(user.getPhone());
cell = dataRow.createCell(3);
cell.setCellValue(user.getStatus());
}
}