Excel Unmerge Before Write
HKUDS/OpenSpace
Unmerge merged cells in openpyxl worksheets before writing values to avoid AttributeError
Exchange data between Excel and MATLAB using Spreadsheet Link VBA macros and worksheet functions.
Install Matlab Use Spreadsheet Link
$ npx skills add matlab/matlab-agentic-toolkit --skill matlab-use-spreadsheet-link -a claude-codeProject install by default; add -g for ~/.claude/skills/.
$ gh skill install matlab/matlab-agentic-toolkit matlab-use-spreadsheet-link --agent claude-codeProject scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).
$ git clone --depth 1 https://github.com/matlab/matlab-agentic-toolkit.git skills-src && mkdir -p .claude/skills && cp -r skills-src/skills-catalog/computational-finance/matlab-use-spreadsheet-link .claude/skills/matlab-use-spreadsheet-link && rm -rf skills-srcUse ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.
Claude Code skills documentation · loads skills from .claude/skills/
Install the "matlab-use-spreadsheet-link" agent skill from https://github.com/matlab/matlab-agentic-toolkit/tree/main/skills-catalog/computational-finance/matlab-use-spreadsheet-link into .claude/skills/matlab-use-spreadsheet-link/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "matlab-use-spreadsheet-link", then confirm the skill loads.Claude Code copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$skill-installer install https://github.com/matlab/matlab-agentic-toolkit/tree/main/skills-catalog/computational-finance/matlab-use-spreadsheet-linkType this inside Codex. $skill-installer <name> installs a curated skill from openai/skills. The installer writes to $CODEX_HOME/skills (default ~/.codex/skills). Restart Codex if the skill does not show up.
$ npx skills add matlab/matlab-agentic-toolkit --skill matlab-use-spreadsheet-link -a codexProject install goes to .agents/skills/; add -g for ~/.codex/skills/.
$ gh skill install matlab/matlab-agentic-toolkit matlab-use-spreadsheet-link --agent codexProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/matlab/matlab-agentic-toolkit.git skills-src && mkdir -p .agents/skills && cp -r skills-src/skills-catalog/computational-finance/matlab-use-spreadsheet-link .agents/skills/matlab-use-spreadsheet-link && rm -rf skills-srcUse ~/.agents/skills/ instead of .agents/skills for a personal install.
Codex skills documentation · loads skills from .agents/skills/
Install the "matlab-use-spreadsheet-link" agent skill from https://github.com/matlab/matlab-agentic-toolkit/tree/main/skills-catalog/computational-finance/matlab-use-spreadsheet-link into .agents/skills/matlab-use-spreadsheet-link/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "matlab-use-spreadsheet-link", then confirm the skill loads.Codex copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ npx skills add matlab/matlab-agentic-toolkit --skill matlab-use-spreadsheet-link -a cursorProject install goes to .agents/skills/; add -g for ~/.cursor/skills/.
$ gh skill install matlab/matlab-agentic-toolkit matlab-use-spreadsheet-link --agent cursorProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/matlab/matlab-agentic-toolkit.git skills-src && mkdir -p .cursor/skills && cp -r skills-src/skills-catalog/computational-finance/matlab-use-spreadsheet-link .cursor/skills/matlab-use-spreadsheet-link && rm -rf skills-srcUse ~/.cursor/skills/ instead of .cursor/skills for a personal install.
Cursor skills documentation · loads skills from .cursor/skills/, .agents/skills/, .claude/skills/, .codex/skills/
Install the "matlab-use-spreadsheet-link" agent skill from https://github.com/matlab/matlab-agentic-toolkit/tree/main/skills-catalog/computational-finance/matlab-use-spreadsheet-link into .cursor/skills/matlab-use-spreadsheet-link/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "matlab-use-spreadsheet-link", then confirm the skill loads.Cursor copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ gemini skills install https://github.com/matlab/matlab-agentic-toolkit.git --path skills-catalog/computational-finance/matlab-use-spreadsheet-link--scope user (default) or --scope workspace; --path is the subfolder of the repo that holds the skill; --consent skips the security confirmation prompt.
$ npx skills add matlab/matlab-agentic-toolkit --skill matlab-use-spreadsheet-link -a gemini-cliProject install goes to .agents/skills/; add -g for ~/.gemini/skills/.
$ gh skill install matlab/matlab-agentic-toolkit matlab-use-spreadsheet-link --agent gemini-cliProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/matlab/matlab-agentic-toolkit.git skills-src && mkdir -p .gemini/skills && cp -r skills-src/skills-catalog/computational-finance/matlab-use-spreadsheet-link .gemini/skills/matlab-use-spreadsheet-link && rm -rf skills-srcUse ~/.gemini/skills/ instead of .gemini/skills for a personal install, then run /skills reload.
Gemini CLI skills documentation · loads skills from .gemini/skills/, .agents/skills/
Install the "matlab-use-spreadsheet-link" agent skill from https://github.com/matlab/matlab-agentic-toolkit/tree/main/skills-catalog/computational-finance/matlab-use-spreadsheet-link into .gemini/skills/matlab-use-spreadsheet-link/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "matlab-use-spreadsheet-link", then confirm the skill loads.Gemini CLI copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ gh skill install matlab/matlab-agentic-toolkit matlab-use-spreadsheet-linkInstalls for Copilot at project scope by default; add --scope user for a personal install. Preview a skill first with gh skill preview. Needs GitHub CLI 2.90.0 or later (public preview).
$ npx skills add matlab/matlab-agentic-toolkit --skill matlab-use-spreadsheet-link -a github-copilotProject install goes to .agents/skills/; add -g for ~/.copilot/skills/.
$ git clone --depth 1 https://github.com/matlab/matlab-agentic-toolkit.git skills-src && mkdir -p .github/skills && cp -r skills-src/skills-catalog/computational-finance/matlab-use-spreadsheet-link .github/skills/matlab-use-spreadsheet-link && rm -rf skills-srcUse ~/.copilot/skills/ instead of .github/skills for a personal install. Commit .github/skills so cloud agent and code review can use it.
GitHub Copilot skills documentation · loads skills from .github/skills/, .claude/skills/, .agents/skills/
Install the "matlab-use-spreadsheet-link" agent skill from https://github.com/matlab/matlab-agentic-toolkit/tree/main/skills-catalog/computational-finance/matlab-use-spreadsheet-link into .github/skills/matlab-use-spreadsheet-link/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "matlab-use-spreadsheet-link", then confirm the skill loads.GitHub Copilot copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ npx skills add matlab/matlab-agentic-toolkit --skill matlab-use-spreadsheet-link -a opencodeOpenCode documents no install command of its own. Project install goes to .agents/skills/; add -g for ~/.config/opencode/skills/.
$ gh skill install matlab/matlab-agentic-toolkit matlab-use-spreadsheet-link --agent opencodeProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/matlab/matlab-agentic-toolkit.git skills-src && mkdir -p .opencode/skills && cp -r skills-src/skills-catalog/computational-finance/matlab-use-spreadsheet-link .opencode/skills/matlab-use-spreadsheet-link && rm -rf skills-srcUse ~/.config/opencode/skills/ instead of .opencode/skills for a personal install.
OpenCode skills documentation · loads skills from .opencode/skills/, .claude/skills/, .agents/skills/
Install the "matlab-use-spreadsheet-link" agent skill from https://github.com/matlab/matlab-agentic-toolkit/tree/main/skills-catalog/computational-finance/matlab-use-spreadsheet-link into .opencode/skills/matlab-use-spreadsheet-link/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "matlab-use-spreadsheet-link", then confirm the skill loads.OpenCode copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
Facts
- Skill name
matlab-use-spreadsheet-link- GitHub stars
- 1.1k
- Token cost
- ~4.1k tokens
- SKILL.md length
- 1,462 words
- Files
- 2
- Skills in repo
- 142
- Repo updated
- First seen
- Licence
- Custom licence
At a glance
Exchange data between Excel and MATLAB using Spreadsheet Link VBA macros and worksheet functions.
- Works in 12 steps: Do NOT create new .m files — Spreadsheet… → Always end with MatlabRequest if the… → MLGetMatrix takes a string for the cell… → …
- Writing Excel VBA macros that call MLPutMatrix
- SKILL.md covers When to Use, When NOT to Use, Architecture and Key Functions, plus 5 more sections
- Instructions only: no scripts, shell commands, URLs or credentials in SKILL.md
What it does
Matlab Use Spreadsheet Link is an agent skill from matlab/matlab-agentic-toolkit. Exchange data between Excel and MATLAB using Spreadsheet Link VBA macros and worksheet functions. Use when writing Excel VBA macros that call MLPutMatrix, MLGetMatrix, MLPutVar, MLGetVar, MLPutRanges, MLEvalString, MLGetFigure, or MatlabRequest.
Its SKILL.md is about 4.1k tokens, which your agent loads only when the skill is triggered. The skill folder holds 1 other file (for example `manifest.yaml`).
It sits in Documents & Office, covering Excel spreadsheets and Educational content. It works with Microsoft Excel. The repository describes itself as: The MATLAB Agentic Toolkit brings proven MATLAB capabilities to AI agents, making engineering and scientific workflows agent-ready.
When your agent uses it
- Writing Excel VBA macros that call MLPutMatrix
- Tasks that involve Excel spreadsheets
- Tasks that involve Educational content
Example prompts
- “/matlab-use-spreadsheet-link”
Requirements
- Python 3
Workflow steps
12 steps, taken from the first numbered list in SKILL.md.
- Do NOT create new .m files — Spreadsheet Link is an orchestration/data-exchange layer. Express MATLAB logic inline via MLEvalString calls…
- Always end with MatlabRequest if the macro contains any MLGetMatrix or MLGetFigure calls. NOT needed if using only MLGetVar.
- MLGetMatrix takes a string for the cell address, not a Range object — use "G1" not Range("G1")
- MLGetFigure requires selecting the cell first — use Range("I1").Select then MLGetFigure 1, 1. Only two arguments (width, height scaling)…
- MLPutMatrix takes a Range object for the data source — use Range("A1:B10")
- MLPutVar takes a VBA variable — use MLPutVar "name", myVar (not a string name of the variable)
- MLGetVar executes immediately — no MatlabRequest needed. Assign to a Variant.
- Use multiple MLEvalString calls for multi-line MATLAB logic rather than packing into one string
- Do NOT write JSON serialization or data conversion code — Spreadsheet Link handles all data type conversion internally
- Convert dates after exporting — export raw data, then convert in MATLAB with datetime(..., 'ConvertFrom', 'excel')
- Variable names must be valid MATLAB identifiers — no spaces, no special characters, must start with a letter
- For multiple figures, make each figure current with figure(N) before each MLGetFigure call
What it can do on your machine
Read from SKILL.md and the folder at commit 59dfd92. It shows what the files ask for, not the result of running them.
Tool permissions
Pre-approves nothing: there is no allowed-tools line, so your agent's usual permission prompts apply.
From allowed-tools in the SKILL.md frontmatter.
Runs code
No scripts in the folder and no shell commands in SKILL.md (its code samples are vba).
From the folder's file list and the shell code blocks in SKILL.md.
Network
No URLs in SKILL.md.
From URLs in SKILL.md, links to its own repository left out.
Credentials
Names no API keys, tokens, secrets or passwords.
From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.
Context cost
Matlab Use Spreadsheet Link loads about 4.1k tokens when it runs. Until then it costs about 68 tokens; SKILL.md has 1,462 words of instructions outside code blocks.
Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.
Safety
Auto-check passed
The automated check found no risky patterns in SKILL.md.
Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); files beside SKILL.md are not scanned.
SKILL.md
Its licence (Custom licence) doesn't allow us to republish the file, so here is its outline and opening line. It has 1,462 words (~4,129 tokens).
“Spreadsheet Link connects Excel to MATLAB, enabling users to exchange data between Excel and MATLAB, run MATLAB commands, using MATLAB as the compute engine from Excel.”
- name
- matlab-use-spreadsheet-link
- license
- https://www.mathworks.com/content/dam/mathworks/license/pmrl/license.md
- metadata.author
- MathWorks
- metadata.version
- 2.0
Files
SKILL.md and 1 other file in skills-catalog/computational-finance/matlab-use-spreadsheet-link of matlab/matlab-agentic-toolkit.
- SKILL.md
- manifest.yaml
Open the folder on GitHubat commit 59dfd92
Compare with similar skills
Matlab Use Spreadsheet Link next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.
| Skill | Stars | Used in | Tokens | Auto-check | Licence | Repo updated |
|---|---|---|---|---|---|---|
| Matlab Use Spreadsheet Link this skillmatlab/matlab-agentic-toolkit | 1.1k | — | ~4.1k | Automated safety check: Pass | Custom licence | |
| Excel Unmerge Before WriteHKUDS/OpenSpace | 7.7k | — | ~820 | Automated safety check: Pass | MIT | |
| Excel To Legendshuotao/REVIT_MCP_study | 102 | — | ~2.2k | Automated safety check: Pass | None | |
| MarkitdownImCa0/just-laws | 781 | 14 repos | ~3.2k | Automated safety check: Notes | MIT | |
| Data Table Managern8n-io/n8n | 207k | — | ~2.3k | Automated safety check: Pass | Custom licence | |
| Docx4jplutext/docx4j | 2.4k | — | ~2.5k | Automated safety check: Pass | None |
Similar skills
Excel To Legend
shuotao/REVIT_MCP_study
將 Excel 中的 worksheet 批次匯入 Revit Drafting View，忠實還原合併儲存格、表格框線、Excel 原始 column/row 尺寸與長文字 wrap 行為，並在覆蓋舊 view 時自動還原所有 sheet 上的 viewport 位置。觸發條件：使用者提到 excel 表格、excel to drafting、excel to legend、表格匯入…
Markitdown
ImCa0/just-laws
Convert files and office documents to Markdown. An agent skill from ImCa0/just-laws.
- Official
Data Table Manager
n8n-io/n8n
Load before calling data-tables or parse-file. An agent skill from n8n-io/n8n.
Docx4j
plutext/docx4j
A skill your agent uses when writing Java code that creates, reads or edits Word (.docx), PowerPoint (.pptx) or Excel (.xlsx) files with docx4j — including generating documents, editing existing…
- Official
Instrument Data To Allotrope
aws-samples/amazon-bedrock-agents-healthcare-lifesciences
Convert laboratory instrument output files (PDF, CSV, Excel, TXT) to Allotrope Simple Model (ASM) JSON format or flattened 2D CSV.
More from matlab/matlab-agentic-toolkit
All 142 skills in this repoMatlab Analyze Time Frequency Content
matlab/matlab-agentic-toolkit
Perform time-frequency analysis in MATLAB using CWT, STFT, synchrosqueezing, reassignment, wavelet coherence, cross spectrogram, EMD/VMD, multiresolution analysis, and time-frequency filtering.
Matlab Design Radar
matlab/matlab-agentic-toolkit
Launch and control the MATLAB Radar Designer app programmatically via MCP.
Matlab Enhance Camera Image
matlab/matlab-agentic-toolkit
Read BEFORE troubleshooting or enhancing camera image quality.
Matlab Import External AI Model
matlab/matlab-agentic-toolkit
Import PyTorch, ONNX, or Keras 3 / TensorFlow 2.16+ deep learning models into MATLAB as dlnetwork objects.
Matlab Modernize Daq
matlab/matlab-agentic-toolkit
Port MATLAB Data Acquisition Toolbox code from the discouraged (legacy) session-based interface (daq.createSession, addAnalogInputChannel, startBackground, DataAvailable listeners, queueOutputData…
Matlab Optimize GPU Codegen
matlab/matlab-agentic-toolkit
Optimize MATLAB design files for GPU Coder to generate faster CUDA code.
Related
Works with
Categories
Questions about Matlab Use Spreadsheet Link
What does Matlab Use Spreadsheet Link do?
Exchange data between Excel and MATLAB using Spreadsheet Link VBA macros and worksheet functions. Matlab Use Spreadsheet Link is an agent skill from matlab/matlab-agentic-toolkit. Exchange data between Excel and MATLAB using Spreadsheet Link VBA macros and worksheet functions.
When should I use Matlab Use Spreadsheet Link?
Matlab Use Spreadsheet Link fits situations like: writing Excel VBA macros that call MLPutMatrix; tasks that involve Excel spreadsheets; tasks that involve Educational content.
How do I install Matlab Use Spreadsheet Link in Claude Code?
Run `npx skills add matlab/matlab-agentic-toolkit --skill matlab-use-spreadsheet-link -a claude-code`. Or copy the skill folder (skills-catalog/computational-finance/matlab-use-spreadsheet-link in matlab/matlab-agentic-toolkit) into .claude/skills/matlab-use-spreadsheet-link in your project. Claude Code loads it when a task matches its description.
How do I install Matlab Use Spreadsheet Link in Codex?
Run `npx skills add matlab/matlab-agentic-toolkit --skill matlab-use-spreadsheet-link -a codex`. Or copy the skill folder (skills-catalog/computational-finance/matlab-use-spreadsheet-link in matlab/matlab-agentic-toolkit) into .agents/skills/matlab-use-spreadsheet-link in your project. Codex loads it when a task matches its description.
Can I use Matlab Use Spreadsheet Link in Cursor, Gemini CLI or GitHub Copilot?
Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add matlab/matlab-agentic-toolkit --skill matlab-use-spreadsheet-link -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/matlab-use-spreadsheet-link, .gemini/skills/matlab-use-spreadsheet-link, .github/skills/matlab-use-spreadsheet-link and .opencode/skills/matlab-use-spreadsheet-link in your project.
What does Matlab Use Spreadsheet Link need to run?
SKILL.md names no scripts, command-line tools or credentials: Matlab Use Spreadsheet Link is instructions for the agent only. Our summary lists: Python 3.
Does Matlab Use Spreadsheet Link access the network?
SKILL.md contains no URLs. Any network use would come from the scripts or tools the agent runs. This is read from the text; nothing was executed.
Is Matlab Use Spreadsheet Link safe to install?
Our automated static check of SKILL.md found no risky patterns, such as piping downloads into a shell, reading credential files or hidden Unicode. It is not a guarantee. Review the folder before installing.
What licence does Matlab Use Spreadsheet Link use?
Matlab Use Spreadsheet Link has a licence file (the repository's licence) that doesn't match a standard licence. Read it on GitHub before reusing the skill.
How many tokens does Matlab Use Spreadsheet Link use?
About 4.1k tokens (SKILL.md is roughly 17k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full.
What are the alternatives to Matlab Use Spreadsheet Link?
Skills that share tags, products or a category with Matlab Use Spreadsheet Link: Excel Unmerge Before Write (HKUDS/OpenSpace, 7.7k stars), Excel To Legend (shuotao/REVIT_MCP_study, 102 stars), Markitdown (ImCa0/just-laws, 781 stars) and Data Table Manager (n8n-io/n8n, 207k stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.
Who maintains Matlab Use Spreadsheet Link?
matlab (a GitHub organization) maintains it in matlab/matlab-agentic-toolkit, which has 1,140 GitHub stars. The repository holds 142 skills in this directory. The repository was last updated on October 7, 2026.
Source: matlab/matlab-agentic-toolkit on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.