xlsx

Name: xlsx
Availability: InStock
Author: wearems_satoshi

Creates, edits, and analyzes spreadsheet files (.xlsx, .csv, .tsv) using Pandas, PyODBC, and OpenPyXL; regenerates formulas with LibreOffice.

Updated Aug 27, 2026

Search Tags:#reporting #data analysis #pandas #openpyxl #formulas #spreadsheet #excel

Ready to run

npx skills add https://github.com/wearemssatoshi/talent-intelligence-calculator2 --skill xlsx-wearemssatoshi

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/wearemssatoshi/talent-intelligence-calculator2/tree/main/.agent/skills/xlsx
Command: npx skills add https://github.com/wearemssatoshi/talent-intelligence-calculator2 --skill xlsx-wearemssatoshi

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill empowers users to effortlessly create, edit, and analyze spreadsheet files, transforming raw data into actionable insights and professional reports.

Core Features & Use Cases

Data Manipulation: Read, write, and modify Excel files using Python's pandas and openpyxl libraries.
Formula Management: Ensure all Excel formulas are correctly implemented and error-free, with automatic recalculation and verification.
Use Case: Automatically generate a monthly sales report by pulling data from multiple sources, applying complex financial formulas, formatting the output professionally, and ensuring zero formula errors.

Quick Start

Use the xlsx skill to create a new spreadsheet named 'sales_report.xlsx' with columns for 'Date', 'Revenue', and 'Profit'.

Frequently Asked Questions about xlsx

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

FAQPage Schema

How do I automate Excel formula calculation and recalculation in Python?▼

Automate Excel formula calculation by using openpyxl to implement formulas and a LibreOffice script to recalculate them, ensuring zero formula errors in .xlsx and .xlsm files. This guarantees correct values without manual recalculation.

What is the best way to clean messy spreadsheet data and format it professionally?▼

Clean messy spreadsheet data and format it professionally by using pandas for data analysis and openpyxl for formatting, ensuring professional font usage and preserving existing templates in your .xlsx, .csv, or .tsv files.

Can I convert between .csv, .tsv, and .xlsx tabular file formats automatically?▼

You can convert between .csv, .tsv, .xlsx, and .xlsm tabular file formats automatically. The Skill reads raw data using pandas and writes it to your desired output format while maintaining data integrity and structure.

Does openpyxl support modifying existing Excel templates without breaking formatting?▼

openpyxl supports modifying existing Excel templates without breaking formatting. The Skill ensures preservation of existing templates while adding columns, computing formulas, and applying professional font usage to your spreadsheets.

How do I generate a formatted Excel report from multiple data sources?▼

Generate a formatted Excel report from multiple data sources by pulling data with pandas, applying financial formulas with openpyxl, and formatting the output professionally. This handles everything from data manipulation to charting.

Why do my Excel formulas show errors after modifying the file with Python?▼

Excel formulas show errors after Python modification due to missing recalculation. The Skill solves this by using openpyxl for formula implementation and a dedicated LibreOffice recalculation script to verify and ensure zero formula errors.