| | |
|---|
| | | - 2026-07 æ导åºä»¶ã è´§è¿ã页为 118x145ï¼æ¯ 8 æå° 2 åï¼ï¼å 7 ææ¯çæ¯ã1-4 æ骨æ¶ãã |
|---|
| | | |
|---|
| | | 详è§ãåè½æµè¯æ¥å/åè½æµè¯æ¥å_è´§è¿é¡µç¾ç´¯è®¡åä¿®å¤ä¸èææ¸
ç_2026-09-16.mdãã |
|---|
| | | |
|---|
| | | --- |
|---|
| | | |
|---|
| | | ## äºåä¸ã2026-07 æ¯çè¡¥é½ + 导åºä»¶ãExcel æä¸å¼ãæ ¹å ä¿®å¤ |
|---|
| | | |
|---|
| | | æ¥æï¼2026-09-16ï¼ç¬¬ 9 è½®ï¼æ¥äºåèï¼ |
|---|
| | | |
|---|
| | | ### 21.1 ä»å¤©åäºä»ä¹ |
|---|
| | | |
|---|
| | | | # | äºé¡¹ | ç»æ | |
|---|
| | | |---|---|---| |
|---|
| | | | 1 | æ¸
ç 2026-09 æ®çæ°æ®ï¼ç¨æ·ç¬¬ 1 æ¡ï¼ | **å®æ**ï¼h204_vehicle_quarterly 1284 / investment_monthly 31 / audit_result 2061 / audit_run 3 / import_batch 5 / h2032 636ï¼å
¨é¨å¤æ ¸ä¸º 0 æ®çï¼å·²çå¯è¿å SQL å¤ä»½ `_backup_2026-09_residual_all_20260916.sql` | |
|---|
| | | | 2 | ä¿® 2026-07 导åºä»¶ãExcel æä¸å¼ã | **å®æ**ï¼P0ï¼è§ 21.2ï¼ | |
|---|
| | | | 3 | è¡¥é½ 2026-07 æ¯çï¼ç¨æ·ç¬¬ 3 æ¡ãå¯ä»¥è¡¥é½ãï¼ | **å®æ**ï¼è§ 21.3ï¼ | |
|---|
| | | | 4 | ä¿®å¤ä»½æ¯çåå¡«æè¡¥é½ãæååå½¢ã | **å®æ**ï¼è§ 21.4ï¼ | |
|---|
| | | |
|---|
| | | ### 21.2 æ ¹å ï¼openpyxl æ¯ç + å¤ä»½åå¡« â æ®ç <is> éæ³æ ¼ |
|---|
| | | |
|---|
| | | - å件é 19 ä¸ªæ ¼åå½¢å¦ `<c r="E15" s="111" t="n"><v>67.0</v><is><t>67.00</t></is></c>`ï¼`t="n"` å´å¸¦ `<is>`ï¼æ¨¡å¼éæ³ï¼Excel ç´æ¥æå¼ï¼COM æ¥ãä¸è½åå¾ç±» Workbooks ç Open å±æ§ãï¼è¿ä¿®å¤æ¨¡å¼ `CorruptLoad=1` ä¹æä¸å¼ï¼ã |
|---|
| | | - 7 ææ¯çæ¯ **openpyxl ååº**ï¼ææ¬å `<is>`ï¼ï¼8 ææ¯çæ¯ **Excel åç**ï¼ææ¬èµ° sharedStringsï¼â å代ç ä¸åªæ 7 æåã |
|---|
| | | - 触åè
æ¯ `restoreSummaryMonthlyBlocks`ï¼7 ææ `_å¤ä»½_2026å¹´7æâ¦æ¸
çåâ¦xlsx`ï¼æ´æ ¼åå¡«æ¶å¾ inlineStr æ ¼éåå¼ï¼çä¸æ§ `<is>`ï¼8 æ没æ `_å¤ä»½_*`ï¼ä¸èµ°åå¡«ï¼æ以ä¸ç´æ¯å¥½çã |
|---|
| | | - å®ä½ææ³ï¼å¼å¾è®°ä½ï¼ï¼å件/好件**é¤ worksheets/styles/sharedStrings å¤å
¨é¨é¨ä»¶éåèç¸å** â zip æ交 + Excel éä¸å¼æ¡£ leave-one-out â éå® **sheet9ãå
¬äº¤ã17 æ ¼ + sheet12ã轨éã轮渡ã2 æ ¼**ã |
|---|
| | | |
|---|
| | | ### 21.3 ä¿®å¤ |
|---|
| | | |
|---|
| | | 1. `ReportExportService.exportSummaryWorkbook`ï¼è½çåæ°å¢ `normalizeStaleInlineStrings(wb)`ï¼æ¸
æææãé inlineStr å´æ®ç `<is>`ãçæ ¼åï¼å¹ç + warn æ¥å¿ï¼ã |
|---|
| | | 2. `ReportExportService.restoreSummaryMonthlyBlocks`ï¼æ°å¢ `skipFreightHistoryBlocks`ï¼ã è´§è¿ã页 **T åå以å**ï¼2025..2021 äºä¸ªå¹´åº¦å + å年累计åï¼æ°¸ä¸ä»å¤ä»½æ¯çåå¡« ââ ä¸æ¢æãä¸å£å¾æåå·¦åãä¿æ¤åä¸æè·¯ï¼é²ãçæåå¤æ´»ãã |
|---|
| | | |
|---|
| | | ### 21.4 7 ææ¯çè¡¥é½ï¼Excel COMï¼360 + 324 æ ¼ï¼ |
|---|
| | | |
|---|
| | | æ `_fix_mother.ps1`ï¼8 ææ¯çé£çï¼**æ´ä½å·¦ç§» 2 å**æ¹åï¼ |
|---|
| | | |
|---|
| | | - 年度åï¼2025 `T,V,X,Z,AB,AD,AF,AH,AJ,AL,AN,AP`ï¼2024 `AV..BR` éåï¼2023 `BW..CS` éåï¼2022 `DK..DV` è¿ç»ï¼2021 `EA..EL` è¿ç»ï¼æ¯åå `r7/r9/r8/r10 = SUM(17 å¸å·)`ã`r5=r7+r9`ã`r6=r8+r10` â **360 æ ¼**ï¼ |
|---|
| | | - 累计åï¼`DX=SUM(DK:DV)`ã`EM=SUM(EA:EL)`ã`DY=IFERROR(DX/SUM(EA:EL)-1,"")`ï¼è¡ 5..112 â **324 æ ¼**ï¼ |
|---|
| | | - `CalculateFullRebuild` åä¿åãæ¯ç 921,559 â 1,440,038 åèï¼è½¬ Excel åçï¼ã |
|---|
| | | |
|---|
| | | ### 21.5 æµè¯ç»ææè¦ |
|---|
| | | |
|---|
| | | | ç¨ä¾ | ç»æ | |
|---|
| | | |---|---| |
|---|
| | | | 2026-07 导åºï¼ä¿®å¤åï¼ | FAILï¼å¤ç°ï¼ | |
|---|
| | | | ç¯å¢/è·¯å¾æé¤ï¼å°ä»¶ã两æ¬æ¯çã09-08 æ§å¯¼åºãæ¹åå¤å¶ï¼ | å
¨é¨ OKï¼ç¡®è®¤éç¯å¢é®é¢ | |
|---|
| | | | ä¿®å¤å 2026-07 å¯¼åº | **OK sheets=19**ï¼`DX5=144979.2825`ã`DY5=-0.101235487797891`ã`EM5=161309.53162`ã`CU5=173045.296428512` | |
|---|
| | | | ä¿®å¤å 2026-08 å¯¼åº | **OK sheets=19**ï¼`DZ5=144979.2825`ã`EO5=161309.53162`ã`CW5=173045.296428512` | |
|---|
| | | | è·¨æä¸è´æ§ | 7 æä¸ 8 æç 2022/2021/2023 累计**å®å
¨ç¸ç** | |
|---|
| | | | éæ³æ ¼å¤æ« | 0 个 | |
|---|
| | | | 2026-09 æ®çå¤æ ¸ | 5 å¼ è¡¨å
¨ 0 | |
|---|
| | | |
|---|
| | | > 注ï¼8 ææ¯ç计ç®å `DZ5` ç±æ§çåæ»å¸¸é `144979.285376043` å为 `144979.2825`ï¼å·® 0.0029 ââ æ£æ¯ç¬¬åäºèè®°å½çãå
¨çè§ä¸å¸¸é â 17 å¸å·ä¹åãé£ç¬å·®é¢ï¼å±**ä¿®æ£**èéåéã |
|---|
| | | |
|---|
| | | ### 21.6 踩å |
|---|
| | | |
|---|
| | | 1. **Excel COM å¤å¿è¿ç¨ä¼è®© `Workbooks.Open` é´ææ§åæ¥åä¸ä¸ªé**ï¼æ¯ä¾æµå®å¿
须强ææ¬æ¬¡æ°å»ºç `EXCEL` è¿ç¨ãææ¥åæå°±å å¤å¿è¿ç¨è¯¯å¤ã8 æ件ä¹æä¸å¼ãï¼æµªè´¹äºä¸è½®ã |
|---|
| | | 2. `CTWorksheet` **没æ** `isSetSheetData()`ï¼sheetData æ¯å¿
å¡«ï¼ï¼è¦ç¨ `getSheetData() != null`ã |
|---|
| | | 3. æ¯çè¡¥é½çå¤ä»½æ件**ä¸è½**ç¨ `_å¤ä»½_` åç¼ï¼ä¼è¢« `resolveSummaryDonor` å½ donor åå¡«ï¼ï¼æ¬æ¬¡ç¨ `_bak_2026å¹´7æéè·¯è¿è¾éæ±æ»è¡¨_è¡¥é½å_20260916.xlsx`ã |
|---|
| | | |
|---|
| | | ### 21.7 éç |
|---|
| | | |
|---|
| | | - 2026-06 / 2026-09 æ æ¯ç â é¢è§ `ready=False`ãæªæ¾å°æ¨¡æ¿æ件ãï¼éå
建æ¯çã |
|---|
| | | - 第 8 æ£éçæªå¨ï¼`h2031` 缺 2025-01ã`passenger_individual_monthly` 2026-08 缺é»åã`PASSENGER_AUTH` 11 æå
¨ 0ã |
|---|
| | | - ä»åºæ ¹ `_*.*`ï¼å«æ¬æ¬¡ `_hyb_*` / `_loo_*` / `_v2_*` / `_final_*` / `_fixed_*` / `_t7_*` / `_poijar`ï¼æªå ï¼å¾
ç¨æ·åæã |
|---|
| | | |
|---|
| | | 详è§ãåè½æµè¯æ¥å/åè½æµè¯æ¥å_2026-07æ¯çè¡¥é½ä¸å¯¼åºä»¶æä¸å¼ä¿®å¤_2026-09-16.mdãã |
|---|
| | | |
|---|
| | | ### 21.8 æ¶å·¥è®°å½ï¼2026-09-16ï¼ |
|---|
| | | |
|---|
| | | - æ¬è½®ä»£ç /æ档已 commit `80e0879`ï¼å¹¶ **push å°ä¸ªäºº gitee `origin/master`**ï¼`e29485b..80e0879`ï¼ã |
|---|
| | | - å
¬å¸ gitea ä»ä¸éï¼`git fetch gitea` æ起约 5 åéæ ååºï¼å·²æ约å®**ä¸å¼ºæ¨**ï¼å¾
ç½ç»æ¢å¤åè¡¥æ¨ï¼æ¬å°ç° `ahead 16`ï¼ã |
|---|
| | | - æ¶å·¥æ¶ç¯å¢ï¼å端 8090ãå端 8080 åå¨è·ï¼Excel å¤å¿è¿ç¨å·²æ¸
å¹²åï¼åªä¿çç¨æ·èªå·±ç 18564/25868ï¼ã |
|---|
| | | - æªæ交å
容ï¼**ææä¿çï¼çç¨æ·ç¡®è®¤**ï¼ï¼`docs/æèµ/` ä¸çæ¢æå¢å ï¼`Xæâ¦` æ¹åçï¼éæ¬è½®æ¹å¨ï¼ãä»åºæ ¹ `_*.*` ææ¥ä¸´æ¶æ件ã |
|---|
| | | - æ天å¯åï¼æ°å»º 2026-09ï¼å 2026-06ï¼æ¯çï¼è®© 9 ææºæ°æ®å¯¼å
¥åè½ç´æ¥åºæ±æ»å¤§è¡¨ï¼å
¬å¸ gitea è¡¥æ¨ã |
|---|
