xlsx

Create and edit Excel workbooks with formulas using openpyxl and pandas.

277|36|Updated Jul 14, 2021
One-click install
npx skills add https://github.com/981377660LMT/algorithm-study --skill xlsx-981377660lmt
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/981377660LMT/algorithm-study/tree/main/.agents/skills/xlsx
Command: npx skills add https://github.com/981377660LMT/algorithm-study --skill xlsx-981377660lmt

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Creating and maintaining complex Excel workbooks with formulas, formatting, and data analysis can be error-prone and time-consuming.

Core Features & Use Cases

  • Create new workbooks from templates while preserving existing formulas and formatting.
  • Edit cells, manage sheets, and apply consistent formatting across large models.
  • Recalculate formulas reliably using the provided recalc tool to ensure up-to-date results in budgeting, forecasting, and data analysis scenarios.

Quick Start

Build a new workbook from a template, add a data table, and set up a simple formula to verify recalculation.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I create Excel workbooks from templates while preserving formulas?

You can create Excel workbooks from templates while preserving formulas by using this tool's openpyxl and pandas workflow to maintain existing formatting and data integrity. It automates model maintenance for budgeting and reporting scenarios.

Can I recalculate formulas in Excel files automatically using Python?

Yes, you can recalculate formulas in Excel files automatically using the dedicated recalc.py workflow provided. This mechanism ensures formulas recalculate safely and produces documented Excel workbooks with up-to-date results for forecasting and data analysis.

Does openpyxl support editing cells and managing sheets in large spreadsheet models?

Yes, openpyxl supports editing cells and managing sheets in large spreadsheet models through this tool's automated workflow. It applies consistent formatting across large models to ensure data integrity for complex Excel file maintenance.

What is the best way to automate Excel reporting and model maintenance with pandas?

The best way to automate Excel reporting and model maintenance with pandas is using this tool's end-to-end creation and analysis workflow. It combines pandas data handling with openpyxl formatting to reliably output documented Excel workbooks.

Why do my spreadsheet formulas break when editing xlsx files with Python?

Spreadsheet formulas often break when editing xlsx files with Python because standard libraries overwrite template structures. This tool prevents that by using a dedicated recalc workflow to ensure formulas recalculate safely and maintain data integrity.