Create, edit, and analyze Excel spreadsheets with pandas and openpyxl.
npx skills add https://github.com/chacha95/advanced-harness --skill xlsx-chacha95
Please help me install this Agent Skill. Skill: xlsx Source: https://github.com/chacha95/advanced-harness/tree/main/.claude/skills/xlsx Command: npx skills add https://github.com/chacha95/advanced-harness --skill xlsx-chacha95
This Skill automates the creation, editing, and analysis of Excel spreadsheets, eliminating manual data manipulation and formula errors.
.xlsx, .csv, and .tsv files using pandas and openpyxl.Use the xlsx skill to create a new spreadsheet named 'sales_report.xlsx' with columns 'Date', 'Sales', and 'Region'.
High-intent search queries and answers about installing and using this skill.
Automating Excel report generation without formula errors is handled by using Python libraries like pandas and openpyxl to programmatically apply calculations and format spreadsheets. This ensures zero formula errors and preserves existing templates while pulling and processing data.
Yes, you can use Python to clean messy data and convert between CSV and xlsx files. By leveraging pandas and openpyxl, the skill reads, writes, and modifies tabular formats like .xlsx, .csv, and .tsv, seamlessly transforming and cleaning the data during the conversion process.
Yes, you need LibreOffice to recalculate Excel formulas in openpyxl. The skill requires LibreOffice specifically for formula recalculation via a dedicated script, ensuring that all computed formulas return correct values when modifying spreadsheets programmatically.
The best way to add columns and format charts in an existing spreadsheet is using Python automation tools like pandas and openpyxl. This method handles data manipulation, computes formulas, and applies formatting while ensuring existing templates are fully preserved.
Yes, this Excel automation approach works with TSV files. Using pandas and openpyxl, the skill fully supports reading, writing, and modifying .xlsx, .csv, and .tsv tabular formats, allowing seamless data manipulation and conversion across all supported file types.
cbbkrd-techCreate, edit, and analyze .xlsx, .xlsm, .csv, and .tsv files with pandas and openpyxl.
aiyinluyaRead and analyze a single Excel worksheet into cleaned rows, metrics, and charts.
mkalhitti-cloudCreate and edit Excel workbooks with formulas and charts.
iOfficeAICreate, edit, and analyze Excel spreadsheets with pandas and openpyxl.