Create and edit Excel spreadsheets with formulas and data analysis.
npx skills add https://github.com/Ansteorra/KMP --skill xlsx-ansteorra
Please help me install this Agent Skill. Skill: xlsx Source: https://github.com/Ansteorra/KMP/tree/main/.github/skills/xlsx Command: npx skills add https://github.com/Ansteorra/KMP --skill xlsx-ansteorra
This Skill empowers users to create, edit, analyze, and manage complex spreadsheet files (.xlsx, .xlsm, .csv, .tsv) efficiently, automating tasks that would otherwise be time-consuming and error-prone.
Use the xlsx skill to create a new spreadsheet named 'sales_report.xlsx' with columns for 'Date', 'Product', and 'Revenue', and add a formula in the 'Total Revenue' cell to sum the 'Revenue' column.
High-intent search queries and answers about installing and using this skill.
Automate spreadsheet creation and formula recalculation by generating or modifying .xlsx files with openpyxl, ensuring formulas are correctly constructed and recalculated. This process builds new spreadsheets with custom formatting and updates existing financial models while preserving data integrity.
Updating an existing financial model in Excel without breaking formulas is possible by modifying assumptions and adding projection years while preserving formula integrity. The system ensures all formulas are error-free and properly recalculated using LibreOffice integration.
openpyxl supports data analysis and visualization for Excel files by reading, writing, and formatting spreadsheet data. When combined with pandas, it facilitates comprehensive data analysis, allowing users to process large datasets and create visual representations efficiently.
The best way to edit .xlsm and .csv files while maintaining formatting standards is using automated spreadsheet management tools. These tools modify existing files, apply custom formatting, and perform error checking via LibreOffice integration to ensure strict adherence to financial modeling standards.
Spreadsheet formulas may return errors after editing xlsx files if formulas are not correctly constructed or recalculated. Using LibreOffice integration for error checking ensures all formulas are error-free, properly documented, and recalculated accurately after modifications.
You need pandas to perform advanced data analysis on .tsv files because it provides the powerful tools required to process and analyze tab-separated data. This combination allows for comprehensive data manipulation and visualization alongside standard spreadsheet management.
mattmacleod16-svgAutomate spreadsheet creation, editing, analysis, and formatting with openpyxl and pandas.
imvladikonAutomate Excel workbook editing with formulas via openpyxl and pandas.
el2060Automate Excel data manipulation, analysis, and formatting with pandas and openpyxl.
DrugClawCreate, edit, and analyze spreadsheet files with pandas and openpyxl.
