create_workbook
Create a new workbook
create_worksheet
Create a new worksheet
get_workbook_metadata
Get workbook metadata
profile_workbook
Profile workbook structure and contents
describe_sheet_layout
Describe the layout of a worksheet
audit_workbook
Audit workbook for issues
plan_workbook_repairs
Plan repairs for workbook issues
apply_workbook_repairs
Apply planned workbook repairs
diff_workbooks
Compare two workbooks
analyze_range_impact
Analyze the impact of changes to a range
explain_formula_cell
Explain a formula in a cell
detect_circular_dependencies
Detect circular dependencies in formulas
create_named_range
Create a named range
inspect_named_range
Inspect a named range
list_named_ranges
List all named ranges
delete_named_range
Delete a named range
list_all_sheets
List all sheets in a workbook
list_tables
List all tables in a workbook
suggest_read_strategy
Suggest a read strategy for a sheet
describe_dataset
Describe a dataset in a sheet
query_table
Query a table using declarative filters
aggregate_table
Aggregate data from a table
bulk_aggregate_workbooks
Aggregate data across multiple workbooks
bulk_filter_workbooks
Filter data across multiple workbooks
union_tables
Union multiple tables
cross_workbook_lookup
Look up data across workbooks
quick_read
Quickly read data from a sheet
read_excel_table
Read an Excel table
read_data_from_excel
Read data from an Excel sheet
read_excel_as_table
Read Excel data as a table
search_in_sheet
Search for values in a sheet
write_data_to_excel
Write data to an Excel sheet
append_table_rows
Append rows to a table
append_excel_table_rows
Append rows to an Excel table
upsert_excel_table_rows
Upsert rows in an Excel table
update_rows_by_key
Update rows by key
copy_worksheet
Copy a worksheet
delete_worksheet
Delete a worksheet
rename_worksheet
Rename a worksheet
set_worksheet_visibility
Set worksheet visibility
get_worksheet_protection
Get worksheet protection state
set_worksheet_protection
Set worksheet protection
copy_range
Copy a range of cells
delete_range
Delete a range of cells
insert_rows
Insert rows into a sheet
insert_columns
Insert columns into a sheet
delete_sheet_rows
Delete rows from a sheet
delete_sheet_columns
Delete columns from a sheet
format_range
Format a range of cells
format_ranges
Format multiple ranges of cells
read_range_formatting
Read formatting of a range
freeze_panes
Set freeze panes
set_autofilter
Set autofilter on a range
set_print_area
Set print area