무엇인가요?

The xlsx skill enables comprehensive spreadsheet operations including creation, editing, analysis, and formula management for Excel files (.xlsx, .xlsm, .csv, .tsv). Emphasizes zero formula errors and professional financial modeling standards with strict formatting and documentation requirements.

사용 방법

Use pandas for data analysis and bulk operations. Use openpyxl for formulas, formatting, and complex Excel features. Use recalc.py for formula recalculation via LibreOffice. Always use Excel formulas instead of hardcoded values. Follow financial model color coding (blue for inputs, black for formulas, green for worksheet links, red for external references).

주요 기능

• Zero formula errors requirement (#REF!, #DIV/0!, etc.)
• Template preservation when updating existing files
• Financial model color coding standards
• Professional number formatting (currency, percentages, negatives)
• Documentation requirements for hardcoded values
• Formula recalculation with zero errors
• Data analysis and visualization
• Support for .xlsx, .xlsm, .csv, .tsv formats