xlsx

Create, edit, and analyze Excel workbooks with Python and LibreOffice recalculation.

Updated Jan 20, 2026
One-click install
npx skills add https://github.com/AndersHsueh/RedNotes-Mate --skill xlsx-andershsueh
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/AndersHsueh/RedNotes-Mate/tree/main/aionui/skills/xlsx
Command: npx skills add https://github.com/AndersHsueh/RedNotes-Mate --skill xlsx-andershsueh

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill tackles the tedious, error-prone process of creating, editing, and analyzing Excel workbooks by providing automated workflows for building formulas, formatting, and data visualization while preserving existing templates and formulas.

Core Features & Use Cases

  • Comprehensive spreadsheet creation, editing, and analysis with formula support, formatting, and visualization.
  • Read, analyze, and modify spreadsheets (.xlsx, .xlsm, .csv, .tsv) while preserving formulas and structure.
  • Recalculate and verify formulas using LibreOffice-based recalculation tooling to ensure correctness across updated data.

Quick Start

Install prerequisites (Python 3.x and LibreOffice). Use the provided Python scripts to create a new workbook or modify an existing one, then run recalc.py to recompute formulas and verify there are no errors.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I automate Excel workbook creation while preserving existing formulas?

You can automate Excel workbook creation by using openpyxl to manipulate spreadsheets and recalc.py to recompute formulas, ensuring formula preservation and formatting consistency across data-heavy workbooks.

What is the best way to recalculate formulas in an xlsx file using Python?

The best way to recalculate formulas in an xlsx file is using LibreOffice-based recalculation tooling via recalc.py, which verifies correctness across updated data and ensures accurate formula computation.

Do I need LibreOffice installed to automate Excel editing with Python?

Yes, you need LibreOffice installed because the skill relies on LibreOffice-based recalculation tooling to recompute formulas and verify there are no errors across updated workbook data.

Can I modify .xlsm and .csv files while maintaining formatting consistency?

Yes, you can read, analyze, and modify .xlsx, .xlsm, .csv, and .tsv files while preserving formulas and structure, ensuring formatting consistency across various spreadsheet formats.

How does openpyxl handle rapid scenario analysis for data-heavy workbooks?

Openpyxl handles rapid scenario analysis by automating workbook editing and formula generation, allowing you to quickly update data-heavy workbooks and verify results through LibreOffice recalculation.