Tool Reference
EditSpreadsheet
Apply one atomic batch to a native Macro spreadsheet: set cell values/formulas, format or clear ranges, fill with relative formulas, add rows, resize columns, add or remove in-cell dropdowns (list data validation with a clickable arrow, optionally with a color per choice), insert checkboxes backed by TRUE/FALSE values, convert a range with a header row to a named table (filterable, sortable, referenced as Table1[Column], with typed columns such as currency, date, checkbox or dropdown), or add/rename/duplicate/delete sheets.