# US 11,443,110 B2 · Editable table in a spreadsheet integrated with a web service > Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt - Number: US 11,443,110 B2 - Document ID: US11443110B2 - Status: Granted - Kind: B2 - Application number: 17/387,411 - Filed: 2021-07-28 - Published: 2021-11-18 - Granted: 2022-09-13 - Earliest claimed: 2017-09-28 - Assignees: Oracle International Corporation - Applicants: Oracle International Corporation - Inventors: Edmund A. Davis; Brian Rowles; Shaun Logan; Kelsey Von Tish - Web page: https://patentgrep.com/patent/US11443110B2 ## CPC - G06F 40/18: of spreadsheets (form-filling G06F40/174) - G06F 16/907: Retrieval characterised by using metadata, e.g. metadata not derived from the content or metadata generated manually - G06F 16/958: Organisation or management of web site content, e.g. publishing, maintaining pages or automatic linking - G06F 40/177: of tables; using ruled lines - H04L 67/51: Discovery or management thereof, e.g. service location protocol [SLP] or web services - H04L 67/535: {Tracking the activity of the user (network monitoring arrangements H04L43/00; recording of computer activity G06F11/34)} - H04L 67/561: Adding application-functional data or data for application control, e.g. adding metadata - H04L 67/565: Conversion or adaptation of application format or content (adding application control or application functional data H04L67/561) - G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N) - H04L: TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION (arrangements common to telegraphic and telephonic communication H04M) ## Abstract Implementations generally relate to an editable table in a spreadsheet integrated with a web service. In some implementations, a method includes obtaining web service metadata from a web service. The method further includes determining one or more capabilities of the web service based on the web service metadata. The method further includes configuring a table component in a spreadsheet based on the one or more capabilities and the web service metadata. The method further includes retrieving data from the web service. The method further includes converting the data to a predetermined format. The method further includes tracking data changes in the spreadsheet based on user input. The method further includes sending the data changes from the spreadsheet to the web service. ## Claims ### Claim 1 A non-transitory computer-readable storage medium carrying program instructions thereon, the program instructions when executed by one or more processors of a client computing device cause the one or more processors to perform operations comprising: obtaining web service metadata from a web service; determining spreadsheet attributes of the web service based on the web service metadata; configuring, by the client computing device, a table component in the spreadsheet based on the spreadsheet attributes; retrieving, by the client computing device, data from the web service including a data value in a web service encoded format; converting, by the client computing device, the data value to a corresponding display value in a spreadsheet encoding format by using mappings of display values to data values, wherein the mappings are stored in the spreadsheet; converting, by the client computing device, user inputted data changes of the display value in the spreadsheet, to a corresponding data value in the web service encoded format by using the mappings; and sending the converted data changes from the spreadsheet to the web service. ### Claim 2 (depends on 1) The computer-readable storage medium of claim 1, wherein the corresponding data value is a non-human readable format and the display value is a human readable format. ### Claim 3 (depends on 1) The computer-readable storage medium of claim 1, wherein the mappings are stored in a hidden worksheet of the spreadsheet. ### Claim 4 (depends on 1) The computer-readable storage medium of claim 1, wherein the data from the web service is sourced from a plurality of databases to the web service for populating fields of the spreadsheet. ### Claim 5 (depends on 4) The computer-readable storage medium of claim 4, wherein the web service is a representational state transfer (REST) service. ### Claim 6 (depends on 1) The computer-readable storage medium of claim 1, wherein the mappings include that at least two display values are mapped to a single data value. ### Claim 7 (depends on 1) The computer-readable storage medium of claim 1, wherein the table component maps attributes, fields, and associated properties with columns and cells of the spreadsheet. ### Claim 8 A computer-implemented method for editing a spreadsheet by a client computing device, the method comprising: obtaining web service metadata from a web service; determining spreadsheet attributes of the web service based on the web service metadata; configuring, by the client computing device, a table component in the spreadsheet based on the spreadsheet attributes; retrieving, by the client computing device, data from the web service including a data value in a web service encoded format; converting, by the client computing device, the data value to a corresponding display value in a spreadsheet encoding format by using mappings of display values to data values, wherein the mappings are stored in the spreadsheet; converting, by the client computing device, user inputted data changes of the display value in the spreadsheet, to a corresponding data value in the web service encoded format by using the mappings; and sending the converted data changes from the spreadsheet to the web service. ### Claim 9 (depends on 8) The method of claim 8, wherein the corresponding data value is a non-human readable format and the display value is a human readable format. ### Claim 10 (depends on 8) The method of claim 8, wherein the mappings are stored in a hidden worksheet of the spreadsheet. ### Claim 11 (depends on 8) The method of claim 8, wherein the data from the web service is sourced from a plurality of databases to the web service for populating fields of the spreadsheet. ### Claim 12 (depends on 11) The method of claim 11, wherein the web service is a representational state transfer (REST) service. ### Claim 13 (depends on 8) The method of claim 8, wherein the mappings include that at least two display values are mapped to a single data value. ### Claim 14 (depends on 8) The method of claim 8, wherein the table component maps attributes, fields, and associated properties with columns and cells of the spreadsheet. ### Claim 15 A system comprising: one or more processors of a client computing device; and logic encoded in one or more non-transitory computer-readable storage media for execution by the one or more processors and when executed operable to perform operations comprising: obtaining web service metadata from a web service; determining spreadsheet attributes of the web service based on the web service metadata; configuring, by the client computing device, a table component in the spreadsheet based on the spreadsheet attributes; retrieving, by the client computing device, data from the web service including a data value in a web service encoded format; converting, by the client computing device, the data value to a corresponding display value in a spreadsheet encoding format by using mappings of display values to data values, wherein the mappings are stored in the spreadsheet; converting, by the client computing device, user inputted data changes of the display value in the spreadsheet, to a corresponding data value in the web service encoded format by using the mappings; and sending the converted data changes from the spreadsheet to the web service. ### Claim 16 (depends on 15) The system of claim 15, wherein the corresponding data value is a non-human readable format and the display value is a human readable format. ### Claim 17 (depends on 15) The system of claim 15, wherein the mappings are stored in a hidden worksheet of the spreadsheet. ### Claim 18 (depends on 15) The system of claim 15, wherein the web service is a representational state transfer (REST) service and the data from the web service is sourced from a plurality of databases to the REST web service for populating fields of the spreadsheet. ### Claim 19 (depends on 15) The system of claim 15, wherein the mappings include that at least two display values are mapped to a single data value. ### Claim 20 (depends on 15) The system of claim 15, wherein the table component maps attributes, fields, and associated properties with columns and cells of the spreadsheet.