From df57cb713d705c9fa8b3b11db014eba89c630a90 Mon Sep 17 00:00:00 2001 From: xyc <jc_xiong@hotmail.com> Date: 星期三, 14 十月 2026 15:00:39 +0800 Subject: [PATCH] docs(交接): 记录Excel COM打不开部分生成件改用WPS KET.Application的坑与绕法 --- HANDOFF.md | 19 ++++++++++++++++++- 1 files changed, 18 insertions(+), 1 deletions(-) diff --git a/HANDOFF.md b/HANDOFF.md index 3e161a7..2a4a1fc 100644 --- a/HANDOFF.md +++ b/HANDOFF.md @@ -4,11 +4,28 @@ > **姣忓ぉ缁撴潫鏃�**锛氭妸褰撳ぉ杩涘睍銆佽俯杩囩殑鍧戙�佹柊闇�姹傘�佹湭瀹屾垚浜嬮」鏇存柊鍒版湰鏂囦欢锛岀劧鍚庡彲浠ユ斁蹇冨紑鏂板璇濄�� > **鍗忎綔绾﹀畾锛�2026-08-31锛�**锛氳銆屾彁浜ゃ��= 鏈湴 commit + 鎺ㄩ�佸埌杩滅 git锛坥rigin main锛孏itblit锛夛紝涓嶅啀鍙仛鏈湴 commit銆� +### 10-14锛�3锛夛細Excel COM 鎵撲笉寮�閮ㄥ垎鐢熸垚浠� 鈫� 鏀圭敤 WPS KET.Application锛堝潙涓庣粫娉曪級 + +- **鐜拌薄**锛氱敤 `New-Object -ComObject Excel.Application` 鑷姩鏍稿鐢熸垚浠舵椂锛宍Workbooks.Open` 鎶ャ�屼笉鑳藉彇寰楃被 Workbooks 鐨� Open 灞炴�с�嶃��**鍚屼竴娆¤剼鏈噷**棰勬祴浠躲�佹瘝鐗� `2026骞�9鏈堥亾璺繍杈撻噺姹囨�昏〃.xlsx`銆乣鐢熸垚_閬撹矾杩愯緭閲忔眹鎬昏〃_2026-07_楠岃瘉.xlsx` 閮芥墦寰楀紑锛涙墦涓嶅紑鐨勬槸 `鐢熸垚_閬撹矾杩愯緭閲忔眹鎬昏〃_2026-09 (12).xlsx` 涓� `杈撳嚭\鐢熸垚_閬撹矾杩愯緭閲忔眹鎬昏〃_2026-08_鍥涢〉鏁版嵁椹卞姩_2026-09-13.xlsx` 鈫� **鏄枃浠剁骇鐨勶紝涓嶆槸鐜绾�**銆� +- **宸叉帓闄わ紙鍧囧疄娴嬶紝涓嶆槸鍘熷洜锛�**锛氣憼 鏂囦欢琚� WPS/寰俊鍗犵敤鈥斺�旀寜瀛楄妭澶嶅埗鍒版湰鍦帮紙SHA256 涓�鑷达級鍚庡湪鐙珛 Excel 瀹炰緥閲�**浠嶇劧鎵撲笉寮�**锛涒憽 缃戠粶鏉ユ簮鏍囪鈥斺�斿壇鏈病鏈変换浣� Zone.Identifier 闄勫姞娴侊紱鈶� `calcPr fullCalcOnLoad="true"`鈥斺�旀妸瀹冨幓鎺夊悗浠嶅け璐ワ紱鈶� OPC 閮ㄤ欢缂哄け鈥斺�旀墦涓嶅紑鐨勬枃浠朵笌鑳芥墦寮�鐨勬枃浠�**閮ㄤ欢鍒楄〃瀹屽叏涓�鑷�**銆傛牴鍥犳湭瀹氫綅锛屼笉瑕佸啀鐩茬洰浜屽垎銆� +- **鍙敤缁曟硶**锛氣憼 **WPS 鐨� COM 缁勪欢 `KET.Application`**锛堟敞鎰� `ET.Application` 鏈敞鍐岋紝鎶� 0x80040154锛夎兘鎵撳紑杩欎簺鏂囦欢锛宍WorksheetFunction.Sum` / `UsedRange` / `Count` 鍧囨甯糕�斺�旀湰杞疄娴嬭鍒扮敓鎴愪欢 594 涓暟鍊兼牸銆丼UM=`658615.2874963345`锛涒憽 `openpyxl(data_only=True)` 璇荤紦瀛樺�煎鎵�鏈夋枃浠堕兘鍙敤锛涒憿 闇�瑕佸湪 Python 閲屽鐜� Excel 鐘舵�佹爮姹傚拰鏃讹紝鎸�**琛屽簭**鐢� double 绱姞鈥斺�斿湪 Excel 鑳芥墦寮�鐨勯偅浠戒笂瀹炴祴涓� COM SUM **瀹屽叏涓�鑷�**锛坄658615.287496335`锛夈�� +- **椤哄甫鐨勬樉绀哄潙**锛欵xcel 鏄剧ず鏈綅鏄�"鍥涜垗浜斿叆"锛孭ython/.NET 鐨� `F8` 鏄�"閾惰瀹惰垗鍏�"锛屽悓涓�涓暟鍙兘鏄剧ず宸渶鍚庝竴浣嶃�傛湰杞細棰勬祴浠� SUM=`658615.287496335` 鈫� 鏄剧ず `鈥�49634`锛涚敓鎴愪欢 SUM=`658615.2874963345` 鈫� 鏄剧ず `鈥�49633`锛�**搴曞眰鍙樊 4.66e-10**锛屽嵈琚樉绀烘垚"宸� 1e-8"銆� +- **杩涚▼鍗敓**锛歚Excel.Application` 浼氱湡鐨勬媺璧� `EXCEL.EXE`銆傛柊寤哄墠璁板綍 EXCEL/ET 鐨� PID锛岀敤瀹屽厛 `Quit()` 鍐� `ReleaseComObject`锛屽彧娓呯悊鑷繁鎷夎捣鐨� PID锛�**缁濅笉瑕佸"鎸備笂鍘�/澶嶇敤"鐨勫疄渚嬭皟 `Quit()`**鈥斺�擡xcel/WPS 閮戒細娉ㄥ唽鍒� ROT锛宍Quit` 鍙兘鎶婄敤鎴锋寮�鐫�鐨勭獥鍙ｅ叧鎺夈�� +- **蹇煡鏂囦欢鏄惁琚崰鐢�**锛歚[System.IO.File]::Open($p, [System.IO.FileMode]::Open, [System.IO.FileAccess]::ReadWrite, [System.IO.FileShare]::None)` 鎶� Access denied 鍗宠鍗犵敤锛涗絾琚崰鐢ㄤ笉鏄湰鍧戠殑鍘熷洜锛堝壇鏈悓鏍锋墦涓嶅紑锛夈�� +- **宸叉寜 AGENTS 搂0 鍚屾鍒伴《灞�** `C:\Users\jcxiong\.codex\AGENTS.md` 绗� 11 鑺傦紙璺ㄩ」鐩�氱敤锛夈�� +- **鏁版嵁杈圭晫**锛氭湰杞彧璇伙紱鏈慨鏀�/鏈繚瀛樹换浣曞師濮嬩笟鍔℃枃浠躲�俙_tmp\_cmp_1014\` 涓嬬暀浜嗗壇鏈� `gen12_copy.xlsx` 涓庡幓鎺� `fullCalcOnLoad` 鐨勫鐓т欢 `gen12_nocalc.xlsx`锛堜复鏃朵骇鐗╋紝鎸夌害瀹氫笉鍒犮�佷笉鍏ュ簱锛夈�� + +### 10-14锛�2锛夛細閲嶅惎鍚庣鍔犺浇鍚堝苟鍚庢柊浠ｇ爜骞舵牳楠岀敓鏁堛�愭棤浠ｇ爜鏀瑰姩銆� + +- **鍋氫簡浠�涔�**锛氭寜 10-14锛�1锛夌殑鎺ユ墜鎻愮ず锛屽彧鍋滃悗绔摼锛坄cmd 27476` 鈫� `maven java 3948` 鈫� `app java 28136`锛夛紝鍓嶇 8080 涓嶅姩锛涘啀鎵ц `start-dev.ps1`锛堣剼鏈娴嬪埌 8080 宸茬洃鍚� 鈫� 璺宠繃鍓嶇锛屽彧鎷夎捣鍚庣锛夈�傛柊鍚庣杩涚▼ **PID 21640**锛�08:35:08 鍚姩銆� +- **鏍搁獙鐢熸晥**锛歚target/classes` 浜� 08:34:45 閲嶆柊缂栬瘧锛宍ReportExportService`銆乣SummaryLayoutExpander`銆乣SummaryMissingDataCheck`銆乣SummaryWorkbookFiller`銆乣FreightReadinessCheck` 鍧囦负鏈缂栬瘧浜х墿锛涘瓧鑺傜爜鍚柊鏄犲皠 `/summaryWorkbook/missing`銆乣/summaryWorkbook/freightCheck` 涓庡弬鏁� `titlesOnly`锛沗backend.log` 涓ゆ潯灏辩华鏍囧織榻愬叏锛坄Tomcat started on port(s): 8090`銆乣Started TrafficAuditApplication in 8.691 seconds`锛夛紱`GET /api/version` 杩斿洖 HTTP 200銆� +- **鏈仛 / 杈圭晫**锛氭湰杞棤浠ｇ爜鏀瑰姩銆佹湭瀵煎叆鎴栬鐩栦换浣曚笟鍔℃暟鎹紱鍙鎺ュ彛 `summaryWorkbook/missing|freightCheck` 鐩存帴璇锋眰杩斿洖 401锛坄JwtAuthFilter` 瑕佹眰鐧诲綍锛夛紝鏈敤璐﹀彿鐧诲綍璋冪敤銆傚悓浜嬭繖鎵广�屾眹鎬诲ぇ琛ㄣ�嶆敼鍔紙澶氫负銆愬緟楠屾敹銆戯級浠嶉渶鐢ㄦ埛鍦ㄩ〉闈㈤噸鏂扮敓鎴� 2026-09 楠屾敹銆� + ### 10-14锛�1锛夛細閲嶅惎鍚庢媺璧峰墠鍚庣 + 鎷夊彇鍚堝苟鍚屼簨 34 涓彁浜わ紙姹囨�诲ぇ琛級銆愭棤浠ｇ爜鏀瑰姩銆� - **鏈疆锛堟湭鏀逛唬鐮侊級**锛氱數鑴戦噸鍚紝鐢� `start-dev.ps1` 鎷夎捣鍓嶅悗绔紝鑴氭湰杈撳嚭鍚庣 OK銆佸墠绔� OK锛涘墠绔� http://localhost:8080锛屽悗绔� 8090锛屾棩蹇楄 `backend.log` / `traffic-audit-web/frontend.log`銆� - **git**锛氭湰鍦板師涓� `a2dfe61`锛岃惤鍚� `origin/main` 34 涓彁浜わ紱宸� `git fetch origin` + `git merge --ff-only origin/main` 蹇繘鍒� `697891d`銆傝繖鎵规彁浜ゆ槸鍚屼簨"姹囨�诲ぇ琛�"绯诲垪锛歚ReportExportService`銆乣SummaryLayoutExpander`銆乣SummaryMissingDataCheck`銆乣FreightReadinessCheck`銆乣ReportExport.vue`锛屼互鍙婇厤濂楁瘝鐗�/瑙勬牸/楠岃瘉鏂规硶鏂囨。锛堝涓恒�愬緟楠屾敹銆戯級銆� -- **銆愭帴鎵嬫敞鎰徛烽渶閲嶅惎鍚庣銆�**锛氬綋鍓� 8090 鐨勫悗绔槸鍚堝苟鍓嶏紙08:23锛夊惎鍔ㄧ殑锛岃窇鐨勬槸鏃у瓧鑺傜爜锛涙湰鍦板伐浣滃尯宸叉槸鏈�鏂帮紝闇�鎸� `AGENTS.md` 閲嶅惎鍚庣鎵嶈兘鍔犺浇鍚屼簨鏈�鏂颁唬鐮侊紙鍓嶇 dev server 浼氳嚜琛� watch 閲嶇紪璇戯級銆傛湰杞湭閲嶅惎锛屼笅涓�姝ユ帴鎵嬫椂鍏堥噸鍚獙璇併�� +- **銆愭帴鎵嬫敞鎰徛峰凡澶勭悊銆�**锛氬綋鏃� 8090 鐨勫悗绔槸鍚堝苟鍓嶏紙08:23锛夊惎鍔ㄧ殑鏃у瓧鑺傜爜锛涘凡鐢变笅涓�鑺� 10-14锛�2锛夐噸鍚紙鏂拌繘绋� PID 21640锛�08:35:08 鍚姩锛夊姞杞藉悓浜嬫渶鏂颁唬鐮侊紝骞舵牳楠岀敓鏁堛�� - **鏁版嵁杈圭晫**锛氭湰杞湭鏀逛唬鐮併�佹湭璺戞祴璇曘�佹湭瀵煎叆/瑕嗙洊浠讳綍涓氬姟鏁版嵁銆� - **宸ヤ綔鍖�**锛氫粎淇濈暀绾﹀畾涓嶅叆搴撶殑涓存椂鐩綍/鏂囦欢锛坄_tmp_doc_compare/`銆乣_tmp_flow_table/`銆乣_tmp_holiday_verify/`銆乣_tmp_rail_label/`銆乣_tmp_pack_smoke_trend.docx`锛夊拰鐢ㄦ埛鏁版嵁 `docs/涓撻」缁熻/閲嶈鑺傚亣鏃�/瑙傛祴绔欏垎鏃ヨ皟鏌ユ暟鎹� (2026骞�10鏈�1鏃�).xls`锛屼笉瑕佸垹闄ゆ垨璇彁浜ゃ�� -- Gitblit v1.9.1