skills.rest
kaustubhhiware
kaustubhhiwareCOMMUNITY
Explore all skills by this author →
Website𝕏@_ofkausGitHub

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

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
shuyu-labsshuyu-labs
288

office-to-md

Convert Word, Excel, PowerPoint, and PDF documents to Markdown with preserved headings, tables, and images.

Official
Advanced
dirnbauerdirnbauer
33

document-processing

Create, extract from, and analyze PDF, DOCX, PPTX, and XLSX office documents using Python and JavaScript libraries.

Community
Advanced
Qiue-GQiue-G

xlsx

Process and transform spreadsheet data across .xlsx, .xlsm, .csv, and .tsv formats.

Community
Advanced