CN110457021A - Achievement data processing method, device and computer readable storage medium - Google Patents
Achievement data processing method, device and computer readable storage medium Download PDFInfo
- Publication number
- CN110457021A CN110457021A CN201910632930.1A CN201910632930A CN110457021A CN 110457021 A CN110457021 A CN 110457021A CN 201910632930 A CN201910632930 A CN 201910632930A CN 110457021 A CN110457021 A CN 110457021A
- Authority
- CN
- China
- Prior art keywords
- index
- indicator template
- template
- indicator
- value
- 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.)
- Granted
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F8/00—Arrangements for software engineering
- G06F8/30—Creation or generation of source code
Abstract
The invention discloses a kind of achievement data processing methods, this method comprises: obtaining indicator template；The indicator template is parsed by POI technology, obtains the index parameter that the indicator template includes, the corresponding guideline code of index parameter that generation unit lattice coordinate and the indicator template include；Obtain the corresponding index value file of the indicator template；The corresponding index value of the guideline code is matched according to the cell coordinate and the guideline code, obtains and stores the corresponding index value of index parameter described in the indicator template.The present invention also proposes a kind of achievement data processing unit and a kind of computer readable storage medium.The processing speed of achievement data can be improved in the present invention, promotes development efficiency.
Description
Technical field
The present invention relates to field of computer technology more particularly to a kind of achievement data processing method, device and computer can
Read storage medium.
Background technique
In the process of development, business demand is usually provided to developer by business personnel, by developer according to industry
The business demand that business personnel provide is developed.Currently, being supplied to the warp such as some products of developer or sale in business personnel
It seeks after relevant indication information (such as turnover index), needs to be matched again manually by developer according to index obtained progress
It sets, i.e. typing again manually, which increase the workloads of developer, reduce development efficiency.
Summary of the invention
The present invention provides a kind of achievement data processing method, device and computer readable storage medium, main purpose and exists
In the processing speed for improving achievement data, development efficiency is promoted.
To achieve the above object, the present invention also provides a kind of achievement data processing methods, this method comprises:
Obtain indicator template；
The indicator template is parsed by POI technology, obtains the index parameter that the indicator template includes, generation unit lattice
The corresponding guideline code of index parameter that coordinate and the indicator template include；
Obtain the corresponding index value file of the indicator template；
The corresponding index value of the guideline code is matched according to the cell coordinate and the guideline code, is obtained simultaneously
Store the corresponding index value of index parameter described in the indicator template.
Optionally, state and the indicator template parsed by POI technology, obtain index parameter that the indicator template includes it
Afterwards, the method also includes:
Judge whether the indicator template is preset standard module, comprising:
Judge whether the Index module includes legend module, if so, judging whether the Index module includes the figure
The explanation of example module；And
Judge whether the indicator template includes formula module；And
Judge whether the index that the indicator template includes is pre-set level；
If the indicator template does not include the explanation of the legend or the indicator template does not include formula module, or
The index that indicator template described in person includes is not the pre-set level, and determining the indicator template not is the preset standard mould
Plate sends indicator template abnormity early warning；
If the indicator template includes the explanation of the legend, and the indicator template includes formula module, and institute
Stating the index that indicator template includes is the pre-set level, determines that the indicator template is the preset standard template, executes institute
State the operation for the corresponding guideline code of index parameter that generation unit lattice coordinate and the indicator template include.
Optionally, the acquisition indicator template includes:
It detects whether to receive the mail that designated user sends；
If receiving the mail of designated user's transmission, whether the attachment for judging the mail includes preset name and presets
The file destination of format；
If the attachment of the mail includes the file destination of preset name and preset format, determine that the file destination is
The indicator template, and obtain the file destination.
Optionally, described that the corresponding index of the guideline code is matched according to the cell coordinate and the guideline code
After numerical value, the method also includes:
Verify whether the index value that the index value file includes is virtual value；
If the index value is virtual value, obtains and store the corresponding index of index parameter described in the indicator template
Numerical value；
If the index value is not virtual value, index value file abnormity prompt is sent.
Optionally, the method also includes:
When getting the instruction of index value file modification, obtains index value and modify file；
The index value modification file is parsed, index to be modified is obtained and the index to be modified is corresponding to be modified
Numerical value；
The initial value of the index to be modified in the stored indicator template is revised as the numerical value to be modified.
In addition, to achieve the above object, the present invention also provides a kind of achievement data processing unit, which includes memory
And processor, the achievement data processing routine that can be run on the processor, the index number are stored in the memory
Following steps are realized when being executed according to processing routine by the processor:
Obtain indicator template；
The indicator template is parsed by POI technology, obtains the index parameter that the indicator template includes, generation unit lattice
The corresponding guideline code of index parameter that coordinate and the indicator template include；
Obtain the corresponding index value file of the indicator template；
The corresponding index value of the guideline code is matched according to the cell coordinate and the guideline code, is obtained simultaneously
Store the corresponding index value of index parameter described in the indicator template.
Optionally, the achievement data processing routine can be executed by the processor, described by described in the parsing of POI technology
Indicator template after obtaining the index parameter that the indicator template includes, also realizes following steps:
Judge whether the indicator template is preset standard module, comprising:
Judge whether the Index module includes legend module, if so, judging whether the Index module includes the figure
The explanation of example module；And
Judge whether the indicator template includes formula module；And
Judge whether the index that the indicator template includes is pre-set level；
If the indicator template does not include the explanation of the legend or the indicator template does not include formula module, or
The index that indicator template described in person includes is not the pre-set level, and determining the indicator template not is the preset standard mould
Plate sends indicator template abnormity early warning；
If the indicator template includes the explanation of the legend, and the indicator template includes formula module, and institute
Stating the index that indicator template includes is the pre-set level, determines that the indicator template is the preset standard template, executes institute
State the operation for the corresponding guideline code of index parameter that generation unit lattice coordinate and the indicator template include.
Optionally, the acquisition indicator template includes:
It detects whether to receive the mail that designated user sends；
If receiving the mail of designated user's transmission, whether the attachment for judging the mail includes preset name and presets
The file destination of format；
If the attachment of the mail includes the file destination of preset name and preset format, determine that the file destination is
The indicator template, and obtain the file destination.
Optionally, the achievement data processing routine can be executed by the processor, described according to the cell coordinate
After index value corresponding with the guideline code matching guideline code, following steps are also realized:
Verify whether the index value that the index value file includes is virtual value；
If the index value is virtual value, obtains and store the corresponding index of index parameter described in the indicator template
Numerical value；
Optionally, the achievement data processing routine can be executed by the processor, also realization following steps:
When getting the instruction of index value file modification, obtains index value and modify file；
The index value modification file is parsed, index to be modified is obtained and the index to be modified is corresponding to be modified
Numerical value；
The initial value of the index to be modified in the stored indicator template is revised as the numerical value to be modified.
In addition, to achieve the above object, it is described computer-readable the present invention also provides a kind of computer readable storage medium
Achievement data processing routine is stored on storage medium, the achievement data processing routine can be held by one or more processor
Row, the step of to realize achievement data processing method as described above.
Achievement data processing method, device and computer readable storage medium proposed by the present invention obtain indicator template；It is logical
It crosses POI technology and parses the indicator template, obtain the index parameter that the indicator template includes, generation unit lattice coordinate and described
The corresponding guideline code of the index parameter that indicator template includes；Obtain the corresponding index value file of the indicator template；According to
The cell coordinate and the guideline code match the corresponding index value of the guideline code, obtain and store the index
The corresponding index value of index parameter described in template.Achievement data is inputted one by one without developer, realizes and mentions
The processing speed of high target data promotes the purpose of development efficiency.
Detailed description of the invention
Fig. 1 is the flow diagram for the achievement data processing method that one embodiment of the invention provides；
Fig. 2 is the schematic diagram of internal structure for the achievement data processing unit that one embodiment of the invention provides；
The module signal of index data processor in the achievement data processing unit that Fig. 3 provides for one embodiment of the invention
Figure.
The embodiments will be further described with reference to the accompanying drawings for the realization, the function and the advantages of the object of the present invention.
Specific embodiment
It should be appreciated that the specific embodiments described herein are merely illustrative of the present invention, it is not intended to limit the present invention.
The present invention provides a kind of achievement data processing method.It is the index that one embodiment of the invention provides shown in referring to Fig.1
The flow diagram of data processing method.This method can be executed by an electronic device.
In the present embodiment, achievement data processing method includes:
Step S10 obtains indicator template.
In the embodiment of the present invention, the indicator template is the file of excel format.
In a kind of alternative embodiment, the calculating side of the title of index, the meaning of index, index may include in indicator template
The information such as method.
For example, including one among profit ratio of sales, assets net profit, operating profit, sales volume, debt in indicator template
Item or many index information.
In a kind of alternative embodiment, the indicator template can be to be obtained in server.In other alternative embodiments, refer to
Mark template, which can be, to be obtained from the local storage space of user.
In an alternative embodiment of the invention, the acquisition indicator template includes:
It detects whether to receive the mail that designated user sends；
If receiving the mail of designated user's transmission, whether the attachment for judging the mail includes preset name and presets
The file destination of format；
If the attachment of the mail includes the file destination of preset name and preset format, determine that the file destination is
The indicator template, and obtain the file destination.
Wherein, designated user can be preset, such as designated user is the business personnel of certain department.
In a kind of alternative embodiment, the email address of business personnel is added in white list, when detecting new reception
To mail be white list in email address send mail when, determine receive designated user transmission mail.
The preset name can be the filename comprising preset keyword, and preset format is the format of file, for example, in advance
If format is excel format, specific preset name and preset format can need preset according to.
In the present embodiment, when receiving the mail comprising indicator template, this document is obtained simultaneously from the attachment of mail
It is parsed, the speed of indicator template file can be improved, and then improve the speed for parsing the indicator template file.
Step S20 parses the indicator template by POI technology, obtains the index parameter that the indicator template includes, raw
The corresponding guideline code of index parameter for including at cell coordinate and the indicator template.
In the present embodiment, the index parameter that each cell is included in indicator template can parse by POI technology.
Specifically, indicator template, that is, worksheet (Workbook) passes through the WorkbookFactory's in POI technology
Create (FileInputStream fis) method obtains；Each table (Sheet) in indicator template passes through in POI technology
Workbook example getSheetAt (int num) method obtain；Row (Row) in table passes through in POI technology
GetRow (int num) method of Sheet example obtains；Each unit lattice (Cell) in a line pass through the Row in POI technology
GetCell (int num) method of example obtains.
For example, obtaining the first row first row index is sales volume, the first row secondary series index is profit on sales, then generating should
The first row first row coordinate is sales volume, and the corresponding guideline code of sales volume is 001, and generating the first row secondary series coordinate is sale
Profit, the corresponding guideline code of profit on sales are 002.
Optionally, in an alternative embodiment of the invention, described that the indicator template is parsed by POI technology, described in acquisition
After the index parameter that indicator template includes, the method also includes:
Judge whether the indicator template is preset standard module, comprising:
Judge whether the Index module includes legend module, if so, judging whether the Index module includes the figure
The explanation of example module；And
Judge whether the indicator template includes formula module；And
Judge whether the index that the indicator template includes is pre-set level；
If the indicator template does not include the explanation of the legend or the indicator template does not include formula module, or
The index that indicator template described in person includes is not the pre-set level, and determining the indicator template not is the preset standard mould
Plate sends indicator template abnormity early warning；
If the indicator template includes the explanation of the legend, and the indicator template includes formula module, and institute
Stating the index that indicator template includes is the pre-set level, determines that the indicator template is the preset standard template, executes institute
State the operation for the corresponding guideline code of index parameter that generation unit lattice coordinate and the indicator template include.
The preset standard template is the indicator template of preset specification, when indicator template is not preset standard template
When, early warning is carried out, the indicator template for whether having used mistake reminded the user that, is conducive to timely find letter in development process
There is the place of mistake in breath interaction.
Wherein, formula module is for being calculated or being illustrated to the formula of index, and legend module is for the pattern to scheme
Show index.
Further, in an alternative embodiment of the invention, the method also includes:
If the indicator template is not the preset standard template, the preset standard template is obtained, and described in acquisition
The transmission user of indicator template；
Obtain the information of the transmission user of the indicator template；
Described preset is sent to the transmission user of the indicator template according to the information of the transmission user of the indicator template
Standard form.
Wherein, the transmission user of the indicator template is the user for sending the indicator template.
Acquired indicator template transmission user information can for indicator template transmission user email address or
Other instant messaging accounts of person.
In the present embodiment, when the indicator template that user uses is wrong, preset standard mould timely is sent to the user
Plate is conducive to the user and creates correct indicator template.
In an alternative embodiment of the invention, the storage path of preset standard template can also be obtained, and to indicator template
Send the storage path that user sends the preset standard template.
Step S30 obtains the corresponding index value file of the indicator template.
Specific value in the present embodiment, comprising index in indicator template in the index value file.Indicator template pair
The type for the index value file answered is identical as the file type of indicator template.
For example, if the index for including in indicator template has sales volume, profit on sales, the corresponding index number of the indicator template
Be worth includes sales volume, the specific value of profit on sales in file.
When it is implemented, the acquisition modes of the corresponding index value file of indicator template and the acquisition modes of indicator template can
With identical or not identical.
Step S40 matches the corresponding index number of the guideline code according to the cell coordinate and the guideline code
Value, obtains and stores the corresponding index value of index parameter described in the indicator template.
Through this embodiment, the corresponding index value of index parameter in indicator template can be quickly obtained automatically, be not necessarily to
User's personal identification and logging data, improve the efficiency and development efficiency of data processing.
Optionally, in an alternative embodiment of the invention, described to be matched according to the cell coordinate and the guideline code
After the corresponding index value of the guideline code, the method also includes:
Verify whether the index value that the index value file includes is virtual value；
If the index value is virtual value, obtains and store the corresponding index of index parameter described in the indicator template
Numerical value；
If the index value is not virtual value, index value file abnormity prompt is sent.
In the present embodiment, it includes: that judgement refers to that whether verify index value that the index value file includes, which be virtual value,
Whether the type for marking the corresponding index value of code is preset kind, alternatively, the corresponding index value of judge index code is big
Whether small be more than preset range, alternatively, whether the corresponding index value of judge index code is exceptional value (for example, judge index
Whether numerical value is N/A, if so, determining that the value is exceptional value).
In the present embodiment, it does not obtain when index value is insignificant values, is obtained when index value is virtual value
It takes, can be improved the validity of the index value got.
The achievement data processing method that the present embodiment proposes obtains indicator template；The index mould is parsed by POI technology
Plate obtains the index parameter that the indicator template includes, the index parameter that generation unit lattice coordinate and the indicator template include
Corresponding guideline code；Obtain the corresponding index value file of the indicator template；According to the cell coordinate and the finger
The corresponding index value of guideline code described in code matches is marked, obtain and stores index parameter described in the indicator template is corresponding
Index value.Achievement data is inputted one by one without developer, the processing speed for improving achievement data is realized, mentions
Rise the purpose of development efficiency.
In an alternative embodiment of the invention, described to obtain and store the corresponding finger of index parameter described in the indicator template
After marking numerical value, the method also includes:
When getting the instruction of index value file modification, obtains index value and modify file；
The index value modification file is parsed, index to be modified is obtained and the index to be modified is corresponding to be modified
Numerical value；
The initial value of the index to be modified in the stored indicator template is revised as the numerical value to be modified.
In the present embodiment, index value modification file can instruct the specified path for including from index value file modification
Middle acquisition.
In a kind of alternative embodiment, after analytic index numerical value modifies file, file can be modified according to index value
In include modified logo determine index to be modified and the corresponding numerical value to be modified of index to be modified, and then to index to be modified
Value modify.
Through this embodiment, it is quickly modified when the numerical value of stored index to be modified can be changed.
The present invention also provides a kind of achievement data processing units.It is the finger that one embodiment of the invention provides referring to shown in Fig. 2
Mark the schematic diagram of internal structure of data processing equipment.
In the present embodiment, achievement data processing unit 1 can be PC (Personal Computer, PC),
It can be the terminal devices such as smart phone, tablet computer, portable computer.The achievement data processing unit 1 includes at least storage
Device 11, processor 12, network interface 13 and communication bus 14.
Wherein, memory 11 include at least a type of readable storage medium storing program for executing, the readable storage medium storing program for executing include flash memory,
Hard disk, multimedia card, card-type memory (for example, SD or DX memory etc.), magnetic storage, disk, CD etc..Memory 11
It can be the internal storage unit of achievement data processing unit 1 in some embodiments, such as the achievement data processing unit 1
Hard disk.Memory 11 is also possible to the External memory equipment of index data processing equipment 1, such as index in further embodiments
The plug-in type hard disk being equipped on data processing equipment 1, intelligent memory card (Smart Media Card, SMC), secure digital
(Secure Digital, SD) card, flash card (Flash Card) etc..Further, memory 11 can also both include index
The internal storage unit of data processing equipment 1 also includes External memory equipment.Memory 11 can be not only used for storage and be installed on
Application software and Various types of data, such as the code of achievement data processing routine 01 of achievement data processing unit 1 etc. can also be used
In temporarily storing the data that has exported or will export.
Processor 12 can be in some embodiments a central processing unit (Central Processing Unit,
CPU), controller, microcontroller, microprocessor or other data processing chips, the program for being stored in run memory 11
Code or processing data, such as index of performance data processor 01 etc..
Network interface 13 optionally may include standard wireline interface and wireless interface (such as WI-FI interface), be commonly used in
Communication connection is established between the device 1 and other electronic equipments.
Communication bus 14 is for realizing the connection communication between these components.
Optionally, which can also include user interface, and user interface may include display (Display), input
Unit such as keyboard (Keyboard), optional user interface can also include standard wireline interface and wireless interface.It is optional
Ground, in some embodiments, display can be light-emitting diode display, liquid crystal display, touch-control liquid crystal display and OLED
(Organic Light-Emitting Diode, Organic Light Emitting Diode) touches device etc..Wherein, display can also be appropriate
Referred to as display screen or display unit, for being shown in the information handled in achievement data processing unit 1 and for showing visually
The user interface of change.
Fig. 2 illustrates only the achievement data processing unit 1 with component 11-14 and achievement data processing routine 01, this
Field technical staff it is understood that Fig. 2 shows structure do not constitute the restriction to achievement data processing unit 1, can be with
Including perhaps combining certain components or different component layouts than illustrating less perhaps more components.
In 1 embodiment of device shown in Fig. 2, achievement data processing routine 01 is stored in memory 11；Processor 12
Following steps are realized when executing the achievement data processing routine 01 stored in memory 11:
Obtain indicator template.
In the embodiment of the present invention, the indicator template is the file of excel format.
In a kind of alternative embodiment, the calculating side of the title of index, the meaning of index, index may include in indicator template
The information such as method.
For example, including one among profit ratio of sales, assets net profit, operating profit, sales volume, debt in indicator template
Item or many index information.
In a kind of alternative embodiment, the indicator template can be to be obtained in server.In other alternative embodiments, refer to
Mark template, which can be, to be obtained from the local storage space of user.
In an alternative embodiment of the invention, the acquisition indicator template includes:
It detects whether to receive the mail that designated user sends；
If receiving the mail of designated user's transmission, whether the attachment for judging the mail includes preset name and presets
The file destination of format；
If the attachment of the mail includes the file destination of preset name and preset format, determine that the file destination is
The indicator template, and obtain the file destination.
Wherein, designated user can be preset, such as designated user is the business personnel of certain department.
In a kind of alternative embodiment, the email address of business personnel is added in white list, when detecting new reception
To mail be white list in email address send mail when, determine receive designated user transmission mail.
The preset name can be the filename comprising preset keyword, and preset format is the format of file, for example, in advance
If format is excel format, specific preset name and preset format can need preset according to.
In the present embodiment, when receiving the mail comprising indicator template, this document is obtained simultaneously from the attachment of mail
It is parsed, the speed of indicator template file can be improved, and then improve the speed for parsing the indicator template file.
The indicator template is parsed by POI technology, obtains the index parameter that the indicator template includes, generation unit lattice
The corresponding guideline code of index parameter that coordinate and the indicator template include.
In the present embodiment, the index parameter that each cell is included in indicator template can parse by POI technology.
Specifically, indicator template, that is, worksheet (Workbook) passes through the WorkbookFactory's in POI technology
Create (FileInputStream fis) method obtains；Each table (Sheet) in indicator template passes through in POI technology
Workbook example getSheetAt (int num) method obtain；Row (Row) in table passes through in POI technology
GetRow (int num) method of Sheet example obtains；Each unit lattice (Cell) in a line pass through the Row in POI technology
GetCell (int num) method of example obtains.
For example, obtaining the first row first row index is sales volume, the first row secondary series index is profit on sales, then generating should
The first row first row coordinate is sales volume, and the corresponding guideline code of sales volume is 001, and generating the first row secondary series coordinate is sale
Profit, the corresponding guideline code of profit on sales are 002.
Optionally, in an alternative embodiment of the invention, described that the indicator template is parsed by POI technology, described in acquisition
After the index parameter that indicator template includes, the method also includes:
Judge whether the indicator template is preset standard module, comprising:
Judge whether the Index module includes legend module, if so, judging whether the Index module includes the figure
The explanation of example module；And
Judge whether the indicator template includes formula module；And
Judge whether the index that the indicator template includes is pre-set level；
If the indicator template does not include the explanation of the legend or the indicator template does not include formula module, or
The index that indicator template described in person includes is not the pre-set level, and determining the indicator template not is the preset standard mould
Plate sends indicator template abnormity early warning；
If the indicator template includes the explanation of the legend, and the indicator template includes formula module, and institute
Stating the index that indicator template includes is the pre-set level, determines that the indicator template is the preset standard template, executes institute
State the operation for the corresponding guideline code of index parameter that generation unit lattice coordinate and the indicator template include.
The preset standard template is the indicator template of preset specification, when indicator template is not preset standard template
When, early warning is carried out, the indicator template for whether having used mistake reminded the user that, is conducive to timely find letter in development process
There is the place of mistake in breath interaction.
Wherein, formula module is for being calculated or being illustrated to the formula of index, and legend module is for the pattern to scheme
Show index.
Further, in an alternative embodiment of the invention, the method also includes:
If the indicator template is not the preset standard template, the preset standard template is obtained, and described in acquisition
The transmission user of indicator template；
Obtain the information of the transmission user of the indicator template；
Described preset is sent to the transmission user of the indicator template according to the information of the transmission user of the indicator template
Standard form.
Wherein, the transmission user of the indicator template is the user for sending the indicator template.
Acquired indicator template transmission user information can for indicator template transmission user email address or
Other instant messaging accounts of person.
In the present embodiment, when the indicator template that user uses is wrong, preset standard mould timely is sent to the user
Plate is conducive to the user and creates correct indicator template.
In an alternative embodiment of the invention, the storage path of preset standard template can also be obtained, and to indicator template
Send the storage path that user sends the preset standard template.
Obtain the corresponding index value file of the indicator template.
Specific value in the present embodiment, comprising index in indicator template in the index value file.Indicator template pair
The type for the index value file answered is identical as the file type of indicator template.
For example, if the index for including in indicator template has sales volume, profit on sales, the corresponding index number of the indicator template
Be worth includes sales volume, the specific value of profit on sales in file.
When it is implemented, the acquisition modes of the corresponding index value file of indicator template and the acquisition modes of indicator template can
With identical or not identical.
The corresponding index value of the guideline code is matched according to the cell coordinate and the guideline code, is obtained simultaneously
Store the corresponding index value of index parameter described in the indicator template.
Through this embodiment, the corresponding index value of index parameter in indicator template can be quickly obtained automatically, be not necessarily to
User's personal identification and logging data, improve the efficiency and development efficiency of data processing.
Optionally, in an alternative embodiment of the invention, described to be matched according to the cell coordinate and the guideline code
After the corresponding index value of the guideline code, the method also includes:
Verify whether the index value that the index value file includes is virtual value；
If the index value is virtual value, obtains and store the corresponding index of index parameter described in the indicator template
Numerical value；
If the index value is not virtual value, index value file abnormity prompt is sent.
In the present embodiment, it includes: that judgement refers to that whether verify index value that the index value file includes, which be virtual value,
Whether the type for marking the corresponding index value of code is preset kind, alternatively, the corresponding index value of judge index code is big
Whether small be more than preset range, alternatively, whether the corresponding index value of judge index code is exceptional value (for example, judge index
Whether numerical value is N/A, if so, determining that the value is exceptional value).
In the present embodiment, it does not obtain when index value is insignificant values, is obtained when index value is virtual value
It takes, can be improved the validity of the index value got.
The achievement data processing unit that the present embodiment proposes obtains indicator template；The index mould is parsed by POI technology
Plate obtains the index parameter that the indicator template includes, the index parameter that generation unit lattice coordinate and the indicator template include
Corresponding guideline code；Obtain the corresponding index value file of the indicator template；According to the cell coordinate and the finger
The corresponding index value of guideline code described in code matches is marked, obtain and stores index parameter described in the indicator template is corresponding
Index value.Achievement data is inputted one by one without developer, the processing speed for improving achievement data is realized, mentions
Rise the purpose of development efficiency.
In an alternative embodiment of the invention, the achievement data processing routine can be executed by the processor, the acquisition
And after storing the corresponding index value of index parameter described in the indicator template, following steps are also realized:
When getting the instruction of index value file modification, obtains index value and modify file；
The index value modification file is parsed, index to be modified is obtained and the index to be modified is corresponding to be modified
Numerical value；
The initial value of the index to be modified in the stored indicator template is revised as the numerical value to be modified.
In the present embodiment, index value modification file can instruct the specified path for including from index value file modification
Middle acquisition.
In a kind of alternative embodiment, after analytic index numerical value modifies file, file can be modified according to index value
In include modified logo determine index to be modified and the corresponding numerical value to be modified of index to be modified, and then to index to be modified
Value modify.
Through this embodiment, it is quickly modified when the numerical value of stored index to be modified can be changed.
Optionally, in other embodiments, achievement data processing routine can also be divided into one or more module,
One or more module is stored in memory 11, and by one or more processors (the present embodiment is processor 12) institute
It executes to complete the present invention, the so-called module of the present invention is the series of computation machine program instruction for referring to complete specific function
Section, for implementation procedure of the description indexes data processor in achievement data processing unit.
It is the achievement data processing routine in one embodiment of achievement data processing unit of the present invention for example, referring to shown in Fig. 3
Program module schematic diagram, in the embodiment, achievement data processing routine can be divided into the first acquisition module 10, parsing mould
Block 20, second obtains module 30 and preserving module 40, illustratively:
First acquisition module 10 is used for: obtaining indicator template；
Parsing module 20 is used for: being parsed the indicator template by POI technology, is obtained the index that the indicator template includes
The corresponding guideline code of index parameter that parameter, generation unit lattice coordinate and the indicator template include；
Second acquisition module 30 is used for: obtaining the corresponding index value file of the indicator template；
Preserving module 40 is used for: it is corresponding to match the guideline code according to the cell coordinate and the guideline code
Index value obtains and stores the corresponding index value of index parameter described in the indicator template.
Above-mentioned first obtains module 10, parsing module 20, second obtains the program modules quilt such as module 30 and preserving module 40
Functions or operations step and the above-described embodiment realized when execution are substantially the same, and details are not described herein.
In addition, the embodiment of the present invention also proposes a kind of computer readable storage medium, the computer readable storage medium
On be stored with achievement data processing routine, the achievement data processing routine can be executed by one or more processors, with realize
Following operation:
Obtain indicator template；
The indicator template is parsed by POI technology, obtains the index parameter that the indicator template includes, generation unit lattice
The corresponding guideline code of index parameter that coordinate and the indicator template include；
Obtain the corresponding index value file of the indicator template；
The corresponding index value of the guideline code is matched according to the cell coordinate and the guideline code, is obtained simultaneously
Store the corresponding index value of index parameter described in the indicator template.
Computer readable storage medium specific embodiment of the present invention and These parameters data processing equipment and each reality of method
It is essentially identical to apply example, does not make tired state herein.
It should be noted that the serial number of the above embodiments of the invention is only for description, do not represent the advantages or disadvantages of the embodiments.And
The terms "include", "comprise" herein or any other variant thereof is intended to cover non-exclusive inclusion, so that packet
Process, device, article or the method for including a series of elements not only include those elements, but also including being not explicitly listed
Other element, or further include for this process, device, article or the intrinsic element of method.Do not limiting more
In the case where, the element that is limited by sentence "including a ...", it is not excluded that including process, device, the article of the element
Or there is also other identical elements in method.
Through the above description of the embodiments, those skilled in the art can be understood that above-described embodiment side
Method can be realized by means of software and necessary general hardware platform, naturally it is also possible to by hardware, but in many cases
The former is more preferably embodiment.Based on this understanding, technical solution of the present invention substantially in other words does the prior art
The part contributed out can be embodied in the form of software products, which is stored in one as described above
In storage medium (such as ROM/RAM, magnetic disk, CD), including some instructions are used so that terminal device (it can be mobile phone,
Computer, server or network equipment etc.) execute method described in each embodiment of the present invention.
The above is only a preferred embodiment of the present invention, is not intended to limit the scope of the invention, all to utilize this hair
Equivalent structure or equivalent flow shift made by bright specification and accompanying drawing content is applied directly or indirectly in other relevant skills
Art field, is included within the scope of the present invention.
Claims (10)
1. a kind of achievement data processing method, which is characterized in that the described method includes:
Obtain indicator template；
The indicator template is parsed by POI technology, obtains the index parameter that the indicator template includes, generation unit lattice coordinate
Guideline code corresponding with the index parameter that the indicator template includes；
Obtain the corresponding index value file of the indicator template；
The corresponding index value of the guideline code is matched according to the cell coordinate and the guideline code, obtains and stores
The corresponding index value of index parameter described in the indicator template.
2. achievement data processing method as described in claim 1, which is characterized in that described to parse the finger by POI technology
Template is marked, after obtaining the index parameter that the indicator template includes, the method also includes:
Judge whether the indicator template is preset standard module, comprising:
Judge whether the Index module includes legend module, if so, judging whether the Index module includes the legend mould
The explanation of block；And
Judge whether the indicator template includes formula module；And
Judge whether the index that the indicator template includes is pre-set level；
If the indicator template does not include the explanation of the legend or the indicator template does not include formula module, Huo Zhesuo
Stating the index that indicator template includes is not the pre-set level, and determining the indicator template not is the preset standard template, hair
Send indicator template abnormity early warning；
If the indicator template includes the explanation of the legend, and the indicator template includes formula module, and the finger
The index that mark template includes is the pre-set level, determines that the indicator template is the preset standard template, executes the life
At the operation for the corresponding guideline code of index parameter that cell coordinate and the indicator template include.
3. achievement data processing method as described in claim 1, which is characterized in that the acquisition indicator template includes:
It detects whether to receive the mail that designated user sends；
If receiving the mail of designated user's transmission, judge whether the attachment of the mail includes preset name and preset format
File destination；
If the attachment of the mail includes the file destination of preset name and preset format, determine that the file destination is described
Indicator template, and obtain the file destination.
4. achievement data processing method as claimed any one in claims 1 to 3, which is characterized in that described according to the list
After first lattice coordinate and the guideline code match the corresponding index value of the guideline code, the method also includes:
Verify whether the index value that the index value file includes is virtual value；
If the index value is virtual value, obtains and store the corresponding index number of index parameter described in the indicator template
Value；
If the index value is not virtual value, index value file abnormity prompt is sent.
5. achievement data processing method as claimed any one in claims 1 to 3, which is characterized in that the method also includes:
When getting the instruction of index value file modification, obtains index value and modify file；
The index value modification file is parsed, index to be modified and the corresponding number to be modified of the index to be modified are obtained
Value；
The initial value of the index to be modified in the stored indicator template is revised as the numerical value to be modified.
6. a kind of achievement data processing unit, which is characterized in that described device includes memory and processor, on the memory
It is stored with the achievement data processing routine that can be run on the processor, the achievement data processing routine is by the processor
Following steps are realized when execution:
Obtain indicator template；
The indicator template is parsed by POI technology, obtains the index parameter that the indicator template includes, generation unit lattice coordinate
Guideline code corresponding with the index parameter that the indicator template includes；
Obtain the corresponding index value file of the indicator template；
The corresponding index value of the guideline code is matched according to the cell coordinate and the guideline code, obtains and stores
The corresponding index value of index parameter described in the indicator template.
7. achievement data processing unit as claimed in claim 6, which is characterized in that the achievement data processing routine can be by institute
State processor execution, it is described that the indicator template is parsed by POI technology, obtain index parameter that the indicator template includes it
Afterwards, following steps are also realized:
Judge whether the indicator template is preset standard module, comprising:
Judge whether the Index module includes legend module, if so, judging whether the Index module includes the legend mould
The explanation of block；And
Judge whether the indicator template includes formula module；And
Judge whether the index that the indicator template includes is pre-set level；
If the indicator template does not include the explanation of the legend or the indicator template does not include formula module, Huo Zhesuo
Stating the index that indicator template includes is not the pre-set level, and determining the indicator template not is the preset standard template, hair
Send indicator template abnormity early warning；
If the indicator template includes the explanation of the legend, and the indicator template includes formula module, and the finger
The index that mark template includes is the pre-set level, determines that the indicator template is the preset standard template, executes the life
At the operation for the corresponding guideline code of index parameter that cell coordinate and the indicator template include.
8. achievement data processing unit as claimed in claim 6, which is characterized in that the acquisition indicator template includes:
It detects whether to receive the mail that designated user sends；
If receiving the mail of designated user's transmission, judge whether the attachment of the mail includes preset name and preset format
File destination；
If the attachment of the mail includes the file destination of preset name and preset format, determine that the file destination is described
Indicator template, and obtain the file destination.
9. the achievement data processing unit as described in any one of claim 6 to 8, which is characterized in that at the achievement data
Reason program can be executed by the processor, described to match the guideline code according to the cell coordinate and the guideline code
After corresponding index value, following steps are also realized:
Verify whether the index value that the index value file includes is virtual value；
If the index value is virtual value, obtains and store the corresponding index number of index parameter described in the indicator template
Value；
If the index value is not virtual value, index value file abnormity prompt is sent.
10. a kind of computer readable storage medium, which is characterized in that be stored with index number on the computer readable storage medium
According to processing routine, the achievement data processing routine can be executed by one or more processor, with realize as claim 1 to
Described in any one of 5 the step of achievement data processing method.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910632930.1A CN110457021B (en) | 2019-07-12 | 2019-07-12 | Index data processing method, device and computer readable storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910632930.1A CN110457021B (en) | 2019-07-12 | 2019-07-12 | Index data processing method, device and computer readable storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN110457021A true CN110457021A (en) | 2019-11-15 |
| CN110457021B CN110457021B (en) | 2023-05-16 |
Family
ID=68482867
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910632930.1A Active CN110457021B (en) | 2019-07-12 | 2019-07-12 | Index data processing method, device and computer readable storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110457021B (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111913993A (en) * | 2020-08-12 | 2020-11-10 | 望海康信(北京)科技股份公司 | Table data generation method and device, electronic equipment and computer readable storage medium |
Citations (15)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1755725A (en) * | 2004-09-28 | 2006-04-05 | 株式会社东芝 | Data file storage/management apparatus and electronic mail processing program thereof |
| US20100235424A1 (en) * | 2009-03-16 | 2010-09-16 | Canon Kabushiki Kaisha | Image processing system, information processing apparatus, control methods thereof, and program |
| US8522083B1 (en) * | 2010-08-22 | 2013-08-27 | Panaya Ltd. | Method and system for semiautomatic execution of functioning test scenario |
| CN104881275A (en) * | 2015-02-11 | 2015-09-02 | 中国农业银行股份有限公司 | Electronic spreadsheet generating method and device |
| CN106201643A (en) * | 2016-07-14 | 2016-12-07 | 北京邮电大学 | Data analysis method and device |
| CN106201537A (en) * | 2016-07-18 | 2016-12-07 | 浪潮通用软件有限公司 | A kind of data processing method and device |
| JP2017058948A (en) * | 2015-09-16 | 2017-03-23 | 株式会社ゼンリンデータコム | Information processing device, program, information processing system and data structure |
| CN108280056A (en) * | 2017-12-26 | 2018-07-13 | 北京市天元网络技术股份有限公司 | A kind of Excel file analytic method |
| US10114624B1 (en) * | 2017-10-12 | 2018-10-30 | Devfactory Fz-Llc | Blackbox matching engine |
| CN108804140A (en) * | 2018-06-15 | 2018-11-13 | 中国建设银行股份有限公司 | A kind of batch instruction analytic method, device and equipment |
| CN109522013A (en) * | 2018-11-08 | 2019-03-26 | 网宿科技股份有限公司 | A kind of code generating method and device of business function |
| CN109542965A (en) * | 2018-11-07 | 2019-03-29 | 平安医疗健康管理股份有限公司 | A kind of data processing method, electronic equipment and storage medium |
| CN109597620A (en) * | 2018-08-08 | 2019-04-09 | 北京字节跳动网络技术有限公司 | A kind of data processing method, device, equipment and storage medium |
| CN109783554A (en) * | 2018-12-13 | 2019-05-21 | 重庆金融资产交易所有限责任公司 | Excel document analytic method, device and computer readable storage medium |
| CN109960811A (en) * | 2019-03-29 | 2019-07-02 | 联想(北京)有限公司 | A kind of data processing method, device and electronic equipment |
-
2019
- 2019-07-12 CN CN201910632930.1A patent/CN110457021B/en active Active
Patent Citations (15)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1755725A (en) * | 2004-09-28 | 2006-04-05 | 株式会社东芝 | Data file storage/management apparatus and electronic mail processing program thereof |
| US20100235424A1 (en) * | 2009-03-16 | 2010-09-16 | Canon Kabushiki Kaisha | Image processing system, information processing apparatus, control methods thereof, and program |
| US8522083B1 (en) * | 2010-08-22 | 2013-08-27 | Panaya Ltd. | Method and system for semiautomatic execution of functioning test scenario |
| CN104881275A (en) * | 2015-02-11 | 2015-09-02 | 中国农业银行股份有限公司 | Electronic spreadsheet generating method and device |
| JP2017058948A (en) * | 2015-09-16 | 2017-03-23 | 株式会社ゼンリンデータコム | Information processing device, program, information processing system and data structure |
| CN106201643A (en) * | 2016-07-14 | 2016-12-07 | 北京邮电大学 | Data analysis method and device |
| CN106201537A (en) * | 2016-07-18 | 2016-12-07 | 浪潮通用软件有限公司 | A kind of data processing method and device |
| US10114624B1 (en) * | 2017-10-12 | 2018-10-30 | Devfactory Fz-Llc | Blackbox matching engine |
| CN108280056A (en) * | 2017-12-26 | 2018-07-13 | 北京市天元网络技术股份有限公司 | A kind of Excel file analytic method |
| CN108804140A (en) * | 2018-06-15 | 2018-11-13 | 中国建设银行股份有限公司 | A kind of batch instruction analytic method, device and equipment |
| CN109597620A (en) * | 2018-08-08 | 2019-04-09 | 北京字节跳动网络技术有限公司 | A kind of data processing method, device, equipment and storage medium |
| CN109542965A (en) * | 2018-11-07 | 2019-03-29 | 平安医疗健康管理股份有限公司 | A kind of data processing method, electronic equipment and storage medium |
| CN109522013A (en) * | 2018-11-08 | 2019-03-26 | 网宿科技股份有限公司 | A kind of code generating method and device of business function |
| CN109783554A (en) * | 2018-12-13 | 2019-05-21 | 重庆金融资产交易所有限责任公司 | Excel document analytic method, device and computer readable storage medium |
| CN109960811A (en) * | 2019-03-29 | 2019-07-02 | 联想(北京)有限公司 | A kind of data processing method, device and electronic equipment |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111913993A (en) * | 2020-08-12 | 2020-11-10 | 望海康信(北京)科技股份公司 | Table data generation method and device, electronic equipment and computer readable storage medium |
| CN111913993B (en) * | 2020-08-12 | 2024-02-23 | 望海康信(北京)科技股份公司 | Table data generation method, apparatus, electronic device and computer readable storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN110457021B (en) | 2023-05-16 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110163476A (en) | Project intelligent recommendation method, electronic device and storage medium | |
| US20070036433A1 (en) | Recognizing data conforming to a rule | |
| CN109471857A (en) | Data modification method, device and storage medium based on SQL statement | |
| CN110457363A (en) | Querying method, device and storage medium based on distributed data base | |
| CN108614859A (en) | Intelligent search method, server and storage medium | |
| CN102855178A (en) | Method and device for generating Mock base during unit test | |
| CN110287098A (en) | Automatically create test script method, server and computer readable storage medium | |
| CN109299177A (en) | Data pick-up method, apparatus, storage medium and electronic equipment | |
| CN112418798A (en) | Information auditing method and device, electronic equipment and storage medium | |
| CN108845839A (en) | Application page loading method, device and computer readable storage medium | |
| CN108765087A (en) | Order asynchronous processing method, server and storage medium | |
| US20130158925A1 (en) | Computing device and method for checking differential pair | |
| CN105641931A (en) | Game operation configuration method and system | |
| CN112115145A (en) | Data acquisition method and device, electronic equipment and storage medium | |
| CN112395251A (en) | Intelligent analysis method and device for data file, electronic equipment and storage medium | |
| CN110727425A (en) | Electronic device, form data verification method and computer-readable storage medium | |
| US20090106459A1 (en) | Configuration identification tool and methods | |
| CN110457021A (en) | Achievement data processing method, device and computer readable storage medium | |
| CN113434542A (en) | Data relation identification method and device, electronic equipment and storage medium | |
| CN110210039B (en) | Translation content checking method, device, system and computer equipment | |
| CN110503378A (en) | A kind of BOM standardized method, system and electronic equipment and storage medium | |
| CN113687827B (en) | Data list generation method, device and equipment based on widget and storage medium | |
| CN105426183A (en) | Form verification method | |
| US8510705B2 (en) | Computing device and method for checking via stub | |
| CN111553133A (en) | Report generation method and device, electronic equipment and storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |