Excel Overflow Fix

Overview

This skill fixes cell overflow/truncation issues in Excel audit working papers. It automatically detects cells where content exceeds the visible area (including merged cells), applies text wrapping, and adjusts row heights so all content is fully visible and printable.

Key guarantees:

• Only modifies the sheet named "審定表" (audit confirmation sheet)
• Never changes cell content, formulas, or data
• Only adjusts formatting (wrap text + row height)
• All other sheets remain completely untouched

Workflow

Step 1: Locate Files

Identify the folder containing the Excel files to process. The skill handles both .xlsx and .xls files.

Step 2: Run the Fix Script

Execute the bundled Python script:

python scripts/fix_overflow.py <input_folder> [output_folder]

Parameters:

• input_folder (required): Path to folder containing Excel files
• output_folder (optional): Where to save fixed files. Defaults to <input_folder>/fixed

Example:

python scripts/fix_overflow.py "C:\Users\Dell\Desktop\底稿"

Step 3: Review Output

Fixed files are saved with _fixed suffix in the output folder. Each file's "審定表" sheet will have:

• Overflow cells wrapped properly
• Row heights adjusted to fit content
• All other sheets identical to original

How It Works

1. Scan: Iterates through all cells in the "審定表" sheet
2. Detect: Identifies cells where text length exceeds visible width
3. Fix: Sets wrapText=True and calculates required row height
4. Adjust: Updates row heights (with 200px max limit to prevent extreme cases)

   小蔥技能站7w4.net發現了升級外掛。

Overflow detection logic:

• Skips metadata markers (---, calction)
• Skips pure numbers and reference codes
• Ignores text shorter than 8 characters
• Calculates needed lines based on column width and font size
• Handles merged cells by distributing height across merged rows

Requirements

• Python 3.x
• openpyxl library (pip install openpyxl)

Resources

scripts/

• fix_overflow.py - Main script for batch processing Excel files

Notes

• The script processes ALL .xlsx and .xls files in the input folder
• Files without a "審定表" sheet are skipped
• Files with no overflow issues are skipped (not saved)
• Maximum row height is capped at 200px to prevent excessive heights

這個 Skill 質量不錯，專門用來解決 Excel 表格列印時文字被截斷的問題。它的優點是隻修改需要修復的單元格，不會亂改其他內容，而且能自動跳過短文本和數字避免誤報。程式碼邏輯清晰，文件說明也很詳細。不過閾值引數目前是寫死的，如果使用者想自定義調整就沒那麼方便了。總體來說是一個可靠實用的格式化工具。