xlsx

Automate spreadsheet data processing and formatting across CSV, XLSX, and TSV files.

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

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires openpyxl.

What problem does it solve?

專業的試算表處理與分析,提供跨格式的自動化數據處理、格式化與公式注入,同時保持現有工作簿的精確修改。

Core Features & Use Cases

  • Data analysis: 讀取大型數據表並產出統計摘要與關鍵指標。
  • Formatting & styling: 對單元格進行對齊、邊框、字體、背景色與條件格式化等美化。
  • Formulas & calculations: 注入 Excel 公式以自動化數據計算並生成報表。
  • Cross-platform compatibility: 確保輸出在 Windows Office 與 macOS Numbers 中呈現一致。

Quick Start

Provide a sample dataset and ask the assistant to generate a formatted summary sheet with basic formulas.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I automate Excel data cleaning and formatting for XLSX files?

To automate Excel data cleaning and formatting, this Skill processes XLSX, CSV, and TSV files to apply styling, inject formulas, and generate reports while preserving the original workbook structure using openpyxl.

Can I inject Excel formulas into a spreadsheet without breaking the existing workbook structure?

Yes, you can inject Excel formulas into a spreadsheet without breaking the existing workbook structure, as this Skill precisely modifies workbooks and calculates data automatically while maintaining the original file integrity.

Does openpyxl support conditional formatting and cross-platform compatibility for spreadsheets?

openpyxl supports conditional formatting and cross-platform compatibility, ensuring your formatted spreadsheet outputs display consistently across Windows Office and macOS Numbers applications.

What is the best way to generate a statistical summary from a large Excel dataset?

The best way to generate a statistical summary from a large Excel dataset is to apply this Skill, which reads large data tables and produces statistical summaries with key metrics and injected formulas.

How do I apply cell styling like borders and background colors to an XLSX file programmatically?

To apply cell styling like borders and background colors programmatically, this Skill automates alignment, borders, fonts, and conditional formatting on XLSX files while keeping the original workbook structure intact.

Are there limitations when using openpyxl for spreadsheet data analysis on very large files?

When using openpyxl for spreadsheet data analysis on very large files, you may encounter performance constraints inherent to the library, though this Skill is designed to read large data tables and generate statistical summaries efficiently.