Create, edit, and analyze XLSX files with formulas and pandas.
npx skills add https://github.com/ttmouse/skills --skill xlsx-ttmouse
Please help me install this Agent Skill. Skill: xlsx Source: https://github.com/ttmouse/skills/tree/main/xlsx Command: npx skills add https://github.com/ttmouse/skills --skill xlsx-ttmouse
This Skill streamlines the creation, modification, and analysis of spreadsheet files, ensuring data integrity and dynamic calculations.
.xlsx files with formulas, formatting, and data.Use the xlsx skill to analyze the data in 'sales_report.xlsx' and create a new file 'summary.xlsx' with calculated quarterly totals.
High-intent search queries and answers about installing and using this skill.
Editing an existing Excel file while preserving formulas requires targeted manipulation that avoids overwriting formula cells. This skill modifies existing spreadsheets while preserving formulas and maintaining structural integrity, ensuring your dynamic calculations remain intact throughout the editing process.
Recalculating formulas in an xlsx spreadsheet ensures accuracy by triggering a recalculation engine to recompute all cell values. This skill uses a dedicated script with LibreOffice to ensure all formulas are correctly recalculated and validated for error-free results.
Yes, you can use pandas for data analysis on an existing Excel spreadsheet to perform in-depth data manipulation and extract insights. This skill leverages pandas to handle data analysis tasks, enabling you to process spreadsheet data and generate calculated summaries from your xlsx files.
The best way to create a new xlsx file with complex formulas is using a library that supports dynamic spreadsheet generation. This skill enables dynamic spreadsheet creation, generating new .xlsx files populated with formulas, formatting, and structured data programmatically.
Yes, validating spreadsheet formulas requires LibreOffice to ensure accurate recalculation and error checking. This skill depends on LibreOffice to run a dedicated script that forces formula recalculation and validates results, guaranteeing data integrity before saving your xlsx files.
ChenYCLCreate, read, edit, and analyze Excel spreadsheet files with openpyxl and pandas.
Ab0umarCreate and modify multi-sheet .xlsx workbooks with formulas and charts.
CHENyiru3Automate reading, cleaning, restructuring, and formatting of spreadsheet files.
soq123Generate and format Excel workbooks with formulas, charts, and pivot summaries using Python.