Java实现根据Word模板填充表格数据（poi方式），以及doc和docx转PDF，最全最详细版本，解决外部引用jar在linux上报ClassNotFound的问题。

适用场景：

1.固定格式的Word模板

2.Word模板中所有需要填充的数据都使用【Word表格】包起来

3.包含简单和复杂数据填充，场景表现为一对多关系的主表和明细列表数据等

4.此方式在Controller层返回为文件流，如果你使用ftp文件服务器，请修改你的代码。

5.此文是我搜集了网上的各种公开的实现方式修改并整合起来，并未用于商业化也不会用于商业化，不涉及侵权或抄袭问题。

现在由pom.xml开始

<dependency><groupId>org.apache.poi</groupId><artifactId>poi-ooxml</artifactId></dependency><dependency><groupId>org.apache.poi</groupId><artifactId>poi-scratchpad</artifactId><version>3.17</version></dependency><dependency><groupId>com.aspose</groupId><artifactId>aspose-words</artifactId><version>15.8.0</version></dependency><dependency><groupId>cn.afterturn</groupId><artifactId>easypoi-base</artifactId><version>4.1.0</version></dependency>

注意：第三个dependency在maven中不存在，百度网盘下载jar包：

链接：/s/13TQTxonrBlle94v3ge6UNg

提取码：xhv7

注意：这里使用15.8.0或15.12.0任意一个都可以

下载好后将jar包打在maven本地仓库中，有本地maven的使用cmd执行mvn命令，没有本地maven的在idea的maven框中点开“M”标记的按钮，输入命令：

mvn install:install-file -Dgroupld=com.aspose -Dartifactld=aspose-words -Dversion=15.8.0 -Dpackaging=jar -Dfile=C:\Users\Administrator.m2\repository\com\aspose\aspose-words\15.8.0\aspose-words-15.8.0-jdk16.jar

使用15.12.0的话则将jar包和命令都更换个版本，-Dfile是你项目中的maven使用的本地仓库默认路径，不一致则更换为你使用的本地仓库路径。

这里不使用将jar放入本地项目的方式是因为我之前使用的就是那种方式，在linux环境下一直找不到外部引用jar包，报ClassNotFound的错，即使在依赖包中存在该依赖，且打成的jar包也存在该依赖。

配置好后，接下来是使用的第一个Util

package mon.utils;import cn.afterturn.easypoi.word.WordExportUtil;import com.baomidou.mybatisplus.core.toolkit.Assert;import org.apache.poi.xwpf.usermodel.*;import org.openxmlformats.schemas.wordprocessingml.x.main.STMerge;import java.io.File;import java.io.FileOutputStream;import java.util.List;import java.util.Map;public class WordUtil {/*** 生成word** @param templatePath* @param temDir* @param fileName* @param params*/public static void exportWord(String templatePath, String temDir, String fileName, Map<String, Object> params) {Assert.notNull(templatePath, "模板路径不能为空");Assert.notNull(temDir, "临时文件路径不能为空");Assert.notNull(fileName, "导出文件名不能为空");Assert.isTrue(fileName.endsWith(".docx"), "word导出请使用docx格式");if (!temDir.endsWith("/")) {temDir = temDir + File.separator;}File dir = new File(temDir);if (!dir.exists()) {dir.mkdirs();}try {XWPFDocument doc = WordExportUtil.exportWord07(templatePath, params);String tmpPath = temDir + fileName;FileOutputStream fos = new FileOutputStream(tmpPath);doc.write(fos);fos.flush();fos.close();} catch (Exception e) {e.printStackTrace();}}/*** @param index（表格索引：第几个表格），dataMap（数据源）* @Method doTable* @Description 替换表格内容* @Return void* @Exception*/public static XWPFDocument doTable(int index, Map<String, Object> map, List<Map<String, Object>> dataMap, String templatePath) throws Exception {//读取模板文件XWPFDocument xwpfDocument = WordExportUtil.exportWord07(templatePath, map);//使用xwpfDocument对象操作word文档XWPFTable table = xwpfDocument.getTables().get(index);if (dataMap != null && dataMap.size() > 0) {List<XWPFTableRow> rows = table.getRows();int rowIndex = 0;//寻找字段绑定行索引String[] fields = null;字段绑定行字段顺序（a,b,c）for (XWPFTableRow row : rows) {List<XWPFTableCell> cells = row.getTableCells();for (XWPFTableCell cell : cells) {String key = cell.getText().replaceAll("\\{", "").replaceAll("}", "");if (dataMap.get(0).get(key) != null) {//找到匹配fields = new String[cells.size()];break;}}if (fields != null && fields.length > 0) {//找到,并获取字段for (int i = 0; i < fields.length; i++) {fields[i] = cells.get(i).getText().replaceAll("\\{", "").replaceAll("}", "");}break;} else {rowIndex++;}}if (rowIndex >= 0 && fields != null) {//从字段绑定行开始插入for (Map<String, Object> rowdata : dataMap) {XWPFTableRow row = null;try {row = rows.get(rowIndex);} catch (Exception e) {row = table.createRow();}if (row != null) {List<XWPFTableCell> cells = row.getTableCells();int cellIndex = 0;for (XWPFTableCell cell : cells) {if (cellIndex != 3) {cell.removeParagraph(0);XWPFParagraph newPara = cell.addParagraph();XWPFRun run = newPara.createRun();Object value = rowdata.get(fields[cellIndex]);if (value != null) {run.setText(value.toString());run.setFontFamily("微软雅黑");run.setFontSize(9);}}cellIndex++;}/* if (rowIndex == 6) {cells.get(3).setText("联系方式：☑");}if (rowIndex == 9) {cells.get(3).setText("控单类型：");}if (rowIndex == 13) {cells.get(3).setText("备注（请务必在此注明该柜的基本情况）：");}*/}rowIndex++;}}}return xwpfDocument;}/*** word跨列合并单元格** @param table* @param row* @param fromCell* @param toCell*/public void mergeCellsHorizontal(XWPFTable table, int row, int fromCell, int toCell) {for (int cellIndex = fromCell; cellIndex <= toCell; cellIndex++) {XWPFTableCell cell = table.getRow(row).getCell(cellIndex);if (cellIndex == fromCell) {// The first merged cell is set with RESTART merge valuecell.getCTTc().addNewTcPr().addNewHMerge().setVal(STMerge.RESTART);} else {// Cells which join (merge) the first one, are set with CONTINUEcell.getCTTc().addNewTcPr().addNewHMerge().setVal(STMerge.CONTINUE);}}}/*** word跨行并单元格*/public void mergeCellsVertically(XWPFTable table, int col, int fromRow, int toRow) {for (int rowIndex = fromRow; rowIndex <= toRow; rowIndex++) {XWPFTableCell cell = table.getRow(rowIndex).getCell(col);if (rowIndex == fromRow) {// The first merged cell is set with RESTART merge valuecell.getCTTc().addNewTcPr().addNewVMerge().setVal(STMerge.RESTART);} else {// Cells which join (merge) the first one, are set with CONTINUEcell.getCTTc().addNewTcPr().addNewVMerge().setVal(STMerge.CONTINUE);}}}}

第二个Util

import com.aspose.words.Document;import com.aspose.words.License;import com.aspose.words.SaveFormat;import org.apache.poi.xwpf.usermodel.XWPFDocument;import org.slf4j.Logger;import org.slf4j.LoggerFactory;import org.yaml.snakeyaml.Yaml;import java.io.*;import java.util.Map;public class Word2PDFUtil {private static boolean license = false;private static String temDir;private static final Logger logger = LoggerFactory.getLogger(Word2PDFUtil.class);//初始化static {Yaml yaml = new Yaml();//文件路径是相对类目录(src/main/java)的相对路径InputStream in = Word2PDFUtil.class.getClassLoader().getResourceAsStream("application.yml");Map<String, Object> map = yaml.loadAs(in, Map.class);temDir = ((Map<String, Object>) map.get("file")).get("temDir").toString();try {// license.xml放在src/main/resources文件夹下InputStream is = Word2PDFUtil.class.getClassLoader().getResourceAsStream("license.xml");License aposeLic = new License();aposeLic.setLicense(is);license = true;} catch (Exception e) {license = false;logger.error("License验证失败...");e.printStackTrace();}}public static InputStream wordToPdf(String fileName, XWPFDocument xwpfDocument) throws Exception {FileOutputStream os = null;InputStream pdfIs = null;File file = null;try {if (!temDir.endsWith("/")) {temDir = temDir + File.separator;}File dir = new File(temDir);if (!dir.exists()) {dir.mkdirs();}String tmpPath = temDir + fileName;//生成根据模板插入数据后的docx文件FileOutputStream fos = new FileOutputStream(tmpPath + ".docx");xwpfDocument.write(fos);fos.flush();fos.close();//生成一个空的PDF文件file = new File(tmpPath + ".pdf");os = new FileOutputStream(file);//要转换的word文件Document doc = new Document(tmpPath + ".docx");doc.save(os, SaveFormat.PDF);//要返回的pdf文件流pdfIs = new FileInputStream(tmpPath + ".pdf");} finally {if (os != null) {try {os.close();} catch (IOException e) {e.printStackTrace();}}//删除临时文件if (file.exists()) {file.delete();}}return pdfIs;}}

以上，如果包找不到，请去掉部分你没有用到的包。

Service

import cn.afterturn.easypoi.excel.ExcelExportUtil;import cn.afterturn.easypoi.excel.entity.TemplateExportParams;import cn.afterturn.easypoi.word.WordExportUtil;import mon.utils.*;import mon.utils.base.ErrorMessageException;import mon.utils.poi.PoiExcelUtils;import com.ruoyi.ladingBill.dto.GlLadingBillOutDTO;import com.ruoyi.marineSpecial.dto.GlMarineSpecialOutDTO;import com.ruoyi.marineSpecial.service.GlMarineSpecialService;import com.ruoyi.pay.dao.GlBusinessPayDao;import com.ruoyi.pay.dto.GLBusinessPayForExport;import com.ruoyi.pushMoney.dao.GlPushMoneyDao;import com.ruoyi.receipt.dao.GlBusinessReceiptDao;import com.ruoyi.receipt.dto.GLBusinessReceiptForExport;import com.ruoyi.storage.dto.GlInventoryDetailOutDTO;import com.ruoyi.storage.dto.GlInventoryOutDTO;import com.ruoyi.storage.dto.GlOutStorageDTO;import com.ruoyi.storage.entity.GlInventoryDetail;import com.ruoyi.storage.entity.GlOutStorageDetail;import com.ruoyi.storage.service.GlInventoryService;import com.ruoyi.towing.dto.GlTowingOutDTO;import com.ruoyi.utils.Word2PDFUtil;import org.apache.poi.ss.usermodel.*;import org.apache.poi.ss.util.CellRangeAddress;import org.apache.poi.ss.util.CellUtil;import org.apache.poi.ss.util.RegionUtil;import org.apache.poi.xssf.usermodel.*;import org.apache.poi.xwpf.usermodel.XWPFDocument;import org.springframework.stereotype.Service;import org.springframework.transaction.annotation.Transactional;import javax.annotation.Resource;import javax.servlet.http.HttpServletResponse;import java.io.File;import java.io.InputStream;import java.text.DecimalFormat;import java.util.*;@Servicepublic class WordService {@Resourceprivate GlMarineSpecialService glMarineSpecialService;@Resourceprivate GlBusinessReceiptDao glBusinessReceiptDao;@Resourceprivate GlBusinessPayDao glBusinessPayDao;@Resourceprivate GlPushMoneyDao glPushMoneyDao;@Resourceprivate GlInventoryService glInventoryService;//标题，一共16个String[] cloName = {"品名", "件数", "装箱数", "总数量", "单位", "价格", "金额", "总金额", "长", "宽", "高", "体积", "总体积", "材质", "条形码", "店面"};/*** 费用确认跟踪单导出** @param id* @return* @throws Exception*/public XWPFDocument costConfirmation(Long id) throws Exception {Map<String, Object> map = new HashMap<>();GlMarineSpecialOutDTO dto = glMarineSpecialService.detail(id);if (dto == null) {throw new ErrorMessageException("找不到该id对应的海运单");}GlLadingBillOutDTO glLadingBillOutDTO = dto.getGlLadingBillOutDTO();if (glLadingBillOutDTO == null) {throw new ErrorMessageException("找不到该id对应的托单明细");}GlTowingOutDTO glTowingOutDTO = dto.getGlTowingOutDTO();map.put("now", DateUtils.getDate());map.put("no", dto.getNo());map.put("businessNature", dto.getBusinessNatureName());map.put("salerName", dto.getSalerName());map.put("originPort", glLadingBillOutDTO.getOriginPort());map.put("expectSailingStartDate", dto.getExpectSailingStartDate());map.put("mblNo", dto.getMblNo());map.put("destination", glLadingBillOutDTO.getDestination());map.put("bookAgent", dto.getBookAgent() == null ? " " : dto.getBookAgent());map.put("ship", dto.getShipName() + (StringUtils.isEmpty(dto.getVoyageNumber()) ? " " : " V." + dto.getVoyageNumber()));map.put("caseNum", glLadingBillOutDTO.getCaseNum());map.put("sealNum", glLadingBillOutDTO.getSealNum());map.put("boxType", glLadingBillOutDTO.getBoxTypeName());map.put("contactTel", dto.getContactTel());map.put("operationRemark", glLadingBillOutDTO.getOperationRemark() == null ? " " : glLadingBillOutDTO.getOperationRemark());map.put("operator", dto.getOperatorName());map.put("clerk", dto.getDocumentClerkName());map.put("business", dto.getBusinessPersonName());if (glTowingOutDTO != null) {map.put("shipmentDate", glTowingOutDTO.getShipmentDate());map.put("destinationAddress", glTowingOutDTO.getDestinationAddress());map.put("towingCompany", glTowingOutDTO.getCompany());} else {map.put("shipmentDate", " ");map.put("destinationAddress", " ");map.put("towingCompany", " ");}List<Map<String, Object>> mapList = mapList(map, id, dto.getCustomerName());XWPFDocument xwpfDocument = WordUtil.doTable(1, map, mapList, "templates/费用确认跟踪单.docx");return xwpfDocument;}/*** 费用确认跟踪单，收款、付款、提成明细数据填充** @param map* @param id* @param customerName* @return*/private List<Map<String, Object>> mapList(Map<String, Object> map, Long id, String customerName) {map.put("customerName", customerName);map.put("providerAccountName", customerName);double receiptRMBSum = 0.0;double receiptUSDSum = 0.0;double receiptEURSum = 0.0;double payRMBSum = 0.0;double payUSDSum = 0.0;double payEURSum = 0.0;List<GLBusinessReceiptForExport> receiptDTOList = glBusinessReceiptDao.exportReceipt(id);//收款List<GLBusinessPayForExport> payDTOList = glBusinessPayDao.exportPay(id);//付款List<GLBusinessPayForExport> pushMoneyList = glPushMoneyDao.exportPushMoney(id);//提成int maxSize = 0;if (receiptDTOList.size() > payDTOList.size()) {maxSize = receiptDTOList.size();} else {maxSize = payDTOList.size();}maxSize += pushMoneyList.size();List<Map<String, Object>> mapList = new ArrayList<>();for (int i = 0; i < maxSize; i++) {Map<String, Object> map1 = new HashMap<>();if (i < receiptDTOList.size()) {//收款GLBusinessReceiptForExport receipt = receiptDTOList.get(i);map1.put("reName", receipt.getReceiptName());map1.put("reMoney", receipt.getReceiptMoney());map1.put("re", customerName.length() <= 8 ? customerName : customerName.substring(0, 8));if (receipt.getCurrency().equals("269")) {receiptRMBSum += receipt.getReceiptMoney();} else if (receipt.getCurrency().equals("270")) {receiptUSDSum += receipt.getReceiptMoney();} else if (receipt.getCurrency().equals("271")) {receiptEURSum += receipt.getReceiptMoney();}}if (i < payDTOList.size()) {//付款GLBusinessPayForExport pay = payDTOList.get(i);map1.put("payName", pay.getPayName());map1.put("payMoney", pay.getPayMoney());map1.put("pay", pay.getPay());if (pay.getCurrency().equals("269")) {payRMBSum += pay.getPayMoney();} else if (pay.getCurrency().equals("270")) {payUSDSum += pay.getPayMoney();} else if (pay.getCurrency().equals("271")) {payEURSum += pay.getPayMoney();}} else {//提成if (i - payDTOList.size() < pushMoneyList.size()) {GLBusinessPayForExport pushMoney = pushMoneyList.get(i - payDTOList.size());map1.put("payName", pushMoney.getPayName());map1.put("payMoney", pushMoney.getPayMoney());map1.put("pay", pushMoney.getPay());payRMBSum += pushMoney.getPayMoney();}}mapList.add(map1);}map.put("receiptRMBSum", receiptRMBSum);map.put("receiptUSDSum", receiptUSDSum);map.put("receiptEURSum", receiptEURSum);map.put("payRMBSum", payRMBSum);map.put("payUSDSum", payUSDSum);map.put("payEURSum", payEURSum);double RMDResult = receiptRMBSum - payRMBSum;double USDResult = receiptUSDSum - payUSDSum;double EURResult = receiptEURSum - payEURSum;double endResult = RMDResult + USDResult * 6.351 + EURResult * 7.0121;map.put("RMDResult", RMDResult);map.put("USDResult", USDResult);map.put("EURResult", EURResult);DecimalFormat df = new DecimalFormat(".##");String endResultFormat = df.format(endResult);map.put("EndResult", endResultFormat);return mapList;}public InputStream costConfirmationPDF(Long id, String fileName) throws Exception {XWPFDocument xwpfDocument = costConfirmation(id);InputStream is = Word2PDFUtil.wordToPdf(fileName + UUID.randomUUID(), xwpfDocument);return is;}}

以上，请删除无用代码、导包和逻辑。

Controller

import mon.core.controller.BaseController;import mon.core.domain.Result;import mon.utils.StringUtils;import com.ruoyi.utils.Word2PDFUtil;import com.ruoyi.file.service.WordService;import com.ruoyi.storage.dto.GlOutStorageDTO;import io.swagger.annotations.Api;import io.swagger.annotations.ApiOperation;import org.apache.poi.hssf.usermodel.HSSFWorkbook;import org.apache.poi.ss.usermodel.Workbook;import org.apache.poi.xssf.usermodel.XSSFWorkbook;import org.apache.poi.xwpf.usermodel.XWPFDocument;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.security.access.prepost.PreAuthorize;import org.springframework.stereotype.Controller;import org.springframework.web.bind.annotation.*;import org.springframework.web.multipart.MultipartFile;import org.yaml.snakeyaml.Yaml;import javax.servlet.http.HttpServletResponse;import java.io.*;import .URLDecoder;import .URLEncoder;import java.util.Date;import java.util.Map;/*** word、pdf、excel Controller** @author admin* @date -03-22*/@Controller@RequestMapping("/file/file")@Api("word、pdf、excel文件操作")public class OfficeController extends BaseController {@Autowiredprivate WordService wordService;private static String temDir;//初始化static {Yaml yaml = new Yaml();//文件路径是相对类目录(src/main/java)的相对路径InputStream in = Word2PDFUtil.class.getClassLoader().getResourceAsStream("application.yml");//或者app.yamlMap<String, Object> map = yaml.loadAs(in, Map.class);temDir = ((Map<String, Object>) map.get("file")).get("temDir").toString();}@ApiOperation(value = "费用确认跟踪单导出")@PreAuthorize("@ss.hasPermi('file:file:costConfirmation')")@GetMapping("/costConfirmation")public Result costConfirmation(HttpServletResponse response, @RequestParam("id") String id, @RequestParam("customerName") String customerName) {response.setCharacterEncoding("UTF-8");try {XWPFDocument xwpfDocument = wordService.costConfirmation(Long.valueOf(id));String fileNameEncode = URLEncoder.encode("费用确认跟踪单-" + customerName, "UTF-8");String fileName = URLDecoder.decode(fileNameEncode, "UTF-8");response.setContentType("application/msword");response.setHeader("Content-disposition", "attachment;filename=" + fileName + ".docx");xwpfDocument.write(response.getOutputStream());return Result.success();} catch (Exception e) {return Result.error(e.getMessage());}}@ApiOperation(value = "费用确认跟踪单导出PDF")@PreAuthorize("@ss.hasPermi('file:file:costConfirmationPDF')")@GetMapping("/costConfirmationPDF")public Result costConfirmationPDF(HttpServletResponse response, @RequestParam("id") String id, @RequestParam("customerName") String customerName) {InputStream is = null;response.setCharacterEncoding("UTF-8");try {String fileNameEncode = URLEncoder.encode("费用确认跟踪单-" + customerName, "UTF-8");String fileName = URLDecoder.decode(fileNameEncode, "UTF-8");is = wordService.costConfirmationPDF(Long.valueOf(id), "费用确认跟踪单-" + customerName);response.setContentType("application/mspdf");response.setHeader("Content-disposition", "attachment;filename=" + fileName + ".pdf");OutputStream toClient = new BufferedOutputStream(response.getOutputStream());byte[] buffer = new byte[is.available()];is.read(buffer);toClient.write(buffer);return Result.success();} catch (Exception e) {return Result.error(e.getMessage());} finally {if (is != null) {try {is.close();} catch (IOException e) {e.printStackTrace();}}}}}

测试方式

以上，在PDF导出保存时，后缀丢了，重命名加上.pdf后缀就好，即时记录该文来不及解决，在Headers中可以看到文件名称。

调试时在D盘下查看生成的.docx和.pdf文件

生成的临时文件会在Word2PDFUtil.java中删除，如不需删除请找到//删除临时文件 并注释。

此时发布至linux，生成后的pdf会乱码。待解决，解决后更新至该文档。

Java实现根据Word模板填充表格数据（poi方式） 以及doc和docx转PDF 最全最详细版本 解决外部引用jar在linux上报ClassNotFound的问题。