Tag: excel
Deep Automated CSV and Excel Data Analysis
This skill automates deep data exploration across CSV, Excel, and TSV formats, generating comprehensive, interactive web reports. It extracts statistical features, identifies anomalies, and provides actionable business insights using struct…
Generate interactive dashboards from CSV and Excel
This tool generates comprehensive, interactive HTML dashboards from tabular data (CSV/Excel). It automatically detects data relationships and generates various visualizations, including heatmaps, time series, and narrative insights, all in …
Advanced Excel Automation via Model Context Protocol
This skill provides comprehensive automation for Microsoft Excel, enabling advanced data manipulation, formatting, and analysis. It supports complex features including DAX, Power Query, PivotTables, and structured data model management.
Core conventions for programmatic Excel automation
This guide outlines the critical architectural patterns and conventions for developing robust Excel automation tools using COM interop. It details best practices for error propagation, COM object cleanup, and structured testing within the E…
MCP Server for Excel Manipulation
This MCP server allows agents to programmatically read from and write to Excel spreadsheets. It provides a standardised interface for spreadsheet-based data manipulation.
Spreadsheet creation and manipulation skill
An automated capability for creating, editing, and analysing spreadsheet files such as .xlsx, .csv, and .tsv. It utilises pandas for data manipulation and openpyxl for formula and formatting management, incorporating LibreOffice-based formu…
Financial Ratio Calculation and Analysis
This skill calculates and interprets a wide range of financial ratios and metrics from provided financial statement data, enabling investment analysis and performance evaluation. It supports various input formats and provides industry bench…