skills.rest
agent0ai
agent0aiOFFICIAL
Explore all skills by this author →
Website𝕏@Agent0aiGitHub

calc-spreadsheets

Creates and edits LibreOffice Calc ODS spreadsheets and XLSX workbooks via the office_artifact tool.

19.1k|3.8k|Updated Jun 10, 2024
Search Tags:#charts#XLSX#budget#ods#workbook#Spreadsheet#libreoffice calc
One-click install
npx skills add https://github.com/agent0ai/agent-zero --skill calc-spreadsheets
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: calc-spreadsheets
Source: https://github.com/agent0ai/agent-zero/tree/main/plugins/_office/skills/calc-spreadsheets
Command: npx skills add https://github.com/agent0ai/agent-zero --skill calc-spreadsheets

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

It lets you create and edit real spreadsheet files (ODS or XLSX) directly from a conversation, without manually opening LibreOffice Calc or writing spreadsheet code yourself.

Core Features & Use Cases

  • Workbook Creation: Create ODS spreadsheets from CSV, TSV, or Markdown table content, with XLSX reserved for explicit Excel compatibility needs.
  • Cell and Row Editing: Set individual cells, replace whole tables with rows, or append new records to an existing workbook.
  • Embedded Charts: Add charts to XLSX workbooks using the create_chart operation when Excel-compatible output is required.
  • Use Case: Ask for a budget workbook with item and amount columns, then refine it by appending new expense rows or updating specific cells.

Quick Start

Create an ODS spreadsheet titled Budget with columns Item and Amount and a first row for Platform at 1000.

Frequently Asked Questions about calc-spreadsheets

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

FAQPage Schema
How do I create a spreadsheet from a Markdown table?▼

Pass the Markdown table as the content field when calling office_artifact with action create and kind spreadsheet. The tool converts the table into real spreadsheet cells in an ODS or XLSX workbook.

When should I use ODS versus XLSX format?▼

Use ODS by default for spreadsheets, budgets, and editable tables. Use XLSX only when Excel compatibility is explicitly requested, an existing .xlsx file is provided, or embedded spreadsheet charts are needed.

How do I edit specific cells in an existing workbook?▼

Call office_artifact with action edit, the workbook file_id, and the set_cells operation, mapping addresses like Sheet1!A1 to values. Use rows for whole-table replacement or append_rows to add records.

Can I add charts to a spreadsheet?▼

Yes, use the create_chart operation with a chart object when working in XLSX format. For ODS chart workflows not covered by direct editing, use the Calc desktop application or code execution instead.

Does creating a spreadsheet open the Calc desktop automatically?▼

No, creating or editing a workbook saves the file without opening a document modal or desktop surface. The Calc desktop is only used for explicit GUI requests or final visual confirmation.

Related Skills

Explore More Data & Analytics Skills→
datheredathere
3.7k

data-clean

Cleans CSV, TSV, and Excel files by normalizing headers and removing duplicates.

Official
Intermediate
MuzeWinterMuzeWinter
1

report-to-google-slides

Convert HTML analytics reports into editable PPTX decks for Google Slides.

Community
Advanced
jonnytacos8jonnytacos8

excel-table-summarize

Summarize key figures and trends from SharePoint Excel tables using rag_search.

Community
Intermediate
J-StaR-Films-StudiosJ-StaR-Films-Studios
23

xlsx

Create, edit, and analyze Excel files with pandas and openpyxl.

Official
Advanced