CN113806696A - Watermark generation and tracing method, device, equipment and storage medium - Google Patents
Watermark generation and tracing method, device, equipment and storage medium Download PDFInfo
- Publication number
- CN113806696A CN113806696A CN202111104341.XA CN202111104341A CN113806696A CN 113806696 A CN113806696 A CN 113806696A CN 202111104341 A CN202111104341 A CN 202111104341A CN 113806696 A CN113806696 A CN 113806696A
- Authority
- CN
- China
- Prior art keywords
- watermark
- file
- tracing
- picture
- excel file
- 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.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 36
- 238000004590 computer program Methods 0.000 claims description 10
- 238000003780 insertion Methods 0.000 claims description 3
- 230000037431 insertion Effects 0.000 claims description 3
- 230000000694 effects Effects 0.000 description 1
- 230000006870 function Effects 0.000 description 1
- 230000000873 masking effect Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000002265 prevention Effects 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
- 230000000007 visual effect Effects 0.000 description 1
- XLYOFNOQVPJJNP-UHFFFAOYSA-N water Substances O XLYOFNOQVPJJNP-UHFFFAOYSA-N 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F21/00—Security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
- G06F21/10—Protecting distributed programs or content, e.g. vending or licensing of copyrighted material ; Digital rights management [DRM]
- G06F21/16—Program or content traceability, e.g. by watermarking
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
Abstract
The invention discloses a watermark generation and tracing method, a device, equipment and a storage medium, wherein the method comprises the following steps: setting a file source, and storing an excel file to be watermarked under the file source; configuring a watermark task for the excel file to be watermarked, and generating watermark information by using a watermark algorithm; generating a picture by utilizing a two-dimensional code generation algorithm according to the watermark information, and inserting the picture into a cell of an excel file as an ole object; tracing the source of the watermarked excel file; or copying at least part of data of the watermarked excel file to other files, and tracing the watermark of the new file; the invention has the advantages that: the watermark information can be hidden, the method is suitable for being used in some scenes needing to hide watermark patterns, and the inserted watermark information can be traced.
Description
Technical Field
The invention relates to the field of data security and leakage prevention, in particular to a watermark generation and tracing method, a watermark generation and tracing device, watermark generation and tracing equipment and a storage medium.
Background
The watermark and tracing system combines two functions of watermark and tracing, can add related watermark information to various electronic files, application system pages and files of a terminal and files of mobile terminal equipment, and provides a comprehensive watermark capability service platform in the aspects of watermark information display, watermark printing, tracing based on watermark information and the like.
In the prior art, there are three methods for adding water print in an EXCEL form, one is to print a character with a print effect, the other is to insert artistic characters, modify characters, set character transparency and then generate a watermark, and the other is to insert a picture method, download or self-make a watermark picture, selectively insert headers and footers in the page layout of the EXCEL form, and insert pictures in the headers. The added watermark information in the three modes is visual characters or pictures, is easy to perceive and is not suitable for being used in some scenes needing to hide watermark patterns, and the watermark information inserted in the three modes cannot be traced.
Chinese patent publication No. CN113177193A provides a watermark adding method, a watermark verifying method, and a terminal device, including: obtaining an Excel file; creating an XML file for embedding watermark information in a folder obtained by decompressing the Excel file; embedding watermark information in the XML file for embedding the watermark information; and compressing the folder obtained by decompressing the Excel file after embedding the watermark information to generate a compressed file in a zip format, and converting the compressed file into a new Excel file. By the method, the Excel file can be effectively protected. However, the method of the patent application cannot hide watermark information, is not suitable for being used in some scenes needing to hide watermark patterns, and cannot trace the source of the inserted watermark information.
Disclosure of Invention
The technical problems to be solved by the invention are that the watermark generation method in the prior art can not hide watermark information, is not suitable for being used in some scenes needing to hide watermark patterns, and the inserted watermark information can not be traced.
The invention solves the technical problems through the following technical means: a watermark generation and tracing method, the method comprising the steps of:
the method comprises the following steps: setting a file source, and storing an excel file to be watermarked under the file source;
step two: configuring a watermark task for the excel file to be watermarked, and generating watermark information by using a watermark algorithm;
step three: generating a picture by utilizing a two-dimensional code generation algorithm according to the watermark information, and inserting the picture into a cell of an excel file as an ole object;
step four: tracing the source of the watermarked excel file; or the like, or, alternatively,
step five: copying at least part of data of the watermarked excel file to other files, and tracing the watermark of the new file.
The invention utilizes a two-dimensional code generation algorithm to generate a picture from watermark information, the picture is taken as an ole object and inserted into a cell of an excel file, the picture is invisible after the picture is inserted into the cell, thereby realizing the hiding of the watermark information, and the invention is suitable for being used in some scenes needing to hide the watermark pattern.
Further, the watermark information is 20-bit octal data.
Further, the fourth step includes:
selecting an excel file to be traced, reading cell data of the excel file to be traced, reading a picture serving as an ole object from the cell data, analyzing the picture into watermark information, and acquiring bound task information according to the watermark information to acquire a corresponding responsible person.
Further, the fifth step includes: when at least part of data of the watermarked excel file is copied to other files, the picture serving as an ole object is copied at the same time; when the watermark tracing is carried out on the new file, the picture in the new file is obtained and analyzed into watermark information, and the bound task information is obtained according to the watermark information so as to obtain the corresponding responsible person.
The invention also provides a watermark generation and tracing device, which comprises:
the file source adding module is used for setting a file source and storing the excel file to be watermarked under the file source;
the watermark generating module is used for configuring a watermark task for the excel file to be watermarked and generating watermark information by using a watermark algorithm;
the watermark insertion module is used for generating a picture by utilizing a two-dimensional code generation algorithm according to the watermark information and inserting the picture into a cell of the excel file as an ole object;
the first tracing module is used for tracing the source of the watermarked excel file;
and the second tracing module is used for copying at least part of data of the watermarked excel file to other files and then performing watermark tracing on the new file.
Further, the watermark information is 20-bit octal data.
Further, the first tracing model is further configured to:
selecting an excel file to be traced, reading cell data of the excel file to be traced, reading a picture serving as an ole object from the cell data, analyzing the picture into watermark information, and acquiring bound task information according to the watermark information to acquire a corresponding responsible person.
Further, the second tracing module is further configured to:
when at least part of data of the watermarked excel file is copied to other files, the picture serving as an ole object is copied at the same time; when the watermark tracing is carried out on the new file, the picture in the new file is obtained and analyzed into watermark information, and the bound task information is obtained according to the watermark information so as to obtain the corresponding responsible person.
The invention also provides an electronic device comprising a processor and a memory, wherein the memory stores computer program instructions capable of being executed by the processor, and the processor implements the above method steps when executing the computer program instructions.
The present invention also provides a computer readable storage medium storing computer program instructions which, when invoked and executed by a processor, implement the method steps described above.
The invention has the advantages that: the invention utilizes a two-dimensional code generation algorithm to generate a picture from watermark information, the picture is taken as an ole object and inserted into a cell of an excel file, and the picture is ensured to be invisible after being inserted into the cell in such a way, so that the watermark information is hidden, and the method is suitable for being used in some scenes needing to hide the watermark pattern.
Drawings
Fig. 1 is a flowchart of watermarking in a watermark generating and tracing method according to an embodiment of the present invention;
fig. 2 is a flowchart of watermark tracing in a watermark generating and tracing method according to an embodiment of the present invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the embodiments of the present invention clearer, the technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the embodiments of the present invention, and it is obvious that the described embodiments are some embodiments of the present invention, but not all embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
Example 1
As shown in fig. 1, a watermark generation and tracing method includes the following steps:
s1: setting a file source, and storing an excel file to be watermarked under the file source;
s2: configuring a watermark task for the excel file to be watermarked, and generating watermark information by using a watermark algorithm; the watermark information is 20-bit octal data. The watermark algorithm belongs to the prior art, is mainly used for generating watermark information, and can adopt a Patchwork algorithm or a transform domain algorithm in the prior art as long as the algorithm can generate the watermark information.
S3: generating a picture by utilizing a two-dimensional code generation algorithm according to the watermark information, and inserting the picture into a cell of an excel file as an ole object; the two-dimensional code generation algorithm mainly generates watermark information into a picture, also belongs to the algorithm of the prior art, and mainly comprises the following steps: determining the character type of encoding, data encoding, error correction encoding, constructing final data information, masking, and determining format and version information.
S4: tracing the source of the watermarked excel file; as shown in fig. 2, the specific process is as follows:
selecting an excel file to be traced, reading cell data of the excel file to be traced, reading a picture serving as an ole object from the cell data, analyzing the picture into watermark information, and acquiring bound task information according to the watermark information to acquire a corresponding responsible person. Tracing the source of the watermarked excel file is essentially the reverse process of the step S3, where the step S3 is to encode the watermark information into a two-dimensional code picture, and the step S4 is to decode the two-dimensional code picture into the watermark information in a decoding manner, where the decoding manner is determined according to the encoding and decoding rules of the two-dimensional code algorithm.
S5: copying at least part of data of the watermarked excel file to other files and tracing the watermark of the new file. The watermark information in the excel file is inserted into a cell of the excel file as an ole object, when partial data is copied into another file (such as the excel file), the watermark information is copied, and the new file is traced through the method of S4, so that the watermark information is read, and finally a person in charge is traced. Similarly, copying the watermarked excel file portion data to another excel file and then watermarking the new file is also an inverse process of S3, except that the watermark is copied to another excel file.
According to the technical scheme, the watermark information is generated into the picture by using the two-dimensional code generation algorithm, the picture is inserted into the cell of the excel file as an ole object, the picture cannot be seen after the picture is inserted into the cell in the mode, and therefore the watermark information is hidden and is suitable for being used in some scenes needing to hide the watermark pattern.
Example 2
Based on embodiment 1, embodiment 2 of the present invention further provides a watermark generating and tracing apparatus, where the apparatus includes:
the file source adding module is used for setting a file source and storing the excel file to be watermarked under the file source;
the watermark generating module is used for configuring a watermark task for the excel file to be watermarked and generating watermark information by using a watermark algorithm;
the watermark insertion module is used for generating a picture by utilizing a two-dimensional code generation algorithm according to the watermark information and inserting the picture into a cell of the excel file as an ole object;
the first tracing module is used for tracing the source of the watermarked excel file;
and the second tracing module is used for copying at least part of data of the watermarked excel file to other files and then performing watermark tracing on the new file.
Specifically, the watermark information is 20-bit octal data.
Specifically, the first tracing module is further configured to:
selecting an excel file to be traced, reading cell data of the excel file to be traced, reading a picture serving as an ole object from the cell data, analyzing the picture into watermark information, and acquiring bound task information according to the watermark information to acquire a corresponding responsible person.
Specifically, the second tracing module is further configured to:
when at least part of data of the watermarked excel file is copied to other files, the picture serving as an ole object is copied at the same time; when the watermark tracing is carried out on the new file, the picture in the new file is obtained and analyzed into watermark information, and the bound task information is obtained according to the watermark information so as to obtain the corresponding responsible person.
Example 3
Based on embodiment 1, embodiment 3 of the present invention further provides an electronic device, which includes a processor and a memory, where the memory stores computer program instructions capable of being executed by the processor, and the processor executes the computer program instructions to implement the method steps described in embodiment 1.
Example 4
Based on embodiment 1, embodiment 4 of the present invention further provides a computer-readable storage medium, which stores computer program instructions, and the computer program instructions, when called and executed by a processor, implement the method steps described in embodiment 1.
The above examples are only intended to illustrate the technical solution of the present invention, but not to limit it; although the present invention has been described in detail with reference to the foregoing embodiments, it will be understood by those of ordinary skill in the art that: the technical solutions described in the foregoing embodiments may still be modified, or some technical features may be equivalently replaced; and such modifications or substitutions do not depart from the spirit and scope of the corresponding technical solutions of the embodiments of the present invention.
Claims (10)
1. A watermark generation and tracing method, said method comprising the steps of:
the method comprises the following steps: setting a file source, and storing an excel file to be watermarked under the file source;
step two: configuring a watermark task for the excel file to be watermarked, and generating watermark information by using a watermark algorithm;
step three: generating a picture by utilizing a two-dimensional code generation algorithm according to the watermark information, and inserting the picture into a cell of an excel file as an ole object;
step four: tracing the source of the watermarked excel file; or the like, or, alternatively,
step five: copying at least part of data of the watermarked excel file to other files, and tracing the watermark of the new file.
2. The watermark generation and tracing method according to claim 1, wherein said watermark information is 20-bit octal data.
3. The watermark generation and tracing method according to claim 1, wherein said step four includes:
selecting an excel file to be traced, reading cell data of the excel file to be traced, reading a picture serving as an ole object from the cell data, analyzing the picture into watermark information, and acquiring bound task information according to the watermark information to acquire a corresponding responsible person.
4. The watermark generation and tracing method according to claim 1, wherein said step five comprises: when at least part of data of the watermarked excel file is copied to other files, the picture serving as an ole object is copied at the same time; when the watermark tracing is carried out on the new file, the picture in the new file is obtained and analyzed into watermark information, and the bound task information is obtained according to the watermark information so as to obtain the corresponding responsible person.
5. A watermark generation and tracing apparatus, the apparatus comprising:
the file source adding module is used for setting a file source and storing the excel file to be watermarked under the file source;
the watermark generating module is used for configuring a watermark task for the excel file to be watermarked and generating watermark information by using a watermark algorithm;
the watermark insertion module is used for generating a picture by utilizing a two-dimensional code generation algorithm according to the watermark information and inserting the picture into a cell of the excel file as an ole object;
the first tracing module is used for tracing the source of the watermarked excel file;
and the second tracing module is used for copying at least part of data of the watermarked excel file to other excel files and then carrying out watermark tracing on the new file.
6. The watermark generation and tracing apparatus of claim 5, wherein said watermark information is 20-bit octal data.
7. The watermark generation and tracing apparatus of claim 5, wherein said first tracing module is further configured to:
selecting an excel file to be traced, reading cell data of the excel file to be traced, reading a picture serving as an ole object from the cell data, analyzing the picture into watermark information, and acquiring bound task information according to the watermark information to acquire a responsible person.
8. The watermark generation and tracing device according to claim 5, wherein said second tracing module is further configured to copy the picture as ole object when copying at least part of data of the watermarked excel file to another file; when the watermark tracing is carried out on the new file, the picture in the new file is obtained and analyzed into watermark information, and the bound task information is obtained according to the watermark information so as to obtain the corresponding responsible person. .
9. An electronic device comprising a processor and a memory, the memory storing computer program instructions executable by the processor, the processor implementing the method steps of any of claims 1-4 when executing the computer program instructions.
10. A computer-readable storage medium, characterized in that computer program instructions are stored which, when called and executed by a processor, implement the method steps of any of claims 1-4.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111104341.XA CN113806696A (en) | 2021-09-18 | 2021-09-18 | Watermark generation and tracing method, device, equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111104341.XA CN113806696A (en) | 2021-09-18 | 2021-09-18 | Watermark generation and tracing method, device, equipment and storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN113806696A true CN113806696A (en) | 2021-12-17 |
Family
ID=78896136
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202111104341.XA Pending CN113806696A (en) | 2021-09-18 | 2021-09-18 | Watermark generation and tracing method, device, equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113806696A (en) |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109948507A (en) * | 2019-03-14 | 2019-06-28 | 北京百度网讯科技有限公司 | Method and apparatus for detecting table |
| CN110874456A (en) * | 2018-08-31 | 2020-03-10 | 浙江大学 | Watermark embedding method, watermark extracting method, watermark embedding device, watermark extracting device and data processing method |
| CN111382399A (en) * | 2020-03-06 | 2020-07-07 | 北京明朝万达科技股份有限公司 | Method and device for adding watermark |
| CN112016061A (en) * | 2019-12-16 | 2020-12-01 | 江苏水印科技有限公司 | Excel document data protection method based on robust watermarking technology |
| CN112800398A (en) * | 2021-03-29 | 2021-05-14 | 北京志翔科技股份有限公司 | PDF file circulation tracking method |
| CN113177193A (en) * | 2021-04-23 | 2021-07-27 | 深圳依时货拉拉科技有限公司 | Watermark adding method, watermark verifying method and terminal equipment |
-
2021
- 2021-09-18 CN CN202111104341.XA patent/CN113806696A/en active Pending
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110874456A (en) * | 2018-08-31 | 2020-03-10 | 浙江大学 | Watermark embedding method, watermark extracting method, watermark embedding device, watermark extracting device and data processing method |
| CN109948507A (en) * | 2019-03-14 | 2019-06-28 | 北京百度网讯科技有限公司 | Method and apparatus for detecting table |
| CN112016061A (en) * | 2019-12-16 | 2020-12-01 | 江苏水印科技有限公司 | Excel document data protection method based on robust watermarking technology |
| CN111382399A (en) * | 2020-03-06 | 2020-07-07 | 北京明朝万达科技股份有限公司 | Method and device for adding watermark |
| CN112800398A (en) * | 2021-03-29 | 2021-05-14 | 北京志翔科技股份有限公司 | PDF file circulation tracking method |
| CN113177193A (en) * | 2021-04-23 | 2021-07-27 | 深圳依时货拉拉科技有限公司 | Watermark adding method, watermark verifying method and terminal equipment |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| Zhang et al. | Viscode: Embedding information in visualization images using encoder-decoder network | |
| US8170273B2 (en) | Encoding and decoding auxiliary signals | |
| WO2002032031A1 (en) | Watermarks carrying content dependent signal metrics for detecting and characterizing signal alteration | |
| CN108052491A (en) | A kind of automatic processing method and device of certificate document | |
| Sonnet et al. | Illustration watermarks for vector graphics | |
| CN107688731B (en) | Digital watermarking algorithm based on text document protection | |
| EP2518685A1 (en) | Method and apparatus for embedding a watermark image in a host image | |
| CN111680273A (en) | Watermark embedding method, device, electronic equipment and readable storage medium | |
| CN103914639A (en) | Document tracing method and document tracing device | |
| US8149451B2 (en) | Information processing device, information embedding method, and program | |
| Cheung et al. | A sequential quantization strategy for data embedding and integrity verification | |
| CN110874456B (en) | Watermark embedding method, watermark extracting method, watermark embedding device, watermark extracting device and data processing method | |
| CN109671011A (en) | Embedding grammar, extracting method and the electronic equipment of copyright information | |
| CN113806696A (en) | Watermark generation and tracing method, device, equipment and storage medium | |
| CN116127419A (en) | Data processing method, data identification method, font file generation method and device | |
| CN109859090A (en) | Reversible water mark method and device based on human visual system | |
| CN115048665A (en) | Excel file-based information hiding method, device, equipment and storage medium | |
| CN114330621A (en) | Two-dimensional code anti-counterfeiting method and device based on identification information and storage medium | |
| Zhou et al. | A QR data hiding method based on redundant region and BCH | |
| CN111914226A (en) | Background picture generation method and device | |
| Al-Saadi et al. | Rapid and blind watermarking approach of the 3d objects using qr code images for securing copyright | |
| CN104200139A (en) | Method for generating instruction codes in Java software watermark virtualizing method | |
| CN113538198B (en) | Watermark adding method, device, storage medium and electronic equipment | |
| CN113537484B (en) | Network training, encoding and decoding method, device and medium for digital watermarking | |
| CN116362202B (en) | Font generation method, storage medium and electronic device |
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 |