XLSX Spreadsheet Management

关于

This skill enables Claude to handle professional spreadsheet tasks ranging from simple data entry to complex financial modeling. It ensures high-quality outputs by enforcing zero-error formula policies, adhering to industry-standard color coding (blue for inputs, black for formulas), and prioritizing dynamic Excel formulas over static hardcoded values. With built-in support for libraries like pandas and openpyxl, alongside a specialized recalculation script, it provides a robust environment for creating, modifying, and verifying .xlsx and .csv files while preserving existing templates and styles.

主要功能

• Sophisticated data manipulation and visualization using pandas and openpyxl
• Adherence to industry-standard financial modeling conventions and color-coding
• Dynamic formula construction and automated verification to eliminate calculation errors
• Preservation of existing spreadsheet templates, formatting, and conventions
• Formula recalculation and error scanning using integrated LibreOffice scripts
• 22,963 GitHub stars

使用场景

• Building professional financial models with automated projections and scenario assumptions
• Analyzing large datasets and generating formatted reports with visualizations
• Updating existing spreadsheet templates while maintaining complex formula chains and styling