1 line
280 KiB
Plaintext
1 line
280 KiB
Plaintext
|
{"ID":"20250916184828-nw2hmej","Spec":"2","Type":"NodeDocument","Properties":{"id":"20250916184828-nw2hmej","title":"处理MPS主计划","type":"doc","updated":"20250918110935"},"Children":[{"ID":"20250916185008-llycax7","Type":"NodeTable","TableAligns":[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0],"Properties":{"colgroup":"|||||||||||||||||","id":"20250916185008-llycax7","updated":"20250916185008"},"Children":[{"Type":"NodeTableHead","Data":"thead","Children":[{"Type":"NodeTableRow","Data":"tr","Children":[{"Type":"NodeTableCell","Data":"th","Children":[{"Type":"NodeText","Data":"线体"}]},{"Type":"NodeTableCell","Data":"th","Children":[{"Type":"NodeText","Data":"順序"}]},{"Type":"NodeTableCell","Data":"th","Children":[{"Type":"NodeText","Data":"工單號碼"}]},{"Type":"NodeTableCell","Data":"th","Children":[{"Type":"NodeText","Data":"MODEL"}]},{"Type":"NodeTableCell","Data":"th","Children":[{"Type":"NodeText","Data":"工單"},{"Type":"NodeBr","Data":"br"},{"Type":"NodeText","Data":"批量"}]},{"Type":"NodeTableCell","Data":"th","Children":[{"Type":"NodeText","Data":"已完工"}]},{"Type":"NodeTableCell","Data":"th","Children":[{"Type":"NodeText","Data":"計劃量"}]},{"Type":"NodeTableCell","Data":"th","Children":[{"Type":"NodeText","Data":"IE標準"},{"Type":"NodeBr","Data":"br"},{"Type":"NodeText","Data":"產量/H"}]},{"Type":"NodeTableCell","Data":"th","Children":[{"Type":"NodeText","Data":"所用"},{"Type":"NodeBr","Data":"br"},{"Type":"NodeText","Data":"工时"}]},{"Type":"NodeTableCell","Data":"th","Children":[{"Type":"NodeText","Data":"REMARK"}]},{"Type":"NodeTableCell","Data":"th","Children":[{"Type":"NodeText","Data":"K/T\u0026外包"}]},{"Type":"NodeTableCell","Data":"th","Children":[{"Type":"NodeText","Data":"回 復"}]},{"Type":"NodeTableCell","Data":"th","Children":[{"Type":"NodeText","Data":"AP"}]},{"Type":"NodeTableCell","Data":"th","Children":[{"Type":"NodeText","Data":"回 復"}]},{"Type":"NodeTableCell","Data":"th","Children":[{"Type":"NodeText","Data":"FA"}]},{"Type":"NodeTableCell","Data":"th","Children":[{"Type":"NodeText","Data":"回复"}]},{"Type":"NodeTableCell","Data":"th","Children":[{"Type":"NodeText","Data":"PCBA"}]},{"Type":"NodeTableCell","Data":"th","Children":[{"Type":"NodeText","Data":"回复"}]}]}]}]},{"ID":"20250916185053-bwct3ji","Type":"NodeParagraph","Properties":{"id":"20250916185053-bwct3ji","updated":"20250916185115"},"Children":[{"Type":"NodeText","Data":"线体 順序\t工單號碼\tMODEL\t工單批量\t已完工\t計劃量\tIE標準產量/H\t所用工時\tREMARK\tK/T\u0026外包\t回復\tAP\t回復\tFA\t回復\tPCBA\t回復"}]},{"ID":"20250916185059-2l7f4rh","Type":"NodeParagraph","Properties":{"id":"20250916185059-2l7f4rh","updated":"20250916191107"},"Children":[{"Type":"NodeText","Data":"我有一个 MPS计划表现在我要对他进行处理，需要你根据MODEL和工单号码，匹配出IE標準\n產量/H"}]},{"ID":"20250916185822-flyr1xq","Type":"NodeCodeBlock","IsFencedCodeBlock":true,"Properties":{"id":"20250916185822-flyr1xq","updated":"20250916185822"},"Children":[{"Type":"NodeCodeBlockFenceOpenMarker","Data":"```"},{"Type":"NodeCodeBlockFenceInfoMarker","CodeBlockInfo":"dmJh"},{"Type":"NodeCodeBlockCode","Data":"Sub DeleteTotalAndEmptyRows()\n ' Define variables\n Dim ws As Worksheet\n Dim lastRow As Long, i As Long\n Dim rngToDelete As Range\n Dim cell As Range\n \n ' Disable screen updating and automatic calculation to improve performance\n Application.ScreenUpdating = False\n Application.Calculation = xlCalculationManual\n \n ' Set the worksheet to operate on - change \"Sheet1\" to your actual sheet name\n Set ws = ActiveSheet ' Using active sheet. Recommended: Set ws = ThisWorkbook.Worksheets(\"Sheet1\")\n \n ' Find the last row in column A\n lastRow = ws.Cells(ws.Rows.Count, \"A\").End(xlUp).Row\n \n ' Loop from bottom to top (best practice when deleting rows)\n For i = lastRow To 1 Step -1\n ' Check cell in column A\n Set cell = ws.Cells(i, 1)\n \n ' Check conditions: if cell is
|