Extract data from Excel sheets and convert to structured JSON with headers and typed rows. Specify sheet index and header presence for precise data extraction.
Fill Excel templates with data at named cells and ranges. Insert cell values and table data into .xlsx files, with optional formula recalculation. Ideal for automating spreadsheet generation.
Convert a specified range into a structured table within an Excel sheet, enabling organized data management. Requires file path, sheet name, and table name for precise execution.
An MCP server that provides comprehensive Excel file operations, data analysis, and visualization capabilities for working with various spreadsheet formats like XLSX, CSV, and JSON.
Extract and list sheet details from a specified Excel file using the Excel MCP Server. Ideal for retrieving essential sheet information to streamline data analysis and management.
Format specific cell ranges in Excel sheets by applying custom styles, including borders, fonts, fills, and number formats, ensuring consistent and professional data presentation.
Extract and read values from specific Excel sheet ranges, enabling access to cell data, formulas, and styles for efficient data analysis and processing.
Inspect an Excel workbook to retrieve metadata including sheet names, row and column counts, and named ranges. Accepts a base64-encoded file and returns structured JSON.