Agent Skills
› fanfan-de/anybox
› sharepoint-spreadsheets
sharepoint-spreadsheets
GitHub用于编辑 SharePoint 上的 .xlsx 文件，强调保留公式、格式和结构。通过搜索定位工作簿，下载后检查结构并修改，最后上传回原位置。
Trigger Scenarios
用户要求更新 SharePoint 中的真实电子表格
需要保留公式和格式的 Excel 编辑任务
Install
npx skills add fanfan-de/anybox --skill sharepoint-spreadsheets -g -y
SKILL.md
Frontmatter
{
"name": "sharepoint-spreadsheets",
"description": "Edit SharePoint-hosted spreadsheet files while preserving workbook structure, formulas, and formatting. Use when the user wants to update a real spreadsheet in SharePoint rather than summarize extracted sheet text."
}
SharePoint Spreadsheets
Overview
Use this skill for .xlsx edits that start from SharePoint. Inspect the workbook structure before editing, preserve formulas and formatting, and upload the revised workbook back to the same SharePoint item only after verifying the exact change.
If the formula itself is the task, pair this with ../sharepoint-spreadsheet-formula-builder/SKILL.md so formula design, syntax checks, and rollout choices stay deliberate instead of being improvised during the workbook edit.
Core Workflow
- Use the site-scoped SharePoint discovery path to locate the exact workbook:
get_site(...)when the user already knows the sitelist_site_drives(...)when the site is known but the library is notsearch(query=None, hostname=..., site_path=..., folder_path=...)to browse a known site or foldersearch(query="...")when the user actually has keywords
- Prefer the exact
urlreturned by keyword search or browse results when you later callfetch. - Fetch extracted content once to identify relevant sheets and the likely target area.
- Fetch the raw
.xlsxwithfetch(download_raw_file=true). - Inspect workbook structure before editing:
- sheet names
- used ranges or dimensions
- formulas
- headers
- the most natural insertion point
- Apply the edit with workbook-aware local tooling such as
openpyxl, preserving workbook structure, formulas, and formatting. - Verify the exact inserted cells, rows, or section header after save rather than relying on a generic workbook-size change.
- Write the revised workbook back with
update_fileusing the exact drive-root-relative path from SharePoint metadata. - Confirm the SharePoint update metadata and, when possible, reopen the workbook locally to verify the targeted cells.
Use the direct Microsoft SharePoint app tools for this flow. Do not rely on generic MCP resource listing for SharePoint workbook discovery in Codex.
Safety
- Do not flatten a workbook into CSV-like text when the user expects the original spreadsheet to remain editable.
- Preserve formulas, charts, sheet structure, and formatting unless the user explicitly asked to change them.
- Treat connector writes as full workbook replacement.
update_filedoes not patch individual cells or formulas inside the existing workbook on the server. fetchenforces the connector's supported-file and max-size constraints. If raw workbook retrieval fails at the connector layer, stop and report the limitation instead of pretending the workbook was safely inspected.- Do not teach or rely on user-recency as the primary browse path. Resolve the right site, library, and folder first when the workbook location is still ambiguous.
- If the workbook contains formulas, charts, or formatting-sensitive layouts, treat operations that can shift references or overwrite styled ranges as high risk and inspect carefully before saving.
- For structured additions such as Q&A sections, notes blocks, or assumption tables, prefer inserting them into the most natural non-formula sheet instead of the main projection grid unless the user explicitly asked otherwise.
Verification
- Verify the exact target cells, rows, or inserted block.
- If you can verify content but not workbook fidelity more broadly, say that clearly instead of implying a full workbook QA pass.
Version History
- 08dc189 Current 2026-07-05 19:06
