xlsx 电子表格

Open, read, edit, repair, and convert .xlsx, .xlsm, .csv, and .tsv files.

1|Updated Jan 15, 2026
One-click install
npx skills add https://github.com/XIYBHK/claude-skills --skill xlsx-xiybhk
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx 电子表格
Source: https://github.com/XIYBHK/claude-skills/tree/main/xlsx
Command: npx skills add https://github.com/XIYBHK/claude-skills --skill xlsx-xiybhk

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires openpyxl, defusedxml, lxml, and includes scripts (resource) components.

What problem does it solve?

This Skill reduces the manual toil of spreadsheet work by offering automated opening, reading, editing, repairing, and converting .xlsx, .xlsm, .csv, and .tsv files, delivering cleaned and ready-to-use spreadsheets.

Core Features & Use Cases

  • Open, read, edit, repair, and convert spreadsheet formats across Excel and CSV varieties.
  • Clean messy data, apply formulas, format cells, and generate charts or outputs for reporting.
  • Use case: you have a disorganized dataset in an .xlsx file with inconsistent headers; run this Skill to normalize the data and export a polished .xlsx.

Quick Start

Provide a path to a spreadsheet file and specify the desired output format; the tool will load, process, and save the result.

Frequently Asked Questions about xlsx 电子表格

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

FAQPage Schema
How do I automate cleaning messy xlsx files and normalizing inconsistent headers?

You can automate cleaning messy xlsx files by running Python scripts that load your spreadsheet, normalize inconsistent headers, apply formulas, and export a polished .xlsx file with reproducible outputs.

What is the best way to convert CSV to xlsx while preserving formulas?

The best way to convert CSV to xlsx while preserving formulas is using Python tooling like openpyxl, which reads the source data, applies the necessary formulas, and saves the result as a formula-preserving .xlsx file.

How do I repair corrupted xlsx files using Python?

You can repair corrupted xlsx files using Python by loading the damaged spreadsheet with openpyxl and defusedxml, which safely parses the underlying XML structure and rewrites a clean, reproducible .xlsx output.

Does openpyxl support reading and editing xlsm files with macros?

Yes, openpyxl supports opening, reading, and editing .xlsm files, allowing you to process macro-enabled spreadsheets, clean the data, apply formatting, and save the modified .xlsm output.

How do I apply formulas and format cells in a spreadsheet via Python?

You apply formulas and format cells in a spreadsheet via Python by loading the file with openpyxl, programmatically assigning the desired formulas and cell styles, and saving the updated .xlsx or .xlsm file.

What are the limitations of using Python for spreadsheet conversion?

A limitation of using Python for spreadsheet conversion is that complex native Excel features like dynamic array formulas or pivot tables may not fully translate, though standard formulas and cell formatting are preserved reproducibly.