页面点击按钮导出Excel表格

页面点击按钮导出Excel表格

以下代码仅供参考,大体流程是正确的,拿去直接使用,小细节需要修改
依赖项

<!-- https://mvnrepository.com/artifact/org.apache.poi/poi -->
<dependency>
    <groupId>org.apache.poi</groupId>
    <artifactId>poi</artifactId>
    <version>3.17</version>
</dependency>

Controller层代码

@RequestMapping(value = "/exportExcelAttachment")
public void exportExcelAttachment(HttpServletResponse response){
    //创建工作表
    HSSFWorkbook workbook = new HSSFWorkbook();
    //创建sheet
    HSSFSheet sheet = workbook.createSheet("附件");
    //创建sheet中的行
    HSSFRow row = sheet.createRow(0);
    //创建sheet中的列
    HSSFCell[] cells = new HSSFCell[4];
    for (int i = 0; i <cells.length ; i++) {
        cells[i] = row.createCell(i);
    }
    //设置表头信息
    cells[0].setCellValue("序号"