Inventory Sheet Spreadsheet Set Cell on Demos Telerik
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)
Demos Telerik source site30 tools on this site
What this tool does
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) Use it on Demos Telerik with an agent. It runs in the browser on the website and needs no package install.
How to install
Open the demos.telerik.com website and ask your browser agent to use inventory-sheet-spreadsheet-set-cell
Run with an agent
Use the inventory-sheet-spreadsheet-set-cell tool on demos.telerik.com with row: <number>, col: <number>, value: <string>, sheet: <string>. Return the structured result and cite the source page.
Input contract
rownumberZero-based row index of the cell
colnumberZero-based column index of the cell
valuestringThe value to set in the cell
sheetstringOptional sheet name. Defaults to the active sheet
Verify the live listing at the source before a production call. Fields marked as a starter contract may differ from what the site expects.
