From ccf28d1fed1aa2e5437dbe64b5133ba1cbde6ec7 Mon Sep 17 00:00:00 2001
From: renkang <8417338+k94314517@user.noreply.gitee.com>
Date: 星期五, 03 一月 2025 15:30:52 +0800
Subject: [PATCH] Merge remote-tracking branch 'origin/master'
---
server/visits/dmvisit_admin/src/main/java/com/doumee/cloud/board/ExcelTestDemo.java | 71 +++++++++++++++++++++++++++++++++++
1 files changed, 71 insertions(+), 0 deletions(-)
diff --git a/server/visits/dmvisit_admin/src/main/java/com/doumee/cloud/board/ExcelTestDemo.java b/server/visits/dmvisit_admin/src/main/java/com/doumee/cloud/board/ExcelTestDemo.java
new file mode 100644
index 0000000..555a682
--- /dev/null
+++ b/server/visits/dmvisit_admin/src/main/java/com/doumee/cloud/board/ExcelTestDemo.java
@@ -0,0 +1,71 @@
+package com.doumee.cloud.board;
+
+import org.apache.poi.xwpf.usermodel.XWPFDocument;
+import org.apache.poi.xwpf.usermodel.XWPFParagraph;
+import org.apache.poi.xwpf.usermodel.XWPFRun;
+
+import java.io.FileInputStream;
+import java.io.FileOutputStream;
+import java.io.IOException;
+import java.io.InputStream;
+import java.net.HttpURLConnection;
+import java.net.URL;
+
+/**
+ * Created by IntelliJ IDEA.
+ *
+ * @Author : Rk
+ * @create 2025/1/3 9:11
+ */
+public class ExcelTestDemo {
+
+ public static void main(String[] args) {
+ modifyWordTemplate("https://bdreport.oss-cn-beijing.aliyuncs.com/xczl/20250103/temp/F0F4B90E185A4A9BA2147841B90F3909.docx", "d://output.docx", "寮犱笁", "Java璇剧▼");
+ }
+
+ public static void modifyWordTemplate(String templatePath, String outputPath, String name, String product) {
+ try (
+// FileInputStream fis = new FileInputStream(templatePath);
+ XWPFDocument document = new XWPFDocument(getFileInputStream(templatePath))) {
+ // 姝ゅ杩炴帴鍒板悗缁浛鎹㈡楠�
+ // 閬嶅巻娈佃惤
+ for (XWPFParagraph paragraph : document.getParagraphs()) {
+ for (XWPFRun run : paragraph.getRuns()) {
+ // 鏇挎崲鍗犱綅绗�
+ String text = run.getText(0);
+ if (text != null) {
+ text = text.replace("{{name}}", name)
+ .replace("{{text}}", product);
+ run.setText(text, 0); // 閲嶆柊璁剧疆鏂囨湰
+ }
+ }
+ }
+ try (FileOutputStream fos = new FileOutputStream(outputPath)) {
+ document.write(fos); // 灏嗕慨鏀瑰悗鐨勬枃妗ｅ啓鍏ヨ緭鍑烘祦
+ }
+ } catch (IOException e) {
+ e.printStackTrace();
+ }
+ }
+
+ /*璇诲彇缃戠粶鏂囦欢*/
+ public static InputStream getFileInputStream(String path) {
+ URL url = null;
+ try {
+ url = new URL(path);
+ HttpURLConnection conn = (HttpURLConnection)url.openConnection();
+ //璁剧疆瓒呮椂闂翠负3绉�
+ conn.setConnectTimeout(3*1000);
+ //闃叉灞忚斀绋嬪簭鎶撳彇鑰岃繑鍥�403閿欒
+ conn.setRequestProperty("User-Agent", "Mozilla/4.0 (compatible; MSIE 5.0; Windows NT; DigExt)");
+ //寰楀埌杈撳叆娴�
+ return conn.getInputStream();
+ } catch (Exception e) {
+
+ }
+ return null;
+ }
+
+
+
+}
--
Gitblit v1.9.3