Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Online excel formula analysis method

A formula parsing and formula technology, applied in the field of formula parsing, can solve the problems of unable to meet the needs of informatization, relying on language grammar, unable to meet the needs of informatization, etc.

Inactive Publication Date: 2017-05-10
中科曙光信息技术无锡有限公司
View PDF2 Cites 1 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0002] In the current trend of informatization, traditional excel tools sometimes cannot meet the needs of informatization. For example, in some dynamic data scenarios, data source links and third-party system access to excel cannot meet the needs of informatization. This drawback is Due to the limitations of the excel tool itself
At present, in terms of formula parsing language, most of them rely on the grammar of the language itself, and do not provide direct support for the commonly used excel formulas in office

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
  • Online excel formula analysis method
  • Online excel formula analysis method
  • Online excel formula analysis method

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0013] In order to make the purpose, technical solutions and advantages of the embodiments of the present invention clearer, the technical solutions in the embodiments of the present invention will be clearly and completely described below in conjunction with the drawings in the embodiments of the present invention. Obviously, the described embodiments It is a part of the embodiments of the present invention, rather than all embodiments; based on the embodiments of the present invention, all other embodiments obtained by those of ordinary skill in the art without creative work, all belong to the protection scope of the present invention .

[0014] figure 1 It is a schematic flow chart of an online excel formula analysis method provided in Embodiment 1 of the present invention, as figure 1 As shown, an online excel formula analysis method includes the following steps:

[0015] S101. Make a javascript function library with the same name as excel, as shown in Table 1.

[0016]...

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 relates to the technical field of formula analysis, in particular to an excel formula analysis method. An online excel formula analysis method capable of dynamically analyzing a formula so that a traditional excel tool can satisfy informational requirements is provided. According to the technical scheme, the analysis method comprises the first step of making a javascript function library of which the name is as same as that of the excel; the second step of using a javascript engine to conduct pretreatment on a context space of the JS; the third step of conducting pretreatment on parameters and transmitting mappings; the fourth step of using the javascript engine to conduct treatment on a dynamically defined formula script to obtain a final result. The online excel formula analysis method is applicable to the field of formula analysis.

Description

technical field [0001] The invention relates to the technical field of formula analysis, in particular to an online excel formula analysis method. Background technique [0002] In the current trend of informatization, traditional excel tools sometimes cannot meet the needs of informatization. For example, in some dynamic data scenarios, data source links and third-party system access to excel cannot meet the needs of informatization. This drawback is Due to the limitations of the excel tool itself. At present, in terms of formula parsing language, most of them rely on the grammar of the language itself, and do not provide direct support for the excel formulas commonly used in office work. With the acceleration of informatization reform, some online excel solutions need to emerge, and the core problem should be the analysis of excel formulas. Contents of the invention [0003] Aiming at the deficiencies in the related technologies, the technical problem to be solved by th...

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
IPC IPC(8): G06F17/22G06F9/44
CPCG06F8/31G06F40/12
Inventor 朱元宇
Owner 中科曙光信息技术无锡有限公司
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products