Create, edit, and analyze spreadsheets with formulas and formatting.
npx skills add https://github.com/xiehust/strands_demos --skill xlsx-xiehust
Please help me install this Agent Skill. Skill: xlsx Source: https://github.com/xiehust/strands_demos/tree/main/strands_skills_demo/skills/xlsx Command: npx skills add https://github.com/xiehust/strands_demos --skill xlsx-xiehust
Streamlines complex spreadsheet operations, eliminating manual data entry, formula creation, and formatting. It ensures accuracy and consistency in financial models, data analysis, and reporting, saving significant time and reducing errors.
import pandas as pd from openpyxl import Workbook
df = pd.read_excel('input.xlsx') print(df.describe())
wb = Workbook() sheet = wb.active sheet['A1'] = 'Sales' sheet['B1'] = '=SUM(A2:A10)' wb.save('output.xlsx')
python recalc.py output.xlsx
High-intent search queries and answers about installing and using this skill.
Automate spreadsheet creation by using openpyxl to build Excel files with formulas, data validation, and formatting, then run recalc.py to ensure formulas recalculate correctly and maintain dynamic integrity without manual intervention.
Yes. Use pandas to read and analyze .xlsx, .csv, or .tsv files, then modify the original spreadsheet with openpyxl while preserving existing formulas, templates, and formatting conventions.
Build spreadsheets using Excel formulas instead of hardcoded Python values, then run recalc.py to automatically recalculate and validate formulas, catching errors before delivery and ensuring model accuracy.
Extract and analyze raw data with pandas, create new spreadsheets with complex formulas and conditional formatting using openpyxl, then recalculate via recalc.py to produce accurate, updateable reports without manual steps.
Yes. The Skill supports multiple spreadsheet formats—.xlsx, .xlsm, .csv, and .tsv—allowing you to read, analyze, create, and modify files across formats while maintaining formula integrity and formatting.
Formulas must be valid Excel syntax; recalc.py is required after modifications to enforce formula recalculation; templates and color-coding are preserved during updates, but complex VBA macros and unsupported formats fall outside scope.
brainbrewlabsCollect data from APIs, databases, and files into validated CSV, JSON, or Parquet outputs.
openaiConverts static HTML analytics-report exports to verified PDFs via headless Chrome with provenance metadata.
IsKenKenYaAnalyze Excel spreadsheets by importing data, cleaning it, and generating pivot tables and charts.
ErrDivineCreate, edit, and analyze Excel files using openpyxl and pandas.
