Multi-table iterative computation method and device, electronic equipment and storage medium

Abstract

The invention provides a multi-table iterative computation method and device, electronic equipment and a storage medium, and is applied to the technical field of data analysis and processing. The method comprises the following steps of: 1, initializing an application program interface, and calling in a function definition file; 2, obtaining a template with multiple tables and verifying each formula in the multiple tables; and 3, executing formula iterative computation after all the formulas pass the verification, wherein the formula iterative computation comprises computation for the maximum iteration times and the maximum error value of the formulas. On the basis of preventing formula configuration errors, the accuracy of formula calculation can be controlled.

Description

technical field [0001] The present application relates to the technical field of data analysis and processing. Specifically, the present application relates to a multi-table iterative calculation method, device, electronic equipment and storage medium. Background technique [0002] At present, the calculation of the formula, especially the calculation of the reference relationship between the parameters in the formula, is generally implemented by using a template such as an Excel table file. For each worksheet (sheet) in the template, it can be understood as a cell in the table , generally use the poi method to fill in the formula of the cell into the sheet of the created excel file, and let excel perform the formula operation. However, when the data source and formula are configured in the template, the template has multiple sheets, The cells of each Sheet contain formulas, and these formulas may span Sheets. These cells containing formulas may refer to each other, and even...

AI Technical Summary

Problems solved by technology

[0002] At present, the calculation of the formula, especially the calculation of the reference relationship between the parameters in the formula, is generally implemented by using a template such as an Excel table file. For each worksheet (sheet) in the template, it can be understood as a cell in the table , generally use the poi method to fill in the formula of the cell into the sheet of the created excel file, and let excel perform the formula operation. However, when the data source and formula are configured in the template, the template has multiple sheets, The cells of each Sheet contain formulas, and these formulas may span Sheets. These cells containing formulas may refer to each other, and eventually form an iterative relationship. For the above configuration, the poi method cannot be applied to the above iterative cycle containing formulas , and because the maximum number of iterations and the maximum error cannot be set, the accuracy of the formula operation in the cell cannot be controlled

In addition, the above-mentioned templates are generally stored in a local computer or a computer connected to a local area network, and it is impossible to import the template online and display the calculation results of the formula. In this way, the template that may have undergone multiple adjustments to the data and formula cannot be flexibly updated online. Display update calculation results

Images