Create, edit, and format Excel workbooks with formulas across .xlsx, .xlsm, and .csv files.
npx skills add https://github.com/roderik/mpe --skill xlsx-roderik
Please help me install this Agent Skill. Skill: xlsx Source: https://github.com/roderik/mpe/tree/main/.agents/skills/xlsx Command: npx skills add https://github.com/roderik/mpe --skill xlsx-roderik
Excel users spend excessive time copying data, applying formulas, and formatting spreadsheets, leading to errors and delays in reporting.
Use the xlsx skill to create a new workbook named 'sample.xlsx' with a 3-row table and a simple total formula, then save and open the file to verify outputs.
High-intent search queries and answers about installing and using this skill.
Automate Excel workbook creation by using openpyxl to populate templates, apply formulas, and format spreadsheets across .xlsx, .xlsm, and .csv files. This approach eliminates manual data entry errors and accelerates automated reporting workflows.
Yes, you can preserve existing Excel template styles while updating data. The workflow applies calculations and data modifications to your templates without overwriting original formatting, ensuring visual consistency across automated report generation.
openpyxl handles formula recalculation by integrating optional recalc tooling and LibreOffice. This mechanism guarantees zero-error outputs by forcing formula updates before saving workbooks, preventing stale cached values in your data analysis.
This automated spreadsheet editing approach fully supports .xlsm and .csv files in addition to standard .xlsx workbooks. You can seamlessly edit, apply formulas, and format across all three formats within your data analytics workflows.
The best way to generate Excel data visualizations is through programmatic workbook editing that creates summaries, charts, and conditional formatting. This method supports decision making by automatically visualizing data within the generated spreadsheets.
Excel formulas show stale cached values when using openpyxl because it does not natively recalculate formulas on save. The workflow resolves this by utilizing LibreOffice and optional recalc tooling to force calculation and guarantee zero-error outputs.
JacksonhufConvert and transform spreadsheet data between .xlsx, .csv, and .tsv files.
shalevaminCreate, edit, analyze, and format .xlsx, .csv, and .tsv spreadsheet files.
DevHive1Generate Excel workbooks with formatting, formulas, and charts using openpyxl and xlsxwriter.
safzanpiraniCreate, edit, and analyze Excel files with pandas and openpyxl.
