xlsx-zh

Name: xlsx-zh
Availability: InStock
Author: senthxu-a11y

Automate data extraction, cleanup, formula management, and format preservation in Excel spreadsheets.

Updated Aug 23, 2026

Search Tags:#automation #spreadsheet #excel #xlsx #data cleaning #formula

Ready to run

npx skills add https://github.com/senthxu-a11y/LTclaw1.0 --skill xlsx-zh

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: xlsx-zh
Source: https://github.com/senthxu-a11y/LTclaw1.0/tree/main/src/ltclaw_gy_x/agents/skills/xlsx-zh
Command: npx skills add https://github.com/senthxu-a11y/LTclaw1.0 --skill xlsx-zh

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires openpyxl, pandas, scripts/recalc.py, and includes scripts (resource) components.

What problem does it solve?

This Skill enables users to automate reading, editing, and transforming Excel files, reducing manual data handling efforts.

Core Features & Use Cases

File Manipulation: Open, read, and write to .xlsx, .xlsm, .csv, and .tsv files programmatically.
Data Cleaning: Detect and fix common errors like formula issues or data inconsistencies.
Use Case: For financial modeling, quickly clean a large dataset by removing cell errors, then apply updates via formulas to generate reports automatically.

Quick Start

Use the xlsx skill to load a spreadsheet, add a formula to sum sales, and save the file.

Frequently Asked Questions about xlsx-zh

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

FAQPage Schema

How do I automate data extraction and cleanup in Excel spreadsheets?▼

Automating Excel spreadsheet data extraction and cleanup involves programmatically detecting and fixing formula issues or data inconsistencies. This Skill uses openpyxl and pandas to read, edit, and transform files while preserving formats and managing formulas.

Can I use pandas and openpyxl to modify xlsx files without losing existing formulas?▼

Yes, you can modify xlsx files without losing existing formulas using pandas and openpyxl. This Skill preserves spreadsheet formats and relies on LibreOffice for formula recalculation and validation after updates are applied.

What is the best way to automate financial reporting from large datasets in Excel?▼

Automating financial reporting from large datasets in Excel is best achieved by programmatically removing cell errors and applying formulas. This Skill supports financial modeling by cleaning data and generating reports automatically via scripts.

Does this approach support reading and writing to both csv and xlsx file formats?▼

Yes, this approach supports reading and writing to both csv and xlsx file formats. The file manipulation capabilities extend to .xlsx, .xlsm, .csv, and .tsv files, allowing you to open, read, and write programmatically.

Why do I need LibreOffice for Excel formula recalculation and validation?▼

You need LibreOffice for Excel formula recalculation and validation because it processes the formulas outside of native Excel. This Skill relies on LibreOffice to ensure formulas calculate correctly and validate results after automated modifications.

Are there limitations when using openpyxl for spreadsheet automation with large datasets?▼

Limitations when using openpyxl for spreadsheet automation with large datasets include handling complex formula recalculations natively. This Skill addresses this by using LibreOffice for recalculation, but users should anticipate processing overhead with very large files.