Create and edit Excel workbooks with Python while preserving formulas and formatting.
npx skills add https://github.com/khaneliman/khanelinix --skill xlsx-khaneliman
Please help me install this Agent Skill. Skill: xlsx Source: https://github.com/khaneliman/khanelinix/tree/main/modules/common/ai-tools/skills/xlsx Command: npx skills add https://github.com/khaneliman/khanelinix --skill xlsx-khaneliman
Excel workbook creation, editing, and analysis with formulas, formatting, and data visualization in a reproducible Python workflow.
Create a new Excel workbook with a sample data table and built-in formulas ready to recalculate.
High-intent search queries and answers about installing and using this skill.
Create an Excel workbook with formulas by using Python to generate data tables with built-in formulas ready for calculation. This approach applies pandas for data handling and openpyxl for standard formatting and styling across multiple sheets.
Yes, you can edit existing Excel templates while preserving their original styles, templates, and existing formulas. The workflow modifies template content directly without destroying the pre-configured formatting or calculation logic.
Recalculate Excel formulas after modifying a workbook by running the recalc.py tool. This validates and recalculates all formulas within the generated or edited xlsx files to ensure computed values are accurate.
Yes, openpyxl supports building financial models with multiple sheets. It handles formulas and styling across sheets, while pandas manages the underlying data analysis for the financial model or ad-hoc analyses.
Automate Excel workbook generation for data analysis by using a reproducible Python workflow. This process combines pandas for data manipulation with openpyxl to apply formatting, insert formulas, and output ready-to-share reports.
JayRHaClean messy tabular datasets with pandas using auditable transformation steps.
eesha000009-devCreate and edit .xlsx spreadsheets with preserved formulas and formatting.
koya-altGenerate .xlsx files with formatting, formulas, charts, and data validation using openpyxl or xlsxwriter.
syusamaAnalyze Excel and CSV files with SQL queries via DuckDB.
