excel▌

Automate Excel workbooks on Windows with 226 COM-based operations covering data, formulas, tables, Power Query, and DAX. \n \n Supports full Excel object model: ranges, tables, worksheets, PivotTables, charts, slicers, conditional formatting, and VBA macro execution \n Includes Power Query (M code evaluation and creation) and Data Model (DAX measures) for advanced analytics workflows \n Provides calculation mode control for batch write performance optimization when handling large data volumes \n

Analyze Excel files to identify data structure, quality issues, format inconsistencies, and statistical patterns. Generate comprehensive markdown reports with actionable insights for data cleaning and improvement.

自动化 Excel 报表生成工具，支持从多种数据源生成专业的 Excel 报告。

你现在是 WPS 表格智能助手，专门帮助用户解决 Excel 相关问题。你的存在是为了让那些被公式折磨的用户解脱，让他们用人话就能操作 Excel。

Merge multiple CSV or Excel files with intelligent column matching and automatic deduplication. \n \n Performs fuzzy column matching to align headers across files with different naming conventions (e.g., \"firstname\" to \"first_name\", \"e-mail\" to \"email\") \n Detects and resolves duplicate records using configurable strategies: keep first, keep last, keep longest value, or flag for manual review \n Handles schema mismatches, encoding detection, and data type normalization across files \n Ge

Automate Microsoft Excel on Windows via CLI with 50+ commands for workbooks, tables, charts, and Power Pivot. \n \n Windows-only tool using COM interop; requires Excel 2016+ installed; install via dotnet tool install --global Sbroenne.ExcelMcp.CLI \n Supports 10+ command categories: worksheets, ranges, tables, charts, PivotTables, Power Query, Data Model/DAX, VBA, and conditional formatting \n Batch mode processes 10+ commands in a single session with auto-captured session IDs, eliminating per-c

Read, analyze, and transform Excel spreadsheets with pandas, pivot tables, charts, and data cleaning. \n \n Supports reading single or multiple sheets, filtering, grouping, aggregating, and calculating derived metrics on tabular data \n Create pivot tables programmatically and generate bar, pie, and other chart visualizations using matplotlib \n Write formatted Excel files with auto-adjusted column widths, conditional formatting, bold headers, and color fills using openpyxl \n Merge and concaten

Real-time Excel automation with live workbook control, VBA execution, and dashboard updates. \n \n Connects to active Excel instances for live interaction, unlike file-only libraries; supports reading, writing, and formatting ranges with array operations for performance \n Executes VBA macros, creates user-defined functions (UDFs), and manages charts, tables, and pictures programmatically \n Includes application-level controls (screen updating, calculation mode) and batch processing patterns for