Create, edit, and analyze Excel workbooks with formulas and formatting.
npx skills add https://github.com/rcstrue/php_payroll --skill xlsx-rcstrue
Please help me install this Agent Skill. Skill: xlsx Source: https://github.com/rcstrue/php_payroll/tree/main/php_payroll/skills/xlsx Command: npx skills add https://github.com/rcstrue/php_payroll --skill xlsx-rcstrue
Comprehensive tool for automatic creation, editing, and analysis of spreadsheet workbooks, enabling formulas, formatting, and data visualization across common formats (.xlsx, .xlsm, .csv, .tsv).
Write a simple directive describing the target workbook and run the tool to produce a ready-to-use Excel file.
High-intent search queries and answers about installing and using this skill.
Automate Excel workbook creation by writing a simple directive to generate new .xlsx spreadsheets with formulas and formatting. The tool uses Python with openpyxl and pandas to produce ready-to-use files for reporting and data-tracking needs.
Yes, you can read and transform data in existing .xlsx or .xlsm workbooks while preserving formulas and structure. The tool edits existing files without breaking formula logic, ensuring data analysis and updates maintain consistency across sheets.
The best way to recalculate formulas in an .xlsx file is using a LibreOffice-based workflow via the recalc.py script. This ensures formula values are refreshed and consistent across sheets without manual intervention.
Yes, the tool supports processing .csv and .tsv files alongside .xlsx and .xlsm formats. It leverages pandas for data processing and openpyxl for workbook generation, enabling comprehensive data analysis and transformation across common spreadsheet formats.
Formulas show stale values when generated with Python because openpyxl writes formulas but does not calculate them. This tool solves the issue by running a LibreOffice-based recalculation script to refresh all formula results reliably.
mattmacleod16-svgAutomate spreadsheet creation, editing, analysis, and formatting with openpyxl and pandas.
phodalAutomate spreadsheet creation, editing, and analysis with Python APIs.
Wesley1600Executes Python scripts that process CLI input and return JSON-formatted results.
ChatAndBuildAutomate Excel spreadsheet creation, editing, and analysis with pandas and openpyxl.
