Create, edit, and validate Excel workbooks as XLSX files.
npx skills add https://github.com/nachopalmeri/agents-system --skill xlsx-nachopalmeri
Please help me install this Agent Skill. Skill: xlsx Source: https://github.com/nachopalmeri/agents-system/tree/main/.agents/skills/xlsx Command: npx skills add https://github.com/nachopalmeri/agents-system --skill xlsx-nachopalmeri
This skill streamlines creating, editing, and validating Excel workbooks, reducing manual data handling and errors in XLSX-related tasks.
Create a new workbook from your data source and export it as an XLSX file.
High-intent search queries and answers about installing and using this skill.
You can automate Excel workbook creation and data cleaning by using scripts to read raw data, apply validation rules, and export polished XLSX files. This skill handles formatting, column changes, and formula updates end-to-end.
Yes, you can update formulas and recalculate them when editing XLSX files programmatically. The skill uses LibreOffice-based formula recalculation via scripts to ensure full recalculation of workbook values.
The best way to validate spreadsheet data against structural rules is to apply automated checks during workbook creation or editing. This skill validates your data against content rules to ensure consistency across large datasets.
Yes, this Excel automation approach supports CSV and TSV files alongside XLSX. You can open, read, and modify .xlsx, .xlsm, .csv, and .tsv files, including formatting and column changes, within the same workflow.
Yes, you need pandas and openpyxl to modify spreadsheets and generate reports. These dependencies are required for data manipulation, while defusedxml and lxml handle XML validation for the workbook files.
thanhquan3010Automate creation, editing, and analysis of spreadsheet files with formulas.
szsip239Execute SQL queries, process spreadsheets, and generate insights from datasets.
wyhlovecppAutomate Word document editing workflows with tracked changes and XML validation.
safzanpiraniCreate, edit, and analyze Excel files with pandas and openpyxl.
