skills.rest
LuisSambrano
LuisSambranoCOMMUNITY
Explore all skills by this author →
𝕏@luissambrano_uxGitHub

xlsx-ops

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

7|2|Updated Jan 28, 2026
Search Tags:#data analysis#pandas#openpyxl#formulas#spreadsheet#excel#xlsx
One-click install
npx skills add https://github.com/LuisSambrano/antigravity-config --skill xlsx-ops
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx-ops
Source: https://github.com/LuisSambrano/antigravity-config/tree/main/skills/10-tools/xlsx-ops
Command: npx skills add https://github.com/LuisSambrano/antigravity-config --skill xlsx-ops

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill automates the creation, modification, and analysis of spreadsheet files (.xlsx), eliminating manual data entry and complex formula calculations.

Core Features & Use Cases

  • Dynamic Spreadsheet Creation: Generate new Excel files with data, formulas, and formatting.
  • Data Analysis & Manipulation: Read, analyze, and transform data within spreadsheets using pandas.
  • Formula Preservation & Recalculation: Ensure formulas are correctly implemented and recalculated using LibreOffice.
  • Use Case: Automatically generate a monthly sales report by pulling data from a database, applying financial formulas, and formatting it according to industry standards.

Quick Start

Use the xlsx-ops skill to create a new spreadsheet named 'sales_report.xlsx' with columns 'Product', 'Quantity', and 'Price', and add a formula to calculate the total sales in the last column.

Frequently Asked Questions about xlsx-ops

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

FAQPage Schema
How do I automate Excel formula recalculation when modifying xlsx files?▼

To automate Excel formula recalculation, this Skill modifies xlsx files and uses LibreOffice to recalculate formulas, ensuring zero formula errors while preserving existing templates and formatting.

Can I use pandas for spreadsheet data analysis and manipulation on existing xlsx files?▼

Yes, you can use pandas for spreadsheet data analysis. This Skill reads, analyzes, and transforms data within existing Excel files (.xlsx, .xlsm, .csv, .tsv) using the pandas library.

What is the best way to generate a new spreadsheet with formulas and formatting?▼

The best way to generate a new spreadsheet with formulas is using openpyxl. This Skill dynamically creates Excel files, applies financial formulas, and formats data according to industry standards.

Does openpyxl support preserving existing templates when editing Excel files?▼

Yes, openpyxl supports preserving templates. This Skill ensures existing spreadsheet templates are preserved when modifying files, preventing structural data loss during automated editing.

Why does my spreadsheet formula return an error after automated data entry?▼

Your spreadsheet formula returns an error because automated data entry tools often fail to trigger recalculation. This Skill resolves this by using LibreOffice to force automated formula recalculation.

Can I create Excel files from CSV or TSV data formats?▼

Yes, you can create Excel files from CSV or TSV data. This Skill supports comprehensive spreadsheet operations across .xlsx, .xlsm, .csv, and .tsv file formats for data transformation.

Related Skills

Explore More Finance & Accounting Skills→
mattmacleod16-svgmattmacleod16-svg
1

spreadsheet

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

Community
Intermediate
Ab0umarAb0umar

Spreadsheets

Create and modify multi-sheet .xlsx workbooks with formulas and charts.

Community
Intermediate
Jaydpatel01Jaydpatel01

xlsx

Create, edit, and analyze spreadsheet files in .xlsx, .xlsm, .csv, and .tsv formats.

Community
Advanced
bowoxdailybowoxdaily

xlsx

Analyze Excel files and generate reports using Python and openpyxl.

Community
Advanced