skills.rest
rafaelramosdf
rafaelramosdfCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

xlsx

Create, edit, and analyze spreadsheets while preserving formulas and formatting.

Updated Jan 21, 2026
Search Tags:#automation#pandas#openpyxl#formulas#spreadsheet#data-analysis#xlsx
One-click install
npx skills add https://github.com/rafaelramosdf/antigravity-agents --skill xlsx-rafaelramosdf
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/rafaelramosdf/antigravity-agents/tree/main/templates/agent-template-en/skills/xlsx
Command: npx skills add https://github.com/rafaelramosdf/antigravity-agents --skill xlsx-rafaelramosdf

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This skill eliminates tedious manual spreadsheet creation, editing, and analysis by providing a structured approach to building and maintaining complex Excel workbooks with formulas, formatting, and data visualization.

Core Features & Use Cases

  • Comprehensive spreadsheet creation, editing, and analysis with support for formulas, formatting, data analysis, and visualization
  • Preserve existing templates and formulas when updating workbooks to maintain consistency across revisions
  • Recalculate formulas and validate results using an integrated LibreOffice-based tool to ensure accuracy

Quick Start

Create a new spreadsheet from your data source using an existing template and apply the required formatting and formulas.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I automate spreadsheet creation and data analysis in Excel?▼

Automate spreadsheet creation and data analysis by using openpyxl and pandas to build workbooks, apply formatting, and preserve formulas. This streamlines financial modeling, data cleaning, and reporting workflows for .xlsx and .csv files.

Can I update an Excel template without overwriting existing formulas?▼

Yes, you can update an Excel template without overwriting existing formulas. The skill preserves existing templates, formulas, and formatting while editing workbooks, maintaining consistency across revisions.

How do I recalculate and validate formulas in an automated spreadsheet workflow?▼

Recalculate and validate formulas in an automated spreadsheet workflow using an integrated LibreOffice-based recalc tool. This ensures formula accuracy after editing workbooks with openpyxl and pandas.

Does this spreadsheet automation approach support both .xlsx and .csv formats?▼

Yes, this spreadsheet automation approach supports both .xlsx and .csv formats. It reads and writes data across these file formats while preserving formulas and enabling data visualization.

What is the best way to generate financial reports from spreadsheet data?▼

The best way to generate financial reports from spreadsheet data is to automate workbook creation using openpyxl and pandas. This allows you to apply formulas, formatting, and visualization directly to your data sources.

Related Skills

Explore More Data & Analytics Skills→
760485464760485464
229

xlsx

Automates spreadsheet editing, cleaning, and conversion across XLSX, CSV, TSV formats.

Community
Intermediate
4tie4tie

excel-generator

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

Community
Advanced
locdinh209locdinh209

xlsx

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

Community
Advanced
pchemguypchemguy

spreadsheet

Automate spreadsheet creation, editing, and analysis with openpyxl and pandas.

Community
Intermediate