xlsx

Create and edit Excel workbooks with formulas and formatting.

1|Updated Dec 15, 2025

Search Tags:#automation #formulas #spreadsheet #excel #data-analysis #xlsx

Ready to run

npx skills add https://github.com/dobeutech/dobeu-agents-sdk --skill xlsx-dobeutech

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/dobeutech/dobeu-agents-sdk/tree/main/excel-demo/agent/.claude/skills/xlsx
Command: npx skills add https://github.com/dobeutech/dobeu-agents-sdk --skill xlsx-dobeutech

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires openpyxl.

What problem does it solve?

This Skill automates complex spreadsheet tasks, enabling creation, modification, data analysis, and formula management while preserving templates and formatting.

Core Features & Use Cases

Automated workbook creation: Build new Excel workbooks with formulas and formatting.
Data analysis & visualization: Analyze data and produce insights directly in spreadsheets.
Template preservation: Respect existing templates and styles when updating workbooks.

Quick Start

Use the xlsx skill to create a new workbook for Q2 forecasts with a simple SUM formula across a range.

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 with formulas automatically?▼

Automate Excel workbook creation using openpyxl to build new .xlsx files with formulas and formatting applied programmatically. The Skill enforces zero formula errors and uses Excel formulas over hardcoded values, enabling rapid generation of spreadsheets with dynamic calculations across ranges.

Can I analyze and modify existing Excel files without losing formulas?▼

Yes. This Skill reads and edits existing .xlsx, .xlsm, .csv, and .tsv files while preserving formulas, templates, and formatting. It integrates with openpyxl and LibreOffice-based recalculation tooling to maintain spreadsheet integrity during updates.

What's the best way to automate data analysis directly in spreadsheets?▼

Use this Skill to perform data analysis and visualization across Excel and CSV formats by applying formulas and pandas integration within workbooks. It automates insights generation while respecting existing templates and maintaining formula accuracy.

Does this work with CSV and TSV files or only Excel?▼

The Skill handles .xlsx, .xlsm, .csv, and .tsv formats. It automates creation, modification, and analysis across all these formats while preserving templates and applying formulas where applicable.

How do I ensure formulas stay error-free when updating spreadsheets?▼

This Skill enforces zero formula errors during creation and modification. It validates formulas through openpyxl and LibreOffice-based recalculation, catching errors before the workbook is finalized.