CN110457021B - Index data processing method, device and computer readable storage medium - Google Patents
Index data processing method, device and computer readable storage medium Download PDFInfo
- Publication number
- CN110457021B CN110457021B CN201910632930.1A CN201910632930A CN110457021B CN 110457021 B CN110457021 B CN 110457021B CN 201910632930 A CN201910632930 A CN 201910632930A CN 110457021 B CN110457021 B CN 110457021B
- Authority
- CN
- China
- Prior art keywords
- index
- template
- value
- preset
- data processing
- 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
Images
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
Landscapes
- Engineering & Computer Science (AREA)
- Software Systems (AREA)
- General Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Aerodynamic Tests, Hydrodynamic Tests, Wind Tunnels, And Water Tanks (AREA)
- Image Analysis (AREA)
- Information Transfer Between Computers (AREA)
Abstract
The invention discloses an index data processing method, which comprises the following steps: obtaining an index template; analyzing the index template through POI technology, obtaining index parameters contained in the index template, and generating cell coordinates and index codes corresponding to the index parameters contained in the index template; acquiring an index value file corresponding to the index template; and according to the cell coordinates and the index code, matching the index value corresponding to the index code, and acquiring and storing the index value corresponding to the index parameter in the index template. The invention also provides an index data processing device and a computer readable storage medium. The invention can improve the processing speed of index data and the development efficiency.
Description
Technical Field
The present invention relates to the field of computer technologies, and in particular, to a method and an apparatus for processing index data, and a computer readable storage medium.
Background
In the development process, service requirements are generally provided to developers by service personnel, and the developers develop according to the service requirements provided by the service personnel. At present, after operators provide operators with index information (such as sales index) related to operations such as some products or sales, manual reconfiguration, i.e. manual re-entry, is needed by the operators according to the obtained index, which increases the workload of the operators and reduces the development efficiency.
Disclosure of Invention
The invention provides an index data processing method, an index data processing device and a computer readable storage medium, and mainly aims to improve the processing speed of index data and the development efficiency.
In order to achieve the above object, the present invention further provides an index data processing method, which includes:
obtaining an index template;
analyzing the index template through POI technology, obtaining index parameters contained in the index template, and generating cell coordinates and index codes corresponding to the index parameters contained in the index template;
acquiring an index value file corresponding to the index template;
and according to the cell coordinates and the index code, matching the index value corresponding to the index code, and acquiring and storing the index value corresponding to the index parameter in the index template.
Optionally, after the index template is parsed by the POI technology and the index parameters contained in the index template are obtained, the method further includes:
judging whether the index template is a preset standard module or not comprises the following steps:
judging whether the index module comprises a legend module or not, if yes, judging whether the index module comprises a description of the legend module or not; and
judging whether the index template comprises a formula module or not; and
judging whether the index contained in the index template is a preset index or not;
if the index template does not contain the description of the legend, or the index template does not contain a formula module, or the index contained in the index template is not the preset index, determining that the index template is not the preset standard template, and sending an index template abnormality early warning;
and if the index template comprises the description of the legend and the index template comprises a formula module, and the index contained in the index template is the preset index, determining that the index template is the preset standard template, and executing the operation of generating the index codes corresponding to the cell coordinates and the index parameters contained in the index template.
Optionally, the obtaining the index template includes:
detecting whether a mail sent by a designated user is received or not;
if a mail sent by a designated user is received, judging whether an attachment of the mail contains a preset name and a target file in a preset format;
if the attachment of the mail comprises a preset name and a target file in a preset format, determining the target file as the index template, and acquiring the target file.
Optionally, after the matching, according to the cell coordinates and the index code, the index value corresponding to the index code, the method further includes:
checking whether the index value contained in the index value file is a valid value;
if the index value is an effective value, acquiring and storing an index value corresponding to the index parameter in the index template;
and if the index value is not the effective value, sending an index value file abnormality reminder.
Optionally, the method further comprises:
when an index value file modification instruction is acquired, acquiring an index value modification file;
analyzing the index value modification file to obtain an index to be modified and a value to be modified corresponding to the index to be modified;
and modifying the initial value of the index to be modified in the stored index template into the value to be modified.
In order to achieve the above object, the present invention provides an index data processing device comprising a memory and a processor, wherein the memory stores an index data processing program that can be executed on the processor, and the index data processing program when executed by the processor realizes the following steps:
obtaining an index template;
analyzing the index template through POI technology, obtaining index parameters contained in the index template, and generating cell coordinates and index codes corresponding to the index parameters contained in the index template;
acquiring an index value file corresponding to the index template;
and according to the cell coordinates and the index code, matching the index value corresponding to the index code, and acquiring and storing the index value corresponding to the index parameter in the index template.
Optionally, the index data processing program may be executed by the processor, and after the index template is parsed by the POI technology to obtain the index parameters contained in the index template, the following steps are further implemented:
judging whether the index template is a preset standard module or not comprises the following steps:
judging whether the index module comprises a legend module or not, if yes, judging whether the index module comprises a description of the legend module or not; and
judging whether the index template comprises a formula module or not; and
judging whether the index contained in the index template is a preset index or not;
if the index template does not contain the description of the legend, or the index template does not contain a formula module, or the index contained in the index template is not the preset index, determining that the index template is not the preset standard template, and sending an index template abnormality early warning;
and if the index template comprises the description of the legend and the index template comprises a formula module, and the index contained in the index template is the preset index, determining that the index template is the preset standard template, and executing the operation of generating the index codes corresponding to the cell coordinates and the index parameters contained in the index template.
Optionally, the obtaining the index template includes:
detecting whether a mail sent by a designated user is received or not;
if a mail sent by a designated user is received, judging whether an attachment of the mail contains a preset name and a target file in a preset format;
if the attachment of the mail comprises a preset name and a target file in a preset format, determining the target file as the index template, and acquiring the target file.
Optionally, the index data processing program may be executed by the processor, and after the index value corresponding to the index code is matched according to the cell coordinates and the index code, the following steps are further implemented:
checking whether the index value contained in the index value file is a valid value;
if the index value is an effective value, acquiring and storing an index value corresponding to the index parameter in the index template;
optionally, the index data processing program may be executed by the processor, and further implement the following steps:
when an index value file modification instruction is acquired, acquiring an index value modification file;
analyzing the index value modification file to obtain an index to be modified and a value to be modified corresponding to the index to be modified;
and modifying the initial value of the index to be modified in the stored index template into the value to be modified.
In addition, to achieve the above object, the present invention also provides a computer-readable storage medium having stored thereon an index data processing program executable by one or more processors to implement the steps of the index data processing method as described above.
The invention provides an index data processing method, an index data processing device and a computer readable storage medium, which are used for acquiring an index template; analyzing the index template through POI technology, obtaining index parameters contained in the index template, and generating cell coordinates and index codes corresponding to the index parameters contained in the index template; acquiring an index value file corresponding to the index template; and according to the cell coordinates and the index code, matching the index value corresponding to the index code, and acquiring and storing the index value corresponding to the index parameter in the index template. The method and the device have the advantages that the index data do not need to be input one by a developer, so that the purposes of improving the processing speed of the index data and improving the development efficiency are achieved.
Drawings
FIG. 1 is a flowchart of a method for processing index data according to an embodiment of the present invention;
FIG. 2 is a schematic diagram illustrating an internal structure of an index data processing device according to an embodiment of the present invention;
fig. 3 is a schematic block diagram illustrating a pointer data processing procedure in the pointer data processing device according to an embodiment of the present invention.
The achievement of the objects, functional features and advantages of the present invention will be further described with reference to the accompanying drawings, in conjunction with the embodiments.
Detailed Description
It should be understood that the specific embodiments described herein are for purposes of illustration only and are not intended to limit the scope of the invention.
The invention provides an index data processing method. Referring to fig. 1, a flowchart of a method for processing index data according to an embodiment of the invention is shown. The method may be performed by an electronic device.
In this embodiment, the index data processing method includes:
step S10, obtaining an index template.
In the embodiment of the invention, the index template is an excel format file.
In an alternative embodiment, the index template may include information such as the name of the index, the meaning of the index, the calculation method of the index, and the like.
For example, the index template includes one or more items of index information among sales profit margin, net profit, operating profit, sales amount and liability.
In an alternative embodiment, the index template may be obtained from a server. In other alternative embodiments, the index template may be retrieved from the user's local storage space.
In another embodiment of the present invention, the obtaining the index template includes:
detecting whether a mail sent by a designated user is received or not;
if a mail sent by a designated user is received, judging whether an attachment of the mail contains a preset name and a target file in a preset format;
if the attachment of the mail comprises a preset name and a target file in a preset format, determining the target file as the index template, and acquiring the target file.
The designated user may be preset, for example, the designated user is a business person of a department.
In an alternative embodiment, the mailbox address of the service personnel is added to the white list, and when the newly received mail is detected to be the mail sent by the mailbox address in the white list, the mail sent by the appointed user is determined to be received.
The preset name may be a file name containing a preset keyword, and the preset format is a file format, for example, the preset format is an excel format, and specific preset names and preset formats may be preset according to needs.
In this embodiment, when a mail containing an index template is received, the file is acquired from the attachment of the mail and analyzed, so that the speed of analyzing the index template file can be increased, and the speed of analyzing the index template file can be further increased.
Step S20, analyzing the index template through POI technology, obtaining index parameters contained in the index template, and generating cell coordinates and index codes corresponding to the index parameters contained in the index template.
In this embodiment, the index parameters included in each cell in the index template may be resolved by the POI technique.
Specifically, an index template, namely a worksheet (Workbook), is obtained by a create (FileInputStream fis) method of a Workbook factor in POI technology; each form (Sheet) in the index template is acquired by getSheetAt (int num) method of Workbook instance in POI technology; the Row (Row) in the form is obtained by the getRow (int num) method of Sheet instance in POI technology; individual cells (cells) in a Row are obtained by the getCell (int num) method of the Row instance in POI technology.
For example, the first row and first column indexes are obtained as sales, the first row and second column indexes are sales profits, the first row and first column coordinates are generated as sales, the index code corresponding to the sales is 001, the first row and second column coordinates are generated as sales profits, and the index code corresponding to the sales profits is 002.
Optionally, in another embodiment of the present invention, after the analyzing the index template by using POI technology to obtain index parameters included in the index template, the method further includes:
judging whether the index template is a preset standard module or not comprises the following steps:
judging whether the index module comprises a legend module or not, if yes, judging whether the index module comprises a description of the legend module or not; and
judging whether the index template comprises a formula module or not; and
judging whether the index contained in the index template is a preset index or not;
if the index template does not contain the description of the legend, or the index template does not contain a formula module, or the index contained in the index template is not the preset index, determining that the index template is not the preset standard template, and sending an index template abnormality early warning;
and if the index template comprises the description of the legend and the index template comprises a formula module, and the index contained in the index template is the preset index, determining that the index template is the preset standard template, and executing the operation of generating the index codes corresponding to the cell coordinates and the index parameters contained in the index template.
The preset standard template is a preset standard index template, and when the index template is not the preset standard template, early warning is carried out, so that a user is reminded of whether the error index template is used or not, and a place where information interaction is wrong in time can be found in the development process.
The formula module is used for calculating or describing the formula of the index, and the legend module is used for displaying the index in a pattern of the graph.
Further, in another embodiment of the present invention, the method further includes:
if the index template is not the preset standard template, acquiring the preset standard template and acquiring a sending user of the index template;
acquiring information of a sending user of the index template;
and sending the preset standard template to the sending user of the index template according to the information of the sending user of the index template.
Wherein, the sending user of the index template is the user who sends the index template.
The obtained information of the sending user of the index template can be a mailbox address or other instant messaging account number of the sending user of the index template.
In this embodiment, when the index template used by the user is wrong, the preset standard template is timely sent to the user, which is beneficial for the user to create a correct index template.
In another embodiment of the present invention, a storage path of a preset standard template may also be obtained, and the storage path of the preset standard template may be sent to the sending user of the index template.
Step S30, obtaining an index value file corresponding to the index template.
In this embodiment, the index value file includes specific values of the indexes in the index template. The type of the index value file corresponding to the index template is the same as the file type of the index template.
For example, if the index included in the index template has sales and sales profits, the index value file corresponding to the index template includes specific values of sales and sales profits.
In the implementation, the acquisition mode of the index numerical value file corresponding to the index template and the acquisition mode of the index template can be the same or different.
And step S40, according to the cell coordinates and the index values corresponding to the index codes, acquiring and storing the index values corresponding to the index parameters in the index template.
According to the method and the device, the index values corresponding to the index parameters in the index template can be automatically and rapidly obtained, user personnel are not required to recognize and input data, and the efficiency of data processing and the development efficiency are improved.
Optionally, in another embodiment of the present invention, after the matching, according to the cell coordinates and the index code, the index value corresponding to the index code, the method further includes:
checking whether the index value contained in the index value file is a valid value;
if the index value is an effective value, acquiring and storing an index value corresponding to the index parameter in the index template;
and if the index value is not the effective value, sending an index value file abnormality reminder.
In this embodiment, verifying whether the index value included in the index value file is a valid value includes: whether the type of the index value corresponding to the index code is a preset type is judged, or whether the size of the index value corresponding to the index code exceeds a preset range is judged, or whether the index value corresponding to the index code is an abnormal value (for example, whether the index value is N/A is judged, if so, the value is determined to be the abnormal value).
In this embodiment, the index value is not acquired when the index value is a non-effective value, and the validity of the acquired index value can be improved by acquiring when the index value is an effective value.
The index data processing method provided by the embodiment obtains an index template; analyzing the index template through POI technology, obtaining index parameters contained in the index template, and generating cell coordinates and index codes corresponding to the index parameters contained in the index template; acquiring an index value file corresponding to the index template; and according to the cell coordinates and the index code, matching the index value corresponding to the index code, and acquiring and storing the index value corresponding to the index parameter in the index template. The method and the device have the advantages that the index data do not need to be input one by a developer, so that the purposes of improving the processing speed of the index data and improving the development efficiency are achieved.
In another embodiment of the present invention, after the obtaining and storing the index value corresponding to the index parameter in the index template, the method further includes:
when an index value file modification instruction is acquired, acquiring an index value modification file;
analyzing the index value modification file to obtain an index to be modified and a value to be modified corresponding to the index to be modified;
and modifying the initial value of the index to be modified in the stored index template into the value to be modified.
In this embodiment, the index value modification file may be obtained from a specified path included in the index value file modification instruction.
In an alternative embodiment, after the index value modification file is parsed, the index to be modified and the value to be modified corresponding to the index to be modified may be determined according to the modification identifier included in the index value modification file, so as to modify the value of the index to be modified.
By the embodiment, the stored index to be modified can be quickly modified when the value of the index to be modified is changed.
The invention also provides an index data processing device. Referring to fig. 2, an internal structure of an index data processing device according to an embodiment of the invention is shown.
In the present embodiment, the index data processing device 1 may be a PC (Personal Computer ), or may be a terminal device such as a smart phone, a tablet computer, or a portable computer. The index data processing device 1 comprises at least a memory 11, a processor 12, a network interface 13 and a communication bus 14.
The memory 11 includes at least one type of readable storage medium including flash memory, a hard disk, a multimedia card, a card memory (e.g., SD or DX memory, etc.), a magnetic memory, a magnetic disk, an optical disk, etc. The memory 11 may in some embodiments be an internal storage unit of the index data processing device 1, for example a hard disk of the index data processing device 1. The memory 11 may also be an external storage device of the index data processing device 1 in other embodiments, such as a plug-in hard disk, a Smart Media Card (SMC), a Secure Digital (SD) Card, a Flash memory Card (Flash Card) or the like, which are provided on the index data processing device 1. Further, the memory 11 may also include both an internal storage unit and an external storage device of the index data processing device 1. The memory 11 may be used not only for storing application software installed in the index data processing device 1 and various types of data, for example, codes of the index data processing program 01 and the like, but also for temporarily storing data that has been output or is to be output.
The processor 12 may in some embodiments be a central processing unit (Central Processing Unit, CPU), controller, microcontroller, microprocessor or other data processing chip for executing program code or processing data stored in the memory 11, such as for executing the index data processing program 01 or the like.
The network interface 13 may optionally comprise a standard wired interface, a wireless interface (e.g. WI-FI interface), typically used to establish a communication connection between the apparatus 1 and other electronic devices.
The communication bus 14 is used to enable connected communication between these components.
Optionally, the device 1 may further comprise a user interface, which may comprise a Display (Display), an input unit such as a Keyboard (Keyboard), and a standard wired interface, a wireless interface. Alternatively, in some embodiments, the display may be an LED display, a liquid crystal display, a touch-sensitive liquid crystal display, an OLED (Organic Light-Emitting Diode) touch, or the like. The display may also be referred to as a display screen or a display unit, as appropriate, for displaying information processed in the index data processing device 1 and for displaying a visual user interface.
Fig. 2 shows only the index data processing device 1 with components 11-14 and an index data processing program 01, it being understood by a person skilled in the art that the structure shown in fig. 2 does not constitute a limitation of the index data processing device 1, and may comprise fewer or more components than shown, or may combine certain components, or a different arrangement of components.
In the embodiment of the apparatus 1 shown in fig. 2, the index data processing program 01 is stored in the memory 11; the processor 12 executes the index data processing program 01 stored in the memory 11, and realizes the following steps:
and obtaining an index template.
In the embodiment of the invention, the index template is an excel format file.
In an alternative embodiment, the index template may include information such as the name of the index, the meaning of the index, the calculation method of the index, and the like.
For example, the index template includes one or more items of index information among sales profit margin, net profit, operating profit, sales amount and liability.
In an alternative embodiment, the index template may be obtained from a server. In other alternative embodiments, the index template may be retrieved from the user's local storage space.
In another embodiment of the present invention, the obtaining the index template includes:
detecting whether a mail sent by a designated user is received or not;
if a mail sent by a designated user is received, judging whether an attachment of the mail contains a preset name and a target file in a preset format;
if the attachment of the mail comprises a preset name and a target file in a preset format, determining the target file as the index template, and acquiring the target file.
The designated user may be preset, for example, the designated user is a business person of a department.
In an alternative embodiment, the mailbox address of the service personnel is added to the white list, and when the newly received mail is detected to be the mail sent by the mailbox address in the white list, the mail sent by the appointed user is determined to be received.
The preset name may be a file name containing a preset keyword, and the preset format is a file format, for example, the preset format is an excel format, and specific preset names and preset formats may be preset according to needs.
In this embodiment, when a mail containing an index template is received, the file is acquired from the attachment of the mail and analyzed, so that the speed of analyzing the index template file can be increased, and the speed of analyzing the index template file can be further increased.
Analyzing the index template through POI technology, acquiring index parameters contained in the index template, and generating cell coordinates and index codes corresponding to the index parameters contained in the index template.
In this embodiment, the index parameters included in each cell in the index template may be resolved by the POI technique.
Specifically, an index template, namely a worksheet (Workbook), is obtained by a create (FileInputStream fis) method of a Workbook factor in POI technology; each form (Sheet) in the index template is acquired by getSheetAt (int num) method of Workbook instance in POI technology; the Row (Row) in the form is obtained by the getRow (int num) method of Sheet instance in POI technology; individual cells (cells) in a Row are obtained by the getCell (int num) method of the Row instance in POI technology.
For example, the first row and first column indexes are obtained as sales, the first row and second column indexes are sales profits, the first row and first column coordinates are generated as sales, the index code corresponding to the sales is 001, the first row and second column coordinates are generated as sales profits, and the index code corresponding to the sales profits is 002.
Optionally, in another embodiment of the present invention, after the analyzing the index template by using POI technology to obtain index parameters included in the index template, the method further includes:
judging whether the index template is a preset standard module or not comprises the following steps:
judging whether the index module comprises a legend module or not, if yes, judging whether the index module comprises a description of the legend module or not; and
judging whether the index template comprises a formula module or not; and
judging whether the index contained in the index template is a preset index or not;
if the index template does not contain the description of the legend, or the index template does not contain a formula module, or the index contained in the index template is not the preset index, determining that the index template is not the preset standard template, and sending an index template abnormality early warning;
and if the index template comprises the description of the legend and the index template comprises a formula module, and the index contained in the index template is the preset index, determining that the index template is the preset standard template, and executing the operation of generating the index codes corresponding to the cell coordinates and the index parameters contained in the index template.
The preset standard template is a preset standard index template, and when the index template is not the preset standard template, early warning is carried out, so that a user is reminded of whether the error index template is used or not, and a place where information interaction is wrong in time can be found in the development process.
The formula module is used for calculating or describing the formula of the index, and the legend module is used for displaying the index in a pattern of the graph.
Further, in another embodiment of the present invention, the method further includes:
if the index template is not the preset standard template, acquiring the preset standard template and acquiring a sending user of the index template;
acquiring information of a sending user of the index template;
and sending the preset standard template to the sending user of the index template according to the information of the sending user of the index template.
Wherein, the sending user of the index template is the user who sends the index template.
The obtained information of the sending user of the index template can be a mailbox address or other instant messaging account number of the sending user of the index template.
In this embodiment, when the index template used by the user is wrong, the preset standard template is timely sent to the user, which is beneficial for the user to create a correct index template.
In another embodiment of the present invention, a storage path of a preset standard template may also be obtained, and the storage path of the preset standard template may be sent to the sending user of the index template.
And obtaining an index value file corresponding to the index template.
In this embodiment, the index value file includes specific values of the indexes in the index template. The type of the index value file corresponding to the index template is the same as the file type of the index template.
For example, if the index included in the index template has sales and sales profits, the index value file corresponding to the index template includes specific values of sales and sales profits.
In the implementation, the acquisition mode of the index numerical value file corresponding to the index template and the acquisition mode of the index template can be the same or different.
And according to the cell coordinates and the index code, matching the index value corresponding to the index code, and acquiring and storing the index value corresponding to the index parameter in the index template.
According to the method and the device, the index values corresponding to the index parameters in the index template can be automatically and rapidly obtained, user personnel are not required to recognize and input data, and the efficiency of data processing and the development efficiency are improved.
Optionally, in another embodiment of the present invention, after the matching, according to the cell coordinates and the index code, the index value corresponding to the index code, the method further includes:
checking whether the index value contained in the index value file is a valid value;
if the index value is an effective value, acquiring and storing an index value corresponding to the index parameter in the index template;
and if the index value is not the effective value, sending an index value file abnormality reminder.
In this embodiment, verifying whether the index value included in the index value file is a valid value includes: whether the type of the index value corresponding to the index code is a preset type is judged, or whether the size of the index value corresponding to the index code exceeds a preset range is judged, or whether the index value corresponding to the index code is an abnormal value (for example, whether the index value is N/A is judged, if so, the value is determined to be the abnormal value).
In this embodiment, the index value is not acquired when the index value is a non-effective value, and the validity of the acquired index value can be improved by acquiring when the index value is an effective value.
The index data processing device provided by the embodiment acquires an index template; analyzing the index template through POI technology, obtaining index parameters contained in the index template, and generating cell coordinates and index codes corresponding to the index parameters contained in the index template; acquiring an index value file corresponding to the index template; and according to the cell coordinates and the index code, matching the index value corresponding to the index code, and acquiring and storing the index value corresponding to the index parameter in the index template. The method and the device have the advantages that the index data do not need to be input one by a developer, so that the purposes of improving the processing speed of the index data and improving the development efficiency are achieved.
In another embodiment of the present invention, the index data processing program may be executed by the processor, and after the index values corresponding to the index parameters in the index template are obtained and stored, the following steps are further implemented:
when an index value file modification instruction is acquired, acquiring an index value modification file;
analyzing the index value modification file to obtain an index to be modified and a value to be modified corresponding to the index to be modified;
and modifying the initial value of the index to be modified in the stored index template into the value to be modified.
In this embodiment, the index value modification file may be obtained from a specified path included in the index value file modification instruction.
In an alternative embodiment, after the index value modification file is parsed, the index to be modified and the value to be modified corresponding to the index to be modified may be determined according to the modification identifier included in the index value modification file, so as to modify the value of the index to be modified.
By the embodiment, the stored index to be modified can be quickly modified when the value of the index to be modified is changed.
Alternatively, in other embodiments, the index data processing program may be further divided into one or more modules, where one or more modules are stored in the memory 11 and executed by one or more processors (the processor 12 in this embodiment) to implement the present invention, and the modules referred to herein are a series of instruction segments of a computer program capable of performing a specific function, for describing the execution of the index data processing program in the index data processing device.
For example, referring to fig. 3, a program module of an index data processing procedure in an embodiment of the index data processing device of the present invention is shown, where the index data processing procedure may be divided into a first obtaining module 10, an analyzing module 20, a second obtaining module 30 and a storing module 40, and the example is as follows:
the first acquisition module 10 is configured to: obtaining an index template;
the parsing module 20 is configured to: analyzing the index template through POI technology, obtaining index parameters contained in the index template, and generating cell coordinates and index codes corresponding to the index parameters contained in the index template;
the second acquisition module 30 is configured to: acquiring an index value file corresponding to the index template;
the saving module 40 is configured to: and according to the cell coordinates and the index code, matching the index value corresponding to the index code, and acquiring and storing the index value corresponding to the index parameter in the index template.
The functions or operation steps implemented when the program modules such as the first acquiring module 10, the analyzing module 20, the second acquiring module 30, and the saving module 40 are executed are substantially the same as those of the foregoing embodiments, and will not be described herein.
In addition, an embodiment of the present invention also proposes a computer-readable storage medium having stored thereon an index data processing program executable by one or more processors to implement the following operations:
obtaining an index template;
analyzing the index template through POI technology, obtaining index parameters contained in the index template, and generating cell coordinates and index codes corresponding to the index parameters contained in the index template;
acquiring an index value file corresponding to the index template;
and according to the cell coordinates and the index code, matching the index value corresponding to the index code, and acquiring and storing the index value corresponding to the index parameter in the index template.
The computer-readable storage medium of the present invention is substantially the same as the above-described embodiments of the index data processing device and method, and will not be described in detail herein.
It should be noted that, the foregoing reference numerals of the embodiments of the present invention are merely for describing the embodiments, and do not represent the advantages and disadvantages of the embodiments. And the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, apparatus, article, or method that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, apparatus, article, or method. Without further limitation, an element defined by the phrase "comprising one … …" does not exclude the presence of other like elements in a process, apparatus, article or method that comprises the element.
From the above description of the embodiments, it will be clear to those skilled in the art that the above-described embodiment method may be implemented by means of software plus a necessary general hardware platform, but of course may also be implemented by means of hardware, but in many cases the former is a preferred embodiment. Based on such understanding, the technical solution of the present invention may be embodied essentially or in a part contributing to the prior art in the form of a software product stored in a storage medium (e.g. ROM/RAM, magnetic disk, optical disk) as described above, comprising instructions for causing a terminal device (which may be a mobile phone, a computer, a server, or a network device, etc.) to perform the method according to the embodiments of the present invention.
The foregoing description is only of the preferred embodiments of the present invention, and is not intended to limit the scope of the invention, but rather is intended to cover any equivalents of the structures or equivalent processes disclosed herein or in the alternative, which may be employed directly or indirectly in other related arts.
Claims (10)
1. A method of processing index data, the method comprising:
obtaining an index template;
analyzing the index template through POI technology, acquiring index parameters contained in the index template, judging whether the index template contains legend description, a formula module and preset indexes, if yes, determining the index template as a preset standard template, and generating cell coordinates and index codes corresponding to the index parameters contained in the index template;
acquiring an index value file corresponding to the index template;
and according to the cell coordinates and the index code, matching the index value corresponding to the index code, and acquiring and storing the index value corresponding to the index parameter in the index template.
2. The method for processing index data according to claim 1, wherein said determining whether the index template includes a description of a legend, a formula module, and a preset index, if yes, determining that the index template is a preset standard template, generating an index code corresponding to a cell coordinate and an index parameter included in the index template, includes:
judging whether the index module comprises a legend module or not, if yes, judging whether the index module comprises a description of the legend module or not; and
judging whether the index template comprises a formula module or not; and
judging whether the index contained in the index template is a preset index or not;
if the index template does not contain the description of the legend, or the index template does not contain a formula module, or the index contained in the index template is not the preset index, determining that the index template is not the preset standard template, and sending an index template abnormality early warning;
and if the index template comprises the description of the legend and the index template comprises a formula module, and the index contained in the index template is the preset index, determining that the index template is the preset standard template, and executing the operation of generating the index codes corresponding to the cell coordinates and the index parameters contained in the index template.
3. The index data processing method as claimed in claim 1, wherein said obtaining an index template includes:
detecting whether a mail sent by a designated user is received or not;
if a mail sent by a designated user is received, judging whether an attachment of the mail contains a preset name and a target file in a preset format;
if the attachment of the mail comprises a preset name and a target file in a preset format, determining the target file as the index template, and acquiring the target file.
4. A method according to any one of claims 1 to 3, wherein after the matching of the index value corresponding to the index code according to the cell coordinates and the index code, the method further comprises:
checking whether the index value contained in the index value file is a valid value;
if the index value is an effective value, acquiring and storing an index value corresponding to the index parameter in the index template;
and if the index value is not the effective value, sending an index value file abnormality reminder.
5. A method of processing index data according to any one of claims 1 to 3, characterized in that the method further comprises:
when an index value file modification instruction is acquired, acquiring an index value modification file;
analyzing the index value modification file to obtain an index to be modified and a value to be modified corresponding to the index to be modified;
and modifying the initial value of the index to be modified in the stored index template into the value to be modified.
6. An index data processing device, characterized in that the device comprises a memory and a processor, wherein an index data processing program capable of running on the processor is stored in the memory, and the following steps are realized when the index data processing program is executed by the processor:
obtaining an index template;
analyzing the index template through POI technology, acquiring index parameters contained in the index template, judging whether the index template contains legend description, a formula module and preset indexes, if yes, determining the index template as a preset standard template, and generating cell coordinates and index codes corresponding to the index parameters contained in the index template;
acquiring an index value file corresponding to the index template;
and according to the cell coordinates and the index code, matching the index value corresponding to the index code, and acquiring and storing the index value corresponding to the index parameter in the index template.
7. The index data processing device of claim 6, wherein the index data processing program is executable by the processor, and wherein the determining whether the index template includes a description of a legend, a formula module, and a preset index, if yes, determining that the index template is a preset standard template, generating an index code corresponding to a cell coordinate and an index parameter included in the index template, further comprises:
judging whether the index module comprises a legend module or not, if yes, judging whether the index module comprises a description of the legend module or not; and
judging whether the index template comprises a formula module or not; and
judging whether the index contained in the index template is a preset index or not;
if the index template does not contain the description of the legend, or the index template does not contain a formula module, or the index contained in the index template is not the preset index, determining that the index template is not the preset standard template, and sending an index template abnormality early warning;
and if the index template comprises the description of the legend and the index template comprises a formula module, and the index contained in the index template is the preset index, determining that the index template is the preset standard template, and executing the operation of generating the index codes corresponding to the cell coordinates and the index parameters contained in the index template.
8. The index data processing device of claim 6, wherein the acquiring an index template comprises:
detecting whether a mail sent by a designated user is received or not;
if a mail sent by a designated user is received, judging whether an attachment of the mail contains a preset name and a target file in a preset format;
if the attachment of the mail comprises a preset name and a target file in a preset format, determining the target file as the index template, and acquiring the target file.
9. The index data processing device according to any one of claims 6 to 8, wherein the index data processing program is executable by the processor, and the following steps are further implemented after matching the index value corresponding to the index code according to the cell coordinates and the index code:
checking whether the index value contained in the index value file is a valid value;
if the index value is an effective value, acquiring and storing an index value corresponding to the index parameter in the index template;
and if the index value is not the effective value, sending an index value file abnormality reminder.
10. A computer-readable storage medium, having stored thereon an index data processing program executable by one or more processors to implement the steps of the index data processing method of any one of claims 1 to 5.
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 CN110457021A (en) | 2019-11-15 |
| CN110457021B true 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) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111913993B (en) * | 2020-08-12 | 2024-02-23 | 望海康信(北京)科技股份公司 | Table data generation method, apparatus, electronic device and computer readable storage medium |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US8522083B1 (en) * | 2010-08-22 | 2013-08-27 | Panaya Ltd. | Method and system for semiautomatic execution of functioning test scenario |
| CN106201537A (en) * | 2016-07-18 | 2016-12-07 | 浪潮通用软件有限公司 | A kind of data processing method and device |
| CN108804140A (en) * | 2018-06-15 | 2018-11-13 | 中国建设银行股份有限公司 | A kind of batch instruction analytic method, device and equipment |
| CN109960811A (en) * | 2019-03-29 | 2019-07-02 | 联想(北京)有限公司 | A kind of data processing method, device and electronic equipment |
Family Cites Families (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2006099243A (en) * | 2004-09-28 | 2006-04-13 | Toshiba Corp | Data file accumulation management device and its e-mail processing program |
| JP5361471B2 (en) * | 2009-03-16 | 2013-12-04 | キヤノン株式会社 | Information processing apparatus, control method thereof, and program |
| CN104881275B (en) * | 2015-02-11 | 2018-08-28 | 中国农业银行股份有限公司 | A kind of electronic report forms generation method and device |
| JP6498574B2 (en) * | 2015-09-16 | 2019-04-10 | 株式会社ゼンリンデータコム | Information processing device, program, terminal |
| CN106201643B (en) * | 2016-07-14 | 2019-11-05 | 北京邮电大学 | Data analysis 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 |
| CN109597620B (en) * | 2018-08-08 | 2022-04-01 | 北京字节跳动网络技术有限公司 | 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 |
-
2019
- 2019-07-12 CN CN201910632930.1A patent/CN110457021B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US8522083B1 (en) * | 2010-08-22 | 2013-08-27 | Panaya Ltd. | Method and system for semiautomatic execution of functioning test scenario |
| CN106201537A (en) * | 2016-07-18 | 2016-12-07 | 浪潮通用软件有限公司 | A kind of data processing method and device |
| CN108804140A (en) * | 2018-06-15 | 2018-11-13 | 中国建设银行股份有限公司 | A kind of batch instruction analytic method, device and equipment |
| CN109960811A (en) * | 2019-03-29 | 2019-07-02 | 联想(北京)有限公司 | A kind of data processing method, device and electronic equipment |
Also Published As
| Publication number | Publication date |
|---|---|
| CN110457021A (en) | 2019-11-15 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109165856B (en) | Dynamic configuration method, device and storage medium of approval chain | |
| CN108874464B (en) | Automatic scanning assembly method and device for middleware and storage medium | |
| CN108845839B (en) | Application page loading method and device and computer readable storage medium | |
| WO2019056793A1 (en) | Device, method, and computer readable storage medium for identifying resume | |
| CN108241529B (en) | Salary calculation method, application server and computer readable storage medium | |
| CN110851298B (en) | Abnormality analysis and processing method, electronic device and storage medium | |
| CN113448862B (en) | Software version testing method and device and computer equipment | |
| CN112115145A (en) | Data acquisition method and device, electronic equipment and storage medium | |
| CN110727425A (en) | Electronic device, form data verification method and computer-readable storage medium | |
| CN110457021B (en) | Index data processing method, device and computer readable storage medium | |
| CN110032731B (en) | Enterprise operation range judgment method and device and computer readable storage medium | |
| JP2017091208A (en) | Document inspection support device, document inspection support system, and program | |
| CN110688315A (en) | Interface code detection report generation method, electronic device, and storage medium | |
| CN114491646A (en) | Data desensitization method and device, electronic equipment and storage medium | |
| CN113806038A (en) | Task scheduling method, device, electronic equipment, storage medium and program product | |
| CN112541688A (en) | Service data checking method and device, electronic equipment and computer storage medium | |
| CN112631903A (en) | Task testing method and device, electronic equipment and storage medium | |
| CN115712422A (en) | Form page generation method and device, computer equipment and storage medium | |
| CN114611477A (en) | Design recommendation method and device for data table, electronic equipment and medium | |
| CN113867715A (en) | Page bottom bar configuration method, device, equipment and storage medium | |
| CN111553133A (en) | Report generation method and device, electronic equipment and storage medium | |
| CN112527443A (en) | Prompt box display method and device, electronic equipment and computer readable storage medium | |
| CN110764745B (en) | Variable transmission and collection method, device and computer readable storage medium | |
| CN112527282B (en) | Front-end page verification method and device, electronic equipment and storage medium | |
| CN116739612B (en) | Method for displaying rights and interests information and electronic equipment |
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 |