{"api":"v1","generated_at":"2026-09-15T22:48:47.868Z","licence":{"name":"CC BY 4.0","url":"https://creativecommons.org/licenses/by/4.0/","attribution":"TOLL, with a link to the page cited"},"page":"https://tollindex.com/e/sheets-api-williamrobinson-dev-v1-sheets-modify-dba165","pinned_page":"https://tollindex.com/e/sheets-api-williamrobinson-dev-v1-sheets-modify-dba165/at/2026-09-15T21-20Z","pinned":false,"method":"https://tollindex.com/ledger/method","snapshot_at":"2026-09-15T21:20:12.737Z","snapshot_stamp":"2026-09-15T21-20Z","endpoint":{"slug":"sheets-api-williamrobinson-dev-v1-sheets-modify-dba165","canonical_url":"https://sheets.api.williamrobinson.dev/v1/sheets/modify","resource":"https://sheets.api.williamrobinson.dev/v1/sheets/modify","http_method":"POST","type":"http","x402_version":2,"registries":["cdp"],"primary_registry":"cdp","curated_by_coinbase":false,"description":"Apply cell and named-range edits to an .xlsx, recalculate it with a real spreadsheet engine, and return the modified workbook alongside a dependency-impact, error, stale-cache, unsupported-function, and invariant audit","service_name":"Spreadsheet Modification & Audit","declared_category":null,"declared_tags":["spreadsheet","excel","xlsx","recalculation","audit"],"route_template":null,"registry_updated":"2026-09-11T00:11:06.387Z"},"derived":{"note":"fields no registry supplies; TOLL derives them and marks them derived on the page","title":"sheets modify","category":"other","first_observed_by_toll":"2026-09-10T21:35:51.205Z","last_observed_by_toll":"2026-09-15T21:20:12.737Z","observation_began":"2026-09-10"},"presence":{"listed_now":true,"first_absent_at":null,"delisting_confirmed_at":null,"events":[{"registry":"cdp","at":"2026-09-10T21:35:51.205Z","event":"listed"}]},"accepts":[{"registry":"cdp","ordinal":0,"network":"eip155:8453","asset":"0x833589fcd6edb6e08f4c7c32d4f71b54bda02913","asset_name":"USD Coin","symbol":"USDC","decimals":6,"amount_display":"0.05 USDC","amount_units":0.05,"decimals_known":true,"pay_to":"0x26026370fe8b2bb17af9092a17691c76519366da","scheme":"exact"}],"counters":{"observed_at":"2026-09-15T21:20:12.737Z","calls_30d":3,"unique_payers_30d":1,"last_called_at":"2026-09-11T00:11:05.855Z"},"validation":{"latest":{"observed_at":"2026-09-15T06:44:15.918Z","state":"pass","failed_checks":[],"endpoint_http_status":402,"run_id":"daily-2026-09-15"},"uptime":[{"days":7,"observed":5,"passed":5,"ratio":1},{"days":30,"observed":5,"passed":5,"ratio":1},{"days":90,"observed":5,"passed":5,"ratio":1}],"history_90d":[{"observed_at":"2026-09-15T06:44:15.918Z","state":"pass","failed_checks":[],"run_id":"daily-2026-09-15","state_changed":false},{"observed_at":"2026-09-14T06:12:36.659Z","state":"pass","failed_checks":[],"run_id":"daily-2026-09-14","state_changed":false},{"observed_at":"2026-09-13T06:03:44.695Z","state":"pass","failed_checks":[],"run_id":"daily-2026-09-13","state_changed":false},{"observed_at":"2026-09-12T08:21:08.623Z","state":"pass","failed_checks":[],"run_id":"daily-2026-09-12","state_changed":false},{"observed_at":"2026-09-11T13:35:13.727Z","state":"pass","failed_checks":[],"run_id":"daily-2026-09-11","state_changed":true}]},"seller":{"wallet":"0x26026370fe8b2bb17af9092a17691c76519366da","page":"https://tollindex.com/seller/0x26026370fe8b2bb17af9092a17691c76519366da","endpoints":12,"hosts":12},"reports":0,"registry_record":{"cdp":[{"tags":["spreadsheet","excel","xlsx","recalculation","audit"],"type":"http","accepts":[{"asset":"0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913","extra":{"name":"USD Coin","version":"2"},"payTo":"0x26026370fe8b2bb17af9092a17691c76519366da","amount":"50000","scheme":"exact","network":"eip155:8453","maxTimeoutSeconds":300}],"quality":{"lastCalledAt":"2026-09-11T00:11:05.855Z","l30DaysTotalCalls":3,"l30DaysUniquePayers":1},"resource":"https://sheets.api.williamrobinson.dev/v1/sheets/modify","extensions":{"bazaar":{"info":{"input":{"body":{"edits":[{"value":0.08,"target":{"cell":"B2","sheet":"Model"}},{"target":{"cell":"B5","sheet":"Model"},"formula":"=B3-B4"}],"watch":[{"cell":"B5","sheet":"Model"}],"workbook":"UEsDBBQAAAAIAAAAIQBuYbgN/gAAAC0CAAATAAAAW0NvbnRlbnRfVHlwZXNdLnhtbK2RzU7DMBCEX8XytYqdckAIJe2BnyNwKA+w2JvEiv/kdUv69jhp4YAKXDit7JnZb2Q328lZdsBEJviWr0XNGXoVtPF9y193j9UNZ5TBa7DBY8uPSHy7aXbHiMRK1lPLh5zjrZSkBnRAIkT0RelCcpDLMfUyghqhR3lV19dSBZ/R5yrPO/imuccO9jazh6lcn3oktMTZ3ck4s1oOMVqjIBddHrz+RqnOBFGSi4cGE2lVDFxeJMzKz4Bz7rk8TDIa2Quk/ASuuORk5XtI41sIo/h9yYWWoeuMQh3U3pWIoJgQNA2I2VmxTOHA+NXf/MVMchnrfy7ytf+zh1y+e/MBUEsDBBQAAAAIAAAAIQCY2uuLrgAAACcBAAALAAAAX3JlbHMvLnJlbHONz8EOgjAMBuBXWXqXgQdjDIOLMeFq8AHmVgYB1mWbCm/vjmI8eGz69/vTsl7miT3Rh4GsgCLLgaFVpAdrBNzay+4ILERptZzIooAVA9RVecVJxnQS+sEFlgwbBPQxuhPnQfU4y5CRQ5s2HflZxjR6w51UozTI93l+4P7TgK3JGi3AN7oA1q4O/7Gp6waFZ1KPGW38UfGVSLL0BqOAZeIv8uOdaMwSCrwq+ebB6g1QSwMEFAAAAAgAAAAhADzCX5K8AAAAGgEAAA8AAAB4bC93b3JrYm9vay54bWyNjz1uwzAMha8icK/ldCgCw3aWooCHbskBFIu2BUukQappc/soTbN34h/ex/faw0+K5oKigamDXVWDQRrZB5o7OB0/XvZgNDvyLjJhB1dUOPTtN8t6Zl5NkZN2sOS8NdbquGByWvGGVC4TS3K5jDJb3QSd1wUxp2hf6/rNJhcIHoRG/sPgaQojvvP4lZDyAyIYXS7mdQmbQt/+ftC/asilYvqTPcaS474afIkJRppQGhn8Dmzf2qfKPoP1N1BLAwQUAAAACAAAACEAWv2Ca7EAAAAoAQAAGgAAAHhsL19yZWxzL3dvcmtib29rLnhtbC5yZWxzjc/JCsJADAbgVxlyt2k9iEinXkToVeoDDNN0oZ2Fybj07R08iAUPnkLyky+kPD7NLO4UeHRWQpHlIMhq1462l3Btzps9CI7Ktmp2liQsxHCsygvNKqYVHkbPIhmWJQwx+gMi64GM4sx5sinpXDAqpjb06JWeVE+4zfMdhm8D1qaoWwmhbgsQzeLpH9t13ajp5PTNkI0/TuDDhYkHophQFXqKEj4jxncpsqQCViWuPqxeUEsDBBQAAAAIAAAAIQBbvLtaHgEAAH0CAAAYAAAAeGwvd29ya3NoZWV0cy9zaGVldDEueG1sfZJfT8MgFMW/CuHJP3GXdq1ZDGVxMfpq5vSdtHcr2kID106/vXRbGmNW3+DA+R0OIJdfbcN69ME4W/BkJjhDW7rK2F3BXzePNwvOAmlb6cZZLPg3Br5Ucu/8R6gRiUW/DQWvibo7gFDW2Oowcx3auLJ1vtUUp34HofOoq4OpbSAV4hZabSxX8qA9aNJKerdnPp4jquUwuE84o4Ib2xiLL+SjboKSpNbYo/1ECaQkDBKUJ8tqMPcqEUJI6I8LELkjPB3h6QT8Ke6kmq01nQ1IDwFiJvLzAfMxYD4R8OzdO5aEFfunx4DZqlVydZFcr9JLCdtjr3yiVzbGZhOxG+13SOeystOdLSbY+cjOJ9hv2httyz9NjhD49cIwfh31A1BLAQIUAxQAAAAIAAAAIQBuYbgN/gAAAC0CAAATAAAAAAAAAAAAAACAAQAAAABbQ29udGVudF9UeXBlc10ueG1sUEsBAhQDFAAAAAgAAAAhAJja64uuAAAAJwEAAAsAAAAAAAAAAAAAAIABLwEAAF9yZWxzLy5yZWxzUEsBAhQDFAAAAAgAAAAhADzCX5K8AAAAGgEAAA8AAAAAAAAAAAAAAIABBgIAAHhsL3dvcmtib29rLnhtbFBLAQIUAxQAAAAIAAAAIQBa/YJrsQAAACgBAAAaAAAAAAAAAAAAAACAAe8CAAB4bC9fcmVscy93b3JrYm9vay54bWwucmVsc1BLAQIUAxQAAAAIAAAAIQBbvLtaHgEAAH0CAAAYAAAAAAAAAAAAAACAAdgDAAB4bC93b3Jrc2hlZXRzL3NoZWV0MS54bWxQSwUGAAAAAAUABQBFAQAALAUAAAAA","invariants":[{"id":"revenue-meets-target","kind":"equals","left":{"cell":"B3","sheet":"Model"},"right":{"cell":"B4","sheet":"Model"},"tolerance":0.01}]},"type":"http","method":"POST","bodyType":"json"},"output":{"type":"json","example":{"edits":[{"after":{"cell":"B2","sheet":"Model","value":0.08},"before":{"cell":"B2","sheet":"Model","value":0.05},"target":{"cell":"B2","sheet":"Model"},"resolved":{"cell":"B2","sheet":"Model"}},{"after":{"cell":"B5","sheet":"Model","value":0,"formula":"=B3-B4"},"before":{"cell":"B5","sheet":"Model","value":null},"target":{"cell":"B5","sheet":"Model"},"resolved":{"cell":"B5","sheet":"Model"}}],"tools":{"calc":"LibreOffice 26.8.0"},"watch":[{"cell":"B5","sheet":"Model","value":0,"formula":"=B3-B4"}],"errors":{"resolved":[],"afterCount":0,"introduced":[],"beforeCount":0},"impact":{"changed":[{"cell":"B3","after":{"value":1080},"sheet":"Model","before":{"value":1050},"formula":"=B1*(1+B2)"}],"changedCount":1},"status":"passed","warnings":[],"workbook":{"sheets":["Model"],"hasMacros":false,"namedRanges":[],"formulaCells":1,"externalLinks":[]},"artifacts":[{"href":"https://sheets.api.williamrobinson.dev/v1/sheets/artifacts/0123456789abcdef0123456789abcdef0123456789abcdef/modified.xlsx","name":"modified.xlsx","sha256":"3aa67f14cafe1cb644e374eacb86537e08949d8a3dd23f620d58c0536521d00a","mediaType":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","sizeBytes":5380},{"href":"https://sheets.api.williamrobinson.dev/v1/sheets/artifacts/0123456789abcdef0123456789abcdef0123456789abcdef/report.json","name":"report.json","sha256":"567adee51e080c135f54670735b19c8624276d9b08465db1d76a2dd2e12b024a","mediaType":"application/json","sizeBytes":1969}],"expiresAt":"2026-01-04T03:04:05.000Z","truncated":false,"invariants":[{"id":"revenue-meets-target","detail":"|1080.0 - 1080.0| = 0.0 <= 0.01","status":"passed","observed":{"left":1080,"right":1080}}],"staleCache":{"checked":true,"mismatches":[],"mismatchCount":0},"limitations":["Dates are reported as their underlying serial number; no calendar conversion is performed.","Boolean results are only reported as true booleans for cells LibreOffice Calc marks with its native boolean format (TRUE()/FALSE()); other formulas that evaluate to a logical result (for example comparison formulas) are reported as 0/1 numbers.","VBA macros are never executed and are dropped from the output workbook.","External links are never refreshed; the worker container has no network access.","Functions LibreOffice Calc does not implement (for example LAMBDA) surface as #NAME? errors and are listed under unsupportedFunctions."],"unsupportedFunctions":[]}}},"schema":{"type":"object","$schema":"https://json-schema.org/draft/2020-12/schema","required":["input"],"properties":{"input":{"type":"object","required":["type","method","bodyType","body"],"properties":{"body":{"type":"object","$defs":{"ref":{"type":"object","required":["sheet","cell"],"properties":{"cell":{"type":"string","pattern":"^[A-Z]{1,3}[1-9][0-9]{0,6}$","description":"A1-style cell reference. This pattern is a superset of the real Calc grid; the API additionally enforces columns A-XFD (1-16384) and rows 1-1048576, which a regex alone cannot express."},"sheet":{"type":"string","pattern":"^[^\\[\\]:*?/\\\\]{1,31}$","maxLength":31,"minLength":1}},"additionalProperties":false}},"$schema":"https://json-schema.org/draft/2020-12/schema","required":["workbook"],"properties":{"edits":{"type":"array","items":{"type":"object","oneOf":[{"required":["value"],"properties":{"value":true}},{"required":["formula"],"properties":{"formula":true}}],"required":["target"],"properties":{"value":{"anyOf":[{"type":"number"},{"type":"string","maxLength":32768},{"type":"boolean"},{"type":"null"}]},"target":{"oneOf":[{"type":"object","required":["sheet","cell"],"properties":{"cell":{"type":"string","pattern":"^[A-Z]{1,3}[1-9][0-9]{0,6}$","description":"A1-style cell reference. This pattern is a superset of the real Calc grid; the API additionally enforces columns A-XFD (1-16384) and rows 1-1048576, which a regex alone cannot express."},"sheet":{"type":"string","pattern":"^[^\\[\\]:*?/\\\\]{1,31}$","maxLength":31,"minLength":1}},"additionalProperties":false},{"type":"object","required":["name"],"properties":{"name":{"type":"string","pattern":"^[A-Za-z_\\\\][A-Za-z0-9_.]{0,254}$"}},"additionalProperties":false}]},"formula":{"type":"string","pattern":"^=","maxLength":8192,"description":"Excel A1 syntax, e.g. \"=SUM(Model!B2:B9)\"."}},"additionalProperties":false},"default":[],"maxItems":200},"watch":{"type":"array","items":{"$ref":"#/properties/input/properties/body/$defs/ref"},"default":[],"maxItems":200},"workbook":{"type":"string","pattern":"^(?:[A-Za-z0-9+/]{4})*(?:[A-Za-z0-9+/]{2}==|[A-Za-z0-9+/]{3}=)?$","maxLength":2796204,"minLength":4,"description":"Base64 .xlsx (OOXML zip), decoded size at most 2097152 bytes. Macros are never executed; external links are never refreshed."},"invariants":{"type":"array","items":{"oneOf":[{"type":"object","required":["id","kind","left","right","tolerance"],"properties":{"id":{"type":"string","pattern":"^[A-Za-z0-9_-]{1,64}$"},"kind":{"const":"equals"},"left":{"$ref":"#/properties/input/properties/body/$defs/ref"},"right":{"$ref":"#/properties/input/properties/body/$defs/ref"},"tolerance":{"type":"number","minimum":0}},"additionalProperties":false},{"type":"object","required":["id","kind","cell"],"properties":{"id":{"type":"string","pattern":"^[A-Za-z0-9_-]{1,64}$"},"max":{"type":"number"},"min":{"type":"number"},"cell":{"$ref":"#/properties/input/properties/body/$defs/ref"},"kind":{"const":"range"}},"additionalProperties":false}]},"default":[],"maxItems":50}},"additionalProperties":false},"type":{"type":"string","const":"http"},"method":{"enum":["POST"],"type":"string"},"bodyType":{"enum":["json","form-data","text"],"type":"string"}},"additionalProperties":false},"output":{"type":"object","required":["type"],"properties":{"type":{"type":"string"},"example":{"type":"object","$defs":{"ref":{"type":"object","required":["sheet","cell"],"properties":{"cell":{"type":"string","pattern":"^[A-Z]{1,3}[1-9][0-9]{0,6}$","description":"A1-style cell reference. This pattern is a superset of the real Calc grid; the API additionally enforces columns A-XFD (1-16384) and rows 1-1048576, which a regex alone cannot express."},"sheet":{"type":"string","pattern":"^[^\\[\\]:*?/\\\\]{1,31}$","maxLength":31,"minLength":1}},"additionalProperties":false},"error":{"anyOf":[{"enum":["#DIV/0!","#NAME?","#REF!","#VALUE!","#N/A","#NUM!","#NULL!"],"type":"string"},{"type":"string","pattern":"^Err:[0-9]+$"}]},"change":{"type":"object","required":["sheet","cell","before","after"],"properties":{"cell":{"type":"string"},"after":{"type":"object","required":["value"],"properties":{"error":{"$ref":"#/properties/output/properties/example/$defs/error"},"value":{"$ref":"#/properties/output/properties/example/$defs/scalar"}},"additionalProperties":false},"sheet":{"type":"string"},"before":{"type":"object","required":["value"],"properties":{"error":{"$ref":"#/properties/output/properties/example/$defs/error"},"value":{"$ref":"#/properties/output/properties/example/$defs/scalar"}},"additionalProperties":false},"formula":{"type":"string"}},"additionalProperties":false},"scalar":{"anyOf":[{"type":"number"},{"type":"string","maxLength":32768},{"type":"boolean"},{"type":"null"}]},"snapshot":{"type":"object","required":["sheet","cell","value"],"properties":{"cell":{"type":"string"},"error":{"$ref":"#/properties/output/properties/example/$defs/error"},"sheet":{"type":"string"},"value":{"$ref":"#/properties/output/properties/example/$defs/scalar"},"formula":{"type":"string"}},"additionalProperties":false}},"$schema":"https://json-schema.org/draft/2020-12/schema","required":["status","tools","workbook","staleCache","edits","impact","errors","unsupportedFunctions","invariants","watch","warnings","limitations","truncated","expiresAt","artifacts"],"properties":{"edits":{"type":"array","items":{"type":"object","required":["target","resolved","before","after"],"properties":{"after":{"$ref":"#/properties/output/properties/example/$defs/snapshot"},"before":{"$ref":"#/properties/output/properties/example/$defs/snapshot"},"target":{"oneOf":[{"type":"object","required":["sheet","cell"],"properties":{"cell":{"type":"string","pattern":"^[A-Z]{1,3}[1-9][0-9]{0,6}$","description":"A1-style cell reference. This pattern is a superset of the real Calc grid; the API additionally enforces columns A-XFD (1-16384) and rows 1-1048576, which a regex alone cannot express."},"sheet":{"type":"string","pattern":"^[^\\[\\]:*?/\\\\]{1,31}$","maxLength":31,"minLength":1}},"additionalProperties":false},{"type":"object","required":["name"],"properties":{"name":{"type":"string","pattern":"^[A-Za-z_\\\\][A-Za-z0-9_.]{0,254}$"}},"additionalProperties":false}]},"resolved":{"$ref":"#/properties/output/properties/example/$defs/ref"}},"additionalProperties":false},"maxItems":200},"tools":{"type":"object","required":["calc"],"properties":{"calc":{"type":"string"}},"additionalProperties":false},"watch":{"type":"array","items":{"$ref":"#/properties/output/properties/example/$defs/snapshot"},"maxItems":200},"errors":{"type":"object","required":["beforeCount","afterCount","introduced","resolved"],"properties":{"resolved":{"type":"array","items":{"$ref":"#/properties/output/properties/example/$defs/snapshot"},"maxItems":100},"afterCount":{"type":"integer","minimum":0},"introduced":{"type":"array","items":{"$ref":"#/properties/output/properties/example/$defs/snapshot"},"maxItems":100},"beforeCount":{"type":"integer","minimum":0}},"additionalProperties":false},"impact":{"type":"object","required":["changedCount","changed"],"properties":{"changed":{"type":"array","items":{"$ref":"#/properties/output/properties/example/$defs/change"},"maxItems":100},"changedCount":{"type":"integer","minimum":0}},"additionalProperties":false},"status":{"enum":["passed","failed"],"type":"string"},"warnings":{"type":"array","items":{"type":"string","maxLength":4096},"maxItems":32},"workbook":{"type":"object","required":["sheets","formulaCells","namedRanges","hasMacros","externalLinks"],"properties":{"sheets":{"type":"array","items":{"type":"string"}},"hasMacros":{"type":"boolean"},"namedRanges":{"type":"array","items":{"type":"object","required":["name","refersTo"],"properties":{"name":{"type":"string"},"refersTo":{"type":"string"}},"additionalProperties":false}},"formulaCells":{"type":"integer","minimum":0},"externalLinks":{"type":"array","items":{"type":"string"}}},"additionalProperties":false},"artifacts":{"type":"array","items":{"type":"object","required":["name","mediaType","sizeBytes","sha256","href"],"properties":{"href":{"type":"string","format":"uri"},"name":{"enum":["modified.xlsx","report.json"],"type":"string"},"sha256":{"type":"string","pattern":"^[a-f0-9]{64}$"},"mediaType":{"type":"string","maxLength":128,"minLength":1},"sizeBytes":{"type":"integer","minimum":0}},"additionalProperties":false},"maxItems":2},"expiresAt":{"type":"string","format":"date-time"},"truncated":{"type":"boolean"},"invariants":{"type":"array","items":{"type":"object","required":["id","status","detail"],"properties":{"id":{"type":"string","pattern":"^[A-Za-z0-9_-]{1,64}$"},"detail":{"type":"string","maxLength":4096},"status":{"enum":["passed","failed","not_checked"],"type":"string"},"observed":{"type":"object","additionalProperties":{"$ref":"#/properties/output/properties/example/$defs/scalar"}}},"additionalProperties":false},"maxItems":50},"staleCache":{"type":"object","required":["checked","mismatchCount","mismatches"],"properties":{"checked":{"type":"boolean"},"mismatches":{"type":"array","items":{"$ref":"#/properties/output/properties/example/$defs/change"},"maxItems":100},"mismatchCount":{"type":"integer","minimum":0}},"additionalProperties":false},"limitations":{"type":"array","items":{"type":"string","maxLength":4096},"maxItems":16},"unsupportedFunctions":{"type":"array","items":{"type":"object","required":["name","cells"],"properties":{"name":{"type":"string"},"cells":{"type":"array","items":{"$ref":"#/properties/output/properties/example/$defs/ref"}}},"additionalProperties":false},"maxItems":100}},"additionalProperties":false}}}}}},"builder-code":{"info":{"s":["cdp_sdk_server"]},"schema":{"type":"object","$schema":"https://json-schema.org/draft/2020-12/schema","properties":{"a":{"type":"string","pattern":"^[a-z0-9_]{1,32}$","description":"App builder code"},"s":{"type":"array","items":{"type":"string","pattern":"^[a-z0-9_]{1,32}$"},"maxItems":11,"description":"Service builder codes"},"w":{"type":"string","pattern":"^[a-z0-9_]{1,32}$","description":"Wallet builder code"}},"additionalProperties":false}},"payment-identifier":{"info":{"required":true},"schema":{"type":"object","$schema":"https://json-schema.org/draft/2020-12/schema","required":["required"],"properties":{"id":{"type":"string","pattern":"^[a-zA-Z0-9_-]+$","maxLength":128,"minLength":16},"required":{"type":"boolean"}}}},"eip2612GasSponsoring":{},"erc20ApprovalGasSponsoring":{}},"description":"Apply cell and named-range edits to an .xlsx, recalculate it with a real spreadsheet engine, and return the modified workbook alongside a dependency-impact, error, stale-cache, unsupported-function, and invariant audit","lastUpdated":"2026-09-11T00:11:06.387Z","serviceName":"Spreadsheet Modification & Audit","x402Version":2}]}}