Create and modify Excel workbooks with formulas and formatting.
npx skills add https://github.com/stvlynn/dingtalk-wukong-skills --skill xlsx-stvlynn
Please help me install this Agent Skill. Skill: xlsx Source: https://github.com/stvlynn/dingtalk-wukong-skills/tree/main/xlsx Command: npx skills add https://github.com/stvlynn/dingtalk-wukong-skills --skill xlsx-stvlynn
Excel is the core tool for data analysis, reporting, and modeling, but repetitive workbook creation and formula maintenance waste time and introduce errors. This Skill provides a structured workflow to create, modify, and analyze spreadsheets while ensuring formulas remain correct and outputs reproducible.
Create a new Excel workbook with data, then apply formulas and formatting and run the recalculation to verify zero errors.
High-intent search queries and answers about installing and using this skill.
You can automate Excel spreadsheets with formulas using a structured workflow that applies openpyxl formulas and validates outputs via a LibreOffice-backed recalculation script to enforce zero formula errors.
Yes, you can update existing Excel templates by injecting new data while preserving the original formulas and formatting, then running a recalculation step to validate that the workbook contains zero formula errors.
The best way to generate formatted Excel reports is to transform data using pandas, write it to a workbook with openpyxl to apply Excel-style formulas and formatting, and recalculate to verify the final output.
You recalculate Excel formulas by executing a recalc.py script backed by LibreOffice, which processes the workbook, evaluates all formulas, and reports any errors to ensure deliverables maintain formula integrity.
Yes, this spreadsheet automation approach works for finance, operations, and analytics workflows by creating new workbooks, updating templates, and generating formatted reports with validated Excel-style formulas.
openpyxl formulas show as plain text because it does not calculate formula values natively; you must run a LibreOffice-backed recalculation script to evaluate the formulas and generate the actual calculated values.
Science-DiscoveryAutomate Excel data analysis and visualization with pandas, openpyxl, and matplotlib.
md-rayConvert Indonesian bank statement PDFs into categorized Excel spreadsheets.
h4vzzClean raw datasets into analysis-ready tables using pandas, pyjanitor, and great_expectations.
Mohamed-ElkahefBuild interactive analytics dashboards with Chart.js for business metrics and KPIs.
