Hybrid Spreadsheet/Workflow Design and Execution Environment

• US 20080256508A1
• Filed: 05/02/2008
• Published: 10/16/2008
• Est. Priority Date: 10/09/2003
• Status: Abandoned Application

• Current Assignee: Einfalt Ehf
• Original Assignee: EINFALT, EHF.
• Inventors: Jonsson, Gunnlaugur
• Application Number:
  US12/114,175
• Publication Number:
  US 20080256508A1
• Time in Patent Office: Days
• US Class Current: 717/104
• CPC Class Codes: G06F 40/18 of spreadsheets form-filling G06F40/174
• CPC Class Codes: G06F 8/10 Requirements analysis; Specification techniques
• CPC Class Codes: G06F 8/34 Graphical or visual programming

Abstract

The present invention provides a user-friendly visual programming and modeling environment with a spreadsheet interface. The invention allows the creation of complex software applications and programs in real-time. A user with no programming skills can easily develop software programs. A hybrid workflow diagram and execution environment is created using a spreadsheet. The workflow and the spreadsheet cause variables in the spreadsheet cells to be manipulated. The hybrid workflow design and execution environment are used to implement computer readable code to create new executable software applications.

Claims

1. A computer implemented method of software programming comprising the steps of:

creating a hybrid workflow diagram and execution environment using a spreadsheet application by;

causing the workflow and the spreadsheet to manipulate variables in the spreadsheet cells; and

using the hybrid workflow design and execution environment to implement computer readable code to create a new executable software application.

2. A computer implemented method of software programming as in claim 1 wherein using the hybrid workflow design and execution environment to implement computer readable code to create a new executable software application further includes executing branches of an IfElse activity using a value of a cell in the spreadsheet, where the IfElse activity controls a portion of the new executable software application.

3. A computer implemented method of software programming as in claim 1 wherein using the hybrid workflow design and execution environment to implement computer readable code to create a new executable software application further includes copying values and formulas between cells, where the copied formulas and values between cells controls a portion of the new executable software application.

4. A computer implemented method of software programming as in claim 1 wherein using the hybrid workflow design and execution environment to implement computer readable code to create a new executable software application further includes defining event handlers using cells in the spreadsheet, where the event handlers control a portion of the new executable software application.

5. A computer implemented method of software programming as in claim 1 wherein the new executable software conforms to a common language runtime (CLR) schema.

6. A computer implemented method of software programming as in claim 1 wherein creating a hybrid workflow diagram and execution environment using a spreadsheet further includes rehosting a software modeling application in a spreadsheet application.

7. A computer implemented method of software programming as in claim 6 wherein rehosting a software modeling application in the spreadsheet application further includes:

creating custom activities capable of calling methods of the spreadsheet'"'"'s object model; and

creating custom activities capable of listening to events exposed in the spreadsheet application.

8. A computer implemented method of software programming as in claim 7 wherein the software modeling application is Workflow Designer and the spreadsheet application is Excel.

9. A computer system for software programming comprising:

a handler responsive to workflow requests and spreadsheet input manipulating variables in the spreadsheet cells; and

an execution engine in communication with the handler creating a hybrid workflow diagram and execution environment using the spreadsheet to implement computer readable code defining a new software application.

10. A software programming system comprising:

means for creating a hybrid workflow diagram and execution environment using a spreadsheet by;

means for causing the workflow and the spreadsheet to manipulate variables in the spreadsheet cells; and

means for using the hybrid workflow design and execution environment to implement computer readable code to create a new executable software application.