skills.rest
wedsamuel1230
wedsamuel1230COMMUNITY
Explore all skills by this author →
GitHub

xlsx

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

1|Updated Jan 5, 2026
Search Tags:#automation#Excel#openpyxl#formulas#spreadsheet#data-analysis#xlsx
One-click install
npx skills add https://github.com/wedsamuel1230/electronic-mcp-server --skill xlsx-wedsamuel1230
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/wedsamuel1230/electronic-mcp-server/tree/main/.github/skills/xlsx
Command: npx skills add https://github.com/wedsamuel1230/electronic-mcp-server --skill xlsx-wedsamuel1230

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill helps users automate the creation, editing, and analysis of Excel workbooks, reducing manual workbook maintenance and errors.

Core Features & Use Cases

  • Workbook creation: Generate new spreadsheets with formulas and formatting.
  • Template preservation: Reuse and respect existing templates and styles when updating workbooks.
  • Data analysis & visualization: Read, analyze, and visualize data across sheets for reporting and decision making.
  • Use Case: Imagine you receive hundreds of financial reports in XLSX format; this Skill creates consolidated workbooks, recalculates formulas, and outputs clean results in a single file.

Quick Start

Run the skill to create a new spreadsheet with a basic sales dashboard from a provided template.

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 and formula recalculation?▼

Automate Excel workbook creation and formula recalculation by using Python libraries like openpyxl for spreadsheet manipulation and a LibreOffice-based workflow to ensure formulas evaluate correctly.

Can I preserve existing Excel templates and styles when updating spreadsheets?▼

Yes, you can preserve existing Excel templates and styles. The solution respects and reuses current templates during workbook updates, maintaining original formatting while injecting new data and formulas.

What is the best way to consolidate multiple financial reports into a single XLSX file?▼

Consolidate financial reports by reading data across multiple XLSX sheets, merging them into a single workbook, recalculating formulas, and outputting clean results for financial reporting and analysis.

Does openpyxl correctly evaluate Excel formulas automatically?▼

openpyxl creates and edits workbook formulas but does not evaluate them automatically. A LibreOffice-based recalculation workflow is required to ensure all spreadsheet formulas are correctly evaluated and calculated.

How to generate a dashboard from an Excel spreadsheet template?▼

Generate a dashboard by running the skill to apply a provided template, inserting data and formulas into the new spreadsheet, and recalculating values to produce a formatted sales dashboard output.

What are the limitations of using Python for spreadsheet data analysis?▼

Python spreadsheet data analysis requires openpyxl for manipulation and relies on a LibreOffice-based recalculation workflow for formulas, meaning it needs specific environment setup rather than native Excel execution.

Related Skills

Explore More Data & Analytics Skills→
cbbkrd-techcbbkrd-tech

xlsx

Create, edit, and analyze .xlsx, .xlsm, .csv, and .tsv files with pandas and openpyxl.

Community
Advanced
pascallammerspascallammers
1

document-processing-xlsx

Creates, parses, and manipulates Excel spreadsheets (.xlsx, .xls) using SheetJS.

Community
Intermediate
MunreaderMunreader

xlsx

Create and edit Excel spreadsheets with formulas, charts, and data analysis.

Community
Intermediate
mattismyname3011mattismyname3011

xlsx

Automate spreadsheet creation, editing, and analysis across .xlsx, .csv, and .tsv files.

Community
Advanced