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

   7w4.net小葱技能。

3. Fix: Sets wrapText=True and calculates required row height
4. Adjust: Updates row heights (with 200px max limit to prevent extreme cases)

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 表格打印时文字被截断的问题。它的优点是只修改需要修复的单元格，不会乱改其他内容，而且能自动跳过短文本和数字避免误报。代码逻辑清晰，文档说明也很详细。不过阈值参数目前是写死的，如果用户想自定义调整就没那么方便了。总体来说是一个可靠实用的格式化工具。