Create, edit, and analyze Excel spreadsheets with formulas, formatting, and recalculation.
npx skills add https://github.com/jvsandhu/agentic-skills --skill xlsx-jvsandhu
Please help me install this Agent Skill. Skill: xlsx Source: https://github.com/jvsandhu/agentic-skills/tree/main/skills/xlsx Command: npx skills add https://github.com/jvsandhu/agentic-skills --skill xlsx-jvsandhu
High-intent search queries and answers about installing and using this skill.
Use openpyxl to write Excel formulas as strings directly into cells, such as sheet['B10'] = '=SUM(B2:B9)'. Avoid calculating values in Python and hardcoding results, so the spreadsheet stays dynamic and recalculates when source data changes.
openpyxl stores formulas as strings without computed values. Run the recalc.py script with LibreOffice installed: python recalc.py output.xlsx. It recalculates all formulas and returns JSON reporting any errors found.
Use pandas for data analysis, reading, and basic operations like filtering and statistics. Use openpyxl when you need formulas, cell formatting, colors, or editing existing workbooks while preserving their structure.
#REF! comes from invalid cell references and #DIV/0! from dividing by empty or zero cells. The recalc.py script scans all cells and returns JSON with error types and exact locations like Sheet1!B5 so you can fix them.
Yes. Load the file with openpyxl's load_workbook, which preserves existing formulas and formatting. Study the template's conventions first and match its color codes and styles rather than imposing new formatting.
markus41Clean and standardize messy tabular data into normalized DataFrames and formatted .xlsx files.
oimiragieoGenerate multi-sheet Excel workbooks with formulas, charts, and formatting.
HKU-MMLabAnalyzes tender pricing, spreadsheet totals, and vendor financial tradeoffs from local files.
TugoukezhangCreate, inspect, and edit Excel workbooks and XLSX files.
