sharepoint-spreadsheets
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.
- License 许可
- MIT
- 最近更新
- 2026-07-19
- Stars
- ★ 1
- Forks
- 1
01 前言 Front Matter
- 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.
02 资源文件 1
- 参考文档agents/openai.yaml261 B
03 SKILL.md 正文
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.
04 同仓库更多 Skills
Zotero
Use Zotero Desktop from Codex to enable/probe the local API, search a local Zotero library, list items/collections/tags, export BibTeX, insert citation keys into LaTeX or Markdown drafts, read indexed full text when requested, and import BibTeX/RIS records into Zotero through the connector server. Use when the user mentions Zotero, citations, references.bib, BibTeX export, local Zotero API, localhost:23119, or adding citations from a Zotero library.
zoom-apps-sdk
Use when using Apps SDK.
youtube
Obtain accurate, timestamped YouTube video transcripts (preferring manual captions over auto-generated) as the primary deliverable, then derive summaries, key claims, or notes from that transcript. Use when the user provides a YouTube URL (or video ID) and wants the transcript, a faithful summary, key claims with attribution, timestamped notes, or "what does this video actually say". The skill is transcript-first: never substitute metadata, title, description, or search snippets for the spoken content. Triggers: "youtube transcript", "get the transcript of this video", "summarize this youtube video", "what did they say in https://youtube.com/...", "key claims from this talk".
yeet
Publish local changes to GitHub by confirming scope, committing intentionally, pushing the branch, and opening a draft PR through the GitHub app from this plugin, with `gh` used only as a fallback where connector coverage is insufficient.
x-post-creator
Create X-ready post threads and co-located story packages from the active conversation or referenced project material. Use when the user says turn this into an X-post, /x-post, make this into an X thread, or wants plain-language social posts with supporting images saved to docs/x-posts/[story-name]/.
x-api
Search, read, and write X posts through the local X API MCP server (the same backend used by the Codex x-api skill). Use for searching X/x.com, reading threads and replies, creating lists, staging/publishing posts for @alltheputs, finding high-visibility reply targets for research outreach, ingesting public context, or any request that mentions /x-api or "search X".