Automates creation, editing, and analysis of spreadsheet files using Python libraries.
npx skills add https://github.com/PM-Shawn/Abu-Cowork --skill xlsx-pm-shawn
Please help me install this Agent Skill. Skill: xlsx Source: https://github.com/PM-Shawn/Abu-Cowork/tree/main/builtin-skills/xlsx Command: npx skills add https://github.com/PM-Shawn/Abu-Cowork --skill xlsx-pm-shawn
This Skill streamlines the creation, editing, and analysis of spreadsheet files, eliminating manual data manipulation and complex formula creation.
scripts/recalc.py tool, which integrates with LibreOffice.Use the xlsx skill to create a new Excel file named 'sales_report.xlsx' with columns 'Date', 'Product', and 'Revenue', and populate it with the provided sales data.
High-intent search queries and answers about installing and using this skill.
To automate Excel spreadsheet creation and formatting, use this Skill to leverage pandas for data analysis and openpyxl for formula insertion and formatting, eliminating manual data manipulation and complex formula creation.
Yes, you can recalculate and verify Excel formulas without opening Excel by using a Python script that integrates with LibreOffice. This ensures formula accuracy, checks for errors, and confirms zero formula errors in your spreadsheets.
Yes, pandas works with .xlsx and .xlsm files for data analysis. This Skill uses pandas combined with openpyxl to handle data manipulation, bulk operations, and analysis on Excel files, including .csv and .tsv formats.
The best way to apply financial model color coding in Excel is by using openpyxl within Python to automate industry-standard color rules and number formatting. This ensures professional formatting and consistency across financial projection spreadsheets.
To preserve existing Excel templates when inserting new formulas, use openpyxl to edit the file while maintaining its original structure. The Skill ensures existing templates are preserved while adding complex formulas and professional formatting.
Yes, you can generate a financial projection spreadsheet from raw data automatically. The Skill constructs complex formulas, applies industry-standard color coding, and ensures zero formula errors by verifying accuracy through recalculation scripts.
vibeingingRead, analyze, and generate results from Excel and CSV files.
imvladikonAutomate Excel workbook editing with formulas via openpyxl and pandas.
loganylchenCreate, edit, analyze, and visualize .xlsx, .csv, and .tsv spreadsheets with Python.
ChatAndBuildAutomate Excel spreadsheet creation, editing, and analysis with pandas and openpyxl.