Function collection method and device of electronic data table

A technology of electronic data table and collection device, which is applied in the direction of electrical digital data processing, special data processing applications, complex mathematical operations, etc., and can solve problems such as inability to realize optimal execution of function A, waste of system computing resources, and low efficiency

Active Publication Date: 2007-10-17
KINGDEE SOFTWARE(CHINA) CO LTD
View PDF1 Cites 14 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0008] However, in practical applications, it is found that the above processing process has the following technical problems in the complex financial data processing process: it is necessary to repeatedly call the same function in the entire spreadsheet, and the scattered and repeated calls of the same function are not conducive to Optimized execution of this function, resulting in inefficiency
Therefore, in the execution process of the prior art, the function A is independently and repeatedly executed M times, and each execution of the function A needs to independently query and match the corresponding data from other data tables, and then complete the calculation, which cannot Realize the optimized execution of function A, waste system computing resources, and the computing rate is low

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 more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Function collection method and device of electronic data table
  • Function collection method and device of electronic data table
  • Function collection method and device of electronic data table

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0102] The external secondary development module is written in Java language as the electronic data sheet, which is used to provide ACCT query function to query the data in the ERP (Enterprise Resource Planning, enterprise resource management) database. ACCT is defined as: public BigDecimal ACCT (String subject code). You can enter the formula "=ACCT("001")" in the cell of the spreadsheet to query the account code whose ID is 001 in the ERP system. For example, this code corresponds to the cash amount, that is, query the ERP system to obtain the corresponding cash amount data.

[0103] In the internal implementation of ACCT, the query to the database is completed by assembling the following SQL_1 statement: select amount from subject balance table while subject code = "001". In the execution of an ACCT query function, the following series of operations need to be performed: connecting to the database, assembling SQL statements according to function parameters, executing SQL st...

Embodiment 2

[0110] Assume that the cell formulas in the 100 cells of the spreadsheet in the first embodiment not only include the ACCT function, but also include rules for calculating the function or other parameters.

[0111] For the above case. The present invention can be calculated in the following two ways:

[0112] A. A complex execution unit is set in the secondary development module to execute the unit formula including the ACCT function.

[0113] This solution is preferably applicable to the case where the unit formulas in the above 100 cells are the same or similar. During the batch collection step, the entire unit formulas are collected and submitted to the complex execution unit. After the batch is completed, the execution results are returned to Spreadsheet.

[0114] B. The execution unit set in the secondary development module is still only for ACCT. After the execution is completed, the execution result is returned to the electronic data sheet, and the units in each cell ...

Embodiment 3

[0117] On the basis of the above-mentioned embodiments, for the collected functions and their parameters, multi-thread technology can also be used to parallelize the various types of collected functions. For computing scenarios where there are multiple CPUs in the computing environment or function execution requires remote data access, it can help make full use of computer resources and significantly improve computing efficiency.

[0118] The process of using the direct matching method to collect functions and complete the calculation in step 101 is described below through a specific example:

[0119] The core idea of ​​the direct matching method is to collect functions and their parameters through string matching. For example, use Excel to complete a report for an ERP system: enter the formula =SUM(ACCT("001"), 100) in the Excel cell, the SUM function can be recognized by Excel, and the ACCT function is used to extract from the ERP system The extension function for extractin...

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

No PUM Login to view more

Abstract

The invention provides a method for collecting the function of cell formula in a spreadsheet, including the steps of: determining each calling order of function in the cell formula, and batch function and non-batch function therein; carrying out the calculation in order according to the calling order, if being non-batch function, calculating to obtain the calculated result of the function; if being batch funtion, storing the function and the parameter into a memory unit; executing in batch the collected batch funtion to obtain the corresponding executed result. The method is, in particular, suitable for calling the other database or datasheet for the function to obtain the data. The calculating speed of spreadsheet and cell is greatly improved by determining each calling order of function in the cell formula, and batch function and non-batch function therein, and directly calculating to obtain the result of the non-batch function if being non-batch function, and storing the function to carry out an optimized execution in batch if being batch funtion, without disperse repeat calling.

Description

technical field [0001] The invention relates to the field of computer data processing, in particular to a function collection method and device for an electronic data sheet. Background technique [0002] Spreadsheet: It is a calculation tool software that organizes data and information in the form of a table, such as Microsoft Excel, Lotus1-2-3, Borland Quattro Pro, LinuxGnumeric, WPS spreadsheet, Yongzhong Office, etc. [0003] A cell is the most basic unit of a spreadsheet, which can contain calculation formulas to calculate the value of this cell. The electronic data sheet can also be pre-set or provided by the secondary developer with some functional functions, which can be used in unit formulas for the convenience of users. [0004] For example, the SUM(number1, number2,...) function is generally used for data aggregation; the AVERAGE(number1, number2,...) function is generally used to return the average value (arithmetic mean) of the parameters. The parameters (numbe...

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
no application Login to view more
Patent Type & Authority Applications(China)
IPC IPC(8): G06F17/24G06F17/15
Inventor 乔昕明
Owner KINGDEE SOFTWARE(CHINA) CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap