skills.rest
duy-tung
duy-tungCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

ck:xlsx

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

Updated Jun 14, 2026
Search Tags:#financial modeling#data analysis#spreadsheet#excel#xlsx
One-click install
npx skills add https://github.com/duy-tung/claude-code-setup --skill ck-xlsx-duy-tung
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: ck:xlsx
Source: https://github.com/duy-tung/claude-code-setup/tree/main/claude/skills/document-skills/xlsx
Command: npx skills add https://github.com/duy-tung/claude-code-setup --skill ck-xlsx-duy-tung

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires pandas, openpyxl, python-dateutil, python-docx, libreoffice, and includes scripts (resource) and references (resource) and assets (resource) components.

What problem does it solve?

This Skill simplifies the creation, editing, and analysis of spreadsheets, saving time and reducing errors in data handling and financial modeling.

Core Features & Use Cases

  • Excel Functions: Utilize Excel's full power with custom formulas and formatting.
  • Data Analysis: Leverage pandas for in-depth data manipulation and visualization.
  • Financial Modeling: Implement robust color coding, number formatting, and formula rules for financial models.
  • Use Case: Create a detailed financial model with multiple sheets, including calculations for revenue, expenses, and cash flow projections. This Skill ensures accurate, consistent, and easy-to-understand outputs.

Quick Start

Use the 'ck:xlsx' skill to create a financial model for the next fiscal year with key metrics and charts.

Frequently Asked Questions about ck:xlsx

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

FAQPage Schema
How do I automate financial modeling in Excel spreadsheets?▼

Automate spreadsheet creation for financial modeling by leveraging Python libraries like pandas and openpyxl to generate multi-sheet files with revenue, expense, and cash flow calculations. This approach applies robust color coding, number formatting, and formula rules to ensure accurate and consistent outputs.

Can I use pandas and openpyxl to edit and analyze .xlsx files?▼

Yes, you can edit and analyze .xlsx files using pandas and openpyxl to perform in-depth data manipulation, validation, and formatting. This enables streamlined spreadsheet automation and detailed data analysis directly within Python workflows.

Do I need LibreOffice to recalculate Excel formulas in Python?▼

Yes, LibreOffice is required to execute formula recalculations when generating or updating .xlsx files. It works alongside openpyxl and pandas to ensure that custom formulas and financial calculations are computed accurately before output.

What is the best way to format financial data and apply validation rules to spreadsheets?▼

The best way to format financial data and apply validation rules is using openpyxl to implement robust color coding, number formatting, and formula rules. This ensures your financial models are accurate, consistent, and easy to understand.

Does spreadsheet automation with Python support custom Excel functions and charts?▼

Yes, spreadsheet automation with Python supports custom Excel functions and charts by utilizing openpyxl for formulas and pandas for data visualization. You can create detailed financial models with key metrics and visual outputs for fiscal year projections.

Related Skills

Explore More Finance & Accounting Skills→
KanishKumar11KanishKumar11

xlsx

Manage and analyze Excel files using Python libraries.

Community
Advanced
Xza85hrfXza85hrf

doc-generation

Generate branded DOCX, PPTX, PDF, and XLSX documents from structured data.

Community
Intermediate
patriotnewsactivismpatriotnewsactivism
2

excel-generator

Generate Excel spreadsheets with formatting, formulas, charts, and data validation.

Community
Advanced
safzanpiranisafzanpirani
1

xlsx

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

Community
Advanced