😊 @ 作者: 瓶盖子io
💖 @ 主页: 瓶盖子io-CSDN博客
@GetMapping("/downloadExcelFile")
public void downloadExcelFile(HttpServletResponse response) throws IOException{
//获取表中所有数据集合
List<Brand> list = brandService.list();
//创建工作薄对象
Workbook workbook= new HSSFWorkbook();
//创建表
Sheet sheet = workbook.createSheet("品牌表");
//创建第一行对象
Row firstRow = sheet.createRow(0);
String[] arr={"编号","品牌名称","企业名称","排序","状态","地区编号"};
//遍历数组,设置第一行表头
for (int i = 0; i < arr.length ; i++) {
firstRow.createCell(i).setCellValue(arr[i]);
}
//遍历list
for (int i = 1; i <=list.size(); i++) {
//获取list中的元素对象
Brand brand=list.get(i-1);
//创建行对象
Row row = sheet.createRow(i);
//将学生对象中的字段保存到对应的列中
row.createCell(0).setCellValue(brand.getBid());
row.createCell(1).setCellValue(brand.getBname());
row.createCell(2).setCellValue(brand.getCompany());
row.createCell(3).setCellValue(brand.getStort());
row.createCell(4).setCellValue(brand.getStatus());
row.createCell(5).setCellValue(brand.getAid());
}
//文件名称
String fileName=new String("品牌表.xls".getBytes(),"iso-8859-1");
//
response.setHeader("content-disposition","attachment;fileName="+fileName);
//通过工作薄对象write方法将对象返回
workbook.write(response.getOutputStream());
workbook.close();
}