From 324a5e115559d5432f04146b4e788d5bcb2237e0 Mon Sep 17 00:00:00 2001 From: Administrator <admin@example.com> Date: 星期一, 11 九月 2023 11:30:32 +0800 Subject: [PATCH] 数据编号重复处理 --- utils/data_export_util.py | 10 +++++++--- 1 files changed, 7 insertions(+), 3 deletions(-) diff --git a/utils/data_export_util.py b/utils/data_export_util.py index 2b17807..2804cec 100644 --- a/utils/data_export_util.py +++ b/utils/data_export_util.py @@ -2,6 +2,7 @@ 鏁版嵁瀵煎嚭宸ュ叿 """ import json +import logging import os import time @@ -147,8 +148,11 @@ num_operate_map[ code]) if buy_index == data["index"]: - ws.write(index, 8, "{}-{}".format(d["index"], d["val"]["time"]), cancel_style) - break + try: + ws.write(index, 8, "{}-{}".format(d["index"], d["val"]["time"]), cancel_style) + break + except Exception as e: + logging.exception(e) ws.write(index, 3, "{}涓�".format(round(int(data["val"]["num"]) * float(data["val"]["price"]) / 100, 2)), style) wb.save(file_name) @@ -206,4 +210,4 @@ if __name__ == "__main__": - export_l2_excel("002178") + export_l2_excel("002207") -- Gitblit v1.8.0