Excel

Apply Excel formula in a cell Parameters: - file_id: File ID - sheet_name: Worksheet name - cell: Cell address (e.g., "A1") - formula: Excel formula (e.g., "=SUM(A1:A10)") Returns: - Operation resul…

Copy cell range to another location. Parameters: - file_id: File ID; - sheet_name: Source sheet name; - source_start: Source range start cell; - source_end: Source range end cell; - target_start: Targ…

Copy worksheet. Parameters: - file_id: File ID; - source_sheet: Source sheet name; - target_sheet: Target sheet name

Create chart in worksheet Parameters: - file__id: File ID - sheet_name: Sheet name - data_range: Data range (e.g., "A1:D10") - chart_type: Chart type (bar, line, pie, scatter, etc.) - target_cell: Ch…

Create pivot table Parameters: - file_id: File ID - sheet_name: Sheet name - data_range: Data range - rows: Row field list - values: Value field list - columns: Column field list (optional) - agg_fun…

Creates an Excel table from a given data range in a worksheet.

Creates a new Excel workbook and returns its file_id. After creating it, call download_excel_file with that file_id to give the user a download link.

Create a new worksheet in a workbook. Parameters: file_id, sheet_name

Permanently deletes the specified Excel file by its file ID.

Delete a range of cells and shift remaining cells Parameters: - file_id: File ID - sheet_name: Sheet name - start_cell: Start cell - end_cell: End cell - shift_direction: Shift direction ("up" or "le…

Delete columns Parameters: - file_id: File ID - sheet_name: Sheet name - start_col: Starting column number - count: Number of columns to delete (default 1)

Delete rows Parameters: - file_id: File ID - sheet_name: Sheet name - start_row: Starting row number - count: Number of rows to delete (default 1)

Delete worksheet Parameters: - file_id: File ID - sheet_name: Name of the worksheet to delete

Downloads a processed Excel file and returns its download URL. Use the file_id returned by upload_excel_file or create_workbook.

Format a range of cells Parameters: - file_id: File ID - sheet_name: Sheet name - start_cell: Starting cell - end_cell: Ending cell (optional) - bold: Bold or not - it…

Get all data validation rules in a worksheet Parameters: - file_id: File ID - sheet_name: Sheet name

Get all merged cells in a worksheet Parameters: - file_id: File ID - sheet_name: Sheet name

Get workbook metadata, including worksheet list, ranges, etc. Parameters: - file_id: File ID - include_ranges: Include range information or not

Insert columns Parameters: - file_id: File ID - sheet_name: Sheet name - start_col: Starting column number - count: Number of columns to insert (default 1)

Insert rows Parameters: - file_id: File ID - sheet_name: Sheet name - start_row: Starting row number - count: Number of rows to insert (default 1)

Lists all Excel files cached for the current user, returning each file's file_id and file info.

Merge cell range Parameters: - file_id: File ID - sheet_name: Sheet name - start_cell: Start cell - end_cell: End cell

Read Excel worksheet data. Parameters: file_id (file ID), sheet_name (worksheet name), start_cell (starting cell, default A1), end_cell (ending cell, optional), preview_only (whether to return preview…

Rename worksheet

Unmerge cells Parameters: - file_id: File ID - sheet_name: Sheet name - start_cell: Start cell - end_cell: End cell

Uploads an Excel file (.xlsx or .xls) to the server so it can be processed, returning a file_id to use in subsequent operations. The source can be a public http(s) URL or an RFC 2397 data: URI, which …

Validate if range exists and format is correct Parameters: - file_id: File ID - sheet_name: Sheet name - start_cell: Start cell - end_cell: End cell (optional)

Validate Excel formula syntax (not applied) Parameters: - file_id: File ID - sheet_name: Sheet name - cell: Cell address - formula: Formula to validate

Writes a 2D array of rows into a worksheet in an existing Excel file, starting at the given cell (A1 by default). Use this when you need to populate or append tabular data to a sheet.