xlsx

Create and edit spreadsheets with preserved formulas using openpyxl and pandas.

2|Updated Mar 13, 2026
One-click install
npx skills add https://github.com/mammut001/pipi-shrimp-agent --skill xlsx-mammut001
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/mammut001/pipi-shrimp-agent/tree/main/src-tauri/skills/xlsx
Command: npx skills add https://github.com/mammut001/pipi-shrimp-agent --skill xlsx-mammut001

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Excel and spreadsheet workflows often require creating, editing, and analyzing complex workbooks while preserving formulas and templates. This Skill helps automate those tasks, ensuring accuracy and consistency across large datasets.

Core Features & Use Cases

  • Spreadsheet creation with formulas and formatting
  • Reading, analyzing, and visualizing data across xlsx, xlsm, csv, and tsv
  • Updating existing templates while preserving formulas and conventions
  • Recalculating formulas to ensure integrity after changes

Quick Start

Ask the agent to generate a new Excel workbook from a template and verify all formulas are intact.

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 by generating new workbooks with explicit formulas and formatting intact. This ensures consistency and accuracy across large datasets by targeting workflows that build and update templates programmatically while preserving formula conventions.

What is the best way to analyze data across xlsx, xlsm, csv, and tsv formats?

Analyzing data across xlsx, xlsm, csv, and tsv formats is handled by leveraging pandas for data manipulation. This process reads multiple spreadsheet formats, extracts the data for analysis, and visualizes results to support data-driven decisions.

How do I update existing Excel templates without breaking formulas?

Updating existing Excel templates without breaking formulas requires preserving the original formula conventions during edits. The process modifies template content while keeping explicit formulas intact, then uses a recalc tool to recalculate and verify formula integrity after changes.

Does openpyxl support recalculating formulas after editing a workbook?

Yes, openpyxl supports editing workbooks, and a dedicated recalc tool recalculates formulas after modifications. This ensures formula integrity and accuracy once data changes are applied, verifying that computed values remain correct across the updated spreadsheet.

Can I visualize spreadsheet data directly from an automated workflow?

Visualizing spreadsheet data within an automated workflow is supported by leveraging pandas for data manipulation after reading xlsx, xlsm, csv, or tsv files. The process analyzes the extracted data and generates visualizations to represent the results.