IP Library Granted Patent US 8,812,950
Granted Patent B2
US 8,812,950 · App. 11/967,704 · Granted Aug 19, 2014

Spreadsheet software services

View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 8,812,950
App. No.
11/967,704
Granted
Aug 19, 2014
Kind
B2
Abstract

Embodiments of the present invention include the creation of spreadsheet software services. In one embodiment, the features and functionality of a spreadsheet may be transformed into a software service, such as a web service, for example. In one embodiment, the present invention includes a method of generating a software service comprising analyzing a spreadsheet to extract an output schema corresponding to at least a portion of the spreadsheet, generating a software service interface description comprising the output schema and the description of the output data, wherein the software service interface is accessible over a network, and accessing the functionality of the spreadsheet using the software service interface description.

Claims (46)

1. A method of generating a spreadsheet software service comprising:

analyzing a spreadsheet to extract an output schema corresponding to at least a portion of the spreadsheet;

generating a spreadsheet software service based in part on the extracted output schema, the spreadsheet software service configured to provide access to data in the spreadsheet, wherein the spreadsheet software service is accessible over a network;

generating a software service interface description of a software service interface associated with the spreadsheet software service, wherein the software service interface is used to access the service; and

storing the software service interface description in a repository comprising a plurality of software service interface descriptions, the repository connected to the network;

the spreadsheet software service configured to provide access to data in the spreadsheet without using a spreadsheet program that was used to create the spreadsheet.

2. The method of claim 1 wherein the software service interface description is contained in a WSDL document, and comprises information about how the spreadsheet software service can be called.

3. The method of claim 1 wherein analyzing comprises generating an XSD document.

4. The method of claim 1 further comprising extracting data from said spreadsheet and storing the data with said software service.

5. The method of claim 4 , further comprising

configuring said data according to data schema information extracted from the spreadsheet; and

accessing first data derived from said data by using the extracted output schema.

6. The method of claim 1 further comprising:

receiving a SOAP request corresponding to the software service interface description in said software; and

generating a SOAP response comprising data.

7. The method of claim 6 wherein the SOAP request comprises data, and wherein said data is processed by said software service according to logic in said spreadsheet, and wherein said SOAP response comprises the processed data.

8. The method of claim 6 wherein the SOAP request comprises a request for data, and wherein the software service queries data from the spreadsheet and the SOAP response comprises output data from the spreadsheet.

9. The method of claim 1 further comprising specifying a business process definition, wherein the business process definition accesses the functionality of at least one spreadsheet using the software service interface description.

10. The method of claim 1 , further comprising

extracting input schema for raw data of said spreadsheet;

receiving new raw data;

processing the new raw data by using logic associated with said input schema; and

providing results of such calculations.

11. A non-transitory computer-readable medium containing instructions for controlling a computer system to perform a method, the method comprising:

analyzing a spreadsheet to extract an output schema corresponding to at least a portion of the spreadsheet;

generating a spreadsheet software service based in part on the extracted output schema, the spreadsheet software service configured to provide access to data in the spreadsheet, wherein the spreadsheet software service is accessible over a network;

generating a software service interface description of a software service interface associated with the spreadsheet software service interface, wherein the software service interface is used to access the service; and

storing the software service interface description in a repository comprising a plurality of software service interface descriptions, the repository connected to the network;

the spreadsheet software service configured to provide access to the data in the spreadsheet without using a spreadsheet program that was originally used to create the spreadsheet.

12. The computer-readable medium of claim 11 wherein the software service interface description is contained in a WSDL document, and comprises information about how the spreadsheet software service can be called.

13. The computer-readable medium of claim 11 wherein analyzing comprises generating an XSD document.

14. The computer-readable medium of claim 11 further comprising instructions for controlling the computer system to performs steps of extracting data from said spreadsheet and storing the data with said software service.

15. The computer-readable medium of claim 14 further comprising instructions for

configuring said data according to data schema information extracted from the spreadsheet; and

accessing first data derived from said data by using the extracted output schema.

16. The computer-readable medium of claim 11 further comprising instructions for controlling the computer system to perform steps of:

receiving a SOAP request corresponding to the software service interface description in said software; and

generating a SOAP response comprising data.

17. The computer-readable medium of claim 16 wherein the SOAP request comprises data, and wherein said data is processed by said software service according to logic in said spreadsheet, and wherein said SOAP response comprises the processed data.

18. The computer-readable medium of claim 16 wherein the SOAP request comprises a request for data, and wherein the software service queries data from the spreadsheet and the SOAP response comprises output data from the spreadsheet.

19. The computer-readable medium of claim 11 further comprising instructions for controlling the computer system to perform steps of specifying a business process definition, wherein the business process definition accesses the functionality of at least one spreadsheet using the software service interface description.

20. The computer-readable medium of claim 11 further comprising instructions for

extracting input schema for raw data of said spreadsheet;

receiving new raw data;

processing the new raw data by using logic associated with said input schema; and

providing results of such calculations.

Assignments (2)
CHANGE OF NAME Recorded Aug 26, 2014
From: SAP AG
To: SAP SE
Reel/Frame 033625/0223 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Mar 7, 2008
From: SIKKA, VISHAL; AGASSI, SHAI
To: SAP AG
Reel/Frame 020616/0513 →