xlsx

Create, modify, and analyze spreadsheet files with Python libraries.

1|Updated Jan 27, 2026
One-click install
npx skills add https://github.com/devskale/skale-skills --skill xlsx-devskale
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/devskale/skale-skills/tree/main/skills/xlsx
Command: npx skills add https://github.com/devskale/skale-skills --skill xlsx-devskale

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill eliminates the tedious, error-prone manual work of creating, editing, and analyzing spreadsheets across formats (xlsx, xlsm, csv, tsv). It enables consistent, formula-driven workbooks and reproducible data work.

Core Features & Use Cases

  • Spreadsheet creation: Generate new workbooks with formulas, formatting, and templates that preserve existing styles.
  • Data analysis and visualization: Read data, perform analyses, and prepare summaries or visuals within Excel-compatible formats.
  • Template preservation and updates: Modify templates while preserving formulas, formats, and structure to ensure consistency.

Quick Start

Use the xlsx skill to create a new workbook, populate sample data, implement a simple formula like =SUM(B2:B10), save as sample.xlsx, and trigger the recalculation workflow.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I automate creating Excel spreadsheets with formulas and formatting?

Automate Excel spreadsheet creation using Python libraries like openpyxl to generate new workbooks with formulas, formatting, and templates. The skill handles formula implementation, style preservation, and file saving in xlsx format for reproducible spreadsheet work.

Can I read and analyze data from xlsx files programmatically?

Yes, you can read xlsx files, extract data, and perform analyses programmatically using openpyxl. The skill enables data extraction, summary calculations, and preparation for visualization within Excel-compatible formats.

How do I update existing Excel templates while preserving formulas and formatting?

Modify existing xlsx or xlsm templates programmatically while maintaining formulas, formats, and structure intact. The skill manages template consistency and updates without corrupting existing calculations or styles.

Do I need external tools to recalculate formulas after editing spreadsheets?

Yes, formula recalculation requires external tools such as a LibreOffice-based recalc script. The skill integrates this recalculation workflow to ensure formulas update after programmatic edits.

What file formats does spreadsheet automation support?

Spreadsheet automation covers xlsx, xlsm, csv, and tsv formats. The skill handles creation, modification, and analysis across these formats with format-specific features like formula preservation in Excel files.

Is formula-driven automation better than manual spreadsheet editing?

Formula-driven automation eliminates tedious, error-prone manual work and enables consistent, reproducible data workflows. It preserves complex formulas and formatting across updates, ensuring reliability at scale.