excel-threshold-analysis-and-styling

by OpenSenseNova5.8k

根据 Excel 数据量级自动判断处理策略，执行数值列清洗、条件过滤，并使用 openpyxl 对符合条件的单元格进行样式标记与导出。

Install

The skill file stays in the publisher's repository.

Paste the copied command in a terminal. It installs this SKILL.md into that agent.

npx skills add OpenSenseNova/SenseNova-Skills --skill threshold-filtering -a cursor -y

Download skill skills/sn-da-excel-workflow/capability/excel-data-filtering/threshold-filtering/SKILL.md on GitHub

Related skills

View all

Questions

How do I install excel-threshold-analysis-and-styling?: Download skills/sn-da-excel-workflow/capability/excel-data-filtering/threshold-filtering/SKILL.md from the publisher, or copy the path and open the repository. PlugMCP lists the skill and does not host the file.
Where does excel-threshold-analysis-and-styling live?: The publisher keeps it at https://github.com/OpenSenseNova/SenseNova-Skills.
Which agents can use excel-threshold-analysis-and-styling?: Claude, Cursor, and Codex can read a SKILL.md you add from the publisher's repository.

name: excel-threshold-analysis-and-styling description: "根据 Excel 数据量级自动判断处理策略，执行数值列清洗、条件过滤，并使用 openpyxl 对符合条件的单元格进行样式标记与导出。"

Excel Threshold Analysis and Styling

Note: This sub-skill covers one step of the Excel analysis workflow. For the full pipeline (file reading, row counting, large-file optimization, export), see the parent workflow SKILL.md.

Step1 读取 Excel 文件中所有工作表的行数并汇总，用于评估数据规模。

import pandas as pd

file_path = 'input_file.xlsx'

# 读取所有 sheet 名称并统计总行数
xls = pd.ExcelFile(file_path)
sheet_names = xls.sheet_names
total_rows = 0

for sheet in sheet_names:
    # header=None 用于快速统计包含表头的总行数
    df_tmp = pd.read_excel(file_path, sheet_name=sheet, header=None)
    rows = len(df_tmp)
    total_rows += rows
    print(f"Sheet '{sheet}': {rows} 行")

print(f"\n总行数汇总: {total_rows}")