skills.rest
Chai-Un
Chai-UnCOMMUNITY
Explore all skills by this author →
GitHub

xlsx

Create and edit Excel workbooks with formulas via a LibreOffice pipeline.

Updated Feb 2, 2026
Search Tags:#automation#Excel#openpyxl#formulas#xlsx#LibreOffice#recalculation
One-click install
npx skills add https://github.com/Chai-Un/wedding --skill xlsx-chai-un
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/Chai-Un/wedding/tree/main/.github/skills/xlsx
Command: npx skills add https://github.com/Chai-Un/wedding --skill xlsx-chai-un

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill automates the creation, editing, and analysis of Excel workbooks, eliminating tedious manual spreadsheet work and enabling repeatable data workflows.

Core Features & Use Cases

  • Workbook creation and formatting: programmatically generate new spreadsheets with formulas, styles, and layouts.
  • Formula-preserving edits: modify existing workbooks without destroying formulas or data integrity.
  • Data analysis and visualization: run calculations, generate summaries across sheets, and export results to CSV or charts for reporting.
  • Use Case: Imagine daily sales data in CSV you need turned into a consolidated Excel workbook with quarterly totals and a summary dashboard.

Quick Start

  • Create a new workbook named 'Sales_Q1.xlsx' with a 'Summary' sheet and a simple SUM formula, then recalculate formulas using the recalc.py script.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I automate Excel workbook creation without losing existing formulas?▼

Automating Excel workbook creation while preserving formulas requires an openpyxl-based pipeline that modifies sheets programmatically and recalculates them via LibreOffice. This ensures formulas and data integrity remain intact during repeatable sheet generation and batch processing.

Can I recalculate Excel formulas programmatically without opening Excel?▼

Yes, recalculating Excel formulas programmatically without opening Excel is possible using a LibreOffice-based recalculation pipeline. This allows headless formula evaluation and batch processing across multiple sheets for automated data workflows.

What's the best way to convert daily CSV data into a formatted Excel workbook with summaries?▼

The best way to convert CSV data into a formatted Excel workbook with summaries is through automated spreadsheet generation. You can programmatically apply styles, layouts, and Excel-like formulas to consolidate raw data into quarterly totals and summary dashboards.

Does openpyxl support formula-preserving edits for existing Excel templates?▼

Yes, openpyxl supports formula-preserving edits for existing Excel templates. It enables you to modify workbook content and apply updates across multiple sheets without destroying existing formulas, styles, or data integrity.

How do I run batch calculations and export results to CSV from multiple Excel sheets?▼

To run batch calculations and export results to CSV from multiple Excel sheets, use an automated pipeline that applies Excel-like formulas across sheets and recalculates them via LibreOffice. This enables headless data analysis and reporting exports.

Related Skills

Explore More Data & Analytics Skills→
jokken79jokken79

xlsx

Automate Excel workbook creation, editing, and analysis with formulas and formatting.

Community
Advanced
invariantlabs-aiinvariantlabs-ai
2.9k

xlsx

Create, edit, and analyze Excel workbooks with formula preservation and recalculation.

Official
Advanced
AndersHsuehAndersHsueh

xlsx

Create, edit, and analyze Excel workbooks with Python and LibreOffice recalculation.

Community
Advanced
Gull-StackGull-Stack

xlsx

Create, edit, and analyze Excel spreadsheets with formulas using Python.

Official
Advanced