EXCEL TABLE-BASED CALCULATION METHOD AND APPARATUS, DEVICE, AND STORAGE MEDIUM

WIPO Patent Application WO/2019/119624

A1

An Excel table-based calculation method and apparatus, a device, and a computer readable storage medium, the method comprising: upon receipt of a calculation instruction, acquiring a target calculation formula, and splitting the target calculation formula into several sub-formulas (S10); reading the profile of an Excel table, locating Java objects of the sub-formulas in the profile according to a preset MAP set class, and acquiring the values of the Java objects (S20); and invoking Java methods corresponding to the sub-formulas according to a preset correlation between formula functions of Excel macros and Java methods, and substituting the values of the Java objects into the Java methods to obtain a calculation result of the target calculation formula, the Java methods being used for representing operation rules based on the Java objects (S30). The method can reduce the consumption of memory during a calculation process of an Excel table while improving calculation efficiency.

JP2020119150	SYSTEM MANAGEMENT SYSTEM AND SYSTEM MANAGEMENT METHOD
WO/2014/176310	CONTROLLING TASKS PERFORMED BY A COMPUTING SYSTEM
JPH0442334	FILE MANAGING SYSTEM FOR INFORMATION PROCESSOR

CHU BIN (CN)

PCT/CN2018/075011

June 27, 2019

February 02, 2018

Click for automatic bibliography generation  

PING AN TECH SHENZHEN CO LTD (CN)

G06F9/44

CN103617045A	2014-03-05
CN103049280A	2013-04-17
CN104090780A	2014-10-08
US7730025B1	2010-06-01

CENFO INTELLECTUAL PROPERTY AGENCY (CN)

View/Download PDF      PDF Help

Previous Patent: RAILWAY WAGON AND MONITORING SYSTEM THEREFOR

Next Patent: ELECTRIC TOOTHBRUSH WITH BRUSH HEAD PRESSURE SENSOR