skills.rest
rafaelcalleja
rafaelcallejaCOMMUNITY
Explore all skills by this author →
GitHub

xlsx

Create, edit, and analyze Excel spreadsheets with formula recalculation.

2|1|Updated Oct 11, 2025
Search Tags:#financial modeling#reporting#data analysis#Excel#xlsx#spreadsheet automation#Python scripting
One-click install
npx skills add https://github.com/rafaelcalleja/claude-market-place --skill xlsx-rafaelcalleja
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/rafaelcalleja/claude-market-place/tree/main/plugins/claudekit-skills/skills/document-skills/xlsx
Command: npx skills add https://github.com/rafaelcalleja/claude-market-place --skill xlsx-rafaelcalleja

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires openpyxl, and includes scripts (resource) components.

What problem does it solve?

Manually managing and analyzing data in Excel spreadsheets is prone to errors and time-consuming, especially for repetitive tasks. This skill automates spreadsheet operations, improving accuracy and efficiency.

Core Features & Use Cases

  • Spreadsheet Manipulation: Create, read, modify, and save Excel files programmatically.
  • Formula Recalculation: Automatically recalculate formulas within spreadsheets, ensuring data integrity.
  • Data Analysis: Extract, transform, and load data for reporting and insights, reducing manual data handling.
  • Automation of Repetitive Tasks: Streamline routine Excel-based workflows, freeing up valuable time.
  • Use Case: Automate the monthly sales report by pulling raw data into an Excel template, recalculating all pivot tables and charts, and then saving the updated report.

Quick Start

Use the xlsx skill to recalculate all formulas in the attached spreadsheet 'sales_data.xlsx'.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I automate recalculating formulas in Excel spreadsheets?▼

Automate formula recalculation by using openpyxl to programmatically modify Excel files, then invoke recalc.py with LibreOffice to ensure all formulas update and preserve data integrity without manual intervention.

Can I create and modify Excel workbooks with Python while keeping formulas intact?▼

Yes. openpyxl enables you to create new spreadsheets, apply formulas and formatting, and edit existing files while preserving template structure and formula logic across modifications.

What's the best way to extract and analyze data from Excel for reporting?▼

Extract data from Excel workbooks using openpyxl, transform and load it into your analysis pipeline, then recalculate pivot tables and charts to generate accurate, updated reports without manual data handling.

How do I streamline repetitive Excel workflows like monthly sales reports?▼

Automate routine tasks by pulling raw data into Excel templates with openpyxl, recalculating all formulas and charts using LibreOffice, and saving the updated report—eliminating manual steps and errors.

Does openpyxl support color formatting and standard number formats in Excel?▼

Yes. openpyxl applies standard color and number formatting to cells and ranges, ensuring consistent spreadsheet presentation and enforcing formula-based calculations across your workbooks.

Why should I recalculate formulas with LibreOffice instead of Excel directly?▼

LibreOffice-based recalculation via recalc.py ensures zero formula errors and cross-platform consistency when automating spreadsheet workflows, especially in headless or server environments without Excel installed.

Related Skills

Explore More Data & Analytics Skills→
zjy-devzjy-dev
2

xlsx

Create, edit, and analyze Excel files with pandas and openpyxl.

Community
Advanced
791994545791994545
4

xlsx

Automate Excel spreadsheet creation, manipulation, and analysis with Python libraries.

Community
Advanced
langbyyilangbyyi
96

xlsx

Create, edit, analyze, and validate Excel spreadsheet files with pandas and openpyxl.

Community
Advanced
Gull-StackGull-Stack

xlsx

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

Official
Advanced