xlsx

Name: xlsx
Availability: InStock
Author: mhafis99

Create, edit, and analyze Excel workbooks while preserving formulas via openpyxl and LibreOffice.

Updated Jan 5, 2026

Search Tags:#automation #formulas #spreadsheet #excel #data-analysis #xlsx

Ready to run

npx skills add https://github.com/Mhafis99/manajemen-keuangan --skill xlsx-mhafis99

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/Mhafis99/manajemen-keuangan/tree/main/menejemenkeuanganarsm/skills/xlsx
Command: npx skills add https://github.com/Mhafis99/manajemen-keuangan --skill xlsx-mhafis99

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Spreadsheets are central to many workflows, but manual workbook creation, inconsistent formatting, and formula maintenance slow progress and introduce errors. This Skill automates creating, editing, and analyzing spreadsheets while preserving formulas and templates, reducing repetitive toil and mistakes.

Core Features & Use Cases

Formula-preserving editing: Modify workbooks without breaking existing formulas or references.
Template-aware creation: Generate new spreadsheets with consistent formatting and predefined structures.
Data analysis & visualization: Perform quick analyses and generate charts or summaries from data in Excel formats.

Quick Start

Create a new workbook, add a simple formula, and verify the results recalculated when data changes.

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 breaking existing formulas?▼

Automating Excel workbook creation while preserving formulas requires modifying cells without overwriting formula references. This Skill uses openpyxl operations to edit spreadsheets and LibreOffice for formula recalculation, ensuring existing formulas and templates remain intact during modifications.

What is the best way to perform data analysis and visualization on xlsx files?▼

Data analysis and visualization on xlsx files involves reading workbook data and generating charts or summaries. This Skill automates quick analyses and creates visualizations directly from Excel-compatible formats, applying standardized formatting to maintain consistent reporting outputs.

Can I use openpyxl to generate new spreadsheets with data validation and standardized formatting?▼

Yes, generating new spreadsheets with data validation and standardized formatting is supported via openpyxl. This Skill enables template-aware creation, applying predefined structures and error-checking rules to new Excel workbooks for consistent data entry.

Does this approach recalculate formulas automatically when data changes in an Excel workbook?▼

Yes, recalculating formulas when data changes in an Excel workbook is handled via LibreOffice. This Skill integrates openpyxl for editing with LibreOffice-based formula recalculation, ensuring computed values update accurately after modifications are applied.

Why do my spreadsheet formulas break when automating workbook edits?▼

Spreadsheet formulas break during automation when editing operations overwrite formula references instead of updating values. This Skill prevents formula loss by preserving formulas during modifications, using openpyxl to apply changes without disrupting existing workbook logic.