spreadsheets by colonelpanic8/dotfiles
npx skills add https://github.com/colonelpanic8/dotfiles --skill spreadsheets当用户希望使用 artifacts 工具创建或修改工作簿时,请使用此技能。
artifacts 工具。type、interface 或 import type。import { ... } from "@oai/artifact-tool"。该包的接口已预加载。Workbook、SpreadsheetFile 和 FileBlob 可直接使用。广告位招租
在这里展示您的产品或服务
触达数万 AI 开发者,精准高效
artifactTool、artifacts 和 codexArtifacts 访问。artifacts/revenue-model.xlsx。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" }),是一个很好的质量保证步骤。references/workbook.md 用于工作簿生命周期和工作表基础。references/ranges.md 用于 A1 寻址、值、公式和格式设置。每周安装数
1
代码仓库
GitHub 星标数
210
首次出现
今天
安全审计
安装于
zencoder1
amp1
cline1
openclaw1
opencode1
cursor1
Use this skill when the user wants to create or modify workbooks with the artifacts tool.
artifacts tool.type, interface, or import type.import { ... } from "@oai/artifact-tool". The package surface is already preloaded.Workbook, SpreadsheetFile, and FileBlob are available directly.artifactTool, artifacts, and codexArtifacts.artifacts/revenue-model.xlsx.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").range.values and range.formulas, then call workbook.recalculate() before reading computed values.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 .await workbook.render({ sheet: index, format: "png" }) is a good QA step before handoff.references/workbook.md for workbook lifecycle and worksheet basics.references/ranges.md for A1 addressing, values, formulas, and formatting.Weekly Installs
1
Repository
GitHub Stars
210
First Seen
Today
Security Audits
Gen Agent Trust HubPassSocketPassSnykPass
Installed on
zencoder1
amp1
cline1
openclaw1
opencode1
cursor1
通过 LiteLLM 代理让 Claude Code 对接 GitHub Copilot 运行 | 高级变通方案指南
31,600 周安装
.xlsxsheet.images.add({ blob, contentType, anchor: { from: ..., to: ... } }). The blob payload shape is the reliable path..xlsx with await SpreadsheetFile.exportXlsx(workbook).