Create, edit, and analyze Excel spreadsheets with formulas, formatting, and recalculation.
npx skills add https://github.com/Emmanuel-R8/aikos --skill xlsx-emmanuel-r8
Please help me install this Agent Skill. Skill: xlsx Source: https://github.com/Emmanuel-R8/aikos/tree/main/.cursor/skills/xlsx Command: npx skills add https://github.com/Emmanuel-R8/aikos --skill xlsx-emmanuel-r8
High-intent search queries and answers about installing and using this skill.
Use openpyxl to create a workbook and assign formula strings like '=SUM(B2:B9)' directly to cells, then save the file. Always use Excel formulas instead of hardcoding Python-calculated values so the spreadsheet recalculates when source data changes.
Use pandas for data analysis, bulk operations, and simple exports with pd.read_excel and df.to_excel. Use openpyxl when you need formulas, cell formatting, styles, or to modify existing workbooks while preserving their structure.
openpyxl saves formulas as strings without computed values, so run the recalc.py script with LibreOffice to recalculate all formulas. It returns JSON reporting total formulas, error counts, and exact cell locations of any errors.
#REF! occurs from invalid cell references and #DIV/0! from dividing by zero or empty cells. Run recalc.py to get exact error locations, verify cell references and denominators, fix the formulas, and recalculate again.
Yes, load the workbook with data_only=True to read cached calculated values. However, never save a workbook opened this way, because doing so permanently replaces all formulas with their static values.
nicepkgTransform raw data from CSVs, spreadsheets, databases, and APIs into executive reports.
cna-bootcampGenerate slide-by-slide presentation scripts from business models using Sequential MCP.
MuzeWinterValidate analysis claims, calculations, visuals, and conclusions before stakeholder sharing.
dfpalhanoManage Google Sheets data and formatting via the Sheets API with Node.js.
