skills.rest
F1shift
F1shiftCOMMUNITY
Explore all skills by this author →
GitHub

xlsx

Create, modify, and analyze .xlsx files with Python and openpyxl.

Updated Jan 22, 2026
Search Tags:#data analysis#Excel#pandas#formulas#spreadsheet
One-click install
npx skills add https://github.com/F1shift/build-aws-infra-with-AI-demo-with-cc-sdd --skill xlsx-f1shift
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/F1shift/build-aws-infra-with-AI-demo-with-cc-sdd/tree/main/.gemini/skills/xlsx
Command: npx skills add https://github.com/F1shift/build-aws-infra-with-AI-demo-with-cc-sdd --skill xlsx-f1shift

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill addresses the challenges of working with Excel files by enabling users to create, edit, analyze, and visualize spreadsheet data efficiently, while ensuring data accuracy and formula integrity.

Core Features & Use Cases

  • Comprehensive Spreadsheet Management: Offers the ability to create, modify, and analyze .xlsx files.
  • Formula Recalculation and Verification: Ensures that formulas are correctly set up and that all cells calculate correctly, even with data changes.
  • Data Analysis with pandas: Utilizes pandas for advanced data manipulation and analysis, enabling complex calculations and visualization directly within Excel.

Quick Start

Utilize the xlsx skill to generate a new workbook with formulas and formatting based on a sample input 'example.xlsx'.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I validate and recalculate Excel formulas after modifying spreadsheet data?▼

To validate Excel formulas, this Skill verifies cell setups and recalculates values automatically when data changes, ensuring spreadsheet formula integrity and accurate calculation results across your workbook.

Can I use pandas for advanced data analysis directly within Excel files?▼

Yes, you can use pandas for advanced data analysis directly within Excel files. This Skill utilizes pandas alongside openpyxl to perform complex data manipulation and calculations on spreadsheet data.

Does openpyxl support creating and modifying .xlsx files for business users?▼

Yes, openpyxl supports creating and modifying .xlsx files for business users. This Skill leverages openpyxl to handle comprehensive spreadsheet operations, including workbook generation and data manipulation.

What is the best way to automate spreadsheet creation and data visualization for financial analysis?▼

The best way to automate spreadsheet creation and data visualization for financial analysis is using this Skill, which generates formatted workbooks and enables complex visualizations directly within Excel files.

Why does LibreOffice need to be installed for Excel file operations?▼

LibreOffice needs to be installed because this Skill relies on it to handle specific spreadsheet recalculations and processing tasks, ensuring accurate formula verification and data handling within the workflow.

Related Skills

Explore More Finance & Accounting Skills→
caobingshengcaobingsheng
1

xlsx

Open, edit, and generate spreadsheet files in .xlsx, .xlsm, .csv, and .tsv formats.

Community
Intermediate
claude-office-skillsclaude-office-skills
368

data-analysis

Analyze Excel or CSV spreadsheet data to generate insights, visualizations, and reports.

Official
Intermediate
patriotnewsactivismpatriotnewsactivism
2

excel-generator

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

Community
Advanced
fefogarciafefogarcia
1

business-intelligence

Design interactive dashboards, automate reports, and define strategic KPIs.

Community
Advanced