CN107463868A - A kind of electronic spreadsheet verification method and device - Google Patents
A kind of electronic spreadsheet verification method and device Download PDFInfo
- Publication number
- CN107463868A CN107463868A CN201610392180.1A CN201610392180A CN107463868A CN 107463868 A CN107463868 A CN 107463868A CN 201610392180 A CN201610392180 A CN 201610392180A CN 107463868 A CN107463868 A CN 107463868A
- Authority
- CN
- China
- Prior art keywords
- veritified
- electronic spreadsheet
- detection zone
- veritify
- electronic
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06V—IMAGE OR VIDEO RECOGNITION OR UNDERSTANDING
- G06V30/00—Character recognition; Recognising digital ink; Document-oriented image-based pattern recognition
- G06V30/40—Document-oriented image-based pattern recognition
- G06V30/41—Analysis of document content
- G06V30/414—Extracting the geometrical structure, e.g. layout tree; Block segmentation, e.g. bounding boxes for graphics or text
Abstract
The invention discloses a kind of electronic spreadsheet verification method and device, is veritified for treating veritification electronic spreadsheet.The checking method is according to default location factor, the coordinate points corresponding to searching location factor in electronic spreadsheet to be veritified, and the elements of a fix point in electronic spreadsheet to be veritified is determined according to the condition of setting, and determines the summit of form in electronic spreadsheet to be veritified；And single mode plate is veritified according to the summit of form in electronic spreadsheet to be veritified and standard, it is determined that the detection zone in electronic spreadsheet to be veritified；Image procossing finally is carried out to detection zone, judges whether electronic spreadsheet to be veritified meets to veritify and requires.Electronic spreadsheet of the present invention, which veritifies device, includes detection zone determining module and image processing module.The method and device of the present invention, detection zone is divided by image procossing, detection zone is detected to judge to veritify result, improves veritification efficiency.
Description
Technical field
The invention belongs to field of computer technology, more particularly to a kind of electronic spreadsheet verification method and device.
Background technology
With the development of computer technology and internet, electronic spreadsheet is transmitted by network, without posting paper
File has become a kind of conventional means of office.But in the application scenario for needing to veritify electronic spreadsheet, still need
Manually to carry out the veritification of electronic spreadsheet.
Such as website record information authenticity is veritified, it is necessary to which " website record information authenticity is veritified single " is sent into service
Provider, such as Tengxun's cloud, new net, A-1. Net etc. externally provide the manufacturer of cloud computing service, are then led to by service provider
Cross and manually " website record information authenticity is veritified single " is veritified, veritify the authenticity that material is provided, it is logical for veritifying
That crosses allows to be put on record, otherwise allows user to provide again.
By manually being veritified to electronic spreadsheets such as " website record information authenticities veritify single ", add personnel into
This, and verification procedure is easily slipped.Artificial factor is especially the introduction of, is easily caused due to artificial subjective evaluation
The injustice result brought.
The content of the invention
It is an object of the invention to provide a kind of electronic spreadsheet verification method and device, detection zone is divided by image procossing
Domain, detection zone is detected to judge to veritify result, solve prior art and veritify the low technical problem of efficiency.
To achieve these goals, technical solution of the present invention is as follows：
A kind of electronic spreadsheet checking method, veritified for treating veritification electronic spreadsheet, the checking method includes：
From the electronic spreadsheet to be veritified of input, it is determined that the detection zone for veritification；
Image procossing is carried out to detection zone, judges whether electronic spreadsheet to be veritified meets to veritify and requires.
Further, in the electronic spreadsheet to be veritified from input, it is determined that the detection zone for veritification, including：
According to default location factor, the coordinate points corresponding to searching location factor in electronic spreadsheet to be veritified, and according to
The condition of setting determines the elements of a fix point in electronic spreadsheet to be veritified；
Elements of a fix point and standard in electronic spreadsheet to be veritified veritify single mode plate, it is determined that in electronic spreadsheet to be veritified
The summit of form；
Single mode plate is veritified according to the summit of form in electronic spreadsheet to be veritified and standard, it is determined that in electronic spreadsheet to be veritified
Detection zone.
Further, the summit of form and standard veritify single mode plate in basis electronic spreadsheet to be veritified, it is determined that treating core
The detection zone tested in electronic spreadsheet, in addition to：
Single mode plate is veritified according to the summit of form in electronic spreadsheet to be veritified and standard, calculated in electronic spreadsheet to be veritified
Detection zone apex coordinate.
Further, the checking method, it is determined that after for the detection zone of veritification, in addition to：
According to the coordinate on form summit in the apex coordinate of detection zone in electronic spreadsheet to be veritified and electronic spreadsheet to be veritified,
Judge whether electronic spreadsheet to be veritified meets veritification condition, image procossing is carried out to detection zone if meeting, judges to wait to veritify
Whether electronic spreadsheet, which meets to veritify, requires, otherwise directly judges that electronic spreadsheet to be veritified is unsatisfactory for veritifying and requires.
It is of the present invention that image procossing is carried out to detection zone, judge whether electronic spreadsheet to be veritified meets to veritify and require, bag
Include：
The pixel color of image in each detection zone is obtained by the method for image procossing；
Calculate the accounting of each color pixel in each detection zone；
The accounting of the pixel set according to each detection zone, judges whether each detection zone is qualified；
If all detection zones are all qualified, then it is assumed that electronic spreadsheet to be veritified, which meets to veritify, to be required, otherwise it is assumed that being unsatisfactory for
Veritify and require.
The invention also provides a kind of electronic spreadsheet veritification device, is veritified for treating veritification electronic spreadsheet, described
Electronic spreadsheet, which veritifies device, to be included：
Detection zone determining module, for from the electronic spreadsheet to be veritified of input, it is determined that the detection zone for veritification；
Image processing module, for carrying out image procossing to detection zone, judge whether electronic spreadsheet to be veritified meets to veritify
It is required that.
Further, the detection zone determining module is from the electronic spreadsheet to be veritified of input, it is determined that the inspection for veritification
Area is surveyed, performs following operation：
According to default location factor, the coordinate points corresponding to searching location factor in electronic spreadsheet to be veritified, and according to
The condition of setting determines the elements of a fix point in electronic spreadsheet to be veritified；
Elements of a fix point and standard in electronic spreadsheet to be veritified veritify single mode plate, it is determined that in electronic spreadsheet to be veritified
The summit of form；
Single mode plate is veritified according to the summit of form in electronic spreadsheet to be veritified and standard, it is determined that in electronic spreadsheet to be veritified
Detection zone.
Further, the detection zone determining module is veritified single according to the summit of form in electronic spreadsheet to be veritified and standard
Template, it is determined that the detection zone in electronic spreadsheet to be veritified, also performs following operation：
Single mode plate is veritified according to the summit of form in electronic spreadsheet to be veritified and standard, calculated in electronic spreadsheet to be veritified
Detection zone apex coordinate.
Further, the electronic spreadsheet veritifies device, in addition to judge module, the judge module are used for：
According to the coordinate on form summit in the apex coordinate of detection zone in electronic spreadsheet to be veritified and electronic spreadsheet to be veritified,
Judge whether electronic spreadsheet to be veritified meets veritification condition, image procossing is carried out to detection zone if meeting, judges to wait to veritify
Whether electronic spreadsheet, which meets to veritify, requires, otherwise directly judges that electronic spreadsheet to be veritified is unsatisfactory for veritifying and requires.
Image processing module of the present invention carries out image procossing to detection zone, judges whether electronic spreadsheet to be veritified meets
Veritify and require, perform following operation：
The pixel color of image in each detection zone is obtained by the method for image procossing；
Calculate the accounting of each color pixel in each detection zone；
The accounting of the pixel set according to each detection zone, judges whether each detection zone is qualified；
If all detection zones are all qualified, then it is assumed that electronic spreadsheet to be veritified, which meets to veritify, to be required, otherwise it is assumed that being unsatisfactory for
Veritify and require.
A kind of electronic spreadsheet verification method and device proposed by the present invention, by determining to detect from the electronic spreadsheet of input
Area, image procossing then is carried out to detection zone, required to judge whether electronic spreadsheet to be veritified meets to veritify.It can realize and be directed to
Cloud computing service business puts on record the true veritification list sought unity of standard in business, submits the veritification free hand drawing piece to come up to do high efficiency user
Detection, it is quick to judge.Relative to the various straight-line detection methods in image procossing morphology, cross detection method, contour detecting etc.
Method, have and computing terminal requirement is not done, processing time is short, easily realized on mobile phone terminal the features such as.
Brief description of the drawings
Fig. 1 is that website of embodiment of the present invention record information authenticity veritifies list；
Fig. 2 is the flow chart of electronic spreadsheet checking method of the present invention；
Fig. 3 is the elements of a fix of the embodiment of the present invention point location drawing；
Fig. 4 is form vertex position figure of the embodiment of the present invention.
Embodiment
Technical solution of the present invention is described in further details with reference to the accompanying drawings and examples, following examples are not formed
Limitation of the invention.
The present embodiment is by taking the veritification of website record information authenticity as an example, by " website record information authenticity is veritified single "
Veritified to elaborate a kind of electronic spreadsheet verification method and device of the present invention, the veritification for other electronic spreadsheets is same
It is applicable." website record information authenticity is veritified single " is sentenced, it is necessary to carry out detection to detection zones such as Q1, Q2, Z1, Z2 as shown in Figure 1
It is disconnected, whether qualified obtain veritification result.
Fig. 2 shows a kind of flow chart of electronic spreadsheet checking method of the present embodiment, including：
Step S1, from the electronic spreadsheet to be veritified of input, it is determined that the detection zone for veritification.
Current embodiment require that determining detection zone from electronic spreadsheet to be veritified, so-called detection zone is exactly, it is necessary to examine when veritifying
The pixel in the region is surveyed, to determine whether to veritify the region passed through.
The electronic spreadsheet to be veritified commonly entered, it is the single soft copy of the veritification being scanned through, the present embodiment is so that " website is standby
Case information authenticity is veritified single " exemplified by, as shown in figure 1, Q1, Q2, Z1, Z2 therein are the detection zone for needing to detect, it is right respectively
People's signature, website director signature, access service unit stamp and website unit official seal should be veritified.
From the electronic spreadsheet to be veritified of input, it is determined that the detection zone for veritification, available method is a lot.Such as can be with
Using the template of setting, detection zone delimited in template, template be compared with electronic spreadsheet to be veritified, found pair
The detection zone answered.
In order to improve accuracy, it is preferable that the present embodiment is from the electronic spreadsheet to be veritified of input, it is determined that for veritification
Detection zone, including：
F1, according to default location factor, coordinate points corresponding to location factor, and root are found in electronic spreadsheet to be veritified
The elements of a fix point in electronic spreadsheet to be veritified is determined according to the condition of setting.
Electronic spreadsheet to be veritified be scanned through obtain soft copy, scanning due to there may be it is crooked, therefore
Detection zone therein is correctly identified out, for judging whether to veritify by extremely important.The present embodiment is first according to standard
Single mode plate is veritified, determines location factor, the position of effective coverage in veritification list is determined subsequently through the location factor.
For example, " website record information authenticity is veritified single " of the present embodiment, its top half are to veritify content, lower half
It is divided into the signature and official seal of signature, the signature and official seal of the latter half is generally veritified when veritifying.And top half is form shape
Formula, wherein each form has four angles, the both ends of line show as a vertical curve and a horizontal stroke between two neighboring form
Line intersects vertically.The present embodiment intersects vertically a vertical curve and a horizontal line, and the position that vertical curve both ends are all lifted one's head
It is preset as location factor.
Therefore according to default location factor, all coordinates for meeting condition are easily found in electronic spreadsheet to be veritified
Point, as shown in figure 3, in figure circle enclose come be all the coordinate points found.The coordinate points found are relatively more, it is only necessary to wherein few
Number coordinate points are used for follow-up positioning, and the coordinate points for being used as subsequently positioning are referred to as elements of a fix point by the present embodiment.At this
In embodiment, coordinate points A, coordinate points B, coordinate points C is selected to be used as elements of a fix point.
It as elements of a fix point is selected according to following condition to select coordinate points A, coordinate points B, coordinate points C：
Take the candidate that two minimum points of y-coordinate are A or C, wherein x values are small for A, x values greatly for C；
The candidate that the maximum point of y-coordinate is B is taken, what wherein x values were minimum is defined as B points.
The method of above-mentioned selected elements of a fix point is only a kind of embodiment, is relatively easily found.It is easily understood that may be used also
To select other coordinate points to be simply used for determining that the specific formula of coordinate is different in subsequent step, not shadow as elements of a fix point
Ring the implementation result of the present invention.
It should be noted that when coordinate points corresponding to location factor are found in veritifying electronic spreadsheet, can be somebody's turn to do
Coordinate of the coordinate points in electronic spreadsheet to be veritified.The length and width of general electronic spreadsheet to be veritified are represented using pixel, also may be used
To be represented using long measure, the present embodiment illustrates so that pixel represents as an example.
Therefore after elements of a fix point is determined, it is possible to obtain the coordinate of elements of a fix point, it is assumed that obtained coordinate points
A, coordinate points B, coordinate points C coordinate are respectively：(xA, yA)、(xB, yB)、(xC, yC)。
F2, the elements of a fix point in basis electronic spreadsheet to be veritified and standard veritify single mode plate, it is determined that electronic watch to be veritified
The summit of form in list.
In the electronic spreadsheet to be veritified of scanning, really need to identify is form therein, by the top for determining the form
Point has determined that the scope of form.It is top left corner apex WN respectively as shown in figure 4, form has four summits, upper right angular vertex
EN, lower-left angular vertex WS, bottom right angular vertex ES.
It is respectively (x in known coordinate point A, coordinate points B, coordinate points C coordinateA, yA)、(xB, yB)、(xC, yC) situation
Under, it is not difficult to obtain the coordinate on each summit：
Assuming that WN coordinate is (xWN, yWN), then xWN=xA, yWN=yA-W*α；
Assuming that EN coordinate is (xEN, yEN), then xEN=xC, yEN=yC-W*α；
Assuming that WS coordinate is (xWS, yWS), then xWS=xB, yWS=yB+W*β；
Assuming that ES coordinate is (xES, yES), then xES=xC, yES=yB+W*β；
The wherein width W=x of formC-xA, the width W of the form is a number that can be determined by elements of a fix point
Value, the coordinate on each summit can be calculated according to the numerical value.And to be veritified in standard on single mode plate, it is assumed that the width of form is W ',
Due to scanning, W and W ' may be differed, but the ratio of the distance between electronic spreadsheet midpoint to be veritified and point than upper W
Value, veritify ratio of the distance than upper W ' on single mode plate between points with standard, it should be the same.Electronic watch i.e. to be veritified
It is singly that standard veritifies zooming in or out for single mode plate, therefore can be according to the width W of form come the coordinate on summit in computation sheet.
Wherein, α and β is the parameter of setting, and the parameter veritifies single mode plate to be calculated according to standard.Such as in standard core
In verification certificate template, the ordinate y of WS pointsWS=yB+ W ' * β, then coordinate actual on single mode plate is veritified according to standard, can be calculated
β is obtained, α can equally be calculated, repeat no more here.α is 0.08, β 0.55 in the present embodiment.
So as to which the summit of form in electronic spreadsheet to be veritified be determined according to elements of a fix point.
The summit of form and standard veritify single mode plate in F3, basis electronic spreadsheet to be veritified, it is determined that electronic spreadsheet to be veritified
In detection zone.
It is identical with the reason for calculating apex coordinate, veritified according to the width W and standard of the form having determined on single mode plate
The position of detection zone, the detection zone position in electronic spreadsheet to be veritified can be conversed.
The present embodiment is as follows as calculating reference, calculating process using the WS point coordinates having determined：
1) Q1 detection zones position：
Q1 left upper apex y-coordinate=WS ordinate yWS-(W*t1)
Q1 left upper apex x coordinate=WS abscissa xWS+(W*t2)
Q1 bottom right vertex y-coordinate=WS ordinate yWS-(W*t3)
Q1 bottom right vertex x coordinate=WS abscissa xWS+(W*t4)
2) Q2 detection zones position：
Q2 left upper apex y-coordinate=WS ordinate yWS-(W*t5)
Q2 left upper apex x coordinate=WS abscissa xWS+(W*t6)
Q2 bottom right vertex y-coordinate=WS ordinate yWS-(W*t7)
Q2 bottom right vertex x coordinate=WS abscissa xWS+(W*t8)
3) Z1 detection zones position：
Z1 left upper apex y-coordinate=WS ordinate yWS-(W*t9)
Z1 left upper apex x coordinate=WS abscissa xWS+(W*t10)
Z1 bottom right vertex y-coordinate=WS ordinate yWS-(W*t11)
Z1 bottom right vertex x coordinate=WS abscissa xWS+(W*t12)
4) Z2 detection zones position：
Z1 left upper apex y-coordinate=WS ordinate yWS-(W*t13)
Z1 left upper apex x coordinate=WS abscissa xWS+(W*t14)
Z1 bottom right vertex y-coordinate=WS ordinate yWS-(W*t15)
Z1 bottom right vertex x coordinate=WS abscissa xWS+(W*t16)
Wherein, t1~t16 is the parameter of setting, and the position that these parameters veritify detection zone on single mode plate according to standard calculates
Obtain, repeat no more here.T1 takes 0.38, t2 to take 0.16, t3 to take 0.28, t4 to take 0.49, t5 to take 0.18, t6 to take in the present embodiment
0.19, t7 takes 0.08, t8 to take 0.40, t9 to take 0.38, t10 to take 0.71, t11 to take 0.26, t12 to take 0.99, t13 to take 0.19, t14 to take
0.40, t15 takes 0.99, t16 to take 0.99.
It should be noted that in the present embodiment, the scope of detection zone is assured that according only to WS coordinate, certainly
It can also be calculated according to the coordinate on any summit in four summits.And calculate WS coordinate, it is only necessary to know coordinate points B
It is calculated with coordinate points C coordinate can.Therefore, the present invention need according to the situation of specific electronic spreadsheet to be veritified come
The coordinate of elements of a fix point and the coordinate on summit are calculated, different electronic spreadsheets to be veritified needs elements of a fix point corresponding to setting
And summit, to determine the scope of detection zone, repeat no more here.
Step S2, image procossing is carried out to detection zone, judges whether electronic spreadsheet to be veritified meets to veritify and require.
For electronic spreadsheet to be veritified, content is veritified according to specific, is required it is determined that veritifying, and the side for passing through image procossing
Method obtains the shape of image, figure, pixel color etc. in detection zone, specifically to be judged.
The present embodiment Q1, Q2, Z1, Z2 are the detection zone for needing to detect, and correspond to veritify people's signature, website director label respectively
Word, access service unit stamp and website unit official seal, are judged according to pixel color in detection zone, are veritified and are required such as
Under：
The veritification requirement of Q1 detection zones is that white pixel accounting is more than 99%, and it is qualified to be considered as；
The veritification requirement of Q2 detection zones is that white pixel accounting is less than 97%, and it is qualified to be considered as；
The veritification requirement of Z1 detection zones is that white pixel accounting is more than 99%, and it is qualified to be considered as；
The veritification requirement of Z2 detection zones is that red pixel accounting is more than 10%, and it is qualified to be considered as.
The pixel color of image in each detection zone is then obtained by image procossing, calculates each colored pixels in each detection zone
Accounting, the accounting of the pixel set according to each detection zone judges whether each detection zone qualified, if all detection zones are all
It is qualified, then it is assumed that electronic spreadsheet to be veritified, which meets to veritify, to be required, is required otherwise it is assumed that being unsatisfactory for veritifying.
The method for wherein carrying out image procossing is a lot, such as carries out image procossing using OpenCV vision processing algorithms,
Obtain the color of all pixels in detection zone.The invention is not restricted to use which kind of specific image processing method.
Further, the electronic spreadsheet checking method of the present embodiment, it is determined that after for the detection zone of veritification, also wrap
Include：
According to the coordinate on form summit in the apex coordinate of detection zone in electronic spreadsheet to be veritified and electronic spreadsheet to be veritified,
Judge whether electronic spreadsheet to be veritified meets veritification condition, image procossing is carried out to detection zone if meeting, judges to wait to veritify
Whether electronic spreadsheet, which meets to veritify, requires, otherwise directly judges that electronic spreadsheet to be veritified is unsatisfactory for veritifying and requires.
The present embodiment calculates four summits in electronic spreadsheet to be veritified, and at detection and localization area, only used one
Summit.In fact, other three summits calculated are also useful, can be used for judging whether electronic spreadsheet to be veritified meets
Veritification condition.
Judge whether electronic spreadsheet to be veritified meets veritification condition for example with summit ES, WS：
The x coordinate of the left upper apex of Q1 detection zones<WS abscissa xWS, it is considered as and is unsatisfactory for veritification condition, that is, waits to veritify electricity
Sublist single image is unqualified.
Or, the y-coordinate of the bottom left vertex of Q2 detection zones>WS ordinate yWS, it is considered as and is unsatisfactory for veritification condition, that is, waits to veritify
Electronic spreadsheet image is unqualified.
Or, the x coordinate of the right vertices of Z1 detection zones>ES abscissa xES, it is considered as and is unsatisfactory for veritification condition, that is, waits to veritify
Electronic spreadsheet image is unqualified.
Or, the x coordinate of the right vertices of Z2 detection zones>ES abscissa xES, it is considered as and is unsatisfactory for veritification condition, that is, waits to veritify
Electronic spreadsheet image is unqualified.
Or, the y-coordinate of the bottom right vertex of Z2 detection zones>ES ordinate yES, it is considered as and is unsatisfactory for veritification condition, that is, waits to veritify
Electronic spreadsheet image is unqualified.
Above-mentioned judgement does not list all Rule of judgment, according to the concrete condition of electronic spreadsheet to be veritified, Ke Yigen
According to the position of detection zone and the coordinate on summit, to judge whether the image of electronic spreadsheet to be veritified scans accurate, can be used for
It is determined further, if image is unqualified, is directly judged as veritifying unqualified.
The invention also provides a kind of electronic spreadsheet veritification device, is veritified for treating veritification electronic spreadsheet, the electricity
Sublist monokaryon experiment device includes：
Detection zone determining module, for from the electronic spreadsheet to be veritified of input, it is determined that the detection zone for veritification；
Image processing module, for carrying out image procossing to detection zone, judge whether electronic spreadsheet to be veritified meets to veritify
It is required that.
Corresponding with the above method, the present embodiment electronic spreadsheet is veritified each module of device and is described as follows：
The present embodiment detection zone determining module is from the electronic spreadsheet to be veritified of input, it is determined that the detection zone for veritification,
Perform following operation：
According to default location factor, the coordinate points corresponding to searching location factor in electronic spreadsheet to be veritified, and according to
The condition of setting determines the elements of a fix point in electronic spreadsheet to be veritified；
Elements of a fix point and standard in electronic spreadsheet to be veritified veritify single mode plate, it is determined that in electronic spreadsheet to be veritified
The summit of form；
Single mode plate is veritified according to the summit of form in electronic spreadsheet to be veritified and standard, it is determined that in electronic spreadsheet to be veritified
Detection zone.
The present embodiment detection zone determining module veritifies single mode plate according to the summit of form in electronic spreadsheet to be veritified and standard,
It is determined that the detection zone in electronic spreadsheet to be veritified, also performs following operation：
Single mode plate is veritified according to the summit of form in electronic spreadsheet to be veritified and standard, calculated in electronic spreadsheet to be veritified
Detection zone apex coordinate.
The present embodiment electronic spreadsheet veritifies device, in addition to judge module, the judge module can be single modules,
It can be integrated in detection zone determining module.The judge module is used for：
According to the coordinate on form summit in the apex coordinate of detection zone in electronic spreadsheet to be veritified and electronic spreadsheet to be veritified,
Judge whether electronic spreadsheet to be veritified meets veritification condition, image procossing is carried out to detection zone if meeting, judges to wait to veritify
Whether electronic spreadsheet, which meets to veritify, requires, otherwise directly judges that electronic spreadsheet to be veritified is unsatisfactory for veritifying and requires.
The present embodiment image processing module carries out image procossing to detection zone, judges whether electronic spreadsheet to be veritified meets core
Requirement is tested, performs following operation：
The pixel color of image in each detection zone is obtained by the method for image procossing；
Calculate the accounting of each color pixel in each detection zone；
The accounting of the pixel set according to each detection zone, judges whether each detection zone is qualified；
If all detection zones are all qualified, then it is assumed that electronic spreadsheet to be veritified, which meets to veritify, to be required, otherwise it is assumed that being unsatisfactory for
Veritify and require.
The above embodiments are merely illustrative of the technical solutions of the present invention rather than is limited, without departing substantially from essence of the invention
In the case of refreshing and its essence, those skilled in the art, which work as, can make various corresponding changes and become according to the present invention
Shape, but these corresponding changes and deformation should all belong to the protection domain of appended claims of the invention.
Claims (10)
1. a kind of electronic spreadsheet checking method, veritified for treating veritification electronic spreadsheet, it is characterised in that the veritification side
Method includes：
From the electronic spreadsheet to be veritified of input, it is determined that the detection zone for veritification；
Image procossing is carried out to detection zone, judges whether electronic spreadsheet to be veritified meets to veritify and requires.
2. electronic spreadsheet checking method according to claim 1, it is characterised in that the electronic watch to be veritified from input
Dan Zhong, it is determined that the detection zone for veritification, including：
According to default location factor, coordinate points corresponding to location factor are found in electronic spreadsheet to be veritified, and according to setting
Condition determine elements of a fix point in electronic spreadsheet to be veritified；
Elements of a fix point and standard in electronic spreadsheet to be veritified veritify single mode plate, it is determined that form in electronic spreadsheet to be veritified
Summit；
Single mode plate is veritified according to the summit of form in electronic spreadsheet to be veritified and standard, it is determined that the detection in electronic spreadsheet to be veritified
Area.
3. electronic spreadsheet checking method according to claim 2, it is characterised in that in the basis electronic spreadsheet to be veritified
The summit of form and standard veritify single mode plate, it is determined that the detection zone in electronic spreadsheet to be veritified, in addition to：
Single mode plate is veritified according to the summit of form in electronic spreadsheet to be veritified and standard, calculates the inspection in electronic spreadsheet to be veritified
Survey the apex coordinate in area.
4. electronic spreadsheet checking method according to claim 3, it is characterised in that the checking method, it is determined that being used for
After the detection zone of veritification, in addition to：
According to the coordinate on form summit in the apex coordinate of detection zone in electronic spreadsheet to be veritified and electronic spreadsheet to be veritified, judge
Whether electronic spreadsheet to be veritified meets veritification condition, carries out image procossing to detection zone if meeting, judges electronics to be veritified
Whether list, which meets to veritify, requires, otherwise directly judges that electronic spreadsheet to be veritified is unsatisfactory for veritifying and requires.
5. electronic spreadsheet checking method according to claim 1, it is characterised in that described to be carried out to detection zone at image
Reason, judge whether electronic spreadsheet to be veritified meets to veritify and require, including：
The pixel color of image in each detection zone is obtained by the method for image procossing；
Calculate the accounting of each color pixel in each detection zone；
The accounting of the pixel set according to each detection zone, judges whether each detection zone is qualified；
If all detection zones are all qualified, then it is assumed that electronic spreadsheet to be veritified, which meets to veritify, to be required, otherwise it is assumed that being unsatisfactory for veritifying
It is required that.
6. a kind of electronic spreadsheet veritifies device, veritified for treating veritification electronic spreadsheet, it is characterised in that the electronic watch
Monokaryon experiment device includes：
Detection zone determining module, for from the electronic spreadsheet to be veritified of input, it is determined that the detection zone for veritification；
Image processing module, for carrying out image procossing to detection zone, judge whether electronic spreadsheet to be veritified meets to veritify and require.
7. electronic spreadsheet according to claim 6 veritifies device, it is characterised in that the detection zone determining module is from input
Electronic spreadsheet to be veritified in, it is determined that the detection zone for veritification, perform following operation：
According to default location factor, coordinate points corresponding to location factor are found in electronic spreadsheet to be veritified, and according to setting
Condition determine elements of a fix point in electronic spreadsheet to be veritified；
Elements of a fix point and standard in electronic spreadsheet to be veritified veritify single mode plate, it is determined that form in electronic spreadsheet to be veritified
Summit；
Single mode plate is veritified according to the summit of form in electronic spreadsheet to be veritified and standard, it is determined that the detection in electronic spreadsheet to be veritified
Area.
8. electronic spreadsheet according to claim 7 veritifies device, it is characterised in that the detection zone determining module is according to treating
Veritify the summit of form and standard in electronic spreadsheet and veritify single mode plate, it is determined that the detection zone in electronic spreadsheet to be veritified, is also performed
Following operation：
Single mode plate is veritified according to the summit of form in electronic spreadsheet to be veritified and standard, calculates the inspection in electronic spreadsheet to be veritified
Survey the apex coordinate in area.
9. electronic spreadsheet according to claim 8 veritifies device, it is characterised in that the electronic spreadsheet veritifies device, also
Including judge module, the judge module is used for：
According to the coordinate on form summit in the apex coordinate of detection zone in electronic spreadsheet to be veritified and electronic spreadsheet to be veritified, judge
Whether electronic spreadsheet to be veritified meets veritification condition, carries out image procossing to detection zone if meeting, judges electronics to be veritified
Whether list, which meets to veritify, requires, otherwise directly judges that electronic spreadsheet to be veritified is unsatisfactory for veritifying and requires.
10. electronic spreadsheet according to claim 6 veritifies device, it is characterised in that described image processing module is to detection
Area carries out image procossing, judges whether electronic spreadsheet to be veritified meets to veritify and requires, performs following operation：
The pixel color of image in each detection zone is obtained by the method for image procossing；
Calculate the accounting of each color pixel in each detection zone；
The accounting of the pixel set according to each detection zone, judges whether each detection zone is qualified；
If all detection zones are all qualified, then it is assumed that electronic spreadsheet to be veritified, which meets to veritify, to be required, otherwise it is assumed that being unsatisfactory for veritifying
It is required that.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610392180.1A CN107463868B (en) | 2016-06-02 | 2016-06-02 | Electronic form verification method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610392180.1A CN107463868B (en) | 2016-06-02 | 2016-06-02 | Electronic form verification method and device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN107463868A true CN107463868A (en) | 2017-12-12 |
| CN107463868B CN107463868B (en) | 2021-02-23 |
Family
ID=60544486
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201610392180.1A Active CN107463868B (en) | 2016-06-02 | 2016-06-02 | Electronic form verification method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107463868B (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113569863A (en) * | 2021-09-26 | 2021-10-29 | 广东电网有限责任公司中山供电局 | Document checking method, system, electronic equipment and storage medium |
Citations (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2008145611A (en) * | 2006-12-07 | 2008-06-26 | Fuji Xerox Co Ltd | Information processor and program |
| CN101236609A (en) * | 2007-02-02 | 2008-08-06 | 富士通株式会社 | Apparatus and method for analyzing and determining correlation of information in a document |
| CN101834968A (en) * | 2009-03-10 | 2010-09-15 | 佳能株式会社 | Image processing equipment and image processing method |
| CN101882225A (en) * | 2009-12-29 | 2010-11-10 | 北京中科辅龙计算机技术股份有限公司 | Engineering drawing material information extraction method based on template |
| CN101981583A (en) * | 2008-03-28 | 2011-02-23 | 智能技术Ulc公司 | Method and tool for recognizing a hand-drawn table |
| CN102088369A (en) * | 2010-12-30 | 2011-06-08 | 天津市国瑞数码安全系统有限公司 | Automatic auditing method of Internet website record information |
| CN102567741A (en) * | 2010-12-27 | 2012-07-11 | 汉王科技股份有限公司 | Form matching method and device |
| CN103246953A (en) * | 2013-04-25 | 2013-08-14 | 天津大学 | Document audit method |
| CN105095842A (en) * | 2014-05-22 | 2015-11-25 | 阿里巴巴集团控股有限公司 | Method and device for identifying information of bill |
| CN105279525A (en) * | 2015-11-19 | 2016-01-27 | 浪潮软件集团有限公司 | Image processing method and device |
-
2016
- 2016-06-02 CN CN201610392180.1A patent/CN107463868B/en active Active
Patent Citations (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2008145611A (en) * | 2006-12-07 | 2008-06-26 | Fuji Xerox Co Ltd | Information processor and program |
| CN101236609A (en) * | 2007-02-02 | 2008-08-06 | 富士通株式会社 | Apparatus and method for analyzing and determining correlation of information in a document |
| CN101981583A (en) * | 2008-03-28 | 2011-02-23 | 智能技术Ulc公司 | Method and tool for recognizing a hand-drawn table |
| CN101834968A (en) * | 2009-03-10 | 2010-09-15 | 佳能株式会社 | Image processing equipment and image processing method |
| CN101882225A (en) * | 2009-12-29 | 2010-11-10 | 北京中科辅龙计算机技术股份有限公司 | Engineering drawing material information extraction method based on template |
| CN102567741A (en) * | 2010-12-27 | 2012-07-11 | 汉王科技股份有限公司 | Form matching method and device |
| CN102088369A (en) * | 2010-12-30 | 2011-06-08 | 天津市国瑞数码安全系统有限公司 | Automatic auditing method of Internet website record information |
| CN103246953A (en) * | 2013-04-25 | 2013-08-14 | 天津大学 | Document audit method |
| CN105095842A (en) * | 2014-05-22 | 2015-11-25 | 阿里巴巴集团控股有限公司 | Method and device for identifying information of bill |
| CN105279525A (en) * | 2015-11-19 | 2016-01-27 | 浪潮软件集团有限公司 | Image processing method and device |
Non-Patent Citations (3)
| Title |
|---|
| 刘真 等: "通用表格处理系统中定位方法的研究", 《软件学报》 * |
| 吕亚军 等: "基于最优坐标系的表格版面分析", 《计算机仿真》 * |
| 郑秀清 等: "一种改进的自动表格框线检测方法", 《中国民航飞行学院学报》 * |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113569863A (en) * | 2021-09-26 | 2021-10-29 | 广东电网有限责任公司中山供电局 | Document checking method, system, electronic equipment and storage medium |
| CN113569863B (en) * | 2021-09-26 | 2022-01-25 | 广东电网有限责任公司中山供电局 | Document checking method, system, electronic equipment and storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN107463868B (en) | 2021-02-23 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN113607742B (en) | Battery cell tab detection method and device, electronic equipment and storage medium | |
| CN109948590A (en) | Pose problem detection method and device | |
| CN105335963A (en) | Edge defect detection method and apparatus | |
| CN106651857B (en) | A kind of printed circuit board patch defect inspection method | |
| TW201543377A (en) | Method and apparatus of extracting particular information from standard card | |
| US20140050387A1 (en) | System and Method for Machine Vision Inspection | |
| CN102980535B (en) | Angle measurement method and device | |
| CN107331031B (en) | A kind of recognition methods of note denomination, device, equipment and storage medium | |
| CN106991423A (en) | Whether the method and device of watermark is included in identification specification picture | |
| WO2021212873A1 (en) | Defect detection method and apparatus for four corners of certificate, and device and storage medium | |
| WO2024021063A1 (en) | Method and device for detecting stability of vision system | |
| CN107036530A (en) | The calibration system and method for the location of workpiece | |
| CN110879131B (en) | Imaging quality testing method and imaging quality testing device for visual optical system, and electronic apparatus | |
| CN111754479A (en) | Checking method for accurate matching of layout graphs | |
| CN114745399A (en) | Intelligent building engineering quality inspection and acceptance management system | |
| CN112381765A (en) | Equipment detection method, device, equipment and storage medium based on artificial intelligence | |
| CN110070491A (en) | Bank card picture antidote, device, equipment and storage medium | |
| CN107463868A (en) | A kind of electronic spreadsheet verification method and device | |
| CN105136818A (en) | Printing substrate image detecting method | |
| CN105975157B (en) | A kind of classifying indication method and system based on mobile terminal application icon shape | |
| JPH11312243A (en) | Facial region detector | |
| CN117173090A (en) | Welding defect type identification method and device, storage medium and electronic equipment | |
| CN116486126A (en) | Template determination method, device, equipment and storage medium | |
| CN108182677B (en) | Prepress register detection method, prepress register detection device and computer readable storage medium | |
| CN114926429A (en) | Method, device and equipment for detecting trace length and readable 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 |