Create, modify, and analyze Excel workbooks with formulas and formatting.
npx skills add https://github.com/plurigrid/asi --skill xlsx-plurigrid
Please help me install this Agent Skill. Skill: xlsx Source: https://github.com/plurigrid/asi/tree/main/skills/xlsx Command: npx skills add https://github.com/plurigrid/asi --skill xlsx-plurigrid
This Skill covers spreadsheet automation and analysis using Python, including reading, writing, formatting, and formulas.
Read an Excel file, modify content, and save the updated workbook.
High-intent search queries and answers about installing and using this skill.
Read and write Excel files using openpyxl to open .xlsx/.xlsm workbooks, access sheets, modify cell values, and save changes. This handles data ingestion and workbook generation across multiple sheets.
Yes, openpyxl preserves formulas when you assign them to cells and save workbooks. This enables dynamic calculations and ensures formulas persist when the file is opened in Excel.
Apply openpyxl styling—font, fill, and borders—directly to cells before saving. Formatting persists in the output workbook and works across .xlsx files.
Combine pandas for statistical analysis and data cleaning with openpyxl for reading .xlsx/.xlsm files, then generate reports or new workbooks. This supports data ingestion, modeling, and visualization tasks.
Yes, the Skill reads and writes .csv and .tsv files alongside .xlsx/.xlsm formats, enabling data ingestion from multiple spreadsheet sources.
Use openpyxl's data_only parameter set to False to read formulas as text, or set it to True to read calculated values only. This supports both formula inspection and data-only analysis.
artgaurav16420-ossAutomate spreadsheet data wrangling across Excel, CSV, and TSV files.
weirdgmeDesign and implement scalable platform engineering patterns for internal developer platforms.
hico-mrmgnAnalyze and visualize CSV and Excel data with Python, Pandas, and Matplotlib/Seaborn.
takemi-ohamaExtract data from multi-sheet Excel workbooks into JSON or CSV.
