spreadsheet

To edit Excel spreadsheets without breaking formulas, you need a formula-aware handler that preserves cached values, cell references, and workbook structure during updates. This skill uses openpyxl to safely modify files while keeping formulas and formatting intact.

Analyzing tabular data from CSV and TSV files is best handled with pandas, which enables filtering, grouping, and pivot-style summaries. This skill processes CSV and TSV inputs to calculate metrics and generate structured analytical outputs.

Yes, openpyxl supports creating Excel workbooks with charts, formulas, and styling. This skill leverages openpyxl to build new workbooks featuring structured layouts, visual formatting, and embedded charts for finance-style reporting.

You can update finance reporting workbooks while preserving formatting by using source-aware editing tools. This skill carefully modifies financial models and reporting files, ensuring readable outputs and maintaining original presentation conventions.

Yes, you need pandas and openpyxl to process spreadsheet files with this skill. Pandas handles tabular analysis and CSV processing, while openpyxl manages workbook creation, formula-aware handling, and visual formatting.

Spreadsheet formulas stop working when updates overwrite formula cells with static values or break references. This skill prevents this by using formula-aware recalculation and structure preservation to maintain formula integrity during edits.