Method and system for converting table cell formula of information management system into Excel formula
Method and system for converting table cell formula of information management system into Excel formula
 CN 101,944,213 A
 Filed: 09/29/2010
 Published: 01/12/2011
 Est. Priority Date: 09/29/2010
 Status: Active Application
First Claim
1. a method that is used for the list cell formula of information management system is converted to the Excel formula is characterized in that, comprising:
 Step S202 carries out syntax parsing to the list cell formula in the described information management system, generates first syntax tree, and described first syntax tree comprises at least one atomic formula;
Step S204 resolves described at least one atomic formula in described information management system;
Step S206 according to the analysis result among the described step S204, generates the corresponding element corresponding to second syntax tree of Excel formula, and generates described second syntax tree according to described corresponding element;
Step S208 generates the new formula that meets Excel formula standard according to described second syntax tree.
Chinese PRB Reexamination
Abstract
The invention discloses a method for converting the table cell formula of an information management system into an Excel formula, which comprises the following steps of: S202, carrying out grammar analysis on the table cell formula in the information management system, and generating a first grammar tree, wherein the first grammar tree comprises at least one atomic formula; S204, analyzing the at least one atomic formula in the information management system; S206, generating the corresponding element of a second grammar tree corresponding to the Excel formula according to an analysis result in the step S204, and generating the second grammar tree according to the corresponding element; and S208, generating a new formula conforming to the criterion of the Excel formula according to the second grammar tree. The invention also discloses a system for converting the table cell formula of the information management system into the Excel formula. According to the technical scheme, when the data of the information management system is derived into an Excel, the formula can be carried, thereby greatly improving the efficiency and the accuracy of compiling the data of the information management system in the Excel by a user.
6 Claims

1. a method that is used for the list cell formula of information management system is converted to the Excel formula is characterized in that, comprising:

Step S202 carries out syntax parsing to the list cell formula in the described information management system, generates first syntax tree, and described first syntax tree comprises at least one atomic formula; Step S204 resolves described at least one atomic formula in described information management system; Step S206 according to the analysis result among the described step S204, generates the corresponding element corresponding to second syntax tree of Excel formula, and generates described second syntax tree according to described corresponding element; Step S208 generates the new formula that meets Excel formula standard according to described second syntax tree.


2. method according to claim 1 is characterized in that described information management system comprises ERP system.

3. method according to claim 1 and 2 is characterized in that, described first syntax tree further comprises at least one operational character, and described operational character comprises :
 +,, *, ÷
.
 +,, *, ÷

4. a system that is used for the list cell formula of information management system is converted to the Excel formula is characterized in that, comprising:

The first syntax tree generation module carries out syntax parsing to the list cell formula in the described information management system, generates first syntax tree, and described first syntax tree comprises at least one atomic formula; The atomic formula parsing module is resolved described at least one atomic formula in described information management system; The second syntax tree generation module according to the analysis result of described atomic formula parsing module, generates the corresponding element corresponding to second syntax tree of Excel formula, and generates described second syntax tree according to described corresponding element; The new formula generation module generates the new formula that meets Excel formula standard according to described second syntax tree.


5. system according to claim 4 is characterized in that described information management system comprises ERP system.

6. according to claim 4 or 5 described systems, it is characterized in that described first syntax tree further comprises at least one operational character, described operational character comprises :
 +,, *, ÷
.
 +,, *, ÷
Specification(s)