skills.rest
frankxai
frankxaiCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

xlsx

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

7|1|Updated Jan 8, 2026
Search Tags:#data analysis#pandas#openpyxl#formulas#spreadsheet#excel#xlsx
One-click install
npx skills add https://github.com/frankxai/agentic-creator-os --skill xlsx-frankxai
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/frankxai/agentic-creator-os/tree/main/.claude/skills/xlsx
Command: npx skills add https://github.com/frankxai/agentic-creator-os --skill xlsx-frankxai

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill streamlines the creation, editing, and analysis of spreadsheet files, ensuring accuracy, proper formatting, and efficient data handling.

Core Features & Use Cases

  • Spreadsheet Creation & Editing: Generate new .xlsx files or modify existing ones with data, formulas, and formatting.
  • Formula Management: Ensures all formulas are correctly implemented and recalculates them using LibreOffice.
  • Data Analysis & Visualization: Leverages pandas for in-depth data analysis and preparation for visualization.
  • Use Case: Automatically generate a financial projection spreadsheet with industry-standard formatting and formulas, or analyze sales data from an existing CSV to identify trends.

Quick Start

Use the xlsx skill to create a new spreadsheet named 'sales_report.xlsx' with columns for 'Date', 'Product', and 'Revenue', and populate it with the provided sales data.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I create and edit Excel files with formulas using Python?▼

You can create and edit .xlsx, .xlsm, .csv, and .tsv files by leveraging openpyxl for spreadsheet manipulation and LibreOffice for formula recalculation, ensuring zero formula errors and proper formatting.

Can I analyze spreadsheet data with pandas while preserving existing Excel templates?▼

Yes, you can use pandas for in-depth data analysis on existing spreadsheet data while relying on openpyxl to preserve the original Excel templates, formatting, and structures during modification.

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

Yes, LibreOffice is required specifically for formula recalculation and validation, ensuring that all formulas implemented in your .xlsx or .xlsm files are computed correctly without errors.

What's the best way to automate financial projections in an Excel file?▼

Automate financial projections by generating new .xlsx files populated with data, applying industry-standard formatting, and implementing formulas that are automatically recalculated and validated via LibreOffice.

Does this approach support analyzing sales data from CSV and TSV files?▼

Yes, it supports reading and analyzing sales data from CSV and TSV files using pandas for trend identification, while also supporting creation and editing of standard Excel formats like .xlsx and .xlsm.

Why do my Excel formulas return errors when edited programmatically?▼

Formulas often return errors when not recalculated after programmatic editing; this tool requires LibreOffice to recalculate and validate formulas, ensuring zero errors and accurate data outputs.

Related Skills

Explore More Finance & Accounting Skills→
ronniwheellike973ronniwheellike973
2

xlsx

Manage and analyze .xlsx files with pandas, openpyxl, and formula recalculation.

Community
Advanced
patriotnewsactivismpatriotnewsactivism
2

excel-generator

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

Community
Advanced
aiyinluyaaiyinluya
2

multi-file-excel-parquet-analysis

Count rows across Excel sheets and generate categorical statistics with Parquet.

Community
Intermediate
vinayakgvinayakg

xlsx

Create and edit Excel files with formulas, formatting, and pandas analysis.

Community
Advanced