xlsx

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

Updated Aug 27, 2026
One-click install
npx skills add https://github.com/synapticera/prod-helm-pm --skill xlsx-synapticera
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/synapticera/prod-helm-pm/tree/main/.claude/skills/xlsx
Command: npx skills add https://github.com/synapticera/prod-helm-pm --skill xlsx-synapticera

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Automate the end-to-end workflow of creating, editing, and analyzing spreadsheets while preserving formulas and formatting across multiple file types.

Core Features & Use Cases

  • Comprehensive spreadsheet creation, editing, and analysis with support for formulas, formatting, data analysis, and visualization.
  • Create new spreadsheets with formulas and formatting; read or analyze data; modify existing templates while preserving formulas; perform data analysis and visualization; recalculate formulas when inputs change.

Quick Start

Create a new spreadsheet with a monthly budget, including a formula that sums expenses and formats cells.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I automate spreadsheet creation while preserving formulas and formatting?

You can automate spreadsheet creation and modification across .xlsx, .xlsm, .csv, and .tsv files while preserving formulas and formatting by using pandas and openpyxl tooling to manipulate data programmatically.

Can I update existing spreadsheet templates without breaking formulas?

Yes, you can modify existing spreadsheet templates while preserving formulas and formatting. The workflow uses openpyxl to apply changes and a recalculation script to refresh formulas when input data changes.

How do I recalculate formulas in an xlsx file after updating data?

To recalculate formulas in an xlsx file after data changes, the workflow utilizes a recalc.py script that refreshes formulas, ensuring calculated values accurately reflect the newly modified spreadsheet inputs.

Does this approach support data analysis and visualization for csv and tsv files?

Yes, this approach supports reading, analyzing, and generating visualizations for csv and tsv files. It leverages pandas for data manipulation to extract insights and create visual representations of the data.

What is the best way to build new spreadsheet models with formulas?

The best way to build new spreadsheet models with formulas is by programmatically defining cell values and formatting through openpyxl, then executing a recalculation workflow to ensure formula outputs compute correctly.