skills.rest
hAcKlyc
hAcKlycCOMMUNITY
Explore all skills by this author →
GitHub

xlsx

Create, edit, and analyze Excel workbooks with preserved formulas and templates.

815|96|Updated Jan 23, 2026
Search Tags:#automation#formulas#spreadsheet#excel#data-analysis#xlsx
One-click install
npx skills add https://github.com/hAcKlyc/MyAgents --skill xlsx-hacklyc
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/hAcKlyc/MyAgents/tree/main/bundled-skills/xlsx
Command: npx skills add https://github.com/hAcKlyc/MyAgents --skill xlsx-hacklyc

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Comprehensive guide to creating, editing, and analyzing Excel workbooks with preserved formulas, templates, and reproducible results, enabling reliable spreadsheet workflows.

Core Features & Use Cases

  • Workbook creation: Build new spreadsheets with formulas and formatting to automate common tasks.
  • Template preservation: Update existing templates while preserving layout and formulas.
  • Data analysis & visualization: Analyze data, generate insights, and visualize results within spreadsheets.
  • Formula recalculation: Recalculate all formulas across sheets using the provided tooling to ensure consistency.

Quick Start

Create or open a workbook, enter data and formulas, and run recalc.py to refresh all formulas across sheets.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I automate Excel workbook editing while preserving existing templates and formulas?▼

Automate Excel workbook editing by applying programmatic updates that preserve existing templates and formulas. This workflow ensures reliable spreadsheet generation and maintenance without breaking layouts or calculations.

What file formats are supported for automated spreadsheet data analysis and reporting?▼

Supported formats for spreadsheet data analysis and reporting include .xlsx, .xlsm, .csv, and .tsv files. This allows flexible handling of tabular data across professional workflows.

How do I recalculate all formulas across multiple Excel sheets consistently?▼

Recalculate formulas across multiple sheets consistently by running recalc.py with LibreOffice. This tooling refreshes calculations across the workbook to ensure uniform data consistency.

Does this spreadsheet automation approach work with .xlsm macro-enabled files?▼

Yes, .xlsm macro-enabled files are fully supported alongside standard .xlsx, .csv, and .tsv formats. You can update existing templates and recalculate formulas within these workbooks.

What is the best way to update existing Excel templates without losing formatting?▼

Update existing Excel templates without losing formatting by using automated editing workflows designed for template preservation. This ensures layout and formulas remain intact while data is modified.

Can I generate data visualizations and insights directly within my Excel workbooks?▼

Generate data visualizations and insights directly within Excel workbooks through automated analysis. This enables in-spreadsheet reporting and model maintenance without external visualization tools.

Related Skills

Explore More Data & Analytics Skills→
duyle10xba1901duyle10xba1901

xlsx

Read, clean, and rewrite .xlsx, .xlsm, .csv, and .tsv spreadsheet files.

Community
Advanced
gracefullightgracefullight

plotly

Generate interactive Plotly visualizations for data analysis and reporting.

Community
Advanced
LinSoapLinSoap

xlsx

Create and edit Excel workbooks with formulas and formatting.

Community
Advanced
pchemguypchemguy

spreadsheet

Automate spreadsheet creation, editing, and analysis with openpyxl and pandas.

Community
Intermediate