xlsx

Create, edit, and validate .xlsx workbooks with openpyxl.

7|Updated Mar 5, 2026
One-click install
npx skills add https://github.com/KrishavRajSingh/computer --skill xlsx-krishavrajsingh
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/KrishavRajSingh/computer/tree/main/sandbox/opencode/skills/xlsx
Command: npx skills add https://github.com/KrishavRajSingh/computer --skill xlsx-krishavrajsingh

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This skill automates end-to-end spreadsheet work, enabling you to create, edit, format, and validate Excel and tabular data files without manual, repetitive effort, ensuring professional, consistent outputs.

Core Features & Use Cases

  • Professional formatting defaults: headers, borders, number formats, frozen panes, and auto-width columns.
  • Formula integration and cross-sheet references with automatic recalculation and validation.
  • Data transformation and format conversion: import from CSV/TSV, export to .xlsx/.xlsm, and ensure data integrity across sheets.
  • Use case: you receive a messy data dump; this skill cleans, formats, computes totals, and generates a polished workbook ready for reporting.

Quick Start

Create a new, professionally formatted workbook from your data and ensure all formulas recalculate automatically.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I automate spreadsheet creation and formatting from a messy data dump?

Automating spreadsheet creation cleans your data dump and generates a polished workbook with professional formatting, robust formulas, and cross-sheet integrity. It applies headers, borders, number formats, frozen panes, and auto-width columns automatically.

Can I convert CSV files to formatted .xlsx workbooks with automatic recalculation?

Yes, you can convert CSV or TSV files to formatted .xlsx workbooks with automatic recalculation. The process imports your tabular data, applies consistent formatting, integrates formulas, and ensures data integrity across sheets for production-ready outputs.

Does openpyxl support cross-sheet references and formula validation for Excel files?

Yes, openpyxl supports cross-sheet references and formula validation for Excel files. The scripts leverage openpyxl as a primary dependency to apply robust formulas, validate cross-sheet integrity, and ensure automatic recalculation in your .xlsx outputs.

What is the best way to ensure consistent formatting across multiple Excel sheets?

The best way to ensure consistent formatting across multiple Excel sheets is to automate the process using Python tooling. This approach applies professional formatting defaults, including headers, borders, number formats, frozen panes, and auto-width columns uniformly.

How do I validate data integrity across sheets when editing an .xlsx workbook?

Validating data integrity across sheets when editing an .xlsx workbook is handled through automated validation scripts. These scripts check cross-sheet references, compute totals, and ensure that formulas recalculate automatically to maintain reliable, production-ready outputs.

When should I not use Python automation for spreadsheet editing?

You should not use Python automation for spreadsheet editing if your workbook requires highly specific manual visual styling or features outside standard .xlsx formatting, as the process focuses on consistent formatting defaults and robust formulas rather than custom manual design.