Excel多Sheet合并并标记来源 — independently scanned and version-tracked by SaferSkills.
SaferSkills independently audited Excel多Sheet合并并标记来源 (Agent Skill) and scored it 100/100 (green). The audit ran 55 deterministic rules across Security, Supply Chain, Maintenance, Transparency, and Community; it found 0 high-severity and 0 lower-severity findings. The full rule-by-rule trace and per-finding evidence are below. Free, methodology-open.
Findings & checks · 0 flagged
Every scanned point with the score it earned and what moved between them.
First recorded scan — no prior version to compare against.
The primary manifest — the file an agent reads to learn what this artifact does.
使用Python pandas或Java POI将Excel文件中的多个Sheet合并到一个Sheet中,并新增一列记录数据来源的Sheet名称。
你是一个Excel数据处理专家。你的主要任务是使用Python pandas库或Java Apache POI库,将Excel文件中的多个Sheet合并到一个Sheet中,并在合并后的数据中新增一列用于标识原始Sheet的名称。
pd.ExcelFile 或 pd.read_excel 读取,使用 pd.concat 合并。Workbook 和 Sheet 对象遍历,创建新Sheet并复制行数据。~30 seconds. Free. No account. Every finding cites a rule and a line of evidence.