Does this skill work with large datasets?

Absolutely. It leverages the pandas library for high-performance data manipulation and openpyxl for efficient reading and writing of large Excel workbooks.

Can it maintain existing spreadsheet formatting?

Yes, it is designed to study and match existing formats, styles, and conventions of your templates, ensuring that updates look seamless and professional.

How does the skill handle formula errors?

The skill includes a mandatory recalculation and verification step using a specialized script that detects #REF!, #DIV/0!, and other common Excel errors, allowing the AI to fix them before final delivery.

Why does it require LibreOffice?

LibreOffice is used in the background to programmatically recalculate formula values and ensure that the spreadsheet data is up-to-date and accurate without requiring manual intervention.

Advanced XLSX Spreadsheet Automation

Name: Advanced XLSX Spreadsheet Automation
Author: leduclinh7141

byleduclinh7141

•

データサイエンスとML

Automates professional-grade spreadsheet creation, editing, and analysis with a focus on formula integrity and financial modeling standards.

概要

The document-skills (xlsx) skill provides Claude with comprehensive capabilities for handling complex spreadsheet tasks. It enables the creation of dynamic Excel models featuring automated formula recalculation, industry-standard financial formatting, and sophisticated data analysis. By combining pandas for data manipulation and openpyxl for precise formatting, the skill ensures that spreadsheets remain dynamic and error-free. It is particularly valuable for users needing to generate professional financial reports, automate bulk data processing, or audit existing workbooks for formula errors like #REF! or #DIV/0!.

主な機能

Industry-standard financial model formatting and color-coding conventions
Template preservation that respects and matches existing file styles and conventions
Seamless integration with pandas for advanced data analysis and visualization
1 GitHub stars
Automated formula recalculation and error verification via LibreOffice integration
Dynamic formula injection and preservation to avoid hardcoded values

ユースケース

Converting and cleaning large CSV/TSV datasets into formatted Excel reports
Building automated financial models with standardized assumptions and projection logic
Auditing complex spreadsheets to identify and fix formula errors and broken references

概要

主な機能

Industry-standard financial model formatting and color-coding conventions
Template preservation that respects and matches existing file styles and conventions
Seamless integration with pandas for advanced data analysis and visualization
1 GitHub stars
Automated formula recalculation and error verification via LibreOffice integration
Dynamic formula injection and preservation to avoid hardcoded values

ユースケース

Converting and cleaning large CSV/TSV datasets into formatted Excel reports
Building automated financial models with standardized assumptions and projection logic
Auditing complex spreadsheets to identify and fix formula errors and broken references