Create, edit, and analyze Excel spreadsheets with formulas, formatting, and recalculation.
npx skills add https://github.com/ramshan00/hackaton --skill xlsx-ramshan00
Please help me install this Agent Skill. Skill: xlsx Source: https://github.com/ramshan00/hackaton/tree/main/Hackathon2-phase2/.claude/skills/xlsx Command: npx skills add https://github.com/ramshan00/hackaton --skill xlsx-ramshan00
High-intent search queries and answers about installing and using this skill.
Use openpyxl to write formula strings directly into cells, such as sheet['B10'] = '=SUM(B2:B9)'. Always use Excel formulas rather than computing values in Python, 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 edits that preserve an existing workbook's structure.
openpyxl stores formulas as strings without computed values, so run the recalc.py script with LibreOffice: python recalc.py output.xlsx. It recalculates all sheets and returns JSON reporting any formula errors with their cell locations.
#REF! comes from invalid cell references and #DIV/0! from dividing by empty or zero cells. The recalc.py output lists each error type with locations like Sheet1!B5, so you can fix references and add denominator checks.
Yes, load the workbook with data_only=True to read cached calculated values. However, never save a workbook opened this way, because formulas are permanently replaced with their static values.
EdgeHuntCreate, edit, and analyze .xlsx, .csv, and .tsv spreadsheets with formulas and pivot tables.
Duzhenyang111Validate Excel workbooks for formula errors and structural flaws using Python.
HKU-MMLabAnalyzes tender pricing, spreadsheet totals, and vendor financial tradeoffs from local files.
MCERQUACreate, edit, and analyze Excel files with openpyxl and pandas.
