Tools

What an AI assistant connected to the bridge can call: three tools, each taking an action and that action's parameters. Written from the same facts the product publishes (ADR 0006); nobody edits this page by hand.

`excel_read`

Reads the bound workbook.

action	params
`read_range`	address, sheet=None, since=None, workbook=None
`analyze_sheet`	sheet=None, since=None, workbook=None
`analyze_workbook`	workbook=None
`get_active_selection`	workbook=None
`trace`	address, sheet=None, depth=3, workbook=None
`find_errors`	workbook=None
`list_private_cells`	workbook=None
`privacy_report`	limit=50
`select_range`	address, sheet=None, workbook=None
`list_comments`	sheet=None, workbook=None
`list_names`	workbook=None
`find_cells`	query, sheet=None, look_in='values', match='contains', workbook=None
`list_charts`	sheet=None, workbook=None
`list_tables`	workbook=None
`list_pivots`	sheet=None, workbook=None
`read_pivot`	name, workbook=None
`get_calculation`	workbook=None

`excel_write`

Changes the bound workbook.

action	params
`write_cells`	writes, is_formula=False, sheet=None, overwrite=False, number_format=None, capability=None, workbook=None
`create_sheet`	sheet, customer_said, workbook=None
`format_cells`	formats, sheet=None, workbook=None
`sort_range`	address, key_column, ascending=True, has_header=True, sheet=None, workbook=None
`apply_filter`	address, column, criteria, sheet=None, workbook=None
`clear_filter`	sheet=None, workbook=None
`add_conditional_format`	address, formula, fill_rgb, sheet=None, workbook=None
`add_validation_list`	address, values, sheet=None, workbook=None
`copy_range`	source, destination, sheet=None, what='all', overwrite=False, workbook=None
`move_range`	source, destination, sheet=None, overwrite=False, workbook=None
`undo_last_write`	set_aside=False, workbook=None
`undo_all_writes`	workbook=None
`list_undoable_writes`	workbook=None
`insert_rows`	at, count=1, sheet=None, workbook=None
`insert_columns`	at, count=1, sheet=None, workbook=None
`delete_rows`	at, count=1, sheet=None, workbook=None
`delete_columns`	at, count=1, sheet=None, workbook=None
`clear_range`	address, what='contents', sheet=None, workbook=None
`rename_sheet`	old, new, workbook=None
`delete_sheet`	sheet, workbook=None
`freeze_panes`	address, sheet=None, workbook=None
`autofit_columns`	address, sheet=None, workbook=None
`set_column_width`	address, width, sheet=None, workbook=None
`add_comment`	address, text, sheet=None, workbook=None
`delete_comment`	address, sheet=None, workbook=None
`define_name`	name, address, sheet=None, workbook=None
`delete_name`	name, workbook=None
`find_replace`	query, replacement, address, sheet=None, workbook=None
`label_rows`	address, question, labels, output, sheet=None, overwrite=False, min_confidence=0.6, workbook=None
`add_hyperlink`	address, url, text=None, sheet=None, overwrite=False, workbook=None
`remove_hyperlink`	address, sheet=None, workbook=None
`add_chart`	kind, data, sheet=None, title=None, anchor=None, width=None, height=None, style=None, palette=None, colors=None, data_labels=None, legend=None, x_axis_title=None, y_axis_title=None, gridlines=None, title_font=None, label_font=None, legend_font=None, axis_title_font=None, label_content=None, label_position=None, label_number_format=None, explode=None, chart_fill=None, plot_fill=None, workbook=None
`delete_chart`	name, sheet=None, workbook=None
`restyle_chart`	name, sheet=None, kind=None, title=None, width=None, height=None, style=None, palette=None, colors=None, data_labels=None, legend=None, x_axis_title=None, y_axis_title=None, gridlines=None, title_font=None, label_font=None, legend_font=None, axis_title_font=None, label_content=None, label_position=None, label_number_format=None, explode=None, chart_fill=None, plot_fill=None, workbook=None
`add_table`	address, name=None, style=None, has_header=True, sheet=None, workbook=None
`remove_table`	name, workbook=None
`add_pivot`	source, rows, values, columns=None, filters=None, sheet=None, name=None, at=None, overwrite=False, workbook=None
`delete_pivot`	name, workbook=None
`change_pivot`	name, add_rows=None, remove_rows=None, add_columns=None, remove_columns=None, add_values=None, remove_values=None, set_aggregation=None, filters=None, workbook=None
`refresh_pivot`	name, workbook=None
`set_calculation`	mode, workbook=None
`calculate`	scope='workbook', sheet=None, workbook=None

`excel_session`

Binds a workbook, reads the operator's instructions, asks the customer a question on the bridge's page, proposes which ranges look private, files a bug or a feature request.

action	params
`bind_workbook`	path, model='', effort='', provider=''
`list_bound_workbooks`
`get_instructions`	workbook=None
`report_session`	model, effort='', provider=''
`ask_customer`	question, options=None, allow_free_text=True, field=''
`report_bug`	summary, what_happened, expected='', steps='', scenario_id='', run_ref='', evidence=None, plain='', add_to_known=True, confirmed=False, reporter_email='', trying='', did='', where='', severity=''
`request_feature`	summary, why, example='', scenario_id='', run_ref='', evidence=None, plain='', reporter_email=''
`collect_bug_evidence`	limit=30, expected=''
`suggest_private_ranges`