What libraries does it use for spreadsheet operations?

It leverages pandas for high-performance data analysis and bulk operations, and openpyxl for complex cell-level formatting, formulas, and Excel-specific features.

Can it modify existing corporate templates?

Yes, the skill is designed to study and match existing styles, formats, and conventions to preserve the visual and structural integrity of your established templates.

Does this skill support complex Excel formulas?

Yes, it prioritizes using native Excel formulas over hardcoded values to ensure your spreadsheets remain dynamic and interactive after generation.

How does the skill handle formula errors like #REF! or #DIV/0!?

It includes a mandatory recalculation and verification step using a specialized script to detect and report any formula errors before the file is finalized.

Is LibreOffice required for this skill?

LibreOffice is used by the integrated recalculation script to ensure all formulas are correctly evaluated and verified across the workbook, providing a fail-safe against broken links.

Advanced Excel & Spreadsheet Toolkit

Name: Advanced Excel & Spreadsheet Toolkit
Author: hameed0342j

byhameed0342j

0•

数据科学与机器学习

Automates the creation, modification, and analysis of complex Excel spreadsheets with high-fidelity formatting and formula preservation.

This skill empowers Claude to perform advanced spreadsheet operations, ranging from simple CSV parsing to building professional financial models with industry-standard formatting. It ensures formula integrity by using dynamic Excel functions instead of hardcoded values and includes a dedicated recalculation engine to verify data accuracy across all sheets. Whether you are generating reports with pandas or styling workbooks with openpyxl, this skill provides the rigorous standards and error-checking needed for professional-grade data manipulation, visualization, and financial analysis.

主要功能

010 GitHub stars

02Advanced data analysis and visualization using pandas and openpyxl libraries

03Professional financial modeling with industry-standard color coding and number formatting

04Dynamic formula generation to ensure spreadsheets remain interactive and updateable

05Comprehensive support for .xlsx, .xlsm, .csv, and .tsv formats

06Automated formula recalculation and error detection using LibreOffice integration

使用场景

01Updating existing reporting templates while strictly preserving original formatting and styles

02Building automated financial models with growth projections and valuation multiples

03Performing large-scale data analysis and cleaning with automated export to formatted workbooks

主要功能

010 GitHub stars

02Advanced data analysis and visualization using pandas and openpyxl libraries

03Professional financial modeling with industry-standard color coding and number formatting

04Dynamic formula generation to ensure spreadsheets remain interactive and updateable

05Comprehensive support for .xlsx, .xlsm, .csv, and .tsv formats

06Automated formula recalculation and error detection using LibreOffice integration

使用场景

01Updating existing reporting templates while strictly preserving original formatting and styles

02Building automated financial models with growth projections and valuation multiples

03Performing large-scale data analysis and cleaning with automated export to formatted workbooks