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 | 11 +++++++++++ 1 files changed, 11 insertions(+), 0 deletions(-) diff --git a/HANDOFF.md b/HANDOFF.md index 9eba9ed..2a4a1fc 100644 --- a/HANDOFF.md +++ b/HANDOFF.md @@ -4,6 +4,17 @@ > **姣忓ぉ缁撴潫鏃�**锛氭妸褰撳ぉ杩涘睍銆佽俯杩囩殑鍧戙�佹柊闇�姹傘�佹湭瀹屾垚浜嬮」鏇存柊鍒版湰鏂囦欢锛岀劧鍚庡彲浠ユ斁蹇冨紑鏂板璇濄�� > **鍗忎綔绾﹀畾锛�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 鍚姩銆� -- Gitblit v1.9.1