xlsx

Create, edit, and analyze spreadsheets in .xlsx, .xlsm, and CSV formats.

333|83|Updated Jan 9, 2026
One-click install
npx skills add https://github.com/zephyrwang6/myskill --skill xlsx-zephyrwang6
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/zephyrwang6/myskill/tree/main/xlsx
Command: npx skills add https://github.com/zephyrwang6/myskill --skill xlsx-zephyrwang6

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill enables seamless creation, editing, and analysis of spreadsheets, reducing manual workbook work and errors.

Core Features & Use Cases

  • Spreadsheet creation & formatting: Build new workbooks with formulas and formatting to match templates.
  • Data reading, analysis, and visualization: Import data from CSV/Excel, perform analyses, and generate visual insights.
  • Preserve formulas when modifying models: Update layouts or inputs while keeping existing formulas intact.
  • Use Case: Imagine preparing a monthly budget in Excel with automatic recalculation as numbers are updated.

Quick Start

Use the xlsx skill to create a new workbook named 'budget.xlsx' and add a sheet 'Overview' with a basic formula.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I create and edit Excel spreadsheets programmatically?

Create and edit Excel spreadsheets by building new workbooks with formulas and formatting using the xlsx Skill. It handles .xlsx, .xlsm, and CSV formats while preserving formulas during modifications, reducing manual errors in financial modeling and data analysis workflows.

Can I preserve formulas when updating spreadsheet data and layouts?

Yes, the xlsx Skill preserves existing formulas when modifying models. It uses LibreOffice-based recalculation to keep formulas intact while you update layouts or inputs, ensuring automatic recalculation as numbers change without losing formula logic.

What's the best way to automate financial modeling and reporting in Excel?

Automate financial modeling by using the xlsx Skill to create workbooks with built-in formulas and formatting templates. It applies to budget preparation, monthly reporting, and dashboarding across Excel and CSV formats with reliable recalculation.

How do I analyze data and generate insights from spreadsheets?

Import data from CSV or Excel files using the xlsx Skill to perform analyses and generate visual insights. The Skill enables reading, analyzing, and visualizing spreadsheet data to support reporting and decision-making workflows.

Do I need any specific environment setup to work with Excel files programmatically?

Yes, the xlsx Skill requires a Python environment and the LibreOffice-based recalc tool to preserve and recalculate formulas reliably. These components enable seamless creation, editing, and analysis of spreadsheets across supported formats.

Why use formula recalculation instead of static spreadsheet values?

Formula recalculation maintains dynamic relationships between cells, enabling automatic updates when inputs change. The xlsx Skill's LibreOffice-based recalc tool ensures formulas remain functional and consistent, critical for financial models and data dashboards.