wps怎么导出简介,07，SpringMVC项目导出wps表格文件
（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