xlsx

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

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

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill automates end-to-end spreadsheet workflows, enabling reliable creation, editing, and analysis of spreadsheet data while preserving formulas and formatting across platforms (Excel-like formats such as .xlsx, .xlsm, and .csv).

Core Features & Use Cases

  • Spreadsheet creation: Generate new workbooks with formulas and consistent styling.
  • Data reading and validation: Import, inspect, and verify data quality across sheets.
  • Template updates: Modify existing spreadsheets while preserving formulas and layout.
  • Analysis and visualization: Perform data analysis and generate insights and visuals from data.
  • Recalculation workflow: Recalculate formulas when data changes using a LibreOffice-based tool.

Quick Start

Use the xlsx skill to load a sample workbook, create a new sheet with a SUM formula, and apply basic formatting.

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 data analysis workflows?

Automating spreadsheet creation and data analysis involves programmatically generating workbooks with formulas, reading data, and performing visualization workflows. This Skill handles these end-to-end processes across common formats like .xlsx, .xlsm, and .csv.

Can I update an existing Excel template while preserving formulas and formatting?

Yes, you can update existing Excel templates while preserving formulas and layout. This Skill modifies spreadsheets by reading the original file and applying changes without breaking the pre-existing formulas or consistent styling.

How do I recalculate Excel formulas after updating spreadsheet data?

To recalculate Excel formulas after updating data, a LibreOffice-based recalc process is triggered to refresh results. This ensures all formula outputs are accurately computed and updated within the .xlsx or .xlsm workbook.

Does this spreadsheet automation approach support .xlsm and .csv files?

Yes, this spreadsheet automation approach supports .xlsm and .csv files. It relies on openpyxl for workbook manipulation, allowing you to import, inspect, and verify data quality across these common Excel-like formats.

What is the best way to perform data visualization and analysis on spreadsheet data?

The best way to perform data visualization and analysis on spreadsheet data is by using an automated workflow that reads your datasets and generates insights. This Skill executes analysis workflows to produce visual outputs directly from workbook data.

Why do my spreadsheet formulas return stale values after programmatic data updates?

Spreadsheet formulas return stale values after programmatic data updates because the workbook engine is not triggered to recalculate. Using a LibreOffice-based recalc process refreshes formula results, ensuring the updated data reflects accurate computations.