xlsx

Create, edit, and analyze Excel workbooks while preserving formulas.

1|1|Updated Nov 8, 2025
One-click install
npx skills add https://github.com/AkhilGurrapu/kubera --skill xlsx-akhilgurrapu
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/AkhilGurrapu/kubera/tree/main/.claude/skills/document-skills/xlsx
Command: npx skills add https://github.com/AkhilGurrapu/kubera --skill xlsx-akhilgurrapu

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires .

What problem does it solve?

This skill streamlines the end-to-end workflow of spreadsheet creation, editing, and analysis, ensuring formulas are preserved and recalculation is easily performed.

Core Features & Use Cases

  • Formula-preserving editing: Update templates and data while keeping embedded calculations intact.
  • Data analysis & visualization: Read data with pandas/openpyxl and prepare reports.
  • Recalculation automation: Recalculate all formulas via recalc.py with LibreOffice, ensuring up-to-date results.
  • Common workflows: Financial models, budget tracking, and data-driven reporting.

Quick Start

  • Install dependencies: pip install pandas openpyxl
  • Create or modify a workbook and save as .xlsx
  • Recalculate formulas: python recalc.py <your_file.xlsx> 30

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I edit an Excel spreadsheet while preserving formulas?

To edit Excel spreadsheets while preserving formulas, this skill uses openpyxl to update templates and data while keeping embedded calculations intact. It ensures financial models and reporting workflows maintain accurate calculations throughout the editing process.

How do I recalculate all formulas in an xlsx workbook using Python?

You can recalculate all formulas in an xlsx workbook by running the recalc.py script with LibreOffice. This automation ensures formula results stay up-to-date by executing `python recalc.py <your_file.xlsx> 30` after modifying data.

Can I use pandas with openpyxl for Excel data analysis and reporting?

Yes, you can use pandas with openpyxl for Excel data analysis and reporting. This skill leverages pandas for reading and preparing data while using openpyxl to handle workbook modifications, enabling data-driven reporting and visualization workflows.

What is the best way to automate financial modeling and budget tracking in Excel?

The best way to automate financial modeling and budget tracking in Excel is using this skill to create, edit, and analyze workbooks while preserving formulas. It leverages pandas and openpyxl for data handling alongside LibreOffice for automated recalculation.

Do I need LibreOffice installed to recalculate Excel formulas via recalc.py?

Yes, you need LibreOffice installed to recalculate Excel formulas via recalc.py. The script relies on LibreOffice as its calculation engine to process and update all formula results within your xlsx workbooks, ensuring accurate and up-to-date outputs.