【无标题】

（1），后台java代码响应xls表格文件到客户端

import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.*;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.OutputStream;
import java.net.URLEncoder;
/**
* @date: 2022/11/5 23:14
* @desc: 测试控制类
*/
@Controller
@RequestMapping(value = "/studentConter")
public class StudentController {
    @RequestMapping(value = "/exportExcelFile")
    public void exportExcelFile(HttpServletRequest request
            , HttpServletResponse response ) {
        response.setContentType("application/vnd.ms-excel");
        String fileName = "";
        OutputStream outputStream;
        try {
            fileName = URLEncoder.encode("导出文件名称1", "UTF-8");
            response.setHeader("content-disposition", "attachment;filename="+ fileName + ".xls");
            XSSFWorkbook xssfWorkbook = writeTextWorkbook();
            outputStream = response.getOutputStream();
            xssfWorkbook.write(outputStream);
            outputStream.flush();
            outputStream.close();
        } catch (Exception ex1) {
            ex1.printStackTrace();
        }
    }

    // 把内容写入表格文件中
    private XSSFWorkbook writeTextWorkbook() {
        XSSFWorkbook xssfWorkbook = new XSSFWorkbook();
        XSSFSheet xssfSheet = xssfWorkbook.createSheet();
        // 在工作薄第一行填充数据
        XSSFRow xssfRow = xssfSheet.createRow(0);
        XSSFCell xssfCellIdx0 = xssfRow.createCell(0);
        xssfCellIdx0.setCellValue("第一行第一个单元格内容");
        XSSFCell xssfCellIdx1 = xssfRow.createCell(1);
        xssfCellIdx1.setCellValue("第一行第二个单元格内容");
        return xssfWorkbook;
    }

}

（2），jar包依赖参考上一篇：06，SpringMVC项目导入wps表格文件

（3），测试请求地址

http://localhost:8085/bl_mave_wf_war_exploded/studentConter/exportExcelFile