Springmvc文件下载_spring mvc 文件下载apk-优快云博客

本文链接：https://blog.youkuaiyun.com/u011108266/article/details/54586462

本文介绍了一个使用Java实现的简单Excel模板导出功能。通过示例代码展示了如何创建包含固定格式和样式的Excel文件，并允许用户下载。具体包括设置单元格格式、对齐方式及背景颜色等。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

工具类：
public class ExcelUtils {
public static WritableWorkbook createTemplate(OutputStream output) throws IOException, WriteException {
WritableWorkbook writableWorkbook= Workbook.createWorkbook(output);
WritableSheet wsheet = writableWorkbook.createSheet(“模板”, 0);

      CellFormat cf = writableWorkbook.getSheet(0).getCell(1, 0).getCellFormat();
      WritableCellFormat wc = new WritableCellFormat();
      // 设置居中
      wc.setAlignment(Alignment.CENTRE);
      // 设置边框线

// wc.setBorder(Border.ALL, BorderLineStyle.THIN);
wc.setBackground(jxl.format.Colour.GREEN);

      Label nc0 = new Label(0, 0, "姓名",wc);//Label(x,y,z)其中x代表单元格的第x+1列，第y+1行, 单元格的内容是z
      Label nc1 = new Label(1, 0, "性别",wc);
      Label nc2 = new Label(2, 0, "年龄",wc);
      Label nc3 = new Label(0, 1, "小红");
      Label nc4 = new Label(1, 1, "男");


      wsheet.addCell(nc0);
      wsheet.addCell(nc1);
      wsheet.addCell(nc2);
      wsheet.addCell(nc3);
      wsheet.addCell(nc4);

      return writableWorkbook;
    }

}
controller类：
@Controller
public class DownloadController {
@RequestMapping(“download”)
public void download(HttpServletRequest request, HttpServletResponse response)
throws IOException, BiffException, WriteException {
response.setHeader(“Content-Disposition”, “attachment; filename=template.xxls”);
WritableWorkbook writableWorkbook =
ExcelUtils.createTemplate(response.getOutputStream());
writableWorkbook.write();
writableWorkbook.close();
}
}