Automate spreadsheet tasks by reading, editing, cleaning, and converting data.
npx skills add https://github.com/wsxwj123/opencode-skills-backup --skill xlsx-wsxwj123
Please help me install this Agent Skill. Skill: xlsx Source: https://github.com/wsxwj123/opencode-skills-backup/tree/main/xlsx Command: npx skills add https://github.com/wsxwj123/opencode-skills-backup --skill xlsx-wsxwj123
Use this skill to manage any task where a spreadsheet is the primary input or output. This includes opening, reading, editing, cleaning, transforming, formatting, or converting .xlsx, .xlsm, .csv, or .tsv files. It also covers creating new spreadsheets from scratch or from other data sources and converting between tabular formats. The deliverable must be a spreadsheet file.
Open the target spreadsheet, apply the requested edits, and return the updated .xlsx file.
High-intent search queries and answers about installing and using this skill.
Automating Excel data cleaning across multiple files is handled by reading, restructuring, and fixing messy data to produce finalized spreadsheets. It targets batch data cleaning, formatting, and formula updates for .xlsx files.
Converting CSV to XLSX format in bulk is supported by reading tabular formats like .csv or .tsv and writing finalized Excel spreadsheets. This process also handles reverse conversions from .xlsx back to plain text formats.
Updating formulas and restructuring malformed spreadsheet rows programmatically is fully supported. It fixes header issues and malformed data by transforming the inputs into properly formatted spreadsheet files.
You need pandas and openpyxl to edit spreadsheets with this automation approach. Pandas handles the underlying data manipulation, while openpyxl manages the Excel input and output operations required to generate spreadsheet files.
This spreadsheet automation works with .xlsm and .tsv files, alongside standard .xlsx and .csv formats. It can open, read, edit, and convert across these supported tabular formats to deliver the final output spreadsheet.
You should not use a spreadsheet automation script when your deliverable is not a spreadsheet file. This task specifically requires spreadsheet inputs or outputs; non-tabular data processing or visualization tasks fall outside its scope.
ChenYCLCreate, read, edit, and analyze Excel spreadsheet files with openpyxl and pandas.
meytalp-devRead Excel files with pandas, create pivot tables, and generate charts.
benyichanGenerate and format Excel reports from DataFrames using openpyxl.
GCWingClean, format, and convert XLSX, CSV, and TSV spreadsheet data.
