spreadsheets 技能：使用 JavaScript 自动化创建和编辑 Excel 电子表格

spreadsheets by colonelpanic8/dotfiles

1 周安装量

210 GitHub Stars

GitHub

安装命令

npx skills add https://github.com/colonelpanic8/dotfiles --skill spreadsheets

办公软件自动化数据处理

🇨🇳中文介绍

电子表格

当用户希望使用 artifacts 工具创建或修改工作簿时，请使用此技能。

工具契约

使用 artifacts 工具。
仅发送原始 JavaScript。不要发送 JSON 对象、带引号的代码或 Markdown 代码块标记。
此工具在 Node 中运行纯 JavaScript，而非 TypeScript。请勿使用类型注解、type、interface 或 import type。
不要编写 import { ... } from "@oai/artifact-tool"。该包的接口已预加载。
命名导出如 Workbook、SpreadsheetFile 和 FileBlob 可直接使用。

广告位招租

在这里展示您的产品或服务

触达数万 AI 开发者，精准高效

联系我们

相关 Skills

FlyClaw：零登录航班聚合查询工具，Python实现多源航班信息与价格搜索

4,000,000 周安装

Azure RBAC 权限管理工具：查找最小角色、创建自定义角色与自动化分配

117,000 周安装

GitHub Actions 官方文档查询助手 - 精准解答 CI/CD 工作流问题

31,800 周安装

Skills CLI 使用指南：AI Agent 技能包管理器安装与管理教程

31,600 周安装

const workbook = Workbook.create();
const sheet = workbook.worksheets.add("Revenue");

sheet.getRange("A1:C1").values = [["Month", "Bookings", "ARR"]];
sheet.getRange("A2:C4").values = [
  ["Jan", 120000, 1440000],
  ["Feb", 135000, 1620000],
  ["Mar", 142000, 1704000],
];

sheet.getRange("E1").values = [["Quarter ARR"]];
sheet.getRange("E2").formulas = [["=SUM(C2:C4)"]];

workbook.recalculate();

const xlsxBlob = await SpreadsheetFile.exportXlsx(workbook);
await xlsxBlob.save("artifacts/revenue-model.xlsx");

使用 Workbook.create() 创建工作簿。
使用 await SpreadsheetFile.importXlsx(await FileBlob.load("book.xlsx")) 导入现有工作簿。
使用 workbook.worksheets.add(name) 添加工作表。
通过 sheet.getRange("A1:C10") 使用 A1 表示法定位单元格和区域。
设置 range.values 和 range.formulas，然后在读取计算值之前调用 workbook.recalculate()。
对于图表，建议先创建图表，然后在返回的对象上直接填充数据。实际上，可靠模式是：const chart = sheet.charts.add("line"); chart.setPosition("A10", "H24"); chart.title = "..."; chart.categories = [...]; const series = chart.series.add("Name"); series.values = [...];。其他一些图表构建风格可能会产生在内存中看起来有效，但导出到最终 .xlsx 文件中时变为空或隐藏的图表对象。
对于工作表图像，建议使用 sheet.images.add({ blob, contentType, anchor: { from: ..., to: ... } })。blob 载荷结构是可靠的途径。
使用 await SpreadsheetFile.exportXlsx(workbook) 导出 .xlsx 文件。

首先对工作簿结构进行建模：工作表、表头和关键公式。
当工作表需要保持可编辑性时，使用公式而不是复制计算值。
在导出或读取公式结果之前重新计算。
如果工作簿包含图表或图像，请在导出后验证布局，而不仅仅是在内存中。在交付之前，执行一次工作表级别的渲染过程，例如 await workbook.render({ sheet: index, format: "png" })，是一个很好的质量保证步骤。
检查绘图在实际工作表上的位置。合并的单元格和非常高的自动调整行可能会将可见内容推到很靠下的位置，因此质量保证不仅应确认图表存在，还应确认它出现在工作表上明显的位置。
编辑现有工作簿时，请先加载它并保留未受影响的工作表。

🇺🇸English

Spreadsheets

Use this skill when the user wants to create or modify workbooks with the artifacts tool.

Tool Contract

Use the artifacts tool.
Send raw JavaScript only. Do not send JSON objects, quoted code, or markdown fences.
This tool runs plain JavaScript in Node, not TypeScript. Do not use type annotations, type, interface, or import type.
Do not write import { ... } from "@oai/artifact-tool". The package surface is already preloaded.
Named exports such as Workbook, SpreadsheetFile, and FileBlob are available directly.
The full module is also available as artifactTool, artifacts, and codexArtifacts.
Save outputs under a user-visible path such as artifacts/revenue-model.xlsx.

Quick Start

const workbook = Workbook.create();
const sheet = workbook.worksheets.add("Revenue");

sheet.getRange("A1:C1").values = [["Month", "Bookings", "ARR"]];
sheet.getRange("A2:C4").values = [
  ["Jan", 120000, 1440000],
  ["Feb", 135000, 1620000],
  ["Mar", 142000, 1704000],
];

sheet.getRange("E1").values = [["Quarter ARR"]];
sheet.getRange("E2").formulas = [["=SUM(C2:C4)"]];

workbook.recalculate();

const xlsxBlob = await SpreadsheetFile.exportXlsx(workbook);
await xlsxBlob.save("artifacts/revenue-model.xlsx");

Common Patterns

Create a workbook with Workbook.create().
Import an existing workbook with await SpreadsheetFile.importXlsx(await FileBlob.load("book.xlsx")).
Add sheets with workbook.worksheets.add(name).
Address cells and ranges with A1 notation via sheet.getRange("A1:C10").
Set range.values and range.formulas, then call workbook.recalculate() before reading computed values.
For charts, prefer creating the chart first, then populating it directly on the returned object. In practice, the reliable pattern is const chart = sheet.charts.add("line"); chart.setPosition("A10", "H24"); chart.title = "..."; chart.categories = [...]; const series = chart.series.add("Name"); series.values = [...];. Some other chart-construction styles can produce workbook objects that look valid in memory but export to empty or hidden charts in the final .

Workflow

Model the workbook structure first: sheets, headers, and key formulas.
Use formulas instead of copying computed values when the sheet should remain editable.
Recalculate before exporting or reading formula results.
If the workbook includes charts or images, verify layout after export, not just in memory. A sheet-level render pass such as await workbook.render({ sheet: index, format: "png" }) is a good QA step before handoff.
Check where drawings land on the actual sheet. Merged cells and very tall autofit rows can push visible content far below the fold, so QA should confirm not only that a chart exists, but that it appears in an obvious on-sheet location.
When editing an existing workbook, load it first and preserve unaffected sheets.

Reference Map

references/workbook.md for workbook lifecycle and worksheet basics.
references/ranges.md for A1 addressing, values, formulas, and formatting.

Weekly Installs

Repository

colonelpanic8/dotfiles

GitHub Stars

210

First Seen

Today

Security Audits

Gen Agent Trust HubPass SocketPass SnykPass

Installed on

zencoder1

amp1

cline1

openclaw1

opencode1

cursor1