First read the real input, then choose a process according to the following relevant categories. The example data in the tables does not represent actual business facts. Each item creates a new empty file by default and does not directly overwrite the original.
- finance: 2 items: quote details, discounts and tax amounts, product gross margin and zero-revenue boundary.
- operations: 4 items: replenishment list for inventory below the safety line, expense reimbursement over-limit review, delivery acceptance ratio and missing items, project task table structuring and frozen headers.
- analysis: 4 items: supplier multi-dimensional weighted scoring, sales ranking with entire rows kept corresponding, sales region summary and chart creation, monthly growth rate and zero-base-period handling.
- quality: 2 items: order duplicate key marking without deleting records, controlled-state dropdown entry.
Invocation and Session
When the host has already opened the embedded editor, use that same MCP session and wait for editor_status to be ready; after reading the host tool schema, execute one by one with run_command {"command":"方法ID","params":{…}} . Tool names and parameters differ due to host adaptation; changes to standalone CLI files cannot be called same-screen editing.
Standalone CLI syntax:gridcraft-cli run --cmd <id=JSON> --out output.xlsx --quiet. Each --cmd value is a single argv parameter consisting of the method ID, an equals sign, and a JSON object. Put the entire group of steps in the same run to avoid losing the cursor, current table, or graphic selection. Use the 0.7.0 native CLI command catalog as the observation basis; query the actual version and schema before execution. After saving, reopen in a new process and check the content, formulas, or objects; export formats are checked separately.
Structured StepsObservable assertions including test input;Command Evidenceproves the method was observed under a fixed runtime, not that the scenario effect has been accepted.Source and Licenserecords the GitHub workflow facts drawn upon; the body text and parameter examples are original adaptations, and no external Office scripts were executed.
gridcraft-cli cat returns a formatted display value, for example 35.0%. To read the calculated value, execute sheet.read {"range":"E2","formulas":false,"formatted":false}in the run; to read the formula, call formulas:trueseparately; do not parse display text into the underlying amount or ratio.
Skill Store Scenario Experience
When encountering a quote model that must remain recalculable, marking duplicates without losing records, or the zero-base-period boundary of a growth rate, readStore Workflow Adaptation, and use the corresponding Craft method and actual result checks. Upstream skills are not a runtime dependency.
Fillable Office Template Development Candidates
- Cross-midnight shift hours and missing-row verification: hand over to the gridcraft-shift-timesheet skill. Standalone installation:
npx skills add full-aigc-skills/gridcraft-skills --skill gridcraft-shift-timesheet。 - Fixed nominal annual interest rate equal monthly payment, zero interest rate, and invalid period count checks: hand over to the gridcraft-fixed-payment skill. Standalone installation:
npx skills add full-aigc-skills/gridcraft-skills --skill gridcraft-fixed-payment。 - Monthly calendar template starting on Monday, leap years, and adjacent-month dates: hand over to the gridcraft-month-calendar skill. Standalone installation:
npx skills add full-aigc-skills/gridcraft-skills --skill gridcraft-month-calendar。
This batch consists of development candidates and has not yet entered a new version of the main marketplace; the three items use newly created worksheets for this task and do not overwrite the original sheets. See each skill for the input area, formula checks, and capability boundaries; actual business and host synchronization still require acceptance.