Create, edit, and analyze Excel spreadsheets with formulas, formatting, and recalculation.
npx skills add https://github.com/Avistian/nba --skill xlsx-avistian
Please help me install this Agent Skill. Skill: xlsx Source: https://github.com/Avistian/nba/tree/main/.cursor/skills/xlsx Command: npx skills add https://github.com/Avistian/nba --skill xlsx-avistian
High-intent search queries and answers about installing and using this skill.
Use openpyxl to write formulas as strings, such as sheet['B10'] = '=SUM(B2:B9)', then save the workbook. Always use Excel formulas instead of computing values in Python so the spreadsheet recalculates when source data changes.
openpyxl stores formulas as strings without computed values, so run the recalc.py script with your filename to recalculate via LibreOffice. It returns JSON with error counts and cell locations for any #REF!, #DIV/0!, or similar issues.
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, multiple sheets, or edits that preserve an existing workbook's structure.
#REF! comes from invalid cell references and #DIV/0! from dividing by empty or zero cells. Run recalc.py to get exact error locations, verify references and denominators, fix the formulas, and recalculate again until zero errors remain.
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.
AIDotNetRead, write, format, and analyze Excel workbooks with Python and openpyxl.
claude-office-skillsAnalyze Excel or CSV spreadsheet data to generate insights, visualizations, and reports.
ComposioHQAutomate spreadsheet operations including workbook creation, data management, and cell formatting across cloud platforms.
