demos.telerik.com

inventory-sheet-spreadsheet-set-cell

Write a single cell value into the Warehouse Capacity spreadsheet. To populate the spreadsheet from the Shipment Tracker grid, ALWAYS first call shipment-tracker Filter (if criteria given) and then shipment-tracker GetData to retrieve the visible rows. Then call this tool MULTIPLE TIMES to write: (1) a header row at row 1 with columns A='Tracking #', B='Origin', C='Destination', D='Delivery Address', E='Status', F='Carrier', G='Value', H='Weight (kg)', I='Ship Date', J='ETA', K='Dest. Lat', L='Dest. Lng'; and (2) one row per shipment starting at row 2, mapping TrackingNumber→A, Origin→B, Destination→C, DestinationStreet→D, Status→E, Carrier→F, Value→G, Weight→H, ShipDate→I, ETA→J, DestinationLat→K, DestinationLng→L. Cell addresses use A1 notation (e.g. 'A1', 'B2'). Clear any old rows the user no longer wants before writing new ones. (inventory-sheet spreadsheet)

Input schema

{
  "type": "object",
  "properties": {
    "row": {
      "type": "number",
      "description": "Zero-based row index of the cell"
    },
    "col": {
      "type": "number",
      "description": "Zero-based column index of the cell"
    },
    "value": {
      "type": "string",
      "description": "The value to set in the cell"
    },
    "sheet": {
      "type": "string",
      "description": "Optional sheet name. Defaults to the active sheet"
    }
  },
  "required": [
    "row",
    "col",
    "value"
  ]
}