Facilitating the development of computer programs

• US 20040268226A1
• Filed: 06/26/2003
• Published: 12/30/2004
• Est. Priority Date: 06/26/2003
• Status: Abandoned Application

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: McMullin, Angelina
• Application Number:
  US10/607,127
• Publication Number:
  US 20040268226A1
• Time in Patent Office: Days
• US Class Current: 715/213
• CPC Class Codes: G06F 40/18 of spreadsheets form-filling G06F40/174
• CPC Class Codes: G06F 8/20 Software design

Abstract

Development of computer programs is facilitated. An interface of a program is created and that program interface encapsulates an existing spreadsheet, such that the spreadsheet itself is the calculation engine of the program. The logic of the spreadsheet is not re-coded, and the spreadsheet is hidden from and unchangeable by the user. The interface provides exclusive input and output access to the spreadsheet.

Claims

1. A method of facilitating development of programs, said method comprising:

providing an interface of a program; and

including in the program a spreadsheet that is to execute logic of the spreadsheet in response to data of the interface, wherein the spreadsheet of the program is unchangeable by a user.

2. The method of claim 1, wherein the spreadsheet of the program is hidden from the user.

3. The method of claim 1, wherein having the spreadsheet execute logic of the spreadsheet avoids re-coding of logic of the spreadsheet.

4. The method of claim 1, wherein the providing comprises creating the interface based on the spreadsheet.

5. The method of claim 4, wherein the creating comprises:

creating an input section of the interface based on an input tab of the spreadsheet; and

creating an output section of the interface based on a results tab of the spreadsheet.

6. The method of claim 1, wherein the including comprises enabling interaction between the interface and the spreadsheet.

7. The method of claim 6, wherein the enabling interaction comprises providing to the spreadsheet one or more inputs from the interface.

8. The method of claim 7, wherein the enabling comprises performing at least one of one or more checks and one or more tasks in preparation of the providing.

9. The method of claim 1, further comprising enabling the interface to provide output data from the spreadsheet.

10. The method of claim 1, wherein the logic comprises one or more calculations to be performed on data provided by the interface.

11. The method of claim 10, further comprising enabling the interface to provide one or more results of at least one calculation of the one or more calculations.

12. The method of claim 1, wherein the interface provides exclusive input access to the spreadsheet of the program.

13. The method of claim 1, wherein the interface provides exclusive output access to the spreadsheet of the program.

14. The method of claim 1, further comprising replacing one or more calculations of the spreadsheet and avoiding re-coding of the interface.

15. A method of facilitating access to spreadsheets, said method comprising:

using an interface to provide data to a spreadsheet, said interface providing exclusive input access to the spreadsheet; and

using the interface to obtain data from the spreadsheet, said interface providing exclusive output access to the spreadsheet.

16. The method of claim 15, wherein the interface encapsulates the spreadsheet, and wherein the encapsulated spreadsheet is hidden from one or more users.

17. The method of claim 15, wherein the interface encapsulates the spreadsheet, and wherein the encapsulated spreadsheet is unchangeable by one or more users.

18. The method of claim 15, wherein at least a portion of the data to be obtained from the spreadsheet is based on one or more calculations performed by the spreadsheet.

19. A system of facilitating development of programs, said system comprising:

means for providing an interface of a program; and

means for including in the program a spreadsheet that is to execute logic of the spreadsheet in response to data of the interface, wherein the spreadsheet of the program is unchangeable by a user.

20. The system of claim 19, wherein the spreadsheet of the program is hidden from the user.

21. The system of claim 19, wherein the means for providing comprises means for creating the interface based on the spreadsheet.

22. The system of claim 19, wherein the means for including comprises means for enabling interaction between the interface and the spreadsheet.

23. The system of claim 22, wherein the means for enabling interaction comprises means for providing to the spreadsheet one or more inputs from the interface.

24. The system of claim 19, further comprising means for enabling the interface to provide output data from the spreadsheet.

25. The system of claim 19, wherein the logic comprises one or more calculations to be performed on data provided by the interface.

26. The system of claim 19, wherein the interface provides at least one of exclusive input access and exclusive output access to the spreadsheet of the program.

27. The system of claim 19, further comprising means for replacing one or more calculations of the spreadsheet and avoiding re-coding of the interface.

28. A storage to store a computer program, said computer program comprising:

an interface; and

a spreadsheet that is to execute logic of the spreadsheet in response to data of the interface, wherein the spreadsheet of the program is unchangeable by a user.

29. An article of manufacture comprising:

at least one computer usable medium having computer readable program code logic to facilitate development of programs, the computer readable program code logic comprising;

provide logic to provide an interface of a program; and

include logic to include in the program a spreadsheet that is to execute logic of the spreadsheet in response to data of the interface, wherein the spreadsheet of the program is unchangeable by a user.

30. The article of manufacture of claim 29, wherein the spreadsheet of the program is hidden from the user.

31. The article of manufacture of claim 29, wherein the provide logic comprises create logic to create the interface based on the spreadsheet.

32. The article of manufacture of claim 29, wherein the include logic comprises enable logic to enable interaction between the interface and the spreadsheet.

33. The article of manufacture of claim 32, wherein the enable logic comprises provide logic to provide to the spreadsheet one or more inputs from the interface.

34. The article of manufacture of claim 29, further comprising enable logic to enable the interface to provide output data from the spreadsheet.

35. The article of manufacture of claim 29, wherein the logic of the spreadsheet comprises one or more calculations to be performed on data provided by the interface.

36. The article of manufacture of claim 29, wherein the interface provides at least one of exclusive input access and exclusive output access to the spreadsheet of the program.

37. The article of manufacture of claim 29, further comprising replace logic to replace one or more calculations of the spreadsheet and avoid re-coding of the interface.

38. An article of manufacture comprising:

at least one computer usable medium having computer readable program code logic to facilitate access to spreadsheets, the computer readable program code logic comprising;

use logic to use an interface to provide data to a spreadsheet, said interface providing exclusive input access to the spreadsheet; and

use logic to use the interface to obtain data from the spreadsheet, said interface providing exclusive output access to the spreadsheet.

39. The article of manufacture of claim 38, wherein at least a portion of the data to be obtained from the spreadsheet is based on one or more calculations performed by the spreadsheet.