excel-outlier-detection-and-highlighting
识别 Excel 中的超限数值与错误单元格并进行高亮标注。
Install / Use
npx skills add OpenSenseNova/SenseNova-Skills --skill outlier-coloringInstalls into whichever agent you are using.
SKILL.md
Installable skill definition
Quality Score
Category
AutomationSupported Platforms
Our assessment of excel-outlier-detection-and-highlighting
excel-outlier-detection-and-highlighting scores 80/100 on our quality scale, 2483rd of 2,780 Automation skills we index.
Its SKILL.md is 3.4 KB long, well organised into 8 sections with 4 code examples: a solid amount of guidance for an agent.
With 5,691 GitHub stars, it is one of the more widely adopted skills in the catalogue.
Maintenance, license and trust
- The repository was last updated about 2 months ago, so excel-outlier-detection-and-highlighting is actively maintained.
- Our last check on 2026-11-08 found the source still online.
- It is released under the MIT license, a permissive license that allows use, modification and commercial use with attribution.
- Its trust signals score 100/100, with no cautions. These come from repository metadata, not a code audit — read the skill file before letting an agent act on it.
Safety scan
No issues foundOur scan of the whole file found no instruction hijacking, hidden characters, credential access, data exfiltration or destructive commands. An AI review of the same text found nothing harmful.
AI review by kimi-k2.7-code on 2026-09-27. Automated pattern scan on 2026-09-27. It catches known dangerous patterns, not every risk — read a skill before letting an agent act on it.
excel-outlier-detection-and-highlighting compared with similar skills
All 4 of these similar skills score higher than excel-outlier-detection-and-highlighting; compare them before choosing.
| Skill | Score | Stars | Updated | Format |
|---|---|---|---|---|
| excel-outlier-detection-and-highlighting (this skill)by OpenSenseNova | 80 | 5.7k | 59d ago | SKILL.md |
| Agent-Reachby Panniantong | 100 | 112.3k | 8d ago | CLAUDE.md |
| rufloby ruvnet | 100 | 81.9k | today | CLAUDE.md |
| headroomby headroomlabs-ai | 100 | 79.8k | today | CLAUDE.md |
| Claude-Code-Game-Studiosby Donchitos | 100 | 39.7k | 7d ago | CLAUDE.md |
Frequently asked questions
- How do I install excel-outlier-detection-and-highlighting?
- Run
npx skills add OpenSenseNova/SenseNova-Skills --skill excel-outlier-detection-and-highlighting. The install tabs above show the steps for each supported agent. - Which AI agents does excel-outlier-detection-and-highlighting work with?
- It is written for Universal, as a SKILL.md file. Other agents that read the same format can often use it too.
- Is excel-outlier-detection-and-highlighting safe to use?
- Our scan of the whole file found no instruction hijacking, hidden characters, credential access, data exfiltration or destructive commands. An AI review of the same text found nothing harmful. It is MIT-licensed and scores 100/100 on trust signals. Skills are instructions an agent will follow, so read the file before installing it and do not approve commands you do not understand.
- Is excel-outlier-detection-and-highlighting still maintained?
- The repository was last updated about 2 months ago, so excel-outlier-detection-and-highlighting is actively maintained.
Skill content
View source on GitHubname: excel-outlier-detection-and-highlighting description: "识别 Excel 中的超限数值与错误单元格并进行高亮标注。"
Outlier_Coloring
This sub-skill covers one capability of the Excel workflow. For reading/counting/Parquet optimization, see the parent workflow SKILL.md.
Step1 使用正则表达式提取限值,并结合上下文逻辑识别总传热系数超限的行。
import re
exceed_rows = []
target_col = 0 # 假设特征列在第一列
value_col = 8 # 假设数值列在第九列
for i, row in df.iterrows():
row_str = str(row.iloc[target_col]) if pd.notna(row.iloc[target_col]) else ""
# 正则表达式精准提取限值,例如 "限值0.5"
if '限值' in row_str:
match = re.search(r'限值([\d.]+)', row_str)
if match:
current_limit = float(match.group(1))
# 识别计算结果行并进行对比
if '共计' in row_str:
try:
actual_val = float(row.iloc[value_col])
# 向上回溯寻找结构名称(实战技巧:遍历还原上下文)
structure_name = "未知结构"
for j in range(i-1, max(0, i-15), -1):
prev_val = str(df.iloc[j, 0])
if any(kw in prev_val for kw in ['系数', '围护']):
structure_name = prev_val
break
# 提取最近的限值进行对比
limit_val = None
for j in range(i-1, max(0, i-15), -1):
check_str = ' '.join([str(x) for x in df.iloc[j, :] if pd.notna(x)])
limit_match = re.search(r'限值([\d.]+)', check_str)
if limit_match:
limit_val = float(limit_match.group(1))
break
if limit_val and actual_val > limit_val:
exceed_rows.append({
'row_index': i,
'name': structure_name,
'value': actual_val,
'limit': limit_val,
'diff': actual_val - limit_val
})
except (ValueError, TypeError):
continue
Step2 遍历指定 Sheet 查找包含 '#DIV/' 等异常错误的单元格,并记录坐标。
# 针对特定 Sheet(如 Sheet3)检测公式错误
ws_error = wb['Sheet3']
error_cells = []
for row in ws_error.iter_rows(min_row=1, max_row=ws_error.max_row):
for cell in row:
if cell.value is not None:
val_str = str(cell.value)
# 识别 Excel 除零错误或其他异常标识
if '#DIV/' in val_str:
error_cells.append({
'coord': cell.coordinate,
'val': cell.value
})
Step3 对识别出的超限行和异常单元格进行红色高亮标注,并保存结果。
from openpyxl.styles import PatternFill
# 定义红色填充样式
red_fill = PatternFill(start_color='FF0000', end_color='FF0000', fill_type='solid')
# 标注超限行(注意:Excel 行号 = pandas 索引 + 1)
# 假设在第一个 Sheet 中标注
ws_main = wb[wb.sheetnames[0]]
for item in exceed_rows:
excel_row = item['row_index'] + 1
for col in range(1, ws_main.max_column + 1):
ws_main.cell(row=excel_row, column=col).fill = red_fill
# 标注异常单元格
for err in error_cells:
ws_error[err['coord']].fill = red_fill
output_path = "highlighted_report.xlsx"
wb.save(output_path)
Step4 汇总超限数据生成分析报告,并提供下载链接。
# 创建汇总 DataFrame
summary_df = pd.DataFrame(exceed_rows)
if not summary_df.empty:
summary_df['Excel行号'] = summary_df['row_index'] + 1
summary_df = summary_df[['Excel行号', 'name', 'value', 'limit', 'diff']]
summary_df.columns = ['行号', '结构名称', '实测值', '限值', '超出值']
summary_path = "outlier_summary.xlsx"
summary_df.to_excel(summary_path, index=False)
# 输出下载链接格式
print(f"处理完成。结果文件:{output_path}")
print(f"汇总报告:{summary_path}")
Related Skills
Agent-Reach
112.3kGive your AI agent eyes to see the entire internet. Read & search Twitter, Reddit, YouTube, GitHub, Bilibili, XiaoHongShu — one CLI, zero API fees.
ruflo
81.9k🌊 The original agent harness. Deploy intelligent multi-player swarms, coordinate autonomous workflows, and build conversational AI systems. Features adaptive memory, self-learning intelligence, federation, vector RAG integration, and native Claude Code / Codex / Hermes and many more Integrated
headroom
79.8kCompress tool outputs, logs, files, and RAG chunks before they reach the LLM. 20% fewer tokens for coding agents, 60-95% fewer tokens for JSON, same answers. Library, proxy, MCP server.
Claude-Code-Game-Studios
39.7kTurn Claude Code into a full game dev studio — 49 AI agents, 72 workflow skills, and a complete coordination system mirroring real studio hierarchy.
Languages
Trust signals
From repository metadata: license, adoption, age and documentation. Not a code audit — see the Safety scan above for what the skill file itself contains.
