SERVICE & TOOLS

Excel

Excel files — create, read, modify with formulas, formatting, charts, pivot tables

29 available tools

download_excel_file

使用示例: download_excel_file(file_id="a1b2c3d4")

apply_formula

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…

create_table

从指定数据范围创建Excel表格参数: - file_id: 文件ID - sheet_name: 工作表名称 - data_range: 数据范围 - table_name: 表格名称（可选） - table_style: 表格样式（默认 "TableStyleMedium9"）

create_workbook

参数: - filename: 文件名（默认 "new_workbook.xlsx"）

format_range

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…

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…

write_data_to_excel

使用示例: write_data_to_excel( file_id="a1b2c3d4", sheet_name="Sheet1", data=[["姓名", "年龄"], ["张三", 25], ["李四", 30]], start_cell="A1" )

copy_range

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

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

create_chart

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

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…

create_worksheet

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

delete_excel_file

使用示例: delete_excel_file(file_id="a1b2c3d4")

delete_range

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_sheet_columns

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_sheet_rows

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

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

get_data_validation_info

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

get_merged_cells

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

get_workbook_metadata

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

insert_columns

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

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

merge_cells

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

rename_worksheet

Rename worksheet

unmerge_cells

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

upload_excel_file

参数: - file_url: Excel 文件来源（支持 .xlsx, .xls）。**支持两种形式**： 1) http(s):// 公网 URL，例如 https://example.com/data.xlsx 2) RFC 2397 data: URI，例如 `data:application/vnd.openxmlformat…

validate_excel_range

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_formula_syntax

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