Automate Excel spreadsheet creation, editing, and analysis with pandas and openpyxl.
npx skills add https://github.com/psd401/psd-claude-plugins --skill xlsx-psd401
Please help me install this Agent Skill. Skill: xlsx Source: https://github.com/psd401/psd-claude-plugins/tree/main/plugins/psd-productivity/skills/xlsx Command: npx skills add https://github.com/psd401/psd-claude-plugins --skill xlsx-psd401
This Skill streamlines spreadsheet management by automating the creation, editing, and analysis of Excel files, ensuring accuracy and efficiency.
Use the xlsx skill to create a new spreadsheet named 'sales_report.xlsx' with columns for 'Date', 'Product', and 'Revenue', and populate it with sample data.
High-intent search queries and answers about installing and using this skill.
Automate Excel spreadsheet creation by using openpyxl for file operations and pandas for data manipulation, then trigger LibreOffice via recalc.py to recalculate formulas and ensure zero formula errors. This workflow generates accurate .xlsx files with industry-standard formatting.
Yes, you can edit an existing .xlsx template without losing formatting because the Skill preserves existing templates and adheres to industry-standard color coding and number formatting rules during any spreadsheet modification or data insertion.
The best way to perform data analysis on Excel spreadsheets is to leverage pandas for in-depth data manipulation directly on .xlsx, .xlsm, .csv, and .tsv files, enabling you to generate insights and visualizations without manual data export.
openpyxl handles file operations and formula creation, but automatic recalculation of complex Excel formulas is achieved by utilizing LibreOffice through a dedicated recalc.py script, ensuring zero formula errors in your spreadsheets.
Excel formulas show errors when generating financial models due to calculation chain breaks, but this Skill prevents formula errors by utilizing LibreOffice for accurate recalculation and adheres to industry-standard number formatting rules.
You need Python with openpyxl>=3.1.0 installed to generate a financial projection model in Excel, allowing you to automate correct formulas, color coding, and number formatting based on provided assumptions.
zjy-devCreate, edit, and analyze Excel files with pandas and openpyxl.
rangerrick337Automate Excel spreadsheet creation, editing, and analysis with formula integrity across .xlsx, .xlsm, .csv, and .tsv.
jeffpeckyAutomate Excel workflows with pandas and openpyxl for data analysis and editing.
kollaboraiCreate, edit, analyze, and convert Excel spreadsheet files with formulas.
