@RequestMapping("/download")
public void exprotData(HttpServletResponse response) throws IOException {
String path="d:/export";
User user01 = new User(0,"小明",18);
User user02 = new User(1,"小华",22);
User user03 = new User(2,"小王",23);
List<User> userList = new ArrayList<>();
userList.add(user01);
userList.add(user02);
userList.add(user03);
//创建工作薄对象
HSSFWorkbook workbook=new HSSFWorkbook();
//创建工作表对象
HSSFSheet sheet = workbook.createSheet();
workbook.createCellStyle().setAlignment(XSSFCellStyle.ALIGN_RIGHT);
HSSFRow rowHead = sheet.createRow(0);
//设置第一行,从零开始
rowHead.createCell(0).setCellValue("id");
rowHead.createCell(1).setCellValue("姓名");
rowHead.createCell(2).setCellValue("年龄");
for (int i = 0; i < userList.size(); i++) {
HSSFRow row = sheet.createRow(i+1);
row.createCell(0).setCellValue(i);
row.createCell(1).setCellValue(userList.get(i).getName());
row.createCell(2).setCellValue(userList.get(i).getAge());
}
//文档输出
FileOutputStream output = new FileOutputStream(path + new SimpleDateFormat("yyyyMMddHHmmss").format(new Date()).toString() +".xls");
workbook.write(output);
output.close();
}
Java POI导出所选数据
最新推荐文章于 2023-11-28 15:50:47 发布