skills.rest
Mhafis99
Mhafis99COMMUNITY
Explore all skills by this author →
GitHub

xlsx

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
One-click install
npx skills add https://github.com/Mhafis99/manajemen-keuangan --skill xlsx-mhafis99
Or copy as Structured Prompt for Agent▼
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.

Related Skills

Explore More Data & Analytics Skills→
nq-rdlnq-rdl

xlsx

Process and validate Excel-compatible spreadsheet files across .xlsx, .xlsm, .csv, and .tsv formats.

Official
Advanced
shalevaminshalevamin

spreadsheet

Create, edit, analyze, and format .xlsx, .csv, and .tsv spreadsheet files.

Community
Intermediate
OpenCoworkAIOpenCoworkAI
2.0k

xlsx

Create and edit Excel workbooks with formulas across .xlsx, .xlsm, .csv, and .tsv formats.

Official
Advanced
ChatAndBuildChatAndBuild
1

xlsx

Automate Excel spreadsheet creation, editing, and analysis with pandas and openpyxl.

Official
Advanced