xlsx

Automate workbook creation by using openpyxl to generate .xlsx files with formulas, formatting, and sample data. The Skill constructs formulas with explicit assumptions, applies color coding and number formatting standards, and prevents formula errors during generation to ensure accurate calculations.

Yes, formula-preserving edits maintain formulas intact while you modify data and structure. The Skill updates templates across .xlsx, .xlsm, .csv, and .tsv formats while preserving formula references, so your existing calculations remain valid.

Use LibreOffice-based recalculation for large workbooks to ensure all formulas update correctly. The Skill automates recalculation workflows to prevent formula errors and maintain data consistency across complex spreadsheets.

Read and analyze spreadsheet data using pandas-based data analysis combined with openpyxl. The Skill extracts data from .xlsx, .xlsm, .csv, and .tsv files and performs analysis and visualization to generate actionable insights.

The Skill handles .xlsx, .xlsm, .csv, and .tsv workflows, so you can automate spreadsheet operations across multiple file formats. It creates, edits, and analyzes data consistently whether working with native Excel files or delimited text formats.

The Skill documents hardcodes explicitly to distinguish them from formulas and maintains both during edits. This prevents confusion about which values are static and which are calculated, ensuring formula integrity.