xlsx

Automate Excel file creation, editing, and analysis with formulas and formatting.

Updated Aug 27, 2026
One-click install
npx skills add https://github.com/fengzhizi319/LobsterAI --skill xlsx-fengzhizi319
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/fengzhizi319/LobsterAI/tree/main/SKILLs/xlsx
Command: npx skills add https://github.com/fengzhizi319/LobsterAI --skill xlsx-fengzhizi319

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Automates spreadsheet creation, editing, and analysis to ensure formula accuracy, consistent formatting, and reproducible data workflows.

Core Features & Use Cases

  • Automated workbook generation with formulas and styles using Python (openpyxl)
  • Read, update, and preserve existing Excel formulas across multiple sheets
  • Recalculate and validate results with the dedicated recalc.py tool to surface errors

Quick Start

Create a new workbook, add data and formulas, and run recalc.py to validate and update all formulas.

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 with formulas and formatting?

You can automate Excel workbook creation by using Python with openpyxl to generate sheets, apply styles, and inject formulas programmatically. This ensures consistent formatting and reproducible data workflows for reporting.

How do I recalculate and validate Excel formulas in an automated workflow?

Recalculate and validate Excel formulas using the dedicated recalc.py tool, which updates all formulas, surfaces errors, and ensures reproducible outputs across XLSX, XLSM, and CSV files without manual intervention.

Can I read and update existing Excel formulas across multiple sheets without breaking them?

Yes, you can read, update, and preserve existing Excel formulas across multiple sheets. The Skill automates editing while maintaining formula integrity and validating results through the recalc.py tool.

Does this openpyxl-based automation support XLSM and CSV files for data preparation?

Yes, the openpyxl-based automation supports data preparation and reporting workflows across XLSX, XLSM, and CSV files, allowing you to create, edit, and analyze workbooks with consistent formatting.

What is the best way to ensure formula accuracy and reproducible outputs in Excel reporting?

The best way to ensure formula accuracy and reproducible outputs is to automate spreadsheet creation with openpyxl and use a dedicated recalc.py tool to recalculate formulas, validate results, and surface errors.

Why do my Excel formulas return errors when I generate workbooks programmatically?

Excel formulas may return errors if not recalculated after programmatic generation. Running the recalc.py tool validates and updates all formulas, surfaces calculation errors, and ensures the final workbook outputs are accurate and reproducible.