Create, modify, and validate spreadsheet files with formulas via LibreOffice.
npx skills add https://github.com/phuhao00/bony-agent --skill xlsx-phuhao00
Please help me install this Agent Skill. Skill: xlsx Source: https://github.com/phuhao00/bony-agent/tree/main/.agent/skills/xlsx Command: npx skills add https://github.com/phuhao00/bony-agent --skill xlsx-phuhao00
This Skill resolves the friction of manual spreadsheet management by providing a robust, formula-aware environment for creating, editing, and cleaning complex tabular data.
Use the xlsx skill to read the file 'sales_data.csv', clean the headers, add a total column with a sum formula, and save the result as 'final_report.xlsx'.
High-intent search queries and answers about installing and using this skill.
Consolidating multiple CSV exports into a formatted .xlsx report requires restructuring messy tabular data and applying sum formulas. This process sanitizes inconsistent data into clean, professional-grade spreadsheets with automated calculations.
openpyxl supports zero-error formula construction for .xlsx and .xlsm files, but automated recalculation requires LibreOffice integration. This combination ensures dynamic formula updates and data validation across spreadsheet formats.
The best way to clean malformed tabular data and convert CSV files to formatted Excel reports is through pandas data restructuring. This sanitizes inconsistent headers and applies formula-based calculations for professional .xlsx output.
You can modify and validate .xlsm files with Python by using formula-aware environments that preserve existing spreadsheet formulas. This ensures zero-error formula construction and automated data validation during modification.
Spreadsheet automation fails during large tabular data restructuring when dependencies lack proper XML parsing or memory management. Utilizing libraries like lxml and defusedxml ensures safe, efficient processing of complex spreadsheet files.
nq-rdlProcess and validate Excel-compatible spreadsheet files across .xlsx, .xlsm, .csv, and .tsv formats.
promptranksExport validated PSV samples to SQL or JSON for database import.
claude-office-skillsAnalyze Excel or CSV spreadsheet data to generate insights, visualizations, and reports.
miriamdongClean, transform, and format XLSX, CSV, and TSV files with Python.
