Automate spreadsheet creation, editing, and analysis with formula preservation.
npx skills add https://github.com/coolsocket/skills-for-GCP --skill xlsx-coolsocket
Please help me install this Agent Skill. Skill: xlsx Source: https://github.com/coolsocket/skills-for-GCP/tree/main/xlsx Command: npx skills add https://github.com/coolsocket/skills-for-GCP --skill xlsx-coolsocket
Automate the creation, editing, and analysis of spreadsheets to replace tedious manual work, ensuring formulas stay intact and results stay consistent across workflows.
Create a new workbook from your data, apply formatting, and recalculate all formulas.
High-intent search queries and answers about installing and using this skill.
To automate spreadsheet creation and analysis while preserving formulas, you can use this Skill to generate, edit, and recalculate workbooks end-to-end. It leverages Python libraries like openpyxl to ensure deterministic formula handling and template preservation.
Cross-sheet recalculation updates formula results across multiple worksheet tabs to ensure data consistency. You need it for Excel analytics and reporting tasks when dependent values change, which this Skill handles using a LibreOffice-based recalc pipeline.
Yes, you can read, analyze, and modify existing Excel workbooks without breaking formatting and templates. The Skill preserves your original template structures while applying data-cleaning, budget planning, or analytics modifications programmatically.
Yes, this approach works with both Excel and CSV formats for data-cleaning tasks. It automates end-to-end editing and analysis across both file types, ensuring reproducible data structures and consistent reporting outputs.
The best way to generate data visualizations from spreadsheet data programmatically is using an automation pipeline that recalculates formulas first. This Skill ensures your visualizations reflect up-to-date results by running a LibreOffice-based recalculation before reporting.
Excel formulas return stale cached values when processed by scripts because standard libraries do not execute formula calculations. This Skill solves the issue by applying a LibreOffice-based recalc pipeline to force cross-sheet recalculation for accurate results.
sky770825Analyze public CSV files from URLs with pandas for structure and statistics.
BaranziniLabConstruct multi-element Excel dashboards from CSV input using ExcelCLI.
Wesley1600Executes Python scripts that process CLI input and return JSON-formatted results.
CodingHeaderCreate and edit Excel workbooks with formulas and formatting.
