System and method for platform-independent, script-based application generation for spreadsheet software

• US 8,539,444 B2
• Filed: 06/30/2008
• Issued: 09/17/2013
• Est. Priority Date: 06/30/2008
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Cao, Rong Zeng, Jiang, Shun, Lee, Juhnyoung, Tian, Chun Hua, Ding, Wei C R
• Primary Examiner(s): MORRISON, JAY A
• Application Number:
  US12/164,582
• Publication Number:
  US 20090328010A1
• Time in Patent Office: 1,905 Days
• Field of Search: None
• US Class Current: 717/115
• CPC Class Codes: G06F 40/18 of spreadsheets form-filling G06F40/174
• CPC Class Codes: G06F 8/38 for implementing user interfaces
• CPC Class Codes: G06F 8/427 Parsing
• CPC Class Codes: G06F 9/44 Arrangements for executing specific programs

Abstract

A script-based application generation for spreadsheet software reads from one or more spreadsheets rendered by a spreadsheet program, description written in said text-based language, the text-based language for describing user interfaces, data models and/or workflow models or combinations thereof. The text-based language is independent of the spreadsheet program. The description is parsed and from the description one or more user interfaces, data model or workflow model or combinations thereof are generated in the spreadsheet program.

Claims

1. A computer-implemented method for platform-independent, script-based application generation for spreadsheet software, comprising:

reading from one or more spreadsheets rendered by a spreadsheet program, description written in text-based language, the text-based language for describing user interfaces, data models, or workflow models or combinations thereof, the text-based language being independent of the spreadsheet program, the description input directly into row and column cells of the one or more spreadsheets;

parsing the description;

translating the parsed description into programming instructions in a language native to the spreadsheet program;

generating one or more user interfaces, data models or workflow models or combinations thereof from the parsed description; and

presenting said one or more user interfaces, data models or workflow models or combination thereof in the spreadsheet program by executing the translated programming instructions in the spreadsheet program.

2. The method of claim 1, further including:

storing into said one or more spreadsheets user input or results or combination thereof, received from said user interface, data model or workflow model or combinations thereof.

3. The method of claim 1,

wherein the step of generating one or more user interfaces is performed by executing the programming instructions in the spreadsheet program.

4. The method of claim 1, wherein the text-based language has tree structure.

5. The method of claim 1, wherein the text-based language has tree structure;

and

the step of parsing includes using row and column structure provided in said one or more spreadsheets.

6. The method of claim 1, wherein the text-based language has tree structure;

and

the step of parsing includes using row and column structure provided in said one or more spreadsheets, wherein text entered in a column has a parent-child relationship with text entered in an adjacent column that succeeds or precedes the column.

7. The method of claim 1, wherein the description written in said text-based language specifies one or more widgets to be included in said one or more interfaces, data models or workflow models or combinations thereof.

8. The method of claim 1, wherein the description written in said text-based language specifies one or more steps for navigating through said one or more of user interfaces.

9. The method of claim 1, wherein the description written in said text-based language specifies one or more widgets to be included in said one or more interfaces, data models or workflow models or combinations thereof, and the description written in said text-base language further specifies data to be bound to one or more widgets.

24. The method of claim 1, wherein the description written in said text-based language can be used without modifications on a plurality of different spreadsheet program platforms.

25. The method of claim 1, wherein the description written in said text-based language can be used without modifications on a plurality of different spreadsheet program platforms, the description being translated into a plurality of different programming languages native respectively to the plurality of different spreadsheet program platforms.

26. The method of claim 1, further including:

generating an output file having a format that is compatible with the spreadsheet program, the output file comprising at least information collected from said generated one or more user interfaces, data models or workflow models or combination thereof.

10. A computer-implemented method for platform-independent, script-based application generation for spreadsheet software, comprising:

providing a text-based language for describing user interfaces, data models or workflow models or combinations thereof, text of the text-based language being enterable directly in row and column cells of one or more spreadsheets of a spreadsheet program, the text-based language being independent of the spreadsheet program; and

providing an interpreter that parses the text and translates the text into programming instructions in a language native to the spreadsheet program based on row and column cell structure provided by the spreadsheet program, the programming instructions for generating one or more user interfaces, data models or workflow models or combination thereof specified by the text, said one or more user interfaces, data models or workflow models or combination thereof being generated and presented in the spreadsheet program by executing the translated programming instructions in the spreadsheet program.

11. The method of claim 10, wherein the interpreter includes at least a user interface interpreter that parses the text for widgets to be built into said one or more user interfaces.

12. The method of claim 10, wherein the interpreter includes at least a process interpreter that parses the text for one or more process steps for navigating through said one or more user interfaces, data models or workflow models of combinations thereof.

13. The method of claim 10, wherein the interpreter includes at least a data interpreter that parses the text for one or more data to be bound to one or more widgets to be built into said one or more user interfaces, data models or workflow models.

14. The method of claim 10, wherein the text-based language has tree structure.

15. The method of claim 10, wherein the text-based language has tree structure;

and

the interpreter parses data in row and column table structure provided in said one or more spreadsheets.

16. The method of claim 10, wherein the text-based language has tree structure;

and

the interpreter parses data in row and column table structure provided in said one or more spreadsheets, wherein text entered in a column of said one or more spreadsheets has a parent-child relationship with text entered in an adjacent column that succeeds or precedes the column.

17. The method of claim 10, wherein the text written in said text-based language specifies one or more widgets to be included in said one or more interfaces, data models or workflow models or combinations thereof.

18. The method of claim 10, wherein the text written in said text-based language specifies one or more steps for navigating through said one or more of user interfaces, data models or workflow models or combinations thereof.

19. The method of claim 10, wherein the text written in said text-based language specifies one or more widgets to be included in said one or more interfaces, data models or workflow models or combinations thereof, and the text written in said text-base language further specifies data to be bound to one or more widgets.

20. The method of claim 10, wherein the interpreter further generates additional programming instructions for storing into said one or more spreadsheets user input or results or combination thereof, received from said one or more user interfaces, data model or workflow model or combinations thereof.

27. The method of claim 10, wherein the text written in said text-based language can be used without modifications on a plurality of different spreadsheet program platforms.

28. The method of claim 10, wherein the text written in said text-based language can be used without modifications on a plurality of different spreadsheet program platforms, the text being translated into a plurality of different programming languages native respectively to the plurality of different spreadsheet program platforms.

29. The method of claim 10, wherein the interpreter is further operable to generate an output file having a format that is compatible with the spreadsheet program, the output file comprising at least information collected from said generated one or more user interfaces, data models or workflow models or combination thereof.

21. A computer-implemented system for platform-independent, script-based application generation for spreadsheet software, comprising:

a computer processor;

a text-based language for describing user interfaces, data models or workflow models or combinations thereof, text of the text-based language being enterable directly in row and column cells of one or more spreadsheets of a spreadsheet program, the text-based language being independent of the spreadsheet program; and

an interpreter, operable to execute on the computer processor, that parses the text and translates the text into programming instructions in a language native to the spreadsheet program based on row and column cell structure provided by the spreadsheet program, the programming instructions for generating one or more user interfaces, data models or workflow models or combination thereof specified by the text, said one or more user interfaces, data models or workflow models or combination thereof being generated and presented in the spreadsheet program by executing the translated programming instructions in the spreadsheet program.

22. The system of claim 21, wherein the interpreter further generates additional programming instructions for storing into said one or more spreadsheets user input or results or combination thereof, received from said one or more user interfaces, data model or workflow model or combinations thereof.

23. The system of claim 21, wherein the text-based language has tree structure and the interpreter parses data in row and column table structure provided in said one or more spreadsheets, wherein text entered in a column of said one or more spreadsheets is interpreted to have a parent-child relationship with text entered in an adjacent column that succeeds or precedes the column.

30. The system of claim 21, wherein the text written in said text-based language can be used without modifications on a plurality of different spreadsheet program platforms.

31. The system of claim 21, wherein the text written in said text-based language can be used without modifications on a plurality of different spreadsheet program platforms, the text being translated into a plurality of different programming languages native respectively to the plurality of different spreadsheet program platforms.

32. The system of claim 21, wherein the interpreter is further operable to generate an output file having a format that is compatible with the spreadsheet program, the output file comprising at least information collected from said generated one or more user interfaces, data models or workflow models or combination thereof.

33. A program storage device readable by a machine, tangibly embodying a program of instructions executable by the machine to perform a method of platform-independent, script-based application generation for spreadsheet software, comprising:

reading from one or more spreadsheets rendered by a spreadsheet program, description written in said text-based language, the text-based language for describing user interfaces, data models or workflow models or combinations thereof, the text-based language being independent of the spreadsheet program, the description input directly into row and column cells of the one or more spreadsheets;

parsing the description;

translating the parsed description into programming instructions in a language native to the spreadsheet program based on row and column cell structure provided by the spreadsheet program;

generating one or more user interfaces, data model or workflow model or combinations thereof from the parsed description; and

presenting said one or more user interfaces, data models or workflow models or combination thereof in the spreadsheet program by executing the translated programming instructions in the spreadsheet program.

34. A program storage device readable by a machine, tangibly embodying a program of instructions executable by the machine to perform a method of platform-independent, script-based application generation for spreadsheet software, comprising:

providing a text-based language for describing user interfaces, data models or workflow models or combinations thereof, text of the text-based language being enterable directly in row and column cells of one or more spreadsheets of a spreadsheet program, the text-based language being independent of the spreadsheet program; and

providing an interpreter that parses the text and translates the text into programming instructions in a language native to the spreadsheet program based on row and column cell structure provided by the spreadsheet program, the programming instructions for generating one or more user interfaces, data models or workflow models or combination thereof specified by the text, said one or more user interfaces, data models or workflow models or combination thereof being generated and presented in the spreadsheet program by executing the translated programming instructions in the spreadsheet program.

35. The program storage device of claim 34, wherein the text written in said text-based language can be used without modifications on a plurality of different spreadsheet program platforms, the text being translated into a plurality of different programming languages native respectively to the plurality of different spreadsheet program platforms.