CN107742089A - A kind of method that Quick Response Code automatic identification is realized using electrical form - Google Patents
A kind of method that Quick Response Code automatic identification is realized using electrical form Download PDFInfo
- Publication number
- CN107742089A CN107742089A CN201710790172.7A CN201710790172A CN107742089A CN 107742089 A CN107742089 A CN 107742089A CN 201710790172 A CN201710790172 A CN 201710790172A CN 107742089 A CN107742089 A CN 107742089A
- Authority
- CN
- China
- Prior art keywords
- quick response
- response code
- worksheet
- cell
- automatic identification
- 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
- G06K—GRAPHICAL DATA READING; PRESENTATION OF DATA; RECORD CARRIERS; HANDLING RECORD CARRIERS
- G06K7/00—Methods or arrangements for sensing record carriers, e.g. for reading patterns
- G06K7/10—Methods or arrangements for sensing record carriers, e.g. for reading patterns by electromagnetic radiation, e.g. optical sensing; by corpuscular radiation
- G06K7/14—Methods or arrangements for sensing record carriers, e.g. for reading patterns by electromagnetic radiation, e.g. optical sensing; by corpuscular radiation using light without selection of wavelength, e.g. sensing reflected white light
- G06K7/1404—Methods for optical code recognition
- G06K7/1408—Methods for optical code recognition the method being specifically adapted for the type of code
- G06K7/1417—2D bar codes
Abstract
A kind of method that Quick Response Code automatic identification is carried out using electrical form, is comprised the following steps：S1, setting unit lattice length and width；S2, read two-dimension code image；S3, positioning；S4, fix pixel point range；S5, the concrete numerical value for judging 0 and 1, and by data with black and show one by one on the cell on the second worksheet in vain；S6, related data filled out according to mask calculation formula；S7, XOR；S8, according to ranking method and arrangement position, respective value is filled out in underlying empty position in the 4th worksheet.Formula and a small amount of vba script simple realization QR Quick Response Code automatic identification of the present invention using electrical form, the process visualization degree entirely identified is very high, be advantageous to lift student's learning interest, teaching is highly suitable as to use, and simply it is easy to grasp, corresponding content can be explained as the case may be, while without error correcting code computing, can identifies typically no wrong Quick Response Code, or even student can also be allowed to identify Quick Response Code by hand.
Description
Technical field
The present invention relates to digital image processing techniques field, especially one kind to realize that Quick Response Code is known automatically using electrical form
Method for distinguishing.
Background technology
Quick Response Code is also known as QR Code, QR full name Quick Response, is one super popular on mobile device in recent years
A kind of coded system, it can deposit more information than traditional Bar Code bar codes, can also represent more data types.
Two-dimensional bar code/Quick Response Code（2-dimensional bar code）It is by a set pattern with certain specific geometric figure
Rule is in plane（On two-dimensional directional）The chequered with black and white graphic recording data symbol information of distribution；On coding dexterously
Using form " 0 " of computer-internal logical foundations, " 1 " bit stream concept, it is corresponding with binary system several using several
What body represents word numerical information, by image input device or photoelectric scanning device automatically identifying and reading to realize that information is automatic
Processing：It has some general character of barcode technology：Every kind of code system has its specific character set；Each character occupies certain width
Degree；With certain verifying function etc., while also there is the information automatic identification function to not going together and processing figure rotation change
Change point.
QR codes are square, it can be common that black-and-white two color, in three corners, are printed on square figure smaller and as " returning " word
Case, this 3 patterns for being to aid in decoding software positioning, user need not be aligned, no matter scan at any angle, data still may be used
To be correctly read.
The classification of Quick Response Code, representative matrix two-dimensional barcode have：Code One、Maxi Code、QR Code、
Data Matrix etc..In current tens kinds of two-dimensional bar codes, conventional code system has：PDF417 two-dimensional bar codes, Datamatrix
Two-dimensional bar code, QR Code, Code 49, Code 16K, Code one, etc., in addition to these common two-dimensional bar codes,
Also Vericode bar codes, CP bar codes, Codablock F bar codes, field character code, Ultracode bar codes, Aztec bar codes. QR
Code, it can store polytype, and the specification of bis- bar codes of QR code used now follows OMIA always（Open
Mobile Internet Alliance）Specification
Application of the Quick Response Code in life is more and more, businessman, software, the personal familiarity more and more higher for Quick Response Code, and two
Code very advantageous in storage information is tieed up, and circulation way is simple.The core technology of Quick Response Code is exactly that image in 2 D code is located in advance
Reason technology, it is possible to achieve the identification for information, ensure storage information has effect spread.In entire society, everywhere may be used now
To see the trace of Quick Response Code, Quick Response Code can not only generate personal business card, and businessman carries out merchandise sales and well-known
Spend the powerful mean propagated.So Quick Response Code has become a very important Internet of Things communication technology at present, soon
Write in textbook.
But when being implemented for Quick Response Code automatic identification, existing mode is all using high-level languages such as C/C++/java
The program write, code readability difficulty for the student for begining to learn the communication technology are very big.
It would therefore be highly desirable to entering using electrical form for Quick Response Code can simply, even be identified by hand by needing a kind of method to realize
The method of row Quick Response Code automatic identification.
The content of the invention
Part in view of the shortcomings of the prior art, two dimension is carried out using electrical form it is an object of the invention to provide one kind
The method of code automatic identification, this method using the high electrical form of visualized operation degree, realize Quick Response Code manual identification and
Automatic identification, by the explanation to Quick Response Code relevant knowledge, it is easy to the study of student and understanding and is applied and put into practice, can
Operability is stronger.
The present invention is to realize above-mentioned purpose by following technological means：
A kind of method that Quick Response Code automatic identification is carried out using electrical form, is comprised the following steps：
S1, its cell length and width is set in the worksheet of correlation so that each unit is square；
S2, the pixel value of vba scripts reading two-dimension code image and the color of fills unit lattice are used in first job table；
S3, positioned according to the witness marker of Quick Response Code；
S4, the pixel point range for fixing according to calibration mark and timing index each data；
S5, the concrete numerical value for judging using optimum receiver method 0 and 1, and by data with black and in vain on the second worksheet
Cell on show one by one；
S6, according in cell of the mask calculation formula on the 3rd worksheet fill out related data；
S7, XOR carried out according to the cell of the second worksheet and the 3rd worksheet corresponding data region one by one, obtained
As a result fill out in the 4th worksheet；
S8, in the 4th worksheet, according to the ranking method of each byte and the arrangement position of each position, in the 4th work
Respective value is filled out in underlying empty position in table.
Further, in addition to S9, if the Quick Response Code comprising character string, then in the cell of next line, use
CHAR () function calculates corresponding letter.
The electrical form that the present invention uses an inherently two-dimentional form, is made all sub-boxes of electrical form
Grid, corresponding pixel color is filled out in corresponding grid, so the more convenient whole Quick Response Code identification technology of displaying is realized
Process, be more convenient student study.
Formula and a small amount of vba script simple realization QR Quick Response Code automatic identification of the present invention using electrical form, it is whole to know
Other process visualization degree is very high, is advantageous to lift student's learning interest, is highly suitable as teaching and uses, and simply
It is easy to grasp, corresponding content can be explained as the case may be, while without error correcting code computing, it is possible to identify typically no mistake
Quick Response Code, or even student can also be allowed to identify Quick Response Code by hand.
Brief description of the drawings
Accompanying drawing 1 is schematic flow sheet of the present invention；
Accompanying drawing 2 is the QR Quick Response Code schematic diagrames of version 2 of the embodiment of the present invention；
The information explanation that QR of the embodiment of the present invention Quick Response Codes of accompanying drawing 3 are recorded；
Accompanying drawing 4 is mask calculation formula of embodiment of the present invention schematic diagram one；
Accompanying drawing 5 is mask calculation formula of embodiment of the present invention schematic diagram two；
Accompanying drawing 6 is data arrangement of embodiment of the present invention sequential schematic one；
Accompanying drawing 7 is data arrangement of embodiment of the present invention sequential schematic two；
Accompanying drawing 8 is that the Quick Response Code to be identified diagram that worksheet of the embodiment of the present invention 1 is read is intended to；
Accompanying drawing 9 is intended to for the Quick Response Code diagram rearranged after the digitization of worksheet of the embodiment of the present invention 2；
Accompanying drawing 10 is that the mask of worksheet of the embodiment of the present invention 3 diagram is intended to；
Accompanying drawing 11 is schematic diagram when the automatic identification of worksheet of the embodiment of the present invention 4 exports.
Embodiment
The present invention is described in further detail below in conjunction with the accompanying drawings：
Embodiment：
Fig. 2 is referred to, the present embodiment is the QR Quick Response Codes of version 2, and it is made up of 25*25 lattice, can just put
Enter in electrical form.
Fig. 3 is referred to, is the information explanation that the QR Quick Response Codes of the present embodiment are recorded.
Fig. 4 and Fig. 5 are referred to, is the mask calculation formula of the present embodiment.
Refer to Fig. 6 and Fig. 7, be data arrangement preface in the present embodiment data field, it is specified that each byte location with
And each position ordering in each byte.
The format information of QR codes have recorded two kinds of data：The type of error-correction level and mask.The effect of mask is in order to right
Data area is masked in favor of scanner Shi Do, and data area can be avoided continuous blank or continuous black occur
Area, while it also avoid data field and the square appearance of similar anchor point pattern occur.Mask pattern is in whole data area
Constantly repeat mask calculating in grid（Functional graphic is without mask）, the unit of mask black module is corresponded on data field
It will invert.Two groups of identical format informations are had on each Quick Response Code to occur, and carry BCH error correction.
Fig. 1 is referred to, for the schematic flow sheet of the present invention.
A kind of method that Quick Response Code automatic identification is carried out using electrical form of the present invention, is comprised the following steps：
S1, its cell length and width is set in worksheet 1,2,3,4 so that each unit is square；
S2, in worksheet 1 using vba scripts read two-dimension code image pixel value fills unit lattice color；Refer to figure
8, it is the Quick Response Code figure to be identified read in worksheet 1；
S3, positioned according to the witness marker of Quick Response Code；
S4, the pixel point range for fixing according to calibration mark and timing index each data；
S5, the concrete numerical value for judging using optimum receiver method 0 and 1, and by data with the black and list on worksheet 2 in vain
Shown one by one on first lattice；Accompanying drawing 9 is referred to, for the Quick Response Code figure rearranged after digitlization, worksheet 2 is to work
Quick Response Code on table 1 identifies that 1 and 0 fills out in respective cells after digitlization is identified, and depth is being filled out for 1 cell
Color, light color is filled out for 0 cell；
Related data is filled out in S6, cell of the mask calculation formula on worksheet 3 according to Fig. 4 and Fig. 5, is referred to
Figure 10, it is mask figure；
S7, XOR carried out according to the cell in corresponding data region in worksheet 2 and worksheet 3 one by one, obtained result
Fill out in worksheet 4, refer to Figure 11, schematic diagram when being exported for automatic identification；
S8, in worksheet 4, according to the ranking method of Fig. 6 and Fig. 7 each byte represented and each arrangement position of position,
Respective value is filled out in underlying empty position in worksheet 4.
S9, due to the Quick Response Code it is the Quick Response Code that includes character string, therefore, in the cell of next line, using CHAR
() function calculates corresponding letter.
To sum up, the present invention is by above-mentioned method, solves technical problem present in prior art, method realize it is simple,
Teaching is highly suitable as to use.
Finally it should be noted that：The preferred embodiments of the present invention are the foregoing is only, are not intended to limit the invention,
Although the present invention is described in detail with reference to the foregoing embodiments, for those skilled in the art, it still may be used
To be modified to the technical scheme described in foregoing embodiments, or equivalent substitution is carried out to which part technical characteristic.
Within the spirit and principles of the invention, any modification, equivalent substitution and improvements made etc., it should be included in the present invention's
Within protection domain.
Claims (2)
- A kind of 1. method that Quick Response Code automatic identification is carried out using electrical form, it is characterised in that comprise the following steps：S1, its cell length and width is set in the worksheet of correlation so that each unit is square；S2, the pixel value of vba scripts reading two-dimension code image and the color of fills unit lattice are used in first job table；S3, positioned according to the witness marker of Quick Response Code；S4, the pixel point range for fixing according to calibration mark and timing index each data；S5, the concrete numerical value for judging using optimum receiver method 0 and 1, and by data with black and in vain on the second worksheet Cell on show one by one；S6, according in cell of the mask calculation formula on the 3rd worksheet fill out related data；S7, XOR carried out according to the cell of the second worksheet and the 3rd worksheet corresponding data region one by one, obtained As a result fill out in the 4th worksheet；S8, in the 4th worksheet, according to the ranking method of each byte and the arrangement position of each position, in the 4th work Respective value is filled out in underlying empty position in table.
- 2. the method for Quick Response Code automatic identification is carried out using electrical form as claimed in claim 1, it is characterised in that also include S9, if the Quick Response Code comprising character string, then in the cell of next line, calculated using CHAR () function corresponding to Letter.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710790172.7A CN107742089B (en) | 2017-09-05 | 2017-09-05 | Method for automatically identifying two-dimensional code by using spreadsheet |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710790172.7A CN107742089B (en) | 2017-09-05 | 2017-09-05 | Method for automatically identifying two-dimensional code by using spreadsheet |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN107742089A true CN107742089A (en) | 2018-02-27 |
| CN107742089B CN107742089B (en) | 2021-03-16 |
Family
ID=61235160
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710790172.7A Active CN107742089B (en) | 2017-09-05 | 2017-09-05 | Method for automatically identifying two-dimensional code by using spreadsheet |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107742089B (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108710932A (en) * | 2018-05-21 | 2018-10-26 | 周冰 | A kind of two-dimensional code generation method, device and electronic equipment |
| CN111079393A (en) * | 2019-10-24 | 2020-04-28 | 龙旭光 | Spreadsheet system for storing customer information based on two-dimensional code |
| CN113947097A (en) * | 2020-07-15 | 2022-01-18 | 华为技术有限公司 | Two-dimensional code identification method and electronic equipment |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| EP0669593A2 (en) * | 1994-02-24 | 1995-08-30 | Kabushiki Kaisha TEC | Two-dimensional code recognition method |
| CN1862560A (en) * | 2006-06-21 | 2006-11-15 | 北京紫光捷通科技有限公司 | 2-D barcode system capable of fast positioning based on positioning graph |
| CN103605917A (en) * | 2013-12-11 | 2014-02-26 | 武钢集团昆明钢铁股份有限公司 | Spreadsheet system based on multi-user environment and implementation method of spreadsheet system |
-
2017
- 2017-09-05 CN CN201710790172.7A patent/CN107742089B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| EP0669593A2 (en) * | 1994-02-24 | 1995-08-30 | Kabushiki Kaisha TEC | Two-dimensional code recognition method |
| CN1862560A (en) * | 2006-06-21 | 2006-11-15 | 北京紫光捷通科技有限公司 | 2-D barcode system capable of fast positioning based on positioning graph |
| CN103605917A (en) * | 2013-12-11 | 2014-02-26 | 武钢集团昆明钢铁股份有限公司 | Spreadsheet system based on multi-user environment and implementation method of spreadsheet system |
Non-Patent Citations (2)
| Title |
|---|
| 王宏伟: "Excel VBA在资产管理中的运用", 《电脑编程技巧与维护》 * |
| 葛峰: "利用Excel生成二维码", 《电脑爱好者》 * |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108710932A (en) * | 2018-05-21 | 2018-10-26 | 周冰 | A kind of two-dimensional code generation method, device and electronic equipment |
| CN111079393A (en) * | 2019-10-24 | 2020-04-28 | 龙旭光 | Spreadsheet system for storing customer information based on two-dimensional code |
| CN113947097A (en) * | 2020-07-15 | 2022-01-18 | 华为技术有限公司 | Two-dimensional code identification method and electronic equipment |
| CN113947097B (en) * | 2020-07-15 | 2024-04-09 | 花瓣云科技有限公司 | Two-dimensional code identification method and electronic equipment |
Also Published As
| Publication number | Publication date |
|---|---|
| CN107742089B (en) | 2021-03-16 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11182579B2 (en) | Two dimensional barcode with dynamic environmental data system, method, and apparatus | |
| Tiwari | An introduction to QR code technology | |
| CN101908125B (en) | QR (Quick Response) bar code decoding chip and decoding method thereof | |
| Sutheebanjard et al. | QR-code generator | |
| CN107742089A (en) | A kind of method that Quick Response Code automatic identification is realized using electrical form | |
| CN101093553A (en) | 2D code system, and identification method | |
| US9613305B2 (en) | Printed material on which two-dimensional code is displayed | |
| CN101645081A (en) | Method and system for tracing farm product information through two-dimension code | |
| CN108351956B (en) | Method and system for printing forensic-encoded 2D barcodes | |
| CN104794518A (en) | Color two-dimension code generating method and device | |
| CN105718979A (en) | Method for generating two-dimensional code picture | |
| CN104715275B (en) | A kind of generation method and generating means of grey Quick Response Code | |
| CN109831309A (en) | A kind of safety code principle and method with multiple-authentication | |
| CN114298259A (en) | Anti-counterfeiting tracing method based on two-dimensional code and bar code | |
| CN104715222A (en) | Method and device for identifying gray two-dimension code | |
| CN105701529B (en) | A method of realizing that color image is shown on two dimensional code | |
| US7987494B1 (en) | Method and apparatus providing end to end protection for a document | |
| CN101303742A (en) | Microminiature Hanxin code and method for generating symbol thereof | |
| US7555145B2 (en) | Multi-level optical mark reading that uses an unambiguous symbology of marks to fill into response bubbles | |
| CN112884101A (en) | Graphic code, graphic code encoding method and graphic code decoding method | |
| CN105825250A (en) | Method and device for counting poor display panels | |
| CN106339907A (en) | Data tracing interaction method | |
| CN102254204B (en) | Coding method for graphemic code | |
| CN108847122A (en) | A kind of novel C CQR code anti-counterfeiting mark | |
| Kulkarni et al. | Creation and analysis of QR code |
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 |