xlsx

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

Updated Jan 11, 2017

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

Ready to run

npx skills add https://github.com/kaustubhhiware/dotfiles --skill xlsx-kaustubhhiware

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/kaustubhhiware/dotfiles/tree/main/claude/plugins/marketplaces/anthropic-agent-skills/skills/xlsx
Command: npx skills add https://github.com/kaustubhhiware/dotfiles --skill xlsx-kaustubhhiware

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires openpyxl, pandas, python-docx, python-pptx, lxml, defusedxml, and includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill streamlines spreadsheet management by automating the creation, editing, and analysis of Excel files, eliminating manual data manipulation and complex formula errors.

Core Features & Use Cases

Dynamic Formula Creation: Generates Excel formulas instead of hardcoding values, ensuring spreadsheets remain updateable.
Data Analysis & Manipulation: Leverages pandas for data cleaning, transformation, and analysis within Excel files.
Use Case: Convert messy CSV data into a clean, professional Excel report with correct formulas and formatting, or automate the creation of financial models based on user-provided assumptions.

Quick Start

Use the xlsx skill to create a new Excel file named 'sales_report.xlsx' with columns for 'Date', 'Product', and 'Revenue'.

Frequently Asked Questions about xlsx

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

FAQPage Schema

How do I automate Excel file creation and add dynamic formulas with pandas?▼

This Skill automates Excel file creation by generating dynamic formulas and manipulating data with pandas. It produces updateable spreadsheets without hardcoding values, ensuring professional formatting and zero formula errors.

What is the best way to clean messy CSV data and convert it to a formatted Excel report?▼

Cleaning messy CSV data is handled by this Skill's pandas integration, which transforms and analyzes tabular data before exporting a professional Excel report with correct formulas and formatting.

Does openpyxl support charting data and computing formulas in Excel files?▼

Yes, openpyxl supports charting data and computing formulas. This Skill leverages openpyxl and pandas to automate cell formatting, data manipulation, and dynamic formula creation within Excel files.

Do I need LibreOffice to recalculate formulas in my Excel spreadsheets?▼

Yes, LibreOffice is required for formula recalculation. This Skill uses a recalc.py script dependent on LibreOffice to ensure all Excel deliverables have zero formula errors before final output.

Can I convert between different tabular file formats using Python automation?▼

Yes, you can convert between tabular file formats using this Skill. It automates format conversion between CSV and Excel by leveraging pandas and openpyxl to maintain professional formatting standards.