xlsx

Build dynamic spreadsheets with verified formulas.

spreadsheet engineering

What it does

Creates, edits, analyzes, visualizes, and recalculates spreadsheets while preserving formulas and formatting.

When to use it

Use when creating, modifying, analyzing, visualizing, or recalculating spreadsheet files.

Give it a spreadsheet task; it creates or modifies a spreadsheet file and can analyze its contents.

This skill

LibreOffice user profile

Write

Writes LibreOffice macro configuration (irreversible)

LibreOffice is required to recalculate formula values.

Python is required to run the spreadsheet code and bundled recalculation script.

pandas is used for spreadsheet data analysis, visualization, and basic operations.

openpyxl is used for spreadsheet formulas and formatting and by the recalculation script for verification.