skills.rest
henkisdabro
henkisdabroCOMMUNITY
Explore all skills by this author →
Website𝕏@henkisGitHub

xlsx

Create, edit, and analyze Excel workbooks while preserving formulas and formatting.

77|9|Updated Oct 10, 2025
Search Tags:#automation#financial modeling#reporting#data analysis#formulas#spreadsheet#excel
One-click install
npx skills add https://github.com/henkisdabro/claudecode-marketplace --skill xlsx-henkisdabro
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/henkisdabro/claudecode-marketplace/tree/main/skills/xlsx
Command: npx skills add https://github.com/henkisdabro/claudecode-marketplace --skill xlsx-henkisdabro

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

Manually creating, editing, and analyzing complex spreadsheets with formulas and formatting is time-consuming and prone to human error. This skill automates comprehensive spreadsheet operations, ensuring accuracy and efficiency.

Core Features & Use Cases

  • Formula-Driven Creation: Generate new spreadsheets with dynamic formulas, not hardcoded values, preserving recalculation capabilities.
  • Data Analysis & Modification: Read, analyze, and modify existing .xlsx files while preserving formulas and formatting.
  • Use Case: A financial analyst needs to update a quarterly report spreadsheet. They can use this skill to automatically pull new data, insert it into the correct cells, and ensure all existing formulas recalculate correctly, then verify for errors.

Quick Start

Create a new Excel file named 'sales_report.xlsx' with two columns: 'Product' and 'Sales'. Add five rows of sample data and a formula in cell B7 to sum the 'Sales' column.

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 with formulas instead of hardcoded values?▼

Automate Excel spreadsheet creation by using this Skill to generate .xlsx files with dynamic formulas that recalculate automatically. It preserves formula integrity and formatting, ensuring calculations update when data changes, eliminating manual formula entry and reducing errors in financial models and reports.

Can I update existing Excel files while keeping formulas and formatting intact?▼

Yes, this Skill reads and modifies existing .xlsx workbooks while preserving all formulas and formatting. You can insert new data into specific cells and trigger formula recalculation without disrupting the spreadsheet structure, ideal for refreshing quarterly reports or updating data sources.

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

This Skill enables programmatic data analysis of .xlsx files by reading cell values, formulas, and formatting. It supports comprehensive analysis workflows where you extract data, perform transformations, and preserve the original spreadsheet structure for downstream reporting and visualization.

Do I need to recalculate formulas after modifying an Excel file?▼

This Skill handles formula recalculation automatically using a LibreOffice-based workflow, ensuring all formulas recompute after data modifications. This eliminates manual recalculation steps and guarantees zero formula errors in updated spreadsheets, critical for financial accuracy.

Can I apply consistent color coding and number formatting across Excel reports?▼

Yes, this Skill applies explicit color coding and number formatting standards to spreadsheets, ensuring consistent presentation across financial reports. It preserves these formatting rules when updating files, maintaining professional report standards without manual reformatting.

What's required to automate spreadsheet operations with openpyxl and pandas?▼

This Skill uses openpyxl for .xlsx file manipulation and pandas for data analysis, combining formula-driven creation with data transformation capabilities. Together they enable end-to-end automation: structuring spreadsheets with formulas, analyzing data, and maintaining Excel compatibility.

Related Skills

Explore More Finance & Accounting Skills→
cookeyholdercookeyholder

xlsx

Open, edit, clean, and convert XLSX, XLSM, CSV, and TSV spreadsheets.

Community
Intermediate
dkyazzentwatwadkyazzentwatwa
86

data-storyteller

Transform tabular data into narrative reports with automated insights and visualizations.

Community
Intermediate
Wesley1600Wesley1600

Python Script Skill Template

Executes Python scripts that process CLI input and return JSON-formatted results.

Community
Basic
Exploration-labsExploration-labs
49

xlsx-editor

Edit Excel workbooks while preserving formulas, formatting, and structure across multiple sheets.

Official
Intermediate