xlsx

Create, edit, validate, and recalculate Excel workbooks with openpyxl.

3|Updated Jan 14, 2022
One-click install
npx skills add https://github.com/bingran-you/bingran-you --skill xlsx-bingran-you
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/bingran-you/bingran-you/tree/main/repo-skills/xlsx
Command: npx skills add https://github.com/bingran-you/bingran-you --skill xlsx-bingran-you

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires openpyxl, defusedxml, lxml, and includes scripts (resource) components.

What problem does it solve?

This Skill automates the creation, editing, formatting, cleaning, and validation of spreadsheet workbooks. It helps users manage Excel files (.xlsx, .xlsm) and related tabular formats (.csv, .tsv) by turning manual spreadsheet work into reliable, repeatable automation.

Core Features & Use Cases

  • Automated workbook creation from data sources and templates.
  • Edit, format, and compute: apply formulas, restructure data, fix messy data, and ensure consistency across sheets.
  • Interformat conversion and validation: convert between CSV/TSV and Excel formats and verify content integrity; recalc formulas to prevent errors.
  • Real-world scenario: consolidate a set of CSV invoices into a single output.xlsx with per-row totals and consistent formatting.

Quick Start

Create a new workbook from a CSV input, apply a simple sum formula to a column, and save the result as output.xlsx.

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 from CSV files?

You can automate Excel workbook creation from CSV files by using openpyxl to generate spreadsheets, apply formulas, and save the consolidated output as a formatted .xlsx file.

Can I recalculate Excel formulas automatically in Python?

You can recalculate Excel formulas automatically using a LibreOffice-based recalculation script that verifies formula computations and applies built-in checks to repair common Excel issues.

What is the best way to consolidate multiple CSV files into a single XLSX workbook?

The best way to consolidate multiple CSV files into a single XLSX workbook is automating the workflow to merge invoices, apply per-row totals, ensure consistent formatting, and validate content integrity.

Does openpyxl support converting between CSV, TSV, and Excel formats?

Yes, openpyxl supports interformat conversion and validation between CSV, TSV, and Excel formats, allowing you to convert tabular data while verifying content integrity and preventing formula errors.

Why do my Excel formulas show errors after generating workbooks with openpyxl?

Excel formulas show errors after generating workbooks with openpyxl because formula caches are not natively calculated, but you can run a LibreOffice recalculation script to verify formulas and repair common issues.

How do I fix messy data and ensure consistency across multiple Excel sheets?

Fix messy data and ensure consistency across multiple Excel sheets by automating workbook editing to restructure data, apply uniform formatting, and validate spreadsheet content end-to-end.