Excel formula object-oriented language automatic conversion method based on recursion replacement expansion backtrack
An object-oriented, automatic conversion technology, applied in programming languages/paradigms, natural language data processing, special data processing applications, etc., can solve the problem that formulas and edited formulas have fixed formats, and achieve ingenious algorithm concepts and broad application scenarios. Effect
Inactive Publication Date: 2017-09-26
DALIAN JIAOTONG UNIVERSITY
View PDF4 Cites 10 Cited by
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
[0002] The EXCEL software integrates a large number of mathematical calculation formulas, and can provide a certain range of custom functions. A large number of front-line office workers can complete the editing formulas in the EXCEL software proficiently. However, because the EXCEL software is not an open source free software, the software The formulas in and edited formulas have fixed formats and can only be used in Microsoft Office environments
Method used
the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View moreImage
Smart Image Click on the blue labels to locate them in the text.
Smart ImageViewing Examples
Examples
Experimental program
Comparison scheme
Effect test
Embodiment Construction
[0036] The technical solutions in the embodiments of the present invention will be clearly and completely described below in conjunction with the accompanying drawings in the embodiments of the present invention. Apparently, the described embodiments are only some of the embodiments of the present invention, not all of them. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts all belong to the protection scope of the present invention.
[0037] Such as figure 1 , figure 2 , image 3 and Figure 4 As shown, the excel formula based on recursive replacement and backtracking is an automatic conversion method for object-oriented language, which mainly includes the following steps:
[0038] Considering that for engineers, it is very clear whether each formula is a string or a value, but it is not clear for an object-oriented language translator. Therefore, in order to ensure th...
the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More PUM
Login to View More Abstract
The invention discloses an excel formula object-oriented language automatic conversion method based on recursion replacement expansion backtrack. The method comprises the following steps that due to the fact that excel needs to be converted into an object-oriented language mathematical formula, a return value is remarked at an excel form column header; as for a mathematical formula of the remarked return value, reverse Polish rules are adopted, on the basis of a predefined formula set and operators in the Excel, parameters in the formula are automatically extracted; the extracted parameters are modified; the mathematical formula obtained after parameter modification is analyzed, the complex mathematical formula is simplified step by step into a plurality of atom formulas corresponding to the mathematical formula; the atom formulas are backtracked step by step according to the object-oriented language till all the mathematical formulas are converted. By adopting the reverse Polish rules, on the basis of the predefined formula set and the operators in the Excel, parameters in the formula are automatically extracted, and the formula capable of being used in the object-oriented language is generated. People who do not have the specific programming language competence can use excel for performing specific operation, formula edition and processing.
Description
technical field [0001] The present invention relates to a kind of conversion method of excel formula object-oriented language, relate in particular to a kind of excel formula conversion method based on recursive replacement expansion backtracking. Involving patent classification number G06 Calculation; Calculation; Counting G06F Electrical digital data processing G06F17 / 00 Especially suitable for digital computing equipment or data processing equipment or data processing methods with specific functions. Background technique [0002] The EXCEL software integrates a large number of mathematical calculation formulas, and can provide a certain range of custom functions. A large number of front-line office workers can complete the editing formulas in the EXCEL software proficiently. However, because the EXCEL software is not an open source free software, the software The formulas in and edited formulas have fixed formats and can only be used in Microsoft Office environments. [...
Claims
the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More Application Information
Patent Timeline
Login to View More Patent Type & Authority Applications(China)
IPC IPC(8): G06F17/22G06F17/21G06F9/44
CPCG06F8/31G06F40/111G06F40/12
Inventor 李正光王世鹏邓武陈恒杨光
Owner DALIAN JIAOTONG UNIVERSITY