skills.rest
lucasmattosped
lucasmattospedCOMMUNITY
Explore all skills by this author →
GitHub

xlsx

Create, edit, and analyze .xlsx, .xlsm, .csv, and .tsv spreadsheets with openpyxl.

Updated Aug 23, 2026
Search Tags:#automation#openpyxl#spreadsheet#excel#data-analysis#formula#recalculate
One-click install
npx skills add https://github.com/lucasmattosped/Blueberry-Math-Analyzer- --skill xlsx-lucasmattosped
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/lucasmattosped/Blueberry-Math-Analyzer-/tree/main/xlsx
Command: npx skills add https://github.com/lucasmattosped/Blueberry-Math-Analyzer- --skill xlsx-lucasmattosped

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Spreadsheets are central to data work, but manual creation, editing, formula maintenance, and analysis are time-consuming and error-prone.

Core Features & Use Cases

  • Create new spreadsheets with formulas, formatting, and templates.
  • Read, analyze, and visualize data across sheets, while preserving existing formulas during edits.
  • Recalculate formulas across all sheets to ensure up-to-date results after data changes.

Quick Start

Create a new budget workbook with basic formulas and formatting to see automatic recalculation.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I automate Excel spreadsheet creation and editing with Python?▼

You can automate spreadsheet creation and editing by using openpyxl to programmatically generate templates, apply formatting, and preserve formulas across .xlsx and .xlsm files.

Can I recalculate formulas across multiple Excel sheets after editing data?▼

Yes, you can recalculate formulas across all sheets to ensure up-to-date results after data changes by utilizing recalculate.py, which relies on a LibreOffice-based engine for computation.

Does this spreadsheet automation approach support CSV and TSV file workflows?▼

Yes, this approach fully supports CSV and TSV file workflows for reading data, performing analysis, and generating new files alongside standard .xlsx and .xlsm formats.

How do I preserve existing formulas when editing an Excel spreadsheet?▼

To preserve existing formulas during spreadsheet edits, the process uses openpyxl to read and modify .xlsx or .xlsm files while keeping the underlying formula logic intact across sheets.

What is the best way to read and visualize spreadsheet data across multiple sheets?▼

The best way to read and visualize spreadsheet data across multiple sheets is to use openpyxl for data extraction and analysis while maintaining existing formulas during the editing process.

Do I need LibreOffice to recalculate formulas in an openpyxl workflow?▼

Yes, you need LibreOffice because the recalculation of formulas across sheets relies on recalculate.py, which uses a LibreOffice-based engine to update results after data modifications.

Related Skills

Explore More Data & Analytics Skills→
cbbkrd-techcbbkrd-tech

xlsx

Create, edit, and analyze .xlsx, .xlsm, .csv, and .tsv files with pandas and openpyxl.

Community
Advanced
Ab0umarAb0umar

Spreadsheets

Create and modify multi-sheet .xlsx workbooks with formulas and charts.

Community
Intermediate
syl2042syl2042

spreadsheet

Automate spreadsheet creation, editing, analysis, and visualization with Python.

Community
Intermediate
zjy-devzjy-dev
2

xlsx

Create, edit, and analyze Excel files with pandas and openpyxl.

Community
Advanced