Excel File Manipulation
Manipulates Excel files without requiring Microsoft Excel installation, enabling creation and modification of workbooks, worksheets, formulas, charts, and pivot tables.
What it does
- Read and write Excel file data
- Apply and validate Excel formulas
- Create charts and pivot tables
- Format cells and ranges
- Create native Excel tables
- Manage worksheets and workbooks
Best for
Tools (25)
Apply Excel formula to cell. Excel formula will write to cell with verification.
Validate Excel formula syntax without applying it.
Apply formatting to a range of cells.
Read data from Excel worksheet with cell metadata including validation rules. Args: filepath: Path to Excel file sheet_name: Name of worksheet start_cell: Starting cell (default A1) end_cell: Ending cell (optional, auto-expands if not provided) preview_only: Whether to return preview only Returns: JSON string containing structured cell data with validation metadata. Each cell includes: address, value, row, column, and validation info (if any).
Write data to Excel worksheet. Excel formula will write to cell without any verification. PARAMETERS: filepath: Path to Excel file sheet_name: Name of worksheet to write to data: List of lists containing data to write to the worksheet, sublists are assumed to be rows start_cell: Cell to start writing to, default is "A1"
