将数据赋值到Word并下载
<!-- poi-tl导出word文档--><dependency><groupId>com.deepoove</groupId><artifactId>poi-tl</artifactId><version>1.12.1</version></dependency>需要的实体类
package com.dream.domain.vo;import lombok.Data;import java.io.Serializable;
import java.util.ArrayList;
import java.util.List;@Data
public class QuestionVo implements Serializable {private String quesTitle;private int type;private String numb;private ArrayList<AnwserVo> anwser;
}
package com.dream.domain.vo;import lombok.Data;import java.io.Serializable;@Data
public class AnwserVo implements Serializable {private String content;private int type;private int supplementType;private String supplement;
}
以下是实现逻辑
package com.dream.controller.file;import com.deepoove.poi.XWPFTemplate;
import com.dream.common.BussinessException;
import com.dream.common.Result;
import com.dream.domain.vo.AnwserVo;
import com.dream.domain.vo.PageVo;
import com.dream.domain.vo.QuestionVo;
import com.dream.domain.vo.Student;
import com.dream.service.admin.QuestionnaireAdminService;
import com.dream.service.admin.UserMangeAdminService;
import com.dream.utils.Utils;
import com.fasterxml.jackson.core.JsonProcessingException;
import com.fasterxml.jackson.core.type.TypeReference;
import com.fasterxml.jackson.databind.ObjectMapper;
import freemarker.template.Configuration;
import freemarker.template.Template;
import org.apache.commons.io.FilenameUtils;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.xssf.streaming.SXSSFSheet;
import org.apache.poi.xssf.streaming.SXSSFWorkbook;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;
import org.springframework.web.multipart.MultipartFile;import javax.servlet.http.HttpServletResponse;
import java.io.*;
import java.nio.charset.StandardCharsets;
import java.nio.file.Files;
import java.nio.file.Path;
import java.nio.file.Paths;
import java.util.*;import org.springframework.core.io.Resource;
import org.springframework.core.io.ResourceLoader;
import org.springframework.http.HttpHeaders;
import org.springframework.http.MediaType;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.io.OutputStream;
import java.net.URLEncoder;
import java.util.zip.ZipEntry;
import java.util.zip.ZipOutputStream;@RestController
@RequestMapping("file")
public class FileUploadController {private final ResourceLoader resourceLoader;@Autowiredprivate QuestionnaireAdminService questionnaireAdminService;// 通过构造函数注入ResourceLoaderpublic FileUploadController(ResourceLoader resourceLoader) {this.resourceLoader = resourceLoader;}/*** 导出单个word* @param id* @param response*/@GetMapping("/export")public void exportStudents(@RequestParam("id") Integer id,HttpServletResponse response) {try {// 1. 加载模板文件Resource resource = resourceLoader.getResource("classpath:templates/question.docx");// 2. 验证模板是否存在if (!resource.exists()) {throw new FileNotFoundException("模板文件未找到");}Map<String,ArrayList<QuestionVo>> map1 = questionnaireAdminService.queryUserQuestionnaireById(id);ArrayList<QuestionVo> list = (ArrayList<QuestionVo>) map1.get("subject");// 3. 准备数据（示例数据，实际应从数据库获取）Map<String, String> data = new HashMap<>();if(list.size() > 0){Map map = questionnaireAdminService.queryNameByQuestionnaireId(id);for (int i = 0; i <list.size(); i++) {QuestionVo questionVo = list.get(i);List<AnwserVo> anwser = questionVo.getAnwser();switch (questionVo.getNumb()){case "one":for (int j = 0; j <anwser.size(); j++) {AnwserVo anwserVo = anwser.get(j);if (anwserVo.getType() == 1){data.put("one_"+j,"√");}}break;case "two":for (int j = 0; j <anwser.size(); j++) {AnwserVo anwserVo = anwser.get(j);if (anwserVo.getType() == 1){data.put("two_"+j,"√");}if(anwserVo.getSupplementType() == 1){data.put("two_supplement",anwserVo.getSupplement());}}break;case "three":for (int j = 0; j <anwser.size(); j++) {AnwserVo anwserVo = anwser.get(j);if (anwserVo.getType() == 1){data.put("three_"+j,"√");}}break;case "four":for (int j = 0; j <anwser.size(); j++) {AnwserVo anwserVo = anwser.get(j);if (anwserVo.getType() == 1){data.put("four_"+j,"√");}if(anwserVo.getSupplementType() == 1){data.put("four_supplement",anwserVo.getSupplement());}}break;case "five":for (int j = 0; j <anwser.size(); j++) {AnwserVo anwserVo = anwser.get(j);if (anwserVo.getType() == 1){data.put("five_"+j,"√");}}break;case "six":for (int j = 0; j <anwser.size(); j++) {AnwserVo anwserVo = anwser.get(j);if (anwserVo.getType() == 1){data.put("six_"+j,"√");}if(anwserVo.getSupplementType() == 1){data.put("six_supplement",anwserVo.getSupplement());}}break;}}// 4. 生成文档try (XWPFTemplate template = XWPFTemplate.compile(resource.getInputStream()).render(data)) {String name = "未知";if (map != null && map.get("name") != null && !"".equals((String)map.get("name"))){Object nameA = map.get("name");name = (String) nameA;}// 5. 设置响应头String encodedFileName = URLEncoder.encode(name + "的问卷调查.docx",StandardCharsets.UTF_8.toString());response.setContentType(MediaType.APPLICATION_OCTET_STREAM_VALUE);response.setCharacterEncoding(StandardCharsets.UTF_8.toString());response.setHeader(HttpHeaders.CONTENT_DISPOSITION,"attachment; filename*=UTF-8''" + encodedFileName);// 6. 输出文件流template.writeAndClose(response.getOutputStream());}}} catch (IOException e) {throw new RuntimeException("文件导出失败: " + e.getMessage(), e);}}}
/*** 查询用户的问卷调查通过id sevice层* @return*/@Overridepublic Map<String, ArrayList<QuestionVo>> queryUserQuestionnaireById(Integer id) {try {Map<String, Object> map1 = questionnaireAdminMapper.queryUserQuestionnaireById(id);if (map1 == null || map1.get("content") == null) {return Collections.singletonMap("subject", new ArrayList<>());}ObjectMapper objectMapper = new ObjectMapper();String subject = (String) map1.get("content");// 使用 TypeReference 指定泛型类型Map<String, ArrayList<QuestionVo>> map2 = objectMapper.readValue(subject,new TypeReference<Map<String, ArrayList<QuestionVo>>>() {});return map2;} catch (JsonProcessingException e) {throw new BussinessException("问卷调查转化异常");}}
/*** 查询用户的问卷调查通过id mapper层* @return*/@Select("select content from module_user_questionnaire where id = #{id}")Map queryUserQuestionnaireById(@Param("id") Integer id);以下是生成的word模板
9、是否对中医药文化感兴趣?
A. 非常感兴趣 {{one_0}}
B.一般 {{one_1}}
C.不感兴趣 {{one_2}}10、想通过中医药元宇宙学习到什么知识?
A. 中医药基本理论 {{two_0}}
B.中医药临床知识 {{two_1}}
C.针灸推拿技术 {{two_2}}
D.食疗养生知识 {{two_3}}
E.其他，请填写! {{two_4}} {{two_supplement}}11、之前是否学习过中医药文化?
A.是 {{three_0}}
B.否 {{three_1}}12、每天入睡时间是_-点，睡眠时长为_-小时
A.21:00-23:00,7-8小时 {{four_0}}
B.23:00-1:00,6-7小时 {{four_1}}
C.1:00-3:00,5-6小时 {{four_2}}
E.其他，请填写: {{four_3}} {{four_supplement}}13、认为自己健康吗?
A. 非常健康 {{five_0}}
B.一般 {{five_1}}
C.不健康 {{five_2}}14、对健康的期许(可多选)
A. 身体健康，不生病 {{six_0}}
B.精神健康，心情愉快 {{six_1}}
C.饮食健康，胃口好、吃饭香 {{six_2}}
D.运动健康，体能充沛 {{six_3}}
E.其他，请填写: {{six_4}} {{six_supplement}}