Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Encryption and decryption algorithm for excel file and file protection method

An encryption and decryption, file technology, applied in the field of encryption and decryption of excel files and file protection, to achieve the effect of protecting personal privacy

Active Publication Date: 2022-06-03
HEFEI UNIV OF TECH
View PDF6 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] The purpose of the present invention is to solve the problem of privacy protection of excel files online filling in information and uploading excel files in the prior art group, and provide a kind of encryption and decryption algorithm and file protection method for excel files

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Encryption and decryption algorithm for excel file and file protection method
  • Encryption and decryption algorithm for excel file and file protection method
  • Encryption and decryption algorithm for excel file and file protection method

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0016] The present invention uses utf-8 encoding and decoding, uses original encryption and decryption algorithms, and designs corresponding interfaces according to specific application scenarios and original application ideas, which is convenient for operation, and the specific contents are as follows:

There are titles and the information corresponding to the titles in the excel file. The only attribute is the number. The title position flage of the number needs to be manually entered according to the information in the excel file. For example, flage="F2", then the F column is the column where all numbers are located. If the number of lines is greater than or equal to 3, the number and all titles do not need to be encrypted, and the rest of the information is encrypted to realize the file protection function. A key is randomly set for each number, and the setting of the key is guaranteed to be irregular, its degree and size All are inconsistent, the key consists of a number, ...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

According to the encryption and decryption algorithm and the file protection method, utf-8 coding and decoding are carried out on a text, an original encryption and decryption algorithm is used, an interface with complete functions is designed according to a specific application scene and an original application idea, operation is convenient, the whole process is high in speed, and practicability is achieved. According to the original application idea, a systematic process exists for excel file operation, a private key is distributed to each user, namely a serial number, the key is irregularly arranged and is difficult to crack, and an administrator and the user can generate the key through at least eight-bit passwords. The encryption has two forms, the first form is to encrypt the whole excel file line, the second form is to encrypt personal information and then upload the personal information to an excel table, and utf-8 codes are improved. The decryption has two forms, namely, the decryption of the whole excel file information and the decryption of the private information.

Description

technical field [0001] The invention relates to the technical field of file encryption and decryption, in particular to an encryption and decryption algorithm and a file protection method for excel files. Background technique [0002] The administrator in the group will let the user fill in the excel file online. For private information, such as ID number, family information, home address, etc., he does not want others to know. low efficiency. [0003] The administrators in the group will upload some excel files containing private information. If they are sent to users separately, privacy is guaranteed but the efficiency is low. Therefore, privacy protection technology is required to ensure that users can only view their own information and cannot obtain other people's information. [0004] We live in an information age where privacy protection is important, so there is a huge market demand. SUMMARY OF THE INVENTION [0005] The purpose of the present invention is to pro...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
IPC IPC(8): G06F21/60G06F21/62G06F40/18G06F7/58
CPCG06F21/602G06F21/6245G06F40/18G06F7/588G06F2221/2107
Inventor 宋万詹曙
Owner HEFEI UNIV OF TECH
Features
  • Generate Ideas
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More