Create, edit, and analyze spreadsheet files using pandas and openpyxl.
npx skills add https://github.com/boazcstrike/opencode --skill xlsx-boazcstrike
Please help me install this Agent Skill. Skill: xlsx Source: https://github.com/boazcstrike/opencode/tree/main/skills/xlsx Command: npx skills add https://github.com/boazcstrike/opencode --skill xlsx-boazcstrike
This Skill streamlines your spreadsheet tasks, from complex data analysis and formula creation to formatting and file conversion, eliminating manual errors and saving significant time.
Use the xlsx skill to create a new spreadsheet with columns 'Product', 'Price', and 'Quantity', then add three rows of sample data.
High-intent search queries and answers about installing and using this skill.
Automate Excel formula creation and recalculation by generating native formulas with openpyxl and executing formula recalculation using LibreOffice, ensuring dynamic calculations and error-free spreadsheet outputs.
Clean messy tabular data and convert between CSV, TSV, and XLSX files using pandas for transformation and openpyxl for formatting, yielding structured, professional spreadsheet outputs.
Financial modeling color-coding standards are supported, applying professional fonts, number formatting, and industry-standard color rules to spreadsheet cells for maintainable financial models.
LibreOffice is required specifically for formula recalculation and error checking via scripts, while openpyxl and pandas handle spreadsheet creation, formatting, and data analysis independently.
Generate charts and compute formulas in an existing spreadsheet by applying openpyxl for chart creation and native formula injection, then triggering LibreOffice recalculation to verify accurate results.
Formulas may show errors because openpyxl writes formulas without calculating them; running LibreOffice recalculation processes the formulas to populate cached values and check for calculation errors.
YouMingYehClean, transform, and convert spreadsheet files between xlsx, csv, and tsv formats.
4tieGenerate Excel workbooks and Google Sheets with formulas, charts, and PDF exports.
pchemguyAutomate spreadsheet creation, editing, and analysis with openpyxl and pandas.
ViviennaMAOAutomate financial model updates with new earnings and guidance data.
