xlsx

Name: xlsx
Availability: InStock
Author: zakarooo

Create, edit, and analyze spreadsheets while preserving formulas and formatting.

Updated Jan 22, 2026

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

Ready to run

npx skills add https://github.com/zakarooo/dataup --skill xlsx-zakarooo

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/zakarooo/dataup/tree/main/xlsx
Command: npx skills add https://github.com/zakarooo/dataup --skill xlsx-zakarooo

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill enables programmatic creation, editing, and analysis of spreadsheets while preserving formulas and formatting across common file formats such as .xlsx, .xlsm, and .csv.

Core Features & Use Cases

Create new workbooks with formulas and custom formatting.
Read, analyze, and summarize data from existing spreadsheets.
Update existing spreadsheets without breaking formulas, while maintaining templates and styling.
Produce simple data-driven reports and visuals by leveraging Python libraries (OpenPyXL) and LibreOffice-based recalculation for formula integrity.

Quick Start

Create a new workbook named report.xlsx with a sheet named "Sales", populate sample data, include a total formula, and save.

Frequently Asked Questions about xlsx

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

FAQPage Schema

How do I create a new Excel spreadsheet with formulas programmatically?▼

Create spreadsheets with formulas using OpenPyXL by defining cells, inserting formulas, and saving as .xlsx. The Skill handles formula syntax and file structure, allowing you to generate workbooks with calculations without manual Excel entry.

Can I edit existing .xlsx files without breaking the formulas?▼

Yes, you can update cells, add data, and modify formatting while preserving existing formulas and templates. The Skill maintains formula integrity and structure when editing, ensuring recalculation accuracy across your workbook.

What's the best way to read and analyze data from spreadsheets programmatically?▼

Use OpenPyXL to read .xlsx, .xlsm, and .csv files, extract cell values and formulas, then analyze data with Python. The Skill extracts structured data for summarization and reporting without manual spreadsheet navigation.

Can I automate report generation by combining spreadsheet data with formulas?▼

Automate report creation by generating workbooks with populated data, calculated totals via formulas, and custom formatting. The Skill enables end-to-end report production, leveraging LibreOffice for formula recalculation and Python for data processing.

Does this work with .xlsm files and macro-enabled spreadsheets?▼

Yes, the Skill supports .xlsm files alongside standard .xlsx and .csv formats. It preserves file structure and formatting when reading or editing macro-enabled workbooks, maintaining compatibility across common Excel file types.

What happens when I need formulas recalculated after updating cell values?▼

LibreOffice integration recalculates formulas after data updates, ensuring accurate results without manual Excel refresh. The Skill manages recalculation automatically, maintaining formula chain integrity across dependent cells.