Read and edit PDFs: extract text and tables, merge, split, rotate, and fill forms.
ANanthropics/skills181k1,119 new stars in the last 7 days
Excel 电子表格读写与编辑最佳实践 — 用 xlsx_read/xlsx_write/xlsx_edit 处理 .xlsx 时遵守的公式、数字格式与可维护性纪律
改编自 anthropics/skills xlsx(Apache 2.0)。
用本插件(xlsx_read / xlsx_write / xlsx_edit)交付 Excel 文件时,遵守以下纪律。
{ formula: 'SUM(B2:B10)' }),不要把算好的结果写死。xlsx_read 中以 =SUM(...) 原文显示,交付前读回自查一遍公式是否正确。#REF! / #DIV/0! / #VALUE! / #NAME? 一个都不允许出现在交付物里。常见成因与预防:
A1 是第一个单元格,不存在第 0 行/第 0 列。越界引用直接 #REF!。Sheet1!A1 语法;sheet 名含空格或特殊字符时用单引号 'My Sheet'!A1。IF(B2=0, 0, A2/B2)。#VALUE!;写入时不要把数字写成带引号的字符串。#NAME? 几乎都是函数名拼错或用了不存在的函数。$#,##0(或 ¥#,##0)0.0%0.0x#,##0;(#,##0)'2024),防止被加千分位显示成 2,024=B5*(1+$B$6),而不是 =B5*1.05。$B$6 绝对引用锁定假设单元格,下拉填充时不会漂移。xlsx_read 先看清原文件的表头、格式、公式风格,再动手。xlsx_edit 的 update_cells / append_rows),不要整体重写文件。Read and edit PDFs: extract text and tables, merge, split, rotate, and fill forms.
ANanthropics/skills181k1,119 new stars in the last 7 days
Create posters and visual art as PNG or PDF, guided by a design philosophy.
ANanthropics/skills181k1,119 new stars in the last 7 days
Create and edit Word docs with TOC, page numbers, headers and more.
ANanthropics/skills181k1,119 new stars in the last 7 days
Co-write specs, proposals and decision docs through a structured, iterative workflow.
ANanthropics/skills181k1,119 new stars in the last 7 days
Read and edit spreadsheets: add columns, compute formulas, format, and clean messy data.
ANanthropics/skills181k1,119 new stars in the last 7 days
Create and edit slide decks, generate slides from templates, and extract text.
ANanthropics/skills181k1,119 new stars in the last 7 days