From 8c9395d6a0e07ea64a7ed88a466c5befb83178e3 Mon Sep 17 00:00:00 2001
From: 阳洁 <2077506045@qq.com>
Date: 星期五, 28 七月 2023 18:42:59 +0800
Subject: [PATCH] 测评系统自动测试

---
 comm/write_data.py |   18 ++++++++++++++++++
 1 files changed, 18 insertions(+), 0 deletions(-)

diff --git a/comm/write_data.py b/comm/write_data.py
new file mode 100644
index 0000000..0d9d6f5
--- /dev/null
+++ b/comm/write_data.py
@@ -0,0 +1,18 @@
+from openpyxl import load_workbook, Workbook
+
+
+def write_excel(file_name, data):
+    # 鎵撳紑Excel鏂囦欢锛屽姞杞絯orkbook
+    flag = False
+    try:
+        workbook = load_workbook(filename=file_name)
+    except FileNotFoundError:
+        flag = True
+        workbook = Workbook()
+    # 鏍规嵁鍚嶇О鑾峰彇worksheet
+    worksheet = workbook.active
+
+    if flag:
+        worksheet.append(["璐﹀彿", "鍏呭�兼暟", "瀹為檯鍏呭�兼暟", "鍏呭�煎墠浣欓", "鍏呭�煎悗浣欓"])
+    worksheet.append(data)
+    workbook.save(filename=file_name)

--
Gitblit v1.9.1