xlsx

Generate, edit, and analyze Excel workbooks with OpenPyXL and LibreOffice.

1|Updated Jul 4, 2025

Search Tags:#openpyxl #formulas #spreadsheet #data-analysis #xlsx #recalculation

Ready to run

npx skills add https://github.com/MoshPitCodes/moshpitcodes.nix --skill xlsx-moshpitcodes

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/MoshPitCodes/moshpitcodes.nix/tree/main/.opencode/skills/document-skills/xlsx
Command: npx skills add https://github.com/MoshPitCodes/moshpitcodes.nix --skill xlsx-moshpitcodes

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Spreadsheets are a backbone of data work, but creating, updating, and maintaining complex sheets with formulas and formatting is error-prone and time-consuming.

Core Features & Use Cases

Create new spreadsheets with formulas and formatting to standard templates.
Read, analyze, and summarize data from existing workbooks while preserving formulas.
Modify existing spreadsheets while maintaining formula integrity and data validation.
Recalculate formulas and generate updated outputs across multiple sheets and file types (.xlsx, .xlsm, .csv, .tsv).

Quick Start

Provide your data and structure and I will generate a ready-to-use workbook with formulas and formatting.

Frequently Asked Questions about xlsx

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

FAQPage Schema

How do I create Excel spreadsheets with formulas and formatting automatically?▼

Yes, you can modify existing spreadsheets while maintaining formula integrity. The Skill reads and edits workbooks without breaking existing calculations, preserving templates, formulas, and data validation rules during updates across multiple sheets.

How does automatic recalculation work for Excel formulas?▼

Automatic recalculation for Excel formulas works through a LibreOffice-based pipeline. When you update data, the Skill triggers recalculation to generate updated outputs, ensuring formula values are correctly computed and reflected across .xlsx, .xlsm, .csv, and .tsv files.

Can I read and analyze data from existing .xlsx workbooks while preserving formulas?▼

Yes, you can read and analyze data from existing .xlsx workbooks while preserving formulas. The Skill reads your workbook, summarizes the data, and performs analysis workflows without overwriting or stripping the underlying formula logic from the original file.

What file formats are supported for spreadsheet data analysis and recalculation?▼

Supported file formats for spreadsheet data analysis and recalculation include .xlsx, .xlsm, .csv, and .tsv. The Skill manipulates these file types using OpenPyXL, allowing you to read, edit, and generate updated outputs across all supported formats.

Does OpenPyXL handle complex spreadsheet workflows with multiple sheets and templates?▼

Yes, OpenPyXL handles complex spreadsheet workflows with multiple sheets and templates. The Skill uses it to automate file manipulation, apply formatting standards, and generate workbooks across multiple sheets while maintaining formula integrity and data validation rules.