xl-cli

What problem does it solve?

This Skill eliminates the manual drudgery of working with Excel files, allowing AI to programmatically interact with spreadsheets. It solves the challenge of integrating complex Excel operations—from data extraction and formula evaluation to advanced styling and reporting—directly into automated workflows, saving significant time and reducing errors.

Core Features & Use Cases

• Comprehensive Excel Control: Read, write, modify, and style cells, rows, and columns with precision.
• Advanced Data Analysis: Evaluate complex formulas, analyze cell dependencies, and perform "what-if" scenarios.
• Flexible Output & Reporting: Export spreadsheet data to various formats like JSON, CSV, HTML, SVG, and high-quality raster images (PNG, JPEG, PDF) for diverse reporting needs.
• Use Case: Automatically generate a weekly sales report. Extract specific data ranges from a master Excel file, apply conditional formatting to highlight key metrics, evaluate a set of financial formulas, and then export the final report as a PDF for stakeholders.

Quick Start

Using the xl-cli skill, list all sheets in the attached Excel file 'quarterly_financials.xlsx'. Then, view the range 'P&L!A1:F20' as a PNG image, including labels, and save it as 'profit_loss.png'.