CN106502966B - EXCEL document treating method and apparatus - Google Patents
EXCEL document treating method and apparatus Download PDFInfo
- Publication number
- CN106502966B CN106502966B CN201510564341.6A CN201510564341A CN106502966B CN 106502966 B CN106502966 B CN 106502966B CN 201510564341 A CN201510564341 A CN 201510564341A CN 106502966 B CN106502966 B CN 106502966B
- Authority
- CN
- China
- Prior art keywords
- calculation expression
- excel document
- seriation
- target excel
- target
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
- 238000000034 method Methods 0.000 title claims abstract description 26
- 230000014509 gene expression Effects 0.000 claims abstract description 182
- 238000004364 calculation method Methods 0.000 claims abstract description 181
- 230000009467 reduction Effects 0.000 claims description 72
- 238000012545 processing Methods 0.000 claims description 24
- 238000003672 processing method Methods 0.000 claims description 6
- 241000239290 Araneae Species 0.000 claims description 3
- 238000005516 engineering process Methods 0.000 abstract description 8
- 230000008859 change Effects 0.000 description 4
- 238000010586 diagram Methods 0.000 description 4
- 238000012935 Averaging Methods 0.000 description 3
- 238000010168 coupling process Methods 0.000 description 3
- 238000005859 coupling reaction Methods 0.000 description 3
- 230000006870 function Effects 0.000 description 3
- 238000004458 analytical method Methods 0.000 description 2
- 238000004891 communication Methods 0.000 description 2
- 230000008878 coupling Effects 0.000 description 2
- 238000009472 formulation Methods 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 230000008569 process Effects 0.000 description 2
- 230000000007 visual effect Effects 0.000 description 2
- 238000013507 mapping Methods 0.000 description 1
- 238000005192 partition Methods 0.000 description 1
- 238000000926 separation method Methods 0.000 description 1
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Document Processing Apparatus (AREA)
Abstract
This application discloses a kind of EXCEL document treating method and apparatus.Wherein, this method comprises: obtaining target EXCEL document；Search the calculation expression in the cell of target EXCEL document；It calls the calculation expression found to be calculated, obtains calculated value；And pass through the calculation expression in calculated value replacement unit lattice.Present application addresses open the slow technical problem of EXCEL document comprising a large amount of calculation formula in the related technology.
Description
Technical field
This application involves data processing fields, in particular to a kind of EXCEL document treating method and apparatus.
Background technique
A large amount of calculation formula are generally comprised in EXCEl document, for example, summing, averaging to column a few in EXCEl table
Operation.When including a large amount of calculation formula in EXCEl document, each user can calculate when opening EXCEL document,
The speed for opening EXCEL can greatly be slowed down when there are many calculative calculation formula, cause bad user experience.
For the slow problem of EXCEL document comprising a large amount of calculation formula is opened in the related technology, at present not yet
It puts forward effective solutions.
Summary of the invention
The embodiment of the present application provides a kind of EXCEL document treating method and apparatus, at least to solve to beat in the related technology
Open the slow technical problem of EXCEL document comprising a large amount of calculation formula.
According to the one aspect of the embodiment of the present application, a kind of EXCEL document processing method is provided, comprising: obtain target
EXCEL document；Search the calculation expression in the cell of target EXCEL document；The calculation expression found is called to carry out
It calculates, obtains calculated value；And pass through the calculation expression in calculated value replacement unit lattice.
Further, before through the calculation expression in calculated value replacement unit lattice, this method further include: obtain each
Location information of a calculation expression in target EXCEL document；Seriation processing is carried out to each calculation expression, is obtained each
The seriation value of calculation expression；And seriation value and the corresponding location information of each calculation expression of storage.
Further, after through the calculation expression in calculated value replacement unit lattice, this method further include: receiving
To when the first reduction instruction, the corresponding seriation value of whole calculation expression in target EXCEL document is obtained, multiple series are obtained
Change value, wherein the first reduction instruction is used to indicate whole calculation expressions in reduction target EXCEL document；To multiple series
Change value carries out reduction treatment, obtains corresponding multiple calculation expressions；And according to multiple calculation expressions in target EXCEL text
The location information of shelves uses corresponding calculated value in multiple calculation expressions replacement target EXCEL document.
Further, after through the calculation expression in calculated value replacement unit lattice, this method further include: receiving
To when the second reduction instruction, the corresponding system of calculation expression in designating unit lattice is obtained according to the location information of designating unit lattice
Column value, wherein the second reduction instruction is used to indicate the calculation expression in reduction target EXCEL document in designating unit lattice；
Reduction treatment is carried out to seriation value, obtains corresponding calculation expression；And designating unit lattice are replaced by calculation expression
In calculated value.
Further, searching the calculation expression in the cell of target EXCEL document includes: to traverse mesh according to row or column
The cell of EXCEL document is marked to search the calculation expression in target EXCEL document in cell.
According to the another aspect of the embodiment of the present application, a kind of EXCEL document processing unit is additionally provided, comprising: first obtains
Unit is taken, for obtaining target EXCEL document；Searching unit, the computational chart in cell for searching target EXCEL document
Up to formula；Call unit obtains calculated value for calling the calculation expression found to be calculated；And first replacement unit,
For passing through the calculation expression in calculated value replacement unit lattice.
Further, the device further include: second acquisition unit, for obtaining each calculation expression in target EXCEL
The location information of document；Seriation processing unit obtains each calculating for carrying out seriation processing to each calculation expression
The seriation value of expression formula；And storage unit, for storing the seriation value and corresponding position letter of each calculation expression
Breath.
Further, the device further include: third acquiring unit, for obtaining mesh when receiving the first reduction instruction
The corresponding seriation value of whole calculation expression in EXCEL document is marked, multiple seriation values are obtained, wherein the first reduction instruction
The whole calculation expressions being used to indicate in reduction target EXCEL document；First reduction treatment unit, for multiple seriations
Value carries out reduction treatment, obtains corresponding multiple calculation expressions；And second replacement unit, for according to multiple calculation expressions
Formula uses corresponding calculating in multiple calculation expressions replacement target EXCEL document in the location information of target EXCEL document
Value.
Further, the device further include: the 4th acquiring unit, for receive the second reduction instruction when, according to finger
Determine the corresponding seriation value of calculation expression in the location information acquisition designating unit lattice of cell, wherein the second reduction refers to
Enable the calculation expression being used to indicate in reduction target EXCEL document in designating unit lattice；Second reduction treatment unit, for pair
Seriation value carries out reduction treatment, obtains corresponding calculation expression；And third replacement unit, for passing through calculation expression
Restore the calculation expression in designating unit lattice.
Further, searching unit includes: spider module, for the unit according to row or column traversal target EXCEL document
Lattice are to search the calculation expression in target EXCEL document in cell.
In the embodiment of the present application, using acquisition target EXCEL document；In the cell for searching target EXCEL document
Calculation expression；It calls the calculation expression found to be calculated, obtains calculated value；And pass through calculated value replacement unit lattice
In calculation expression.The application replaces the cell of target EXCEL document by the calculated value that calculation expression is calculated
The calculation expression of middle storage increases when so as to avoid opening target EXCEL document because of the calculating of calculation expression
Load time effectively increases the speed for opening the EXCEL document comprising a large amount of calculation formula, and then solves in the related technology
Open the slow technical problem of EXCEL document comprising a large amount of calculation formula.
Detailed description of the invention
The drawings described herein are used to provide a further understanding of the present application, constitutes part of this application, this Shen
Illustrative embodiments and their description please are not constituted an undue limitation on the present application for explaining the application.In the accompanying drawings:
Fig. 1 is the flow chart according to the EXCEL document processing method of the embodiment of the present application；
Fig. 2 is the schematic diagram according to the EXCEL document before the replacement of the calculation expression of the embodiment of the present application；
Fig. 3 is the schematic diagram according to the replaced EXCEL document of calculation expression of the embodiment of the present application；And
Fig. 4 is the schematic diagram according to the EXCEL document processing unit of the embodiment of the present application.
Specific embodiment
In order to make those skilled in the art more fully understand application scheme, below in conjunction in the embodiment of the present application
Attached drawing, the technical scheme in the embodiment of the application is clearly and completely described, it is clear that described embodiment is only
The embodiment of the application a part, instead of all the embodiments.Based on the embodiment in the application, ordinary skill people
Member's every other embodiment obtained without making creative work, all should belong to the model of the application protection
It encloses.
It should be noted that the description and claims of this application and term " first " in above-mentioned attached drawing, "
Two " etc. be to be used to distinguish similar objects, without being used to describe a particular order or precedence order.It should be understood that using in this way
Data be interchangeable under appropriate circumstances, so as to embodiments herein described herein can in addition to illustrating herein or
Sequence other than those of description is implemented.In addition, term " includes " and " having " and their any deformation, it is intended that cover
Cover it is non-exclusive include, for example, the process, method, system, product or equipment for containing a series of steps or units are not necessarily limited to
Step or unit those of is clearly listed, but may include be not clearly listed or for these process, methods, product
Or other step or units that equipment is intrinsic.
According to the embodiment of the present application, a kind of EXCEL document processing method is provided, it should be noted that in the stream of attached drawing
The step of journey illustrates can execute in a computer system such as a set of computer executable instructions, although also, flowing
Logical order is shown in journey figure, but in some cases, it can be to be different from shown or described by sequence execution herein
The step of.
Fig. 1 is according to the flow chart of the EXCEL document processing method of the embodiment of the present application, as shown in Figure 1, this method includes
Following steps:
Step S102 obtains target EXCEL document.
The target EXCEL document of the embodiment of the present application can be EXCEL report.For example, in existing data processing system
In function usually all comprising export EXCEL report, user can be by checking that EXCEL report analyzes data
Meet the needs of user carries out variety analysis to data, generally comprises a large amount of calculation expression in existing EXCEL report
Formula, for example, expression formula of summing, expression formula of averaging etc..
Step S104 searches the calculation expression in the cell of target EXCEL document.
In general, a target EXCEL document includes multiple tables, a table includes multiple row and columns, and each ranks are handed over
Crunode, that is, cell.Specifically, the embodiment of the present application can be by calling existing class libraries to fast implement target EXCEL document
The lookup of calculation expression in cell, for example, VBA (answer by Visual Basic for Applications, visual basis
With language) class libraries, it can also be searching calculation expression by way of traversing the cell of target EXCEL document.Optionally, it looks into
The calculation expression looked in the cell of target EXCEL document includes: the cell according to row or column traversal target EXCEL document
To search the calculation expression in target EXCEL document in cell.
The embodiment of the present application searches target EXCEL text by traversing the cell of target EXCEL document according to row or column
Calculation expression in shelves in cell, while convenient for obtaining calculation expression in the location information of target EXCEL document.
Step S106 calls the calculation expression found to be calculated, obtains calculated value.
Step S108 passes through the calculation expression in calculated value replacement unit lattice.
Specifically, as shown in Fig. 2, the data stored in cell B6 in target EXCEL document are calculation expression SUM
(B1:B5), wherein the calculated value that calculation expression SUM (B1:B5) is calculated is 38.The embodiment of the present application passes through calculated value
Calculation expression in replacement unit lattice, for example, calculation expression SUM (B1:B5) in cell B6 is replaced with into calculated value 38,
As shown in figure 3, the data stored in cell B6 in target EXCEL document replace with calculated value 38.
It should be noted that the embodiment of the present application executes above-mentioned steps, example before user opens target EXCEL document
Such as, above-mentioned steps are executed when exporting target EXCEL document, and the target EXCEL document that exports that treated is opened for user and looked into
It sees.
The embodiment of the present application is replaced in the cell of target EXCEL document by the calculated value that calculation expression is calculated
The calculation expression of storage increases because of the calculating of calculation expression when so as to avoid opening target EXCEL document and adds
The time is carried, the speed for opening the EXCEL document comprising a large amount of calculation formula is effectively increased, solves and opens packet in the related technology
The slow problem of EXCEL table containing a large amount of calculation formula.
Preferably, for the ease of the calculation expression in reduction target EXCEL document, passing through calculated value replacement unit lattice
In calculation expression before, this method further include: obtain each calculation expression in the location information of target EXCEL document；
Seriation processing is carried out to each calculation expression, obtains the seriation value of each calculation expression；And each calculating of storage
The seriation value of expression formula and corresponding location information.
Specifically, calculation expression the location information of target EXCEL document include table locating for calculation expression with
And the information such as locating cell, for example, the corresponding location information of calculation expression SUM (B1:B5) in Fig. 2 be (table 1,
B6).In order to avoid the calculating of calculation expression, the embodiment of the present application carries out seriation processing to calculation expression, obtains series
Change value obtains cryptographic Hash for example, carrying out Hash operation to calculation expression.By converting seriation value for calculation expression,
It can be calculated to avoid calculation expression when target EXCEL document loads.It is alternatively possible to by target EXCEL document
The seriation value and location information of each calculation expression are stored in target EXCEL document one and open in newly-built table, and in the table
Mapping relations between the middle seriation value for establishing each calculation expression and corresponding location information are convenient for subsequent lookup.
Preferably, after through the calculation expression in calculated value replacement unit lattice, this method further include: receiving
When the first reduction instruction, the corresponding seriation value of whole calculation expression in target EXCEL document is obtained, multiple seriations are obtained
Value, wherein the first reduction instruction is used to indicate whole calculation expressions in reduction target EXCEL document；To multiple seriations
Value carries out reduction treatment, obtains corresponding multiple calculation expressions；And according to multiple calculation expressions in target EXCEL document
Location information, use multiple calculation expressions replacement target EXCEL document in corresponding calculated value.
Specifically, reduction menu bar can be set in target EXCEL document in advance, for example, by VBA class libraries in target
Setting reduction menu bar in EXCEL document, can be set multiple sub-menu bars in reduction menu bar, for example, the whole meters of reduction
The sub-menu bars such as operator expression formula and/or reduction designating unit lattice calculation expression.After user opens target EXCEL document,
When re-starting calculating if necessary to restore the calculation expression in target EXCEL document, menu bar can be restored by operation
It carries out.
For example, reduction can be clicked all when user needs to restore calculation expressions whole in target EXCEL document
Calculation expression sub-menu bar (receives the first reduction instruction), at this point, obtaining whole computational charts in target EXCEL document
Up to the corresponding seriation value of formula, and reduction treatment is carried out, obtains corresponding calculation expression, and according to each calculation expression
Location information finds each calculation expression cell locating for target EXCEL document, and is replaced by the calculation expression
The value in the cell is changed, realizes the reduction of whole calculation expressions in target EXCEL document.
Preferably, after through the calculation expression in calculated value replacement unit lattice, this method further include: receiving
When the second reduction instruction, the corresponding series of calculation expression in designating unit lattice is obtained according to the location information of designating unit lattice
Change value, wherein the second reduction instruction is used to indicate the calculation expression in reduction target EXCEL document in designating unit lattice；It is right
Seriation value carries out reduction treatment, obtains corresponding calculation expression；And it is replaced in designating unit lattice by calculation expression
Calculated value.
Specifically, when user needs to restore the calculation expression in target EXCEL document in designating unit lattice, Ke Yidian
Corresponding cell (receiving the second reduction instruction) is hit, and obtains the location information of the designating unit lattice, and this is specified
The location information of the location information of cell and previously stored calculation expression is matched, to search the designating unit lattice
The corresponding seriation value of calculation expression, and reduction treatment is carried out to the seriation value and obtains corresponding calculation expression, and is led to
The value for crossing calculation expression replacement designating unit lattice, realizes the reduction of the calculation expression in designating unit lattice.
It should be noted that restoring the operation of calculation expression whole in target EXCEL document in the embodiment of the present application
Operation with the calculation expression in reduction target EXCEL document in designating unit lattice be user open target EXCEL document it
The operation executed afterwards.
The embodiment of the present application also provides a kind of EXCEL document processing units, it should be noted that the embodiment of the present application
EXCEL document processing unit can be used for executing provided by the embodiment of the present application for EXCEL document processing method.It is right below
EXCEL document processing unit provided by the embodiments of the present application is introduced.
Fig. 4 is the schematic diagram according to the EXCEL document processing unit of the embodiment of the present application.As shown in figure 4, the device packet
It includes: first acquisition unit 40, searching unit 42, call unit 44 and the first replacement unit 46.
First acquisition unit 40, for obtaining target EXCEL document.
The target EXCEL document of the embodiment of the present application can be EXCEL report.For example, in existing data processing system
In function usually all comprising export EXCEL report, user can be by checking that EXCEL report analyzes data
Meet the needs of user carries out variety analysis to data, generally comprises a large amount of calculation expression in existing EXCEL report
Formula, for example, expression formula of summing, expression formula of averaging etc..
Searching unit 42, the calculation expression in cell for searching target EXCEL document.
One target EXCEL document may include multiple tables, and a table may include multiple row and columns, each ranks
Crosspoint, that is, cell.Specifically, the embodiment of the present application can be by calling existing class libraries to fast implement target EXCEL document
Cell in the lookup of calculation expression can also pass through the cell of traversal target EXCEL document for example, VBA class libraries
Mode search calculation expression.Optionally, searching unit 42 includes: spider module, for traversing target according to row or column
The cell of EXCEL document is to search the calculation expression in target EXCEL document in cell.
The embodiment of the present application searches target EXCEL text by traversing the cell of target EXCEL document according to row or column
Calculation expression in shelves in cell, while convenient for obtaining calculation expression in the location information of target EXCEL document.
Call unit 44 obtains calculated value for calling the calculation expression found to be calculated.
First replacement unit 46, for passing through the calculation expression in calculated value replacement unit lattice.
It should be noted that the EXCEL document processing unit of the embodiment of the present application user open target EXCEL document it
It is preceding that processing executed to target EXCEL document, and the EXCEL document that exports that treated is opened for user and is checked.
The embodiment of the present application obtains target EXCEL document by first acquisition unit 40；Searching unit 42 searches target
Calculation expression in the cell of EXCEL document；Call unit 44 calls the calculation expression found to be calculated, and obtains
Calculated value；And first replacement unit 46 pass through the calculation expression in calculated value replacement unit lattice.Pass through calculation expression meter
The calculation expression stored in the cell of obtained calculated value replacement target EXCEL document, so as to avoid opening mesh
Increase the load time because of the calculating of calculation expression when marking EXCEL document, it is public comprising largely calculating to effectively increase opening
The speed of the EXCEL document of formula, so solve in the related technology open comprising a large amount of calculation formula EXCEL document speed compared with
Slow technical problem.
Preferably, the device further include: second acquisition unit, for obtaining each calculation expression in target EXCEL text
The location information of shelves；Seriation processing unit obtains each computational chart for carrying out seriation processing to each calculation expression
Up to the seriation value of formula；And storage unit, for store each calculation expression seriation value and corresponding location information.
Preferably, the device further include: third acquiring unit, for obtaining target when receiving the first reduction instruction
The corresponding seriation value of whole calculation expression, obtains multiple seriation values in EXCEL document, wherein the first reduction instruction is used
Whole calculation expressions in instruction reduction target EXCEL document；First reduction treatment unit, for multiple seriation values
Reduction treatment is carried out, corresponding multiple calculation expressions are obtained；And second replacement unit, for according to multiple calculation expressions
In the location information of target EXCEL document, corresponding calculated value in multiple calculation expressions replacement target EXCEL document is used.
Preferably, the device further include: the 4th acquiring unit, for when receiving the second reduction instruction, according to specified
The location information of cell obtains the corresponding seriation value of calculation expression in designating unit lattice, wherein the second reduction instruction
It is used to indicate the calculation expression in reduction target EXCEL document in designating unit lattice；Second reduction treatment unit, for being
Column value carries out reduction treatment, obtains corresponding calculation expression；And third replacement unit, for passing through calculation expression also
Calculation expression in former designating unit lattice.
Above-mentioned the embodiment of the present application serial number is for illustration only, does not represent the advantages or disadvantages of the embodiments.
In above-described embodiment of the application, all emphasizes particularly on different fields to the description of each embodiment, do not have in some embodiment
The part of detailed description, reference can be made to the related descriptions of other embodiments.
In several embodiments provided herein, it should be understood that disclosed technology contents can pass through others
Mode is realized.Wherein, the apparatus embodiments described above are merely exemplary, such as the division of the unit, Ke Yiwei
A kind of logical function partition, there may be another division manner in actual implementation, for example, multiple units or components can combine or
Person is desirably integrated into another system, or some features can be ignored or not executed.Another point, shown or discussed is mutual
Between coupling, direct-coupling or communication connection can be through some interfaces, the INDIRECT COUPLING or communication link of unit or module
It connects, can be electrical or other forms.
The unit as illustrated by the separation member may or may not be physically separated, aobvious as unit
The component shown may or may not be physical unit, it can and it is in one place, or may be distributed over multiple
On unit.It can some or all of the units may be selected to achieve the purpose of the solution of this embodiment according to the actual needs.
It, can also be in addition, each functional unit in each embodiment of the application can integrate in one processing unit
It is that each unit physically exists alone, can also be integrated in one unit with two or more units.Above-mentioned integrated list
Member both can take the form of hardware realization, can also realize in the form of software functional units.
If the integrated unit is realized in the form of SFU software functional unit and sells or use as independent product
When, it can store in a computer readable storage medium.Based on this understanding, the technical solution of the application is substantially
The all or part of the part that contributes to existing technology or the technical solution can be in the form of software products in other words
It embodies, which is stored in a storage medium, including some instructions are used so that a computer
Equipment (can for personal computer, server or network equipment etc.) execute each embodiment the method for the application whole or
Part steps.And storage medium above-mentioned includes: that USB flash disk, read-only memory (ROM, Read-Only Memory), arbitrary access are deposited
Reservoir (RAM, Random Access Memory), mobile hard disk, magnetic or disk etc. be various to can store program code
Medium.
The above is only the preferred embodiment of the application, it is noted that for the ordinary skill people of the art
For member, under the premise of not departing from the application principle, several improvements and modifications can also be made, these improvements and modifications are also answered
It is considered as the protection scope of the application.
Claims (8)
1. a kind of EXCEL document processing method characterized by comprising
Obtain target EXCEL document；
Search the calculation expression in the cell of the target EXCEL document；
It calls the calculation expression found to be calculated, obtains calculated value；And
The calculation expression in the cell is replaced by the calculated value,
Before replacing the calculation expression in the cell by the calculated value, the method also includes: it obtains each
Location information of the calculation expression in the target EXCEL document；Each calculation expression is carried out at seriation
Reason, obtains the seriation value of each calculation expression；And the seriation value of each calculation expression of storage and corresponding
Location information,
Wherein, above-mentioned steps execute before user opens target EXCEL；
Also, the method also includes: setting reduction menu bar, the reduction menu in the target EXCEL document in advance
Column is used to restore the calculation expression in the target EXCEL document.
2. the method according to claim 1, wherein replacing the meter in the cell by the calculated value
After operator expression formula, the method also includes:
When receiving the first reduction instruction, the corresponding seriation of whole calculation expression in the target EXCEL document is obtained
Value, obtains multiple seriation values, wherein the first reduction instruction is used to indicate complete in the reduction target EXCEL document
Portion's calculation expression；
Reduction treatment is carried out to the multiple seriation value, obtains corresponding multiple calculation expressions；And
According to the multiple calculation expression in the location information of the target EXCEL document, the multiple calculation expression is used
Formula replaces corresponding calculated value in the target EXCEL document.
3. the method according to claim 1, wherein replacing the meter in the cell by the calculated value
After operator expression formula, the method also includes:
When receiving the second reduction instruction, the calculating in the designating unit lattice is obtained according to the location information of designating unit lattice
The corresponding seriation value of expression formula, wherein the second reduction instruction, which is used to indicate in the reduction target EXCEL document, specifies
Calculation expression in cell；
Reduction treatment is carried out to the seriation value, obtains corresponding calculation expression；And
The calculated value in the designating unit lattice is replaced by the calculation expression.
4. the method according to claim 1, wherein searching the meter in the cell of the target EXCEL document
Operator expression formula includes: to traverse the cell of the target EXCEL document according to row or column to search in the target EXCEL document
Calculation expression in cell.
5. a kind of EXCEL document processing unit, which is characterized in that be used for before user opens target EXCEL document to target
EXCEL document executes processing, and the EXCEL document processing unit includes:
First acquisition unit, for obtaining target EXCEL document；
Searching unit, the calculation expression in cell for searching the target EXCEL document；
Call unit obtains calculated value for calling the calculation expression found to be calculated；And
First replacement unit, for replacing the calculation expression in the cell by the calculated value,
Described device further include: second acquisition unit, for obtaining each calculation expression in the target EXCEL document
Location information；Seriation processing unit obtains each calculating for carrying out seriation processing to each calculation expression
The seriation value of expression formula；And storage unit, for store each calculation expression seriation value and corresponding position
Confidence breath,
Wherein, described device is also used to setting reduction menu bar, the reduction menu bar in the target EXCEL document in advance
For restoring the calculation expression in the target EXCEL document.
6. device according to claim 5, which is characterized in that described device further include:
Third acquiring unit, for when receiving the first reduction instruction, obtaining whole computational charts in the target EXCEL document
Up to the corresponding seriation value of formula, multiple seriation values are obtained, wherein the first reduction instruction is used to indicate the reduction target
Whole calculation expressions in EXCEL document；
First reduction treatment unit obtains corresponding multiple computational charts for carrying out reduction treatment to the multiple seriation value
Up to formula；And
Second replacement unit, for, in the location information of the target EXCEL document, being used according to the multiple calculation expression
The multiple calculation expression replaces corresponding calculated value in the target EXCEL document.
7. device according to claim 5, which is characterized in that described device further include:
4th acquiring unit, for receive the second reduction instruction when, according to the location information of designating unit lattice obtain described in
The corresponding seriation value of calculation expression in designating unit lattice, wherein the second reduction instruction is used to indicate described in reduction
Calculation expression in target EXCEL document in designating unit lattice；
Second reduction treatment unit obtains corresponding calculation expression for carrying out reduction treatment to the seriation value；And
Third replacement unit, for restoring the calculation expression in the designating unit lattice by the calculation expression.
8. device according to claim 5, which is characterized in that the searching unit includes: spider module, for according to row
Or column traverse the cell of the target EXCEL document to search the calculation expression in the target EXCEL document in cell
Formula.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510564341.6A CN106502966B (en) | 2015-09-07 | 2015-09-07 | EXCEL document treating method and apparatus |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510564341.6A CN106502966B (en) | 2015-09-07 | 2015-09-07 | EXCEL document treating method and apparatus |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN106502966A CN106502966A (en) | 2017-03-15 |
| CN106502966B true CN106502966B (en) | 2019-08-20 |
Family
ID=58287040
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201510564341.6A Active CN106502966B (en) | 2015-09-07 | 2015-09-07 | EXCEL document treating method and apparatus |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106502966B (en) |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102722682A (en) * | 2012-04-28 | 2012-10-10 | 飞天诚信科技股份有限公司 | Protection method for Excel document |
| CN102782675A (en) * | 2009-10-09 | 2012-11-14 | 微软公司 | Data analysis expression |
-
2015
- 2015-09-07 CN CN201510564341.6A patent/CN106502966B/en active Active
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102782675A (en) * | 2009-10-09 | 2012-11-14 | 微软公司 | Data analysis expression |
| CN102722682A (en) * | 2012-04-28 | 2012-10-10 | 飞天诚信科技股份有限公司 | Protection method for Excel document |
Non-Patent Citations (1)
| Title |
|---|
| 使用VBA程序快速删除单元格中的公式的方法;Office办公助手;《http://www.officezhushou.com/excel2013/4489.html》;20150505;1-4 |
Also Published As
| Publication number | Publication date |
|---|---|
| CN106502966A (en) | 2017-03-15 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| RU2607621C2 (en) | Method, system and computer-readable data medium for grouping in social networks | |
| CN110166455A (en) | A kind of multi-operator platform data adaptation method and relevant device | |
| CN106815226A (en) | Text matching technique and device | |
| CN104424240B (en) | Multilist correlating method, main service node, calculate node and system | |
| CN109118353A (en) | The data processing method and device of air control model | |
| CN104346443B (en) | Network text processing method and processing device | |
| CN110276060A (en) | The method and device of data processing | |
| CN110378124A (en) | A kind of network security threats analysis method and system based on LDA machine learning | |
| CN103077049B (en) | Intelligence desktop navigation bar update method and system | |
| CN109783494A (en) | Date storage method and relevant apparatus | |
| JPWO2018025707A1 (en) | Table meaning estimation system, method and program | |
| CN106033444B (en) | Text content clustering method and device | |
| CN104182546B (en) | The data query method and device of database | |
| CN106502966B (en) | EXCEL document treating method and apparatus | |
| CN104268293B (en) | The index treating method and apparatus that can not add up in database | |
| CN106257507A (en) | The methods of risk assessment of user behavior and device | |
| CN109086289A (en) | A kind of media data processing method, client, medium and equipment | |
| CN109992659B (en) | Method and device for sorting text | |
| CN105160547A (en) | Cross-network identification method and system based on stable contact index | |
| CN114841371B (en) | Feature-based binning processing method, device, equipment, and medium | |
| CN105589896B (en) | Data mining method and device | |
| CN106502972B (en) | The methods of exhibiting and device of data mode | |
| CN103823891B (en) | Data processing method and device for computer historical behavior analysis | |
| CN105447018B (en) | Verify the method and device of Web page classifying model | |
| CN110209656A (en) | Data processing method and device |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| CB02 | Change of applicant information |
Address after: 100083 No. 401, 4th Floor, Haitai Building, 229 North Fourth Ring Road, Haidian District, Beijing Applicant after: Beijing Guoshuang Technology Co.,Ltd. Address before: 100086 Cuigong Hotel, 76 Zhichun Road, Shuangyushu District, Haidian District, Beijing Applicant before: Beijing Guoshuang Technology Co.,Ltd. |
|
| CB02 | Change of applicant information | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |