skills.rest
autonomous-ai
autonomous-aiOFFICIAL
Explore all skills by this author →
Website𝕏@autonomous_labsGitHub

sheetsdoc

Generate editable DOCX reports, formula-driven XLSX workbooks, and PDF previews from structured JSON source.

465|41|Updated Aug 4, 2026
Search Tags:#pdf#report generation#document automation#xlsx#docx#libreoffice#ooxml
One-click install
npx skills add https://github.com/autonomous-ai/openharness --skill sheetsdoc-autonomous-ai
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: sheetsdoc
Source: https://github.com/autonomous-ai/openharness/tree/main/store/agents/sheet-docs/skills/sheetsdoc
Command: npx skills add https://github.com/autonomous-ai/openharness --skill sheetsdoc-autonomous-ai

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) components.

What problem does it solve? Manually keeping a Word report, an Excel workbook, and a PDF preview in sync is error-prone: totals get typed twice, formulas drift from prose, and stale PDFs get shared. This Skill builds all three deliverables from a single structured doc.json source so numbers, narrative, and previews always reconcile. ## Core Features & Use Cases - Shared-source document generation: One doc.json drives an editable DOCX report, a formula-driven XLSX workbook (SUM, subtraction, guarded growth formulas), and a fresh LibreOffice-rendered PDF preview. - Comparison and generic modes: Build a two-period regional revenue comparison with derived totals, growth, and narrative prose, or a generic literal-data report from rectangular sheet rows (1-10 columns, up to 1,000 rows). - Verified export pipeline: The build re-saves the workbook through LibreOffice to recalculate formulas, validates the fresh PDF, and writes verdict and export receipts to .harness. - Use Case: A finance analyst edits doc.json with quarterly regional revenue in USD, runs the export script, and hands off a coordinated Word report, recalculated spreadsheet, and PDF preview for review. ## Quick Start Edit doc.json with your comparison periods, currency, and regional revenue rows, then ask the agent to run the sheetsdoc export script and inspect the generated DOCX, XLSX, and PDF.

Frequently Asked Questions about sheetsdoc

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

FAQPage Schema
How do I generate a Word report and Excel workbook from the same data?▼

Define a single doc.json with title, paragraphs, and either comparison data or sheet rows, then run scripts/export.sh. The build writes out.docx and out.xlsx from that one source so totals and prose stay reconciled.

How do I create XLSX files with formulas without any npm dependencies?▼

The included ooxml.mjs is a zero-dependency pure-Node writer that produces valid OOXML workbooks with SUM, subtraction, and guarded growth formulas plus cached values. It uses only Node built-ins like zlib for ZIP packaging.

Does the PDF preview require LibreOffice?▼

Yes, the fresh PDF preview requires LibreOffice (or SOFFICE_BIN pointing to it) and Node 20+. Without LibreOffice the build still writes the DOCX and XLSX but exits incomplete rather than blessing an old PDF.

Can I edit the generated XLSX and have the report update automatically?▼

No, exports do not round-trip to source. Editing out.xlsx updates only its own formulas; to refresh the Word report and PDF together you must edit doc.json and rebuild.

What are the limitations of this document generator?▼

It supports comparison reports and generic rectangular sheets of 1-10 columns and up to 1,000 rows. Arbitrary user formulas, charts, PPTX output, and automated accounting-correctness claims are outside its scope.

Related Skills

Explore More Finance & Accounting Skills→
brainbrewlabsbrainbrewlabs
7

data-collection

Collect data from APIs, databases, and files into validated CSV, JSON, or Parquet outputs.

Official
Intermediate
opensquillaopensquilla
6.8k

meta-multi-format-export-pack

Renders one source content into docx, pptx, xlsx, and PDF deliverables.

Official
Intermediate
MaxDehautMaxDehaut

xlsx

Automates Excel workbook validation, repair, and formula recalculation for XLSX outputs.

Community
Advanced
omeraltnomeraltn

agency-document-generator

Generate branded PDF, PPTX, DOCX and XLSX files from structured data and templates.

Community
Intermediate