Run2 xlsx analysis
Improved Excel data analysis and formula manipulation using openpyxl.From its SKILL.md
npx -y skills add cxcscmu/SkillLearnBench --skill run2_xlsx-analysisAssembled from the repository path, not quoted from the project. Check it against their README if it does not work.
SKILL.md
0.4 KB, 85 tokens by cl100k_base, as published. Nobody here has run it
Usage
- Use openpyxl.load_workbook('file.xlsx') to work with formulas.
- Use sheet.cell(row=R, column=C).number_format to set format.
- Use sheet.cell(row=R, column=C).value = '=Formula' for calculations.
- Use recalc.py to evaluate formulas after changes.
- Handle potential compatibility issues (e.g. PERCENTILE vs PERCENTILE.INC).
What ships with it
Read from the repository
Just SKILL.md. No reference files, no scripts.