Systems, methods and machine readable mediums for defining and executing new commands in a spreadsheet software application
Systems, methods and machine-readable mediums for defining and executing new commands in a spreadsheet application are provided. A method may include receiving a declaration command in a first spreadsheet cell. The declaration command identifying a command name for the new command and operations performed for the command name based on a plurality of second spreadsheet cells. A system may include a processor programmed to evaluate the declaration command in the first spreadsheet cell according to the instructions stored in a storage device, receive the command name and at least two parameters identifying at least one input spreadsheet cell and at least one output spreadsheet cell of the spreadsheet application, create a new command for the spreadsheet application, and evaluate the new command as identified by the command name in a second spreadsheet cell for execution. The computer readable mediums provide instructions to cause the processor to perform the operations above.
1. A method for executing a new command in a spreadsheet application, the method comprising:
storing, in a storage device, instructions for implementing a declaration command, the declaration command assigning a command name as the new command with at least two parameters; and
evaluating, by a processor, the declaration command in a first spreadsheet cell according to the instructions stored in the storage device,
receiving, by the processor, the command name and at least two parameters identifying at least one input spreadsheet cell and at least one output spreadsheet cell of the spreadsheet application,
creating, by the processor, a new command for the spreadsheet application, and
evaluating, by the processor, the new command as identified by the command name in a second spreadsheet cell by providing input data to the at least one input spreadsheet cell and receive output data from the at least one output spreadsheet cell.
2. The method of claim 1 , further comprising:
translating, by the processor, the new command declared in a spreadsheet language to a fragment of code in a predetermined programming language.
3. The method of claim 1 , wherein the command name and the at least two parameters are inputted with the declaration command in the first spreadsheet cell.
4. The method of claim 1 , wherein a parameter of the at least two parameters is a function associated with a third spreadsheet cell.
5. The method of claim 1 , further comprising:
calling, by the processor, the declaration command and the command name in a spreadsheet language.
6. The method of claim 1 , further comprising:
receiving the declaration command in the first spreadsheet cell, the declaration command identifying the command name for the new command and operations performed for the command name based on a plurality of second spreadsheet cells.
7. The method of claim 6 , further comprising generating, in a predetermined programming language, a fragment of code corresponding to a function of the new command declared using a spreadsheet language.
8. The method of claim 6 , further comprising receiving the command name and at least two parameters in the first spreadsheet cell, the at least two parameters identifying the plurality of second spreadsheet cells, the plurality of second spreadsheet cells including at least one input cell to receive at least one input parameter of the new command and at least one output cell to provide a return result of the new command.
9. The method of claim 6 , wherein the declaration command is programmed for receiving the command name from a third spreadsheet cell, receiving a first parameter, to identify an input cell for the new command, in a fourth spreadsheet cell, and receiving a second parameter, to identify an output cell for the new command, in a fifth spreadsheet cell.
10. A system for executing a new command in a spreadsheet application, the system comprising:
a storage device to store instructions for implementing a declaration command, the declaration command assigning a command name as the new command with at least two parameters; and
a processor programmed to:
evaluate the declaration command in a first spreadsheet cell according to the instructions stored in the storage device,
receive the command name and at least two parameters identifying at least one input spreadsheet cell and at least one output spreadsheet cell of the spreadsheet application,
create a new command for the spreadsheet application, and
evaluate the new command as identified by the command name in a second spreadsheet cell by providing input data to the at least one input spreadsheet cell and receive output data from the at least one output spreadsheet cell.
11. The system of claim 10 , wherein the processor is programmed to translate the new command declared in a spreadsheet language to a fragment of code in a predetermined programming language.
12. The system of claim 10 , wherein the command name and the at least two parameters are inputted with the declaration command in the first spreadsheet cell.
13. The system of claim 10 , wherein a parameter of the at least two parameters is a function associated with a third spreadsheet cell.
14. The system of claim 10 , wherein the processor is programmed to call the declaration command and the command name in a spreadsheet language.
15. A non-transitory computer readable medium having stored thereon a set of instructions, which when executed by a computer having a processor and a memory, causes the computer to perform operations, comprising:
storing, in the memory, instructions for implementing a declaration command, the declaration command assigning a command name as the new command with at least two parameters; and
evaluating, by the processor, the declaration command in a first spreadsheet cell according to the instructions stored in the storage device,
receiving, by the processor, the command name and at least two parameters identifying at least one input spreadsheet cell and at least one output spreadsheet cell of the spreadsheet application,
creating, by the processor, a new command for the spreadsheet application, and
evaluating, by the processor, the new command as identified by the command name in a second spreadsheet cell by providing input data to the at least one input spreadsheet cell and receive output data from the at least one output spreadsheet cell.
16. The medium of claim 15 , wherein the operations further comprise:
translating, by the processor, the new command declared in a spreadsheet language to a fragment of code in a predetermined programming language.
17. The medium of claim 15 , wherein the command name and the at least two parameters are inputted with the declaration command in the first spreadsheet cell.
18. The medium of claim 15 , wherein a parameter of the at least two parameters is a function associated with a third spreadsheet cell.
19. The medium of claim 15 , wherein the operations further comprise:
calling, by the processor, the declaration command and the command name in a spreadsheet language.