CN109902272A - Electronic form data processing method, device, computer equipment and storage medium - Google Patents
Electronic form data processing method, device, computer equipment and storage medium Download PDFInfo
- Publication number
- CN109902272A CN109902272A CN201910082337.4A CN201910082337A CN109902272A CN 109902272 A CN109902272 A CN 109902272A CN 201910082337 A CN201910082337 A CN 201910082337A CN 109902272 A CN109902272 A CN 109902272A
- Authority
- CN
- China
- Prior art keywords
- initial
- head information
- column head
- information
- code
- 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
- 238000003672 processing method Methods 0.000 title claims abstract description 26
- 238000000034 method Methods 0.000 claims abstract description 22
- 238000012795 verification Methods 0.000 claims description 96
- 238000004590 computer program Methods 0.000 claims description 27
- 238000012986 modification Methods 0.000 claims description 14
- 230000004048 modification Effects 0.000 claims description 14
- 238000001514 detection method Methods 0.000 claims description 8
- 238000012545 processing Methods 0.000 claims description 8
- 238000012217 deletion Methods 0.000 claims description 7
- 230000037430 deletion Effects 0.000 claims description 7
- 238000000605 extraction Methods 0.000 claims description 4
- 230000009467 reduction Effects 0.000 claims description 4
- 230000008859 change Effects 0.000 description 13
- 230000000977 initiatory effect Effects 0.000 description 6
- 238000010586 diagram Methods 0.000 description 5
- 239000000284 extract Substances 0.000 description 5
- 238000004321 preservation Methods 0.000 description 4
- 230000001965 increasing effect Effects 0.000 description 3
- 235000013399 edible fruits Nutrition 0.000 description 2
- 230000005611 electricity Effects 0.000 description 2
- 239000000203 mixture Substances 0.000 description 2
- 230000008569 process Effects 0.000 description 2
- 238000004891 communication Methods 0.000 description 1
- 230000002708 enhancing effect Effects 0.000 description 1
- 230000003068 static effect Effects 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
- 230000001360 synchronised effect Effects 0.000 description 1
- 238000012360 testing method Methods 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/23—Updating
Abstract
This application involves big data technical field, in particular to a kind of electronic form data processing method, device, computer equipment and storage medium.The described method includes: receiving spread-sheet data, spread-sheet data carries electrical form mark；Target column head information is extracted from spread-sheet data；Inquire initial column head information corresponding with electrical form mark and initial code table；Judge whether target column head information matches with initial column head information；When target column head information and initial column head information mismatch, obtain that it fails to match when forefront head information；Object code corresponding with forefront head information is worked as is generated, initial code table is modified according to object code and is saved.It can be improved the update efficiency of spread-sheet data using this method.
Description
Technical field
This application involves big data technical fields, more particularly to a kind of electronic form data processing method, device, calculating
Machine equipment and storage medium.
Background technique
When handling client traffic, it is desirable to when retaining the personal information or company's information of client, it is generally the case that Ke Yitong
It crosses electrical form form document and records customer information, then pass through relevant staff for the client in electrical form form document
Message composition uploads to Corporation system preservation at correlative code.
However, current information saving method, when the information category of each client updates, for example client will increase a Xiang Xin newly
Customer information when, need relevant staff to write related generation according to the electrical form form document of newly-added information is again secondary
Code uploading system, inefficiency.
Summary of the invention
Based on this, it is necessary in view of the above technical problems, provide a kind of electrical form that can be improved information update efficiency
Data processing method, device, computer equipment and storage medium.
A kind of electronic form data processing method, which comprises
Spread-sheet data is received, the spread-sheet data carries electrical form mark；
Target column head information is extracted from the spread-sheet data；
Inquire initial column head information corresponding with electrical form mark and initial code table；
Judge whether the target column head information and the initial column head information match；
When the target column head information and the initial column head information mismatch, then obtain that it fails to match works as forefront
Head information；
It generates with described when the corresponding object code of forefront head information, and according to the object code modification initial generation
Code table saves modified initial code table.
It is described when target column head information and initial column head information mismatch in one of the embodiments, then
Obtain that it fails to match when forefront head information, comprising:
When detecting target column head information information content increase compared with the initial column head information, obtain newly-increased
Column head information；
The generation with described when the corresponding object code of forefront head information, and it is described first according to object code modification
Beginning code table, comprising:
Corresponding newly-increased object code is generated according to the newly-increased column head information, and is increased in the initial code table
Add the newly-increased object code.
It is described when target column head information and initial column head information mismatch in one of the embodiments, then
Obtain that it fails to match when forefront head information, comprising:
When detecting the target column head information information content being reduced compared with the initial column head information, obtains and delete
Column head information；
The generation with described when the corresponding object code of forefront head information, and it is described first according to object code modification
Beginning code table, comprising:
Object code is deleted according to the column head acquisition of information deleted is corresponding, and is deleted in the initial code table
Object code is deleted except described.
The generating mode of the initial code table in one of the embodiments, comprising:
Obtain the corresponding initial verification rule of the initial column head information and specification information；
Pre-set code format is obtained, according to the pre-set code format, the initial column head information, specification information and initial
Verification rule generates initial code table.
The electronic form data processing method in one of the embodiments, further include:
It obtains described when the corresponding newly-increased verification rule of forefront head information；
The newly-increased verification rule is detected with the initial verification rule with the presence or absence of rule conflict；
When there are deleting when rule conflict, there are the initial of rule conflict with the verification rule for the newly-increased verification rule
Verification rule；
It is described to be generated initially according to pre-set code format, the initial column head information, specification information and initial verification rule
Code table, comprising:
It is regular and newly-increased according to the initial verification after pre-set code format, the initial column head information, specification information, deletion
Verification rule generates initial code table.
The acquisition pre-set code format in one of the embodiments, will be described first according to the pre-set code format
Beginning column head information, specification information and initial verification rule generate initial code table, comprising:
History codes table is obtained, the corresponding object code format of the history codes table is extracted；
It is generated according to the object code format, the initial column head information, specification information and initial verification rule initial
Code table.
A kind of spread-sheet data processing unit, described device include:
Receiving module, for receiving spread-sheet data, the spread-sheet data carries electrical form mark；
Extraction module, for extracting target column head information from the spread-sheet data；
Enquiry module, for inquiring initial column head information corresponding with electrical form mark and initial code table；
Judgment module, for judging whether the target column head information and the initial column head information match；
Module is obtained, the then acquisition when the target column head information and initial column head information mismatch is used for
Work as forefront head information with failure；
Generation module, for generating with described when the corresponding object code of forefront information, and according to the object code
The initial code table is modified, modified initial code table is saved.
Described device in one of the embodiments, further include:
Detection module detects that target column head information information content compared with the initial column head information increases for working as
When, obtain newly-increased column head information；
Second generation module, for generating corresponding newly-increased object code according to the newly-increased column head information, and in institute
It states and increases the newly-increased object code in initial code table.
A kind of computer equipment, including memory and processor, the memory are stored with computer program, the processing
The step of device realizes the above method when executing the computer program.
A kind of computer readable storage medium, is stored thereon with computer program, and the computer program is held by processor
The step of above method is realized when row.
Above-mentioned electronic form data processing method, device, computer equipment and storage medium, server receive electrical form
Data carry electrical form mark in spread-sheet data, and target column head information is then extracted from spread-sheet data, and
Initial column head information corresponding with electrical form mark and initial code table are inquired, secondly judges that the target column head extracted is believed
Whether breath and initial column head information match, and when target column head information and initial column head information mismatch, it fails to match for acquisition
When forefront head information, ultimately produce when the corresponding object code of forefront head information, and initial code is modified according to object code
Table saves modified initial code table.Judge whether the type of spread-sheet data changes by column head information, and generates and change
The corresponding code of column head information after change is modified and is saved to initial code table, with traditional staff according to change
Spreadsheet information again it is secondary write correlative code upload compare, improve the update efficiency of spread-sheet data.
Detailed description of the invention
Fig. 1 is the application scenario diagram of electronic form data processing method in one embodiment；
Fig. 2 is the flow diagram of electronic form data processing method in one embodiment；
The flow diagram for the step of Fig. 3 is the generation method of initial code table in one embodiment；
Fig. 4 is the structural block diagram of spread-sheet data processing unit in one embodiment；
Fig. 5 is the internal structure chart of computer equipment in one embodiment.
Specific embodiment
It is with reference to the accompanying drawings and embodiments, right in order to which the objects, technical solutions and advantages of the application are more clearly understood
The application is further elaborated.It should be appreciated that specific embodiment described herein is only used to explain the application, not
For limiting the application.
Electronic form data processing method provided by the present application can be applied in application environment as shown in Figure 1.Its
In, terminal 102 is communicated by network with server 104.Server 104 receives the spread-sheet data that terminal 102 uploads,
Electrical form mark is carried in spread-sheet data, target column head information is then extracted from spread-sheet data, and inquire
Initial column head information corresponding with electrical form mark and initial code table, secondly judge the target column head information extracted with
And whether initial column head information matches, when target column head information and initial column head information mismatch, obtain that it fails to match works as
Forefront head information generates when the corresponding object code of forefront head information, and modifies initial code table according to object code, and preservation is repaired
Initial code table after changing.Wherein, terminal 102 can be, but not limited to be various personal computers, laptop, intelligent hand
Machine, tablet computer and portable wearable device, server 104 can be formed with the either multiple servers of independent server
Server cluster realize.
In one embodiment, it as shown in Fig. 2, providing a kind of electronic form data processing method, applies in this way
It is illustrated for server 104 in Fig. 1, comprising the following steps:
Step 202, spread-sheet data is received, spread-sheet data carries electrical form mark.
Specifically, the data type in electrical form may include the personal information data of client in enterprise, enterprise and visitor
Transaction data between family, all data of enterprise etc. are counted between enterprise and client by way of electrical form
According to circulation or interim preservation, spread-sheet data is then written as code, is saved in business system, electrical form specifically may be used
Think excel electrical form, Kingsoft WPS etc..Electrical form mark can be used for identifying electrical form before to data modification, just
The column head information of the electrical form of beginning and the corresponding initial code table of initial electrical form.What server receiving terminal uploaded
Spread-sheet data, spread-sheet data carry electrical form mark.
Step 204, target column head information is extracted from spread-sheet data.
Specifically, after server receives the spread-sheet data that terminal uploads, the target in spread-sheet data is extracted
Column head information, target column head information can be the gauge outfit in spread-sheet data, indicate the type of various data, such as in client
In the electrical form of information, target column head information can indicate the type of various customer informations, for example, the name of client, the age,
City etc..
Step 206, initial column head information corresponding with electrical form mark and initial code table are inquired.
Specifically, initial column head information can be electrical form without data modification, the corresponding column of initial electrical form
Head information, initial code table are that initiating electron table is corresponding for saving code table in systems.Server receives
After the spread-sheet data that terminal uploads, the electrical form that inquiry spread-sheet data carries identifies corresponding initial column head information
And initial code table.
Step 208, judge whether target column head information and initial column head information match.
Specifically, after server gets target column head information and initial column head information, judge the target got
Whether column head information and initial column head information are identical, if the change of data class have occurred, the change of data class can be
Increase, reduction and the change of certain definition of data item of data class.
Step 210, when target column head information and initial column head information mismatch, obtain that it fails to match when forefront head
Information.
Specifically, when server judges that target column head information and initial column head information mismatch, illustrate current spreadsheet
The type of data is changed compared with initiating electron table, for example the increase of data class is exactly that data class changes
One kind can increase the name for client, age, city and transaction time by the name of the client in initial table, age, city
Number etc., server obtain after it fails to match when forefront head information.
Step 212, object code corresponding with forefront head information is worked as is generated, and initial code is modified according to object code
Table saves modified initial code table.
Specifically, server can be generated with modified after detecting that change has occurred in data class when forefront head
Information correspondence can upload to the object code of system, modify the corresponding initial code of initial column head information according to object code
Table, the method for modification can increase object code or data such as when the type of data increases in initial code table
When type is reduced, is deleted in initial code table and reduce the corresponding object code of data class, after modification, after modification
Initial code table be saved in system.
In above-mentioned electronic form data processing method, server receives spread-sheet data, carries in spread-sheet data
There is electrical form mark, target column head information is then extracted from spread-sheet data, and inquire corresponding with electrical form mark
Initial column head information and initial code table, secondly judge whether are the target column head information extracted and initial column head information
Matching, when target column head information and initial column head information mismatch, obtain that it fails to match when forefront head information, generate current
The corresponding object code of column head information, and initial code table is modified according to object code, save modified initial code table.It is logical
It crosses and target column head information is judged whether the type of spread-sheet data changes with initial column head information matches, given birth to if changing
At after change when head information corresponding object code in forefront modifies to initial code table, with traditional staff according to
The spreadsheet information of change again it is secondary write correlative code upload compare, improve the update efficiency of spread-sheet data.
In one embodiment, in electronic form data processing method when target column head information and initial column head information not
When matching, then obtain that it fails to match when forefront head information, comprising: when detecting target column head information and initial column head information phase
When increasing than information content, newly-increased column head information is obtained；Object code corresponding with forefront head information is worked as is generated, and according to target
Code revision initial code table, comprising: corresponding newly-increased object code is generated according to newly-increased column head information, and in initial code
Increase newly-increased object code in table.
Specifically, server is after obtaining target column head information and initial column head information, and whether both comparisons match, such as
Both fruits mismatch and detect that target column head information when information content increase, illustrates the electricity received compared with initial column head information
Compared with initiating electron table, data class increased sub-table data, then obtains target column head information and believe than initial column head
Newly-increased column head information is ceased, it is first then according to the newly-increased corresponding newly-increased object code of column head information generation, and in systems
Increase newly-increased object code in beginning code table.For example spread-sheet data includes name, age and the city of client, and service
Device by the column head information of spread-sheet data compared with initial column head information after, find compared with initial column head information, city is
Newly-increased data class then generates the corresponding code " city " in city according to newly-increased data class, corresponding code line is added
The initial code table being added in system.
In above-mentioned electronic form data processing method, server corresponds to code by automatically generating newly-increased data class come more
Change the data in system, compared with traditional manual compiling code saves, has saved human resources, also improved electrical form number
According to update efficiency.
In one embodiment, in electronic form data processing method when target column head information and initial column head information not
When matching, then obtain that it fails to match when forefront head information, comprising: when detecting target column head information and initial column head information phase
When reducing than information content, the column head information deleted is obtained；Object code corresponding with forefront head information is worked as is generated, and according to target
Code revision initial code table, comprising: delete object code according to the column head acquisition of information deleted is corresponding, and in initial code
Object code is deleted in table.
Specifically, server is after obtaining target column head information and initial column head information, and whether both comparisons match, such as
Both fruits mismatch and detect that target column head information when information content reduction, illustrates the electricity received compared with initial column head information
Compared with initiating electron table, data class is reduced sub-table data, then obtains target column head information and believe than initial column head
Cease the column head information deleted, then according to the column head information deleted generate it is corresponding deletes object code, and in systems just
Object code is deleted in beginning code table.For example spread-sheet data includes name, age and the city of client, and service
Device by the column head information of spread-sheet data compared with initial column head information after, find compared with initial column head information, initial column
Further include the telephone number of client in head information, then deletes " tel " code in initial code table according to the data class of reduction
Row.
In above-mentioned electronic form data processing method, server by be automatically deleted reduced data class correspond to code come
Data in change system have saved human resources, have also improved electrical form compared with traditional manual compiling code saves
The update efficiency of data.
In one embodiment, as shown in figure 3, in electronic form data processing method, the generating mode of initial code table,
Include:
Step 302, the corresponding initial verification rule of initial column head information and specification information are obtained.
Specifically, initial verification rule can be the restriction to various aspects such as length, the sizes of initial column head information, such as
When initial column head information is the name of client, corresponding initial verification rule can be with are as follows: the length of customer name must be at 10
Within field, the font of name is necessary for Song typeface etc. rule, and specification information can be, corresponding to initial column head information initial
The restriction of the size of electrical form, such as initiating electron table include that several column equal-specifications of several rows limit.I.e. server is inquiring
After initial column head information, initial verification rule corresponding with initial column head information and specification information are obtained.
Step 304, pre-set code format is obtained, according to pre-set code format, initial column head information, specification information and initial
Verification rule generates initial code table.
Specifically, pre-set code format can be format existing for code in preset system, such as xml, json,
The formats such as database, server is after obtaining pre-set code format, the initial column head that will acquire according to preset code format
Information, specification information and initial verification rule generate initial code table, subsequent that initial code table can be uploaded to system, use
Initial code table is directly modified when data save and data class is modified.
In above-mentioned electronic form data processing method, server passes through pre-set code format, initial column head information, specification letter
Breath and initial verification rule generate initial code table.Initial code table can be used in data preservation and subsequent data class is repaired
Change, improves the efficiency of follow-up data modification.
In one embodiment, a kind of electronic form data processing method is provided, this method may include: to obtain currently
The corresponding newly-increased verification rule of column head information；The newly-increased verification rule of detection whether there is rule conflict with initial verification rule；When
There are deleting when rule conflict, there are the initial verification of rule conflict rules with verification rule for newly-increased verification rule；According to default
Code format, initial column head information, specification information and initial verification rule generate initial code table, comprising: according to pre-set code
Initial verification rule and newly-increased verification rule after format, initial column head information, specification information, deletion generate initial code table.
Specifically, server is judging target column head information and initial column head information mismatch, and obtains what it fails to match
After the head information of forefront, obtains and work as corresponding newly-increased verification rule in the head information of forefront, wherein current verification rule can be pair
When the restriction of the various aspects such as length, the size of forefront head information.Current verification rule and initial verification rule are compared, examined
It surveys and whether there is rule conflict, and when there are rule conflicts there are deleting when rule conflict with verification rule for newly-increased verification rule
Initial verification rule, wherein rule conflict can be the conflict when two kinds of regular existence ranges, size, formats etc., than
Length if initial verification rule is customer name must be within 10 fields, and newly-increased verification rule is the length of customer name
Degree must then delete initial verification rule within 8 fields, there are rule conflict, and pass through newly-increased verification rule and pre-
If the initial verification rule after code format, initial column head information, specification information, deletion generates initial code table.
In above-mentioned electronic form data processing method, there are rule conflicts by newly-increased verification rule substitution for server
Initial verification rule ensure that if verification rule also can be timely with data class when follow-up data type changes
Update and update.
In one embodiment, electronic form data processing method obtains pre-set code format, according to pre-set code format
Initial column head information, specification information and initial verification rule are generated into initial code table, may include: to obtain history codes table,
Extract the corresponding object code format of history codes table；According to object code format, initial column head information, specification information and initial
Verification rule generates initial code table.
Specifically, server is obtaining history codes table, by extracting the object code format in history codes table come really
Surely initial code tableau format is generated, because usually, speed of the system when interpreting the code with history codes format of the same race
Degree faster, shared resource it is less, and if occurring completely new code format in systems, system can solution read it is time-consuming, very
It can not extremely interpret.So server can obtain object code format in history codes table, and getting object code lattice
After formula, according to object code format, initial code table is generated with initial column head information, specification information and initial verification rule.
In above-mentioned electronic form data processing method, server by extract history codes table in object code format come
It determines and generates initial code tableau format, save follow-up system and interpreting time and memory source consumed by code table.
In one embodiment, above-mentioned electronic form data processing method, after receiving spread-sheet data, by sentencing
Whether the type whether disconnected column head information changes to judge spread-sheet data compared with initial column head information changes,
If changing, generates column head information and change the corresponding object code of item to modify initial code table, saved manually again
Write time and the human resources of code.For example, initiating electron list data includes client's such as in enterprise's data
Name and age, the crucial row of the initial code table in corresponding system can be corresponding two row, " name " and " age ",
Server detects that column head information and initial column head information mismatch, not only includes client after receiving spread-sheet data
Name and the age, also include client city, then generate the corresponding code in city " city ", corresponding code line be added to
It in initial code table, is saved in the system of upload, the subsequent data that can directly fill in client in systems.It saves in this way
Human resources also improve the update efficiency of spread-sheet data.
It should be understood that although each step in the flow chart of Fig. 2, Fig. 3 is successively shown according to the instruction of arrow,
It is these steps is not that the inevitable sequence according to arrow instruction successively executes.Unless expressly stating otherwise herein, these steps
There is no stringent sequences to limit for rapid execution, these steps can execute in other order.Moreover, in Fig. 2, Fig. 3 extremely
Few a part of step may include that perhaps these sub-steps of multiple stages or stage are not necessarily same to multiple sub-steps
Moment executes completion, but can execute at different times, and the execution sequence in these sub-steps or stage is also not necessarily
It successively carries out, but in turn or can be handed over at least part of the sub-step or stage of other steps or other steps
Alternately execute.
In one embodiment, as shown in figure 4, providing a kind of spread-sheet data processing unit, comprising: receiving module
402, extraction module 404, enquiry module 406, judgment module 408, acquisition module 410 and generation module 412, in which:
Receiving module 402, for receiving spread-sheet data, spread-sheet data carries electrical form mark.
Extraction module 404, for extracting target column head information from spread-sheet data.
Enquiry module 406, for inquiring initial column head information corresponding with electrical form mark and initial code table.
Judgment module 408, for judging whether target column head information and initial column head information match.
Module 410 is obtained, it fails to match for when target column head information and initial column head information mismatch, then obtaining
When forefront head information.
Generation module 412 for generating object code corresponding with forefront head information is worked as, and is modified just according to object code
Beginning code table saves modified initial code table.
In one embodiment, device can also include:
Detection module, for obtaining when detecting the information content increase compared with initial column head information of target column head information
Newly-increased column head information.
Second generation module, for generating corresponding newly-increased object code according to newly-increased column head information, and in initial generation
Increase newly-increased object code in code table lattice.
In one embodiment, device can also include:
Second detection module, for when detect target column head information compared with initial column head information information content reduce when,
Obtain the column head information deleted.
Module is deleted, for deleting object code according to the column head acquisition of information deleted is corresponding, and in initial code table
Object code is deleted in lattice.
In one embodiment, device can also include:
Second obtains module, for obtaining the corresponding initial verification rule of initial column head information and specification information.
Third obtains module, for obtaining pre-set code format, and according to pre-set code format, initial column head information, rule
Lattice information and initial verification rule generate initial code table.
In one embodiment, device can also include:
4th obtains module, for obtaining when the corresponding newly-increased verification rule of forefront head information.
Third detection module, for detecting newly-increased verification rule with initial verification rule with the presence or absence of rule conflict.
Removing module, for when there are rule conflicts there are deleting when rule conflict with verification rule for newly-increased verification rule
Initial verification rule.
Third generation module, for according to initial after pre-set code format, initial column head information, specification information, deletion
Verification rule and newly-increased verification rule generate initial code table.
In one embodiment, device can also include:
5th obtains module, for obtaining history codes table, extracts the corresponding object code format of history codes table.
4th generation module, for according to object code format, initial column head information, specification information and initial verification rule
Generate initial code table.
Specific restriction about spread-sheet data processing unit may refer to above for spread-sheet data processing
The restriction of method, details are not described herein.Modules in above-mentioned spread-sheet data processing unit can be fully or partially through
Software, hardware and combinations thereof are realized.Above-mentioned each module can be embedded in the form of hardware or independently of the place in computer equipment
It manages in device, can also be stored in a software form in the memory in computer equipment, in order to which processor calls execution or more
The corresponding operation of modules.
In one embodiment, a kind of computer equipment is provided, which can be server, internal junction
Composition can be as shown in Figure 5.The computer equipment include by system bus connect processor, memory, network interface and
Database.Wherein, the processor of the computer equipment is for providing calculating and control ability.The memory packet of the computer equipment
Include non-volatile memory medium, built-in storage.The non-volatile memory medium is stored with operating system, computer program and data
Library.The built-in storage provides environment for the operation of operating system and computer program in non-volatile memory medium.The calculating
The database of machine equipment is for storing spread-sheet data.The network interface of the computer equipment is used to pass through with external terminal
Network connection communication.To realize a kind of electronic form data processing method when the computer program is executed by processor.
It will be understood by those skilled in the art that structure shown in Fig. 5, only part relevant to application scheme is tied
The block diagram of structure does not constitute the restriction for the computer equipment being applied thereon to application scheme, specific computer equipment
It may include perhaps combining certain components or with different component layouts than more or fewer components as shown in the figure.
In one embodiment, a kind of computer equipment, including memory and processor are provided, which is stored with
Computer program, the processor perform the steps of reception spread-sheet data, spread-sheet data when executing computer program
Carry electrical form mark；Target column head information is extracted from spread-sheet data；It inquires corresponding with electrical form mark
Initial column head information and initial code table；Judge whether target column head information and initial column head information match；Work as target column
When head information and initial column head information mismatch, then obtain that it fails to match when forefront head information；It generates and works as forefront head letter
Corresponding object code is ceased, and initial code table is modified according to object code, saves modified initial code table.
In one embodiment, processor executes related when target column head information and initial column when computer program
It when head information mismatches, then obtains that it fails to match when forefront head information, may include: when detecting target column head information and just
When beginning column head information increases compared to information content, newly-increased column head information is obtained；Generate target generation corresponding with forefront head information is worked as
Code, and initial code table is modified according to object code, comprising: in corresponding newly-increased target generation, is generated according to newly-increased column head information
Code, and increase newly-increased object code in initial code table.
In one embodiment, processor executes related when target column head information and initial column when computer program
It when head information mismatches, then obtains that it fails to match when forefront head information, may include: when detecting target column head information and just
When beginning column head information is reduced compared to information content, the column head information deleted is obtained；Generate target generation corresponding with forefront head information is worked as
Code, and initial code table is modified according to object code, comprising: target generation is deleted according to the column head acquisition of information deleted is corresponding
Code, and object code is deleted in initial code table.
In one embodiment, processor executes the generating mode of related initial code table when computer program, can
To include: to obtain the corresponding initial verification rule of initial column head information and specification information；Pre-set code format is obtained, according to pre-
If code format, initial column head information, specification information and initial verification rule generate initial code table.
In one embodiment, acquisition is also performed the steps of when processor executes computer program when forefront head information
Corresponding newly-increased verification rule；The newly-increased verification rule of detection whether there is rule conflict with initial verification rule；When newly-increased verification
There are deleting when rule conflict, there are the initial verification of rule conflict rules with verification rule for rule；According to pre-set code format,
Initial column head information, specification information and initial verification rule generate initial code table, comprising: according to pre-set code format, initially
Initial verification rule and newly-increased verification rule after column head information, specification information, deletion generate initial code table.
In one embodiment, processor executes related acquisition pre-set code format when computer program, according to pre-
It may include: that acquisition is gone through if initial column head information, specification information and initial verification rule are generated initial code table by code format
History code table extracts the corresponding object code format of history codes table；According to object code format, initial column head information, specification
Information and initial verification rule generate initial code table.
In one embodiment, a kind of computer readable storage medium is provided, computer program is stored thereon with, is calculated
Machine program performs the steps of reception spread-sheet data when being executed by processor, spread-sheet data carries electrical form
Mark；Target column head information is extracted from spread-sheet data；Inquire corresponding with electrical form mark initial column head information with
And initial code table；Judge whether target column head information and initial column head information match；When target column head information and initially
When column head information mismatches, then obtain that it fails to match when forefront head information；Generate target generation corresponding with forefront head information is worked as
Code, and initial code table is modified according to object code, save modified initial code table.
In one embodiment, it is related when target column head information and initial when computer program is executed by processor
When column head information mismatches, then obtain that it fails to match when forefront head information, may include: when detect target column head information with
When initial column head information increases compared to information content, newly-increased column head information is obtained；Generate target corresponding with forefront head information is worked as
Code, and initial code table is modified according to object code, comprising: in corresponding newly-increased target generation, is generated according to newly-increased column head information
Code, and increase newly-increased object code in initial code table.
In one embodiment, it is related when target column head information and initial when computer program is executed by processor
When column head information mismatches, then obtain that it fails to match when forefront head information, may include: when detect target column head information with
When initial column head information is reduced compared to information content, the column head information deleted is obtained；Generate target corresponding with forefront head information is worked as
Code, and initial code table is modified according to object code, comprising: target generation is deleted according to the column head acquisition of information deleted is corresponding
Code, and object code is deleted in initial code table.
In one embodiment, the generating mode of related initial code table when computer program is executed by processor,
It may include: to obtain the corresponding initial verification rule of initial column head information and specification information；Pre-set code format is obtained, according to
Pre-set code format, initial column head information, specification information and initial verification rule generate initial code table.
In one embodiment, acquisition is also performed the steps of when computer program is executed by processor when forefront head letter
Cease corresponding newly-increased verification rule；The newly-increased verification rule of detection whether there is rule conflict with initial verification rule；When newly-increased school
Testing rule, there are deleting when rule conflict, there are the initial verification of rule conflict rules with verification rule；According to pre-set code lattice
Formula, initial column head information, specification information and initial verification rule generate initial code table, comprising: according to pre-set code format, just
Initial verification rule and newly-increased verification rule after beginning column head information, specification information, deletion generate initial code table.
In one embodiment, related acquisition pre-set code format when computer program is executed by processor, according to
Initial column head information, specification information and initial verification rule are generated initial code table by pre-set code format, may include: to obtain
History codes table extracts the corresponding object code format of history codes table；According to object code format, initial column head information, rule
Lattice information and initial verification rule generate initial code table.
Those of ordinary skill in the art will appreciate that realizing all or part of the process in above-described embodiment method, being can be with
Relevant hardware is instructed to complete by computer program, the computer program can be stored in a non-volatile computer
In read/write memory medium, the computer program is when being executed, it may include such as the process of the embodiment of above-mentioned each method.Wherein,
To any reference of memory, storage, database or other media used in each embodiment provided herein,
Including non-volatile and/or volatile memory.Nonvolatile memory may include read-only memory (ROM), programming ROM
(PROM), electrically programmable ROM (EPROM), electrically erasable ROM (EEPROM) or flash memory.Volatile memory may include
Random access memory (RAM) or external cache.By way of illustration and not limitation, RAM is available in many forms,
Such as static state RAM (SRAM), dynamic ram (DRAM), synchronous dram (SDRAM), double data rate sdram (DDRSDRAM), enhancing
Type SDRAM (ESDRAM), synchronization link (Synchlink) DRAM (SLDRAM), memory bus (Rambus) direct RAM
(RDRAM), direct memory bus dynamic ram (DRDRAM) and memory bus dynamic ram (RDRAM) etc..
Each technical characteristic of above embodiments can be combined arbitrarily, for simplicity of description, not to above-described embodiment
In each technical characteristic it is all possible combination be all described, as long as however, the combination of these technical characteristics be not present lance
Shield all should be considered as described in this specification.
The several embodiments of the application above described embodiment only expresses, the description thereof is more specific and detailed, but simultaneously
It cannot therefore be construed as limiting the scope of the patent.It should be pointed out that coming for those of ordinary skill in the art
It says, without departing from the concept of this application, various modifications and improvements can be made, these belong to the protection of the application
Range.Therefore, the scope of protection shall be subject to the appended claims for the application patent.
Claims (10)
1. a kind of electronic form data processing method, which comprises
Spread-sheet data is received, the spread-sheet data carries electrical form mark；
Target column head information is extracted from the spread-sheet data；
Inquire initial column head information corresponding with electrical form mark and initial code table；
Judge whether the target column head information and the initial column head information match；
When the target column head information and the initial column head information mismatch, then obtains the forefront head of working as that it fails to match and believe
Breath；
It generates with described when the corresponding object code of forefront head information, and according to the object code modification initial code
Table saves modified initial code table.
2. the method according to claim 1, wherein described when target column head information and the initial column head are believed
When breath mismatches, then obtain that it fails to match when forefront head information, comprising:
When detecting target column head information information content increase compared with the initial column head information, newly-increased column head is obtained
Information；
The generation with described when the corresponding object code of forefront head information, and according to the object code modification initial generation
Code table, comprising:
Corresponding newly-increased object code is generated according to the newly-increased column head information, and increases institute in the initial code table
State newly-increased object code.
3. the method according to claim 1, wherein described when target column head information and the initial column head are believed
When breath mismatches, then obtain that it fails to match when forefront head information, comprising:
When detecting target column head information information content reduction compared with the initial column head information, the column head deleted is obtained
Information；
The generation with described when the corresponding object code of forefront head information, and according to the object code modification initial generation
Code table, comprising:
Object code is deleted according to the column head acquisition of information deleted is corresponding, and deletes institute in the initial code table
It states and deletes object code.
4. the method according to claim 1, wherein the generating mode of the initial code table, comprising:
Obtain the corresponding initial verification rule of the initial column head information and specification information；
Pre-set code format is obtained, according to the pre-set code format, the initial column head information, specification information and initial verification
Rule generates initial code table.
5. according to the method described in claim 4, it is characterized in that, the method also includes:
It obtains described when the corresponding newly-increased verification rule of forefront head information；
The newly-increased verification rule is detected with the initial verification rule with the presence or absence of rule conflict；
When there are deleting when rule conflict, there are the initial verifications of rule conflict with the verification rule for the newly-increased verification rule
Rule；
It is described that initial code is generated according to pre-set code format, the initial column head information, specification information and initial verification rule
Table, comprising:
According to the initial verification rule and newly-increased verification after pre-set code format, the initial column head information, specification information, deletion
Rule generates initial code table.
6. according to the method described in claim 4, it is characterized in that, the acquisition pre-set code format, according to the default generation
The initial column head information, specification information and initial verification rule are generated initial code table by code format, comprising:
History codes table is obtained, the corresponding object code format of the history codes table is extracted；
Initial code is generated according to the object code format, the initial column head information, specification information and initial verification rule
Table.
7. a kind of spread-sheet data processing unit, which is characterized in that described device includes:
Receiving module, for receiving spread-sheet data, the spread-sheet data carries electrical form mark；
Extraction module, for extracting target column head information from the spread-sheet data；
Enquiry module, for inquiring initial column head information corresponding with electrical form mark and initial code table；
Judgment module, for judging whether the target column head information and the initial column head information match；
Module is obtained, for when the target column head information and initial column head information mismatch, then obtaining matching and losing
That loses works as forefront head information；
Generation module, for generating with described when the corresponding object code of forefront head information, and according to object code modification
The initial code table saves modified initial code table.
8. device according to claim 7, which is characterized in that described device includes:
Detection module, for when detect the target column head information compared with the initial column head information information content increase when,
Obtain newly-increased column head information；
Second generation module, for generating corresponding newly-increased object code according to the newly-increased column head information, and described first
Increase the newly-increased object code in beginning code table.
9. a kind of computer equipment, including memory and processor, the memory are stored with computer program, feature exists
In the step of processor realizes any one of claims 1 to 6 the method when executing the computer program.
10. a kind of computer readable storage medium, is stored thereon with computer program, which is characterized in that the computer program
The step of method described in any one of claims 1 to 6 is realized when being executed by processor.
Priority Applications (2)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910082337.4A CN109902272B (en) | 2019-01-28 | 2019-01-28 | Electronic form data processing method, electronic form data processing device, computer equipment and storage medium |
| PCT/CN2019/118376 WO2020155771A1 (en) | 2019-01-28 | 2019-11-14 | Spreadsheet data processing method and apparatus, computer device, and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910082337.4A CN109902272B (en) | 2019-01-28 | 2019-01-28 | Electronic form data processing method, electronic form data processing device, computer equipment and storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN109902272A true CN109902272A (en) | 2019-06-18 |
| CN109902272B CN109902272B (en) | 2024-02-06 |
Family
ID=66944319
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910082337.4A Active CN109902272B (en) | 2019-01-28 | 2019-01-28 | Electronic form data processing method, electronic form data processing device, computer equipment and storage medium |
Country Status (2)
| Country | Link |
|---|---|
| CN (1) | CN109902272B (en) |
| WO (1) | WO2020155771A1 (en) |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110705226A (en) * | 2019-08-22 | 2020-01-17 | 平安科技（深圳）有限公司 | Spreadsheet creating method and device and computer equipment |
| WO2020155771A1 (en) * | 2019-01-28 | 2020-08-06 | 平安科技（深圳）有限公司 | Spreadsheet data processing method and apparatus, computer device, and storage medium |
| CN112966481A (en) * | 2019-12-13 | 2021-06-15 | 北京懿医云科技有限公司 | Data table display method and device |
| CN113254520A (en) * | 2021-06-03 | 2021-08-13 | 武汉众邦银行股份有限公司 | Method for processing credit investigation data missing report and automatically generating supplementary message |
| CN113312881A (en) * | 2021-05-06 | 2021-08-27 | 上海移远通信技术股份有限公司 | Frequency band information conversion method and device, electronic equipment and computer storage medium |
| CN115757423A (en) * | 2022-11-29 | 2023-03-07 | 中诚智信工程咨询集团股份有限公司 | Engineering cost data correction method, system, equipment and storage medium |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104298517A (en) * | 2014-07-08 | 2015-01-21 | 中标软件有限公司 | Software updating method and system |
| CN109062883A (en) * | 2018-07-18 | 2018-12-21 | 平安科技（深圳）有限公司 | Tables of data dynamic deriving method, device, computer equipment and storage medium |
Family Cites Families (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US9588954B2 (en) * | 2013-06-15 | 2017-03-07 | Microsoft Technology Licensing, Llc | Application/document collaboration in a multi-device environment |
| CN109062925B (en) * | 2018-06-06 | 2023-08-22 | 中国平安人寿保险股份有限公司 | Method, device, computer equipment and storage medium for automatically generating insert sentences |
| CN109271411B (en) * | 2018-09-28 | 2023-08-29 | 中国平安财产保险股份有限公司 | Report generation method, report generation device, computer equipment and storage medium |
| CN109902272B (en) * | 2019-01-28 | 2024-02-06 | 平安科技（深圳）有限公司 | Electronic form data processing method, electronic form data processing device, computer equipment and storage medium |
-
2019
- 2019-01-28 CN CN201910082337.4A patent/CN109902272B/en active Active
- 2019-11-14 WO PCT/CN2019/118376 patent/WO2020155771A1/en active Application Filing
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104298517A (en) * | 2014-07-08 | 2015-01-21 | 中标软件有限公司 | Software updating method and system |
| CN109062883A (en) * | 2018-07-18 | 2018-12-21 | 平安科技（深圳）有限公司 | Tables of data dynamic deriving method, device, computer equipment and storage medium |
Cited By (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2020155771A1 (en) * | 2019-01-28 | 2020-08-06 | 平安科技（深圳）有限公司 | Spreadsheet data processing method and apparatus, computer device, and storage medium |
| CN110705226A (en) * | 2019-08-22 | 2020-01-17 | 平安科技（深圳）有限公司 | Spreadsheet creating method and device and computer equipment |
| CN112966481A (en) * | 2019-12-13 | 2021-06-15 | 北京懿医云科技有限公司 | Data table display method and device |
| CN112966481B (en) * | 2019-12-13 | 2023-09-29 | 北京懿医云科技有限公司 | Data form display method and device |
| CN113312881A (en) * | 2021-05-06 | 2021-08-27 | 上海移远通信技术股份有限公司 | Frequency band information conversion method and device, electronic equipment and computer storage medium |
| CN113312881B (en) * | 2021-05-06 | 2024-04-05 | 上海移远通信技术股份有限公司 | Frequency band information conversion method and device, electronic equipment and computer storage medium |
| CN113254520A (en) * | 2021-06-03 | 2021-08-13 | 武汉众邦银行股份有限公司 | Method for processing credit investigation data missing report and automatically generating supplementary message |
| CN115757423A (en) * | 2022-11-29 | 2023-03-07 | 中诚智信工程咨询集团股份有限公司 | Engineering cost data correction method, system, equipment and storage medium |
| CN115757423B (en) * | 2022-11-29 | 2024-01-30 | 中诚智信工程咨询集团股份有限公司 | Engineering cost data correction method, system, equipment and storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN109902272B (en) | 2024-02-06 |
| WO2020155771A1 (en) | 2020-08-06 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109902272A (en) | Electronic form data processing method, device, computer equipment and storage medium | |
| CN110069449B (en) | File processing method, device, computer equipment and storage medium | |
| CN109558404B (en) | Data storage method, device, computer equipment and storage medium | |
| CN109542428A (en) | Method for processing business, device, computer equipment and storage medium | |
| CN108334625B (en) | User information processing method and device, computer equipment and storage medium | |
| CN108629567A (en) | Declaration information processing method, device, computer equipment and storage medium | |
| CN108509424A (en) | Institutional information processing method, device, computer equipment and storage medium | |
| CN108874661A (en) | Test mapping relations library generating method, device, computer equipment and storage medium | |
| CN106445815B (en) | A kind of automated testing method and device | |
| CN110990390A (en) | Data cooperative processing method and device, computer equipment and storage medium | |
| CN109144799A (en) | Integrated testing method, apparatus, computer equipment and storage medium | |
| CN109308305A (en) | Querying method, device and the computer equipment of monitoring data | |
| CN109325058B (en) | Rule batch comparison method, device, computer equipment and storage medium | |
| CN110795171A (en) | Service data processing method and device, computer equipment and storage medium | |
| CN112286934A (en) | Database table importing method, device, equipment and medium | |
| CN111191079A (en) | Document content acquisition method, device, equipment and storage medium | |
| CN113949889A (en) | Object processing method and device, electronic equipment and storage medium | |
| CN109785867A (en) | Double record process configuration methods, device, computer equipment and storage medium | |
| CN109359176A (en) | Data extraction method, device, computer equipment and storage medium | |
| CN110362478A (en) | Application upgrade test method, device, computer equipment and storage medium | |
| CN107766228B (en) | Multi-language-based automatic testing method and device | |
| CN114416847A (en) | Data conversion method, device, server and storage medium | |
| CN112632266B (en) | Data writing method and device, computer equipment and readable storage medium | |
| CN105447012B (en) | A kind of write-in mutual exclusion method and device for database | |
| CN110442478A (en) | Product failure processing method, device, computer 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 |