Create, edit, analyze, and validate spreadsheet files with pandas and openpyxl.
npx skills add https://github.com/bingo2gether/BingotwoGether --skill xlsx-bingo2gether
Please help me install this Agent Skill. Skill: xlsx Source: https://github.com/bingo2gether/BingotwoGether/tree/main/.agent/skills/xlsx Command: npx skills add https://github.com/bingo2gether/BingotwoGether --skill xlsx-bingo2gether
This Skill streamlines all your spreadsheet tasks, from creating new files and editing existing ones to complex data analysis and ensuring formula integrity.
Use the xlsx skill to create a new spreadsheet named 'sales_report.xlsx' with columns 'Product', 'Quantity', and 'Revenue'.
High-intent search queries and answers about installing and using this skill.
To automate Excel formula recalculation and error checking in xlsx files, this Skill uses openpyxl for formatting control and integrates LibreOffice to recalculate formulas and validate errors. This ensures your spreadsheet formulas are processed correctly without manual intervention.
Yes, you can use pandas for data analysis and cleaning directly within an Excel spreadsheet. This Skill leverages pandas for powerful data manipulation and analysis, allowing you to clean, transform, and visualize tabular data efficiently before saving the updated file.
The best way to convert CSV or TSV files into formatted xlsx spreadsheets is by using this Skill's format conversion feature. It reads tabular formats and applies openpyxl to generate professionally formatted xlsx files with custom fonts, colors, and number formatting.
Yes, this spreadsheet automation approach fully supports creating financial models from scratch. It can generate new xlsx files, apply new financial assumptions, insert formulas, and maintain professional format and style adherence for financial reporting.
Spreadsheet formulas show errors after editing an existing xlsx file when calculations are not triggered properly. This Skill resolves this by using LibreOffice integration to recalculate all formulas and check for errors, ensuring formula integrity before saving.
GayanKavindaCreate, edit, and repair spreadsheet files from raw tabular data.
ZJU-REALCreate, edit, and convert Word documents into finished DOCX files.
mkhsu2002Generate and manipulate DOCX files with python-docx.
nomifunCreate and manipulate Excel workbooks with formulas and formatting via OfficeCLI.
