skills.rest
nathankoerschner
nathankoerschnerCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

spreadsheets

Create and edit spreadsheet workbooks using the @oai/artifact-tool JavaScript surface.

Updated Jan 22, 2024
Search Tags:#javascript#reporting#spreadsheet#excel#data manipulation#workbook
One-click install
npx skills add https://github.com/nathankoerschner/dotfiles --skill spreadsheets-nathankoerschner
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: spreadsheets
Source: https://github.com/nathankoerschner/dotfiles/tree/main/agent-skills/_shared-skills/.system/spreadsheets
Command: npx skills add https://github.com/nathankoerschner/dotfiles --skill spreadsheets-nathankoerschner

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill automates the creation and modification of spreadsheet workbooks, streamlining data organization and analysis.

Core Features & Use Cases

  • Workbook Creation: Generate new spreadsheets from scratch using JavaScript.
  • Data Manipulation: Add, edit, and recalculate values and formulas within sheets.
  • Import/Export: Load existing workbooks and export them in various formats.
  • Use Case: Automatically generate a monthly sales report by creating a new workbook, populating it with data, calculating totals, and saving it as an Excel file.

Quick Start

Use the artifacts tool to create a new workbook, add a sheet named 'Sales', and populate cell A1 with the value 'Hello World'.

Frequently Asked Questions about spreadsheets

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I create and populate an Excel workbook using JavaScript?▼

To create and populate an Excel workbook using JavaScript, this Skill utilizes the preloaded @oai/artifact-tool surface to generate new spreadsheets, manage worksheet operations, and populate cell ranges with values and formulas.

Can I import an existing spreadsheet, edit cell values, and recalculate formulas?▼

Yes, you can import an existing spreadsheet, edit cell values, and recalculate formulas. The Skill operates on raw JavaScript with named exports like Workbook to manage the full workbook lifecycle and data manipulation.

What is the best way to automate generating a monthly sales report as an Excel file?▼

The best way to automate generating a monthly sales report is using this Skill to create a new workbook, populate it with sales data, calculate totals with formulas, and export the final result as an Excel file.

Does this spreadsheet manipulation tool support embedding charts and images for data visualization?▼

Yes, this spreadsheet manipulation tool supports embedding charts and images for data visualization. It handles cell range manipulation and chart embedding to facilitate comprehensive data analysis and reporting.

What JavaScript exports and components are needed for deterministic workbook task execution?▼

Deterministic workbook task execution requires using raw JavaScript supporting named exports like Workbook, SpreadsheetFile, and FileBlob through the preloaded @oai/artifact-tool JavaScript surface.

Related Skills

Explore More Data & Analytics Skills→
nathankoerschnernathankoerschner

slides

Create, edit, and export presentation decks with JavaScript and @oai/artifact-tool.

Community
Advanced
ChoshimWyChoshimWy
8

excel

Automate creation, modification, and analysis of Excel-compatible workbooks.

Community
Advanced
jonathan-vellajonathan-vella
6

python-diagrams

Automates Azure environment diagrams and charts using Python libraries and Graphviz.

Community
Intermediate
xpert-aixpert-ai
8

spreadsheets

Create and modify .xlsx, .xls, .csv, and .tsv spreadsheets with formulas and charts.

Official
Advanced