skills.rest
71261121
71261121COMMUNITY
Explore all skills by this author →
GitHub

xlsx

Create, edit, and analyze Excel spreadsheet files with formulas and formatting.

Updated Dec 14, 2025
Search Tags:#reporting#data analysis#pandas#openpyxl#formulas#spreadsheet#excel
One-click install
npx skills add https://github.com/71261121/auto-jarvis- --skill xlsx-71261121
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/71261121/auto-jarvis-/tree/main/skills/xlsx
Command: npx skills add https://github.com/71261121/auto-jarvis- --skill xlsx-71261121

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill automates the creation, editing, and analysis of spreadsheet files, handling complex formulas, formatting, and data manipulation efficiently.

Core Features & Use Cases

  • Spreadsheet Creation: Generate new .xlsx files with custom formulas, styles, and data.
  • Data Analysis & Visualization: Use pandas for data processing and create charts within spreadsheets.
  • Formula Recalculation & Verification: Ensure all formulas are error-free using LibreOffice integration.
  • Use Case: Automatically generate a monthly sales report in Excel, including complex financial formulas, specific formatting, and data visualizations, ensuring all calculations are accurate and verified.

Quick Start

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

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I automate Excel spreadsheet creation with formulas and formatting?▼

Automate Excel spreadsheet creation by using openpyxl to define formulas, apply custom styles, and populate data structures. Generate new .xlsx files programmatically to ensure consistent formatting and accurate formula deployment across financial reports.

How do I verify Excel formulas and recalculate them in bulk?▼

Verify Excel formulas and recalculate them in bulk by integrating LibreOffice. This process ensures all complex spreadsheet calculations are error-free and accurately evaluated before finalizing financial models or data reports.

Can I use pandas for data analysis and visualization in xlsx files?▼

Use pandas for data analysis and visualization in xlsx files by processing raw data and generating embedded charts. This approach combines pandas data manipulation capabilities with openpyxl formatting to produce enriched spreadsheet outputs.

Does this approach support financial modeling with standard color coding?▼

Financial modeling with standard color coding is fully supported. Apply industry-standard formatting rules to spreadsheets using openpyxl, ensuring financial data presentations meet professional reporting and modeling aesthetics.

What is the best way to edit existing .xlsx and .csv files for reporting?▼

The best way to edit existing .xlsx and .csv files for reporting involves using openpyxl for structural changes and pandas for data transformation. This combination handles diverse formats including .xlsm, .tsv for comprehensive data management.

Related Skills

Explore More Data & Analytics Skills→
thanhquan3010thanhquan3010

spreadsheet

Automate creation, editing, and analysis of spreadsheet files with formulas.

Community
Intermediate
4tie4tie

excel-generator

Generate Excel workbooks and Google Sheets with formulas, charts, and PDF exports.

Community
Advanced
patriotnewsactivismpatriotnewsactivism
2

excel-generator

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

Community
Advanced
zizhenchen47-osszizhenchen47-oss

xlsx

Create, edit, and convert spreadsheet files while preserving formulas and formatting.

Community
Advanced