Parser, code generator, and data calculation and transformation engine for spreadsheet calculations
First Claim
1. A computer-readable medium containing instructions for implementing a source code generator for use with a computer system the source code generator comprising:
- an interface configured to receive a user-specification of spreadsheets that include spreadsheet data for which source code is to be generated, and a specification of spreadsheet cells for which no source code is to be generated where the cells are specified by setting cell attributes as markers for exclusion;
a data acquisition interface configured to receive the spreadsheet data;
a parser configured to extract information from the spreadsheet data received by the data acquisition interface excluding the spreadsheet cells for which the specification was received by the interface; and
an information processor configured to perform a data transformation of the information extracted by the parser into source code representative of the spreadsheet data.
1 Assignment
0 Petitions
Accused Products
Abstract
A system including spreadsheet sheets, makes calculations and data transformations, which is available through a programming interface, and conforms to the grammar and syntax of a target software development language is presented. The system includes an Object Model with Data Structures representing entities involved in spreadsheets. The system includes a Parser and Code Generator that extracts data from a body of spreadsheet data, instantiates instances of Data Structures of the Object Model to represent the spreadsheet data, parses the data and formulas contained in the cells of the spreadsheets, iterates through the instantiated instances of the Data Structures, and generates source code that performs the calculations and data transformations embodied in the spreadsheet data. The system includes a Calculation Engine with software base classes that implement the common structural and data access features of spreadsheet data, and further implement the operations of common spreadsheet functions and operators.
127 Citations
23 Claims
-
1. A computer-readable medium containing instructions for implementing a source code generator for use with a computer system the source code generator comprising:
-
an interface configured to receive a user-specification of spreadsheets that include spreadsheet data for which source code is to be generated, and a specification of spreadsheet cells for which no source code is to be generated where the cells are specified by setting cell attributes as markers for exclusion; a data acquisition interface configured to receive the spreadsheet data; a parser configured to extract information from the spreadsheet data received by the data acquisition interface excluding the spreadsheet cells for which the specification was received by the interface; and an information processor configured to perform a data transformation of the information extracted by the parser into source code representative of the spreadsheet data. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20)
-
-
21. A computer-readable medium containing instructions for implementing a source code generator for use with a computer system the source code generator comprising:
-
a data acquisition interface configured to receive spreadsheet data; a parser configured to extract information from the spreadsheet data, and an information processor configured to perform a data transformation of extracted information into source code representative of the spreadsheet data, which excludes implementations of built-in spreadsheet functions that are not referred to in the spreadsheet data.
-
-
22. A computer-readable medium containing instructions for implementing a source code generator for use with a computer system the source code generator comprising:
-
a data acquisition interface configured to receive spreadsheet data; a parser configured to extract information from the spreadsheet data, and an information processor configured to perform a data transformation of extracted information into source code representative of the spreadsheet data, which excludes implementations of user-defined spreadsheet functions that are not referred to in the spreadsheet data.
-
-
23. A computer-readable medium containing instructions for implementing a source code generator for use with a computer system the source code generator comprising:
-
a data acquisition interface configured to receive spreadsheet data; a parser configured to extract information from the spreadsheet data, and an information processor configured to perform a data transformation of extracted information into source code representative of the spreadsheet data, including; identifying and isolating a first spreadsheet cell formula having a similar structure as a second spreadsheet cell formula; generating parameterized source code representative of the structure; generating source code representative of the first spreadsheet cell formula that calls the generated parameterized source code; and generating source code representative of the second spreadsheet cell formula that calls the generated parameterized source code.
-
Specification