A method for encrypting EXCEL data

By dividing cell categories in Excel files and performing disguised data replacement and position exchange, encryption algorithm switching, the problem of insufficient security of data encryption in Excel files is solved, and the overall security and difficulty of the file is improved.

CN118520477BActive Publication Date: 2024-11-12北京科杰科技有限公司
View PDF 0 Cites 0 Cited by

Patent Information

Application Number
CN202410667457.1
Authority / Receiving Office
CN · China
Patent Type
Patents(China)
Current Assignee / Owner
Filing Date
2024-05-28
Publication Date
2024-11-12
Estimated Expiration
2044-05-28

AI Technical Summary

Technical Problem

In the prior art, when encrypting Excel file data, different encryption methods are not adopted for the criticality of the data in the file, resulting in poor encryption security.

Method used

By obtaining the Excel file to be sent, dividing cell categories, filtering out the referenced cells and isolated cells, generating fake data to replace the real data, performing position exchange, and selecting encryption algorithms based on the number of cells to encrypt the data and Decryption to increase file security.

Benefits of technology

Improves the security of Excel file data, increases the difficulty of content interpretation, and reduces the risk of being cracked or attacked.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN118520477B_ABST
    Figure CN118520477B_ABST
Patent Text Reader

Abstract

The invention relates to the technical field of data security, and in particular to an EXCEL data encryption method. The invention obtains an EXCEL file to be sent, divides the categories of each cell, screens out referenced cells and referenced cells, identifies characteristic referenced cells, generates a plurality of disguised data, replaces real data in the characteristic referenced cells, selects a plurality of isolated cell pairs, swaps the positions of real contents contained in the isolated cell pairs, adds a new workbook, randomly stores the remaining disguised data and real data in the new workbook, determines a disguised record, selects an encryption algorithm, encrypts the disguised data, obtains encrypted ciphertext, stores it in a ciphertext storage cell of the new workbook, and sends it to a receiving end. The receiving end selects a decryption algorithm, extracts the encrypted ciphertext in the ciphertext storage cell, and decrypts it to obtain a disguised record. The invention adopts different methods to encrypt cells, increases the difficulty of interpreting contents in the EXCEL file, and improves the security of the EXCEL file data.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The present invention relates to the technical field of data security, and in particular to an EXCEL data encryption method. Background Art

[0002] Excel files may contain sensitive information such as personal identity information, financial data, and business secrets. Encrypting Excel file data is to protect the sensitive information contained therein from being accessed or leaked by unauthorized personnel and to ensure data security.

[0003] Chinese Patent Publication No.: CN114580001A, discloses an encryption and decryption algorithm and file protection method for excel files, performs utf-8 encoding and decoding on text, uses original encryption and decryption algorithms, designs a functional interface based on specific application scenarios and original application ideas, is easy to operate, and the whole process is fast and practical. Original application ideas, there is a systematic process for excel file operations, each user number will be assigned a private key, the key setting is irregular and difficult to crack, and administrators and users can generate keys through at least eight-digit passwords. There are two forms of encryption, the first is to encrypt the entire excel file, and the second is to encrypt personal information and upload it to an excel table, in which the utf-8 encoding code is improved. There are two forms of decryption, namely, decryption of the entire excel file information and decryption of private information.

[0004] However, there are still the following problems in the prior art:

[0005] In the prior art, when encrypting data information in an Excel file, different encryption methods are not used according to the criticality of the data in the Excel file, so there may be a problem of poor encryption security of the Excel file data. Summary of the invention

[0006] To this end, the present invention provides an EXCEL data encryption method to overcome the problem in the prior art that when encrypting Excel file data information, different encryption methods are not used according to the criticality of the data in the Excel file, thereby possibly resulting in poor encryption security of the Excel file data.

[0007] To achieve the above object, the present invention provides an EXCEL data encryption method, comprising:

[0008] Step S1, obtaining an EXCEL file to be sent, and classifying each cell according to the reference relationship between the formula and the cell in the EXCEL file, including reference relationship type cells and isolated type cells;

[0009] Step S2, performing encryption replacement on the characteristic referenced cells, including:

[0010] Select any disguised data to replace the real data in the cell referenced by the feature;

[0011] The characteristic referenced cells are selected from the reference relationship class cells, and the disguised data is generated based on the character length of the real data;

[0012] Step S3, randomly selecting a number of isolated cell pairs, obtaining position coordinate pairs of the isolated cell pairs, and swapping the positions of the real contents contained in the isolated cell pairs;

[0013] Step S4, adding a new workbook, randomly storing the remaining disguised data and real data in the new workbook, and determining disguised records, including the position coordinates of the characteristic referenced cells, the position coordinates of the real data in the new workbook, and the position coordinate pairs of the isolated cell pairs that exchange the real content;

[0014] Step S5, selecting an encryption algorithm according to the number of characteristic referenced cells, encrypting the disguised record according to the encryption algorithm to obtain encrypted ciphertext, storing the encrypted ciphertext in the ciphertext storage cell of the new workbook, and sending the EXCEL file to the receiving end;

[0015] Step S6, the receiving end selects a decryption algorithm according to the number of characteristic referenced cells in the EXCEL file, extracts the encrypted ciphertext in the ciphertext storage cell and decrypts it to obtain a disguised record, exchanges the real content in the isolated cell pair according to the disguised record, and extracts the real data in the corresponding cells in the new workbook to replace the disguised data in the characteristic referenced cells.

[0016] Furthermore, in step S1, if the first preset condition is met, the cell category is a reference relationship cell; if the first preset condition is not met, the cell category is an isolated cell, and the first preset condition is that there is a formula in the cell or the cell is a cell referenced by a formula.

[0017] Furthermore, in step S2, the process of identifying the characteristic referenced cell includes:

[0018] Determine the referenced cells in the reference relationship class cells;

[0019] The number of times the referenced cell is referenced is compared with a preset reference number comparison threshold. If the number of times the referenced cell is referenced is greater than the preset reference number comparison threshold, the referenced cell is identified as a characteristic referenced cell.

[0020] Furthermore, in the step S2, a number of disguised data are generated according to the character length of the real data in the characteristic referenced cell, wherein the character length of the disguised data is the same as the character length of the real data.

[0021] Furthermore, in step S3, the process of selecting several isolated cell pairs includes selecting cells with the same text character length as isolated cell pairs, or selecting cells with the same numeric character length as isolated cell pairs, wherein a single isolated cell pair contains two cells.

[0022] Furthermore, in step S3, the number of isolated cell pairs is selected according to the number of isolated cells, wherein the number of isolated cells is positively correlated with the number of isolated cell pairs.

[0023] Furthermore, in step S5, an encryption algorithm is selected according to the number of cells referenced by the feature.

[0024] Matching the quantity with a plurality of quantity intervals one by one, and if the quantity belongs to any of the quantity intervals, selecting an encryption algorithm associated with the quantity interval;

[0025] There are several encryption algorithms preset, each of which is associated with a unique number interval, and each of which is different.

[0026] Furthermore, in step S6, the receiving end selects a decryption algorithm according to the number of characteristic referenced cells in the EXCEL file.

[0027] Matching the number with a number of number intervals one by one, and if the number belongs to any of the number intervals, selecting a decryption algorithm associated with the number interval;

[0028] There are several decryption algorithms preset, each of which is associated with a unique number interval, and each of which is different.

[0029] Furthermore, in step S6, the process of extracting the real data in the corresponding cell in the new workbook to replace the disguised data in the characteristic referenced cell includes:

[0030] Determine the location coordinates of the real data in the new workbook;

[0031] Determine the position coordinates of the referenced cell of the characteristic of the disguised data to be replaced;

[0032] Replace the fake data with real data.

[0033] Furthermore, in step S6, the process of exchanging the real content in the isolated cell pair according to the disguised record includes:

[0034] Determine the position coordinate pairs of isolated cell pairs that exchange real contents;

[0035] Swap the contents contained in the position coordinate pair.

[0036] Compared with the prior art, the present invention obtains an EXCEL file to be sent, divides the categories of each cell, screens out referenced cells and referencing cells, identifies characteristic referenced cells, generates a number of disguised data, replaces the real data in the characteristic referenced cells, selects a number of isolated cell pairs, swaps the positions of the real contents contained in the isolated cell pairs, adds a new workbook, randomly stores the remaining disguised data and the real data in the new workbook, determines the disguised records, selects an encryption algorithm, encrypts the disguised records, obtains encrypted ciphertext, stores it in a ciphertext storage cell of the new workbook, and sends it to a receiving end, where the receiving end selects a decryption algorithm, extracts the encrypted ciphertext in the ciphertext storage cell, and decrypts it to obtain the disguised record. The present invention encrypts cells in different ways, increases the difficulty of interpreting the contents in the EXCEL file, and improves the security of the EXCEL file data.

[0037] In particular, the present invention classifies each cell according to the reference relationship between the formula and the cell in the EXCEL file. Since the formula in the EXCEL file calculates the result by referencing the numerical value or formula of other cells, the data content in the cell containing the formula will be affected by the data in the cell referenced in the formula. Therefore, if there is a problem with the referenced cell, other cells that reference the cell may also be affected. The numerical value of the cell that does not have a reference relationship will not affect the data of other cells. The content contained in the cell that does not have a reference relationship may make it difficult to interpret the content of the EXCEL file due to the existence of a logical relationship. Therefore, different methods should be used to encrypt the cells, thereby making the EXCEL file data more secure.

[0038] In particular, the present invention identifies characteristic referenced cells based on the number of times the referenced cells are referenced. Since the number of times the referenced cells are referenced can characterize the importance of the cell to a certain extent, the more times the cells are referenced, the greater the importance of the cell is. Therefore, it is more necessary to encrypt the cells to prevent leakage of the cell data, thereby improving the security of the EXCEL file data.

[0039] In particular, the present invention selects a number of isolated cell pairs, obtains the position coordinate pairs of the isolated cell pairs, and swaps the positions of the real contents contained in the isolated cell pairs. By swapping the positions of the real contents, the real contents that may have a logical relationship can be confused, making the logical structure in the EXCEL file less obvious, thereby increasing the difficulty of interpreting the contents in the EXCEL file and improving the security of the EXCEL file data.

[0040] In particular, the present invention selects an encryption algorithm based on the number of characteristic referenced cells. The security requirements of EXCEL files corresponding to different data volumes may be different, and different data volumes have different sensitivity levels. For large data sets, the security requirements are higher, and the encryption algorithm is selected based on the number of characteristic referenced cells so that the encryption algorithm of each EXCEL file is constantly switched, and the switching method is unpredictable, thereby improving the security of the EXCEL file data and reducing the risk of being cracked or attacked. BRIEF DESCRIPTION OF THE DRAWINGS

[0041] Figure 1 It is a step diagram of the EXCEL data encryption method of an embodiment of the invention;

[0042] Figure 2 A category logic decision diagram for dividing each cell in an embodiment of the invention;

[0043] Figure 3 The identification feature of the embodiment of the invention is a referenced cell logic decision diagram;

[0044] Figure 4 Schematic diagram of encryption method for each cell category according to an embodiment of the invention. DETAILED DESCRIPTION

[0045] In order to make the objects and advantages of the present invention more clearly understood, the present invention is further described below in conjunction with embodiments; it should be understood that the specific embodiments described herein are only used to explain the present invention and are not used to limit the present invention.

[0046] The preferred embodiments of the present invention are described below with reference to the accompanying drawings. It should be understood by those skilled in the art that these embodiments are only used to explain the technical principles of the present invention and are not intended to limit the protection scope of the present invention.

[0047] In addition, it should be noted that in the description of the present invention, unless otherwise clearly specified and limited, the term "connection" should be understood in a broad sense, for example, it can be a fixed connection, a detachable connection, or an integral connection; it can be a mechanical connection or an electrical connection; it can be a direct connection, or it can be an indirect connection through an intermediate medium, or it can be the internal communication of two components. For those skilled in the art, the specific meanings of the above terms in the present invention can be understood according to specific circumstances.

[0048] See also Figure 1-Figure 4 As shown, Figure 1 This is a step diagram of the EXCEL data encryption method of the embodiment of the invention. Figure 2 The logical decision diagram for classifying each cell in the embodiment of the invention is shown below. Figure 3 The identification feature of the embodiment of the invention is a referenced cell logic decision diagram, Figure 4 The following is a schematic diagram of the encryption method of each cell type in an embodiment of the invention. The EXCEL data encryption method of the present invention includes:

[0049] Step S1, obtaining an EXCEL file to be sent, and classifying each cell according to the reference relationship between the formula and the cell in the EXCEL file, including reference relationship type cells and isolated type cells;

[0050] Step S2, performing encryption replacement on the characteristic referenced cells, including:

[0051] Select any disguised data to replace the real data in the cell referenced by the feature;

[0052] The characteristic referenced cells are selected from the reference relationship class cells, and the disguised data is generated based on the character length of the real data;

[0053] Step S3, randomly selecting a number of isolated cell pairs, obtaining position coordinate pairs of the isolated cell pairs, and swapping the positions of the real contents contained in the isolated cell pairs;

[0054] Step S4, adding a new workbook, randomly storing the remaining disguised data and real data in the new workbook, and determining disguised records, including the position coordinates of the characteristic referenced cells, the position coordinates of the real data in the new workbook, and the position coordinate pairs of the isolated cell pairs that exchange the real content;

[0055] Step S5, selecting an encryption algorithm according to the number of characteristic referenced cells, encrypting the disguised record according to the encryption algorithm to obtain encrypted ciphertext, storing the encrypted ciphertext in the ciphertext storage cell of the new workbook, and sending the EXCEL file to the receiving end;

[0056] Step S6, the receiving end selects a decryption algorithm according to the number of characteristic referenced cells in the EXCEL file, extracts the encrypted ciphertext in the ciphertext storage cell and decrypts it to obtain a disguised record, exchanges the real content in the isolated cell pair according to the disguised record, and extracts the real data in the corresponding cells in the new workbook to replace the disguised data in the characteristic referenced cells.

[0057] Specifically, the present invention does not limit the specific method of generating a plurality of disguised data. Optionally, a random generator is used to generate a plurality of random character strings having the same character length as the real data. This is a prior art and will not be described in detail.

[0058] Specifically, in step S1, if the first preset condition is met, the cell category is a reference relationship cell; if the first preset condition is not met, the cell category is an isolated cell, and the first preset condition is that there is a formula in the cell or the cell is a cell referenced by a formula.

[0059] It can be understood that, for example, if the formula in cell F1 is SUM=D1+E1, then cell F1 is the cell containing the formula, cell D1 and cell E1 are cells referenced by the formula, so cell D1, cell E1, and cell F1 are reference relationship cells.

[0060] Specifically, the present invention classifies each cell according to the reference relationship between the formula and the cell in the EXCEL file. Since the formula in the EXCEL file calculates the result by referencing the numerical value or formula of other cells, the data content in the cell containing the formula will be affected by the data in the cell referenced in the formula. Therefore, if there is a problem with the referenced cell, it may cause other cells that reference the cell to be affected as well. The numerical value of the cell without a reference relationship will not affect the data of other cells. The content contained in the cell without a reference relationship may be difficult to interpret the content of the EXCEL file due to the existence of a logical relationship. Therefore, different methods should be used to encrypt the cells, thereby making the EXCEL file data more secure.

[0061] Specifically, in step S2, the referencing cell is a cell containing a formula, and the referenced cell is a cell referenced in the formula.

[0062] Specifically, in step S2, the process of identifying the characteristic referenced cell includes:

[0063] Determine the referenced cells in the reference relationship class cells;

[0064] The number of times the referenced cell is referenced is compared with a preset reference number comparison threshold. If the number of times the referenced cell is referenced is greater than the preset reference number comparison threshold, the referenced cell is identified as a characteristic referenced cell.

[0065] In this embodiment, the preset citation count comparison threshold is selected within the range of [3, 5].

[0066] Specifically, the present invention identifies characteristic referenced cells based on the number of times the referenced cells are referenced. Since the number of times the referenced cells are referenced can characterize the importance of the cell to a certain extent, the more times the cells are referenced, the greater the importance of the cell is. Therefore, it is more necessary to encrypt the cells to prevent the leakage of the cell data, thereby improving the security of the EXCEL file data.

[0067] Specifically, in step S2, a number of disguised data are generated according to the character length of the real data in the characteristic referenced cell, wherein the character length of the disguised data is the same as the character length of the real data.

[0068] Specifically, in step S3, the process of selecting several isolated cell pairs includes selecting cells with the same text character length as isolated cell pairs, or selecting cells with the same numeric character length as isolated cell pairs, wherein a single isolated cell pair contains two cells.

[0069] It is understandable that in an EXCEL file, the first row and the first column usually contain headers and identification data, such as column headers or row labels. These data are usually used to describe the content of the entire data set, rather than actual sensitive information. Therefore, it may not be necessary to encrypt the data in these cells, so the cells contained in the first row and the first column are not selected when selecting isolated cell pairs.

[0070] Specifically, in step S3, the number of isolated cell pairs is selected according to the number of isolated cells, wherein the number of isolated cells Qg is positively correlated with the number of isolated cell pairs Qd.

[0071] In this embodiment, optionally, Qd=0.1Qg.

[0072] Specifically, the present invention selects a number of isolated cell pairs, obtains the position coordinate pairs of the isolated cell pairs, and swaps the real contents contained in the isolated cell pairs. By swapping the real contents, the real contents that may have a logical relationship can be confused, making the logical structure in the EXCEL file less obvious, thereby increasing the difficulty of interpreting the contents in the EXCEL file and improving the security of the EXCEL file data.

[0073] Specifically, in step S5, an encryption algorithm is selected according to the number of cells referenced by the feature.

[0074] Matching the quantity with a plurality of quantity intervals one by one, and if the quantity belongs to any of the quantity intervals, selecting an encryption algorithm associated with the quantity interval;

[0075] There are several encryption algorithms preset, each of which is associated with a unique number interval, and each of which is different.

[0076] Specifically, there is no limitation on the specific form of the encryption algorithm, as long as it can encrypt characters into encrypted ciphertext. The encryption algorithm can be in the form of a symmetric encryption algorithm. To meet the needs, several groups of encryption algorithms need to be set. Of course, the decryption algorithms corresponding to each encryption algorithm are set synchronously, which will not be repeated here.

[0077] Specifically, the interval length of the number interval can be selected within [5, 10]. It can be understood that the number of number intervals is the same as the number of encryption algorithms to build an association relationship so that a single encryption algorithm is associated with the number interval of the displacement. Preferably, the number interval should be continuous, which will not be repeated here.

[0078] Specifically, the present invention selects an encryption algorithm based on the number of characteristic referenced cells. The security requirements of EXCEL files corresponding to different data volumes may be different, and different data volumes have different sensitivity levels. For large data sets, the security requirements are higher, and the encryption algorithm is selected based on the number of characteristic referenced cells so that the encryption algorithm of each EXCEL file is constantly switched, and the switching method is unpredictable, thereby improving the security of EXCEL file data and reducing the risk of being cracked or attacked.

[0079] Specifically, in step S6, the receiving end selects a decryption algorithm according to the number of characteristic referenced cells in the EXCEL file.

[0080] Matching the number with a number of number intervals one by one, and if the number belongs to any of the number intervals, selecting a decryption algorithm associated with the number interval;

[0081] There are several decryption algorithms preset, each of which is associated with a unique number interval, and each of which is different.

[0082] Specifically, in step S6, the process of extracting the real data in the corresponding cell in the new workbook to replace the disguised data in the characteristic referenced cell includes:

[0083] Determine the location coordinates of the real data in the new workbook;

[0084] Determine the position coordinates of the referenced cell of the characteristic of the disguised data to be replaced;

[0085] Replace the fake data with real data.

[0086] For example, the real coordinates in the new workbook are located at F10, and the characteristic referenced cell of the disguised data to be replaced is located at E5. Then, the content contained in the characteristic referenced cell with the coordinates F10 in the new workbook will be replaced with the content contained in the characteristic referenced cell with the coordinates E5.

[0087] Specifically, in step S6, the process of exchanging the real content in the isolated cell pair according to the disguised record includes:

[0088] Determine the position coordinate pairs of isolated cell pairs that exchange real contents;

[0089] Swap the contents contained in the position coordinate pair.

[0090] For example, if the position coordinate pair of the isolated cell pair that exchanges the real content is (D1, M20), then the positions of the content contained in D1 and M20 are exchanged.

[0091] If the EXCEL data encryption method of the present invention is implemented in the form of a software functional unit and sold or used as an independent product, it can be stored in a computer-readable storage medium. Based on such an understanding, the technical solution of the present invention is essentially or the part that contributes to the prior art or all or part of the technical solution can be embodied in the form of a software product. The computer software product is stored in a storage medium, including a number of instructions for enabling a computer device (which can be a personal computer, a server, or a network device, etc.) to execute all or part of the steps of the method described in each embodiment of the present invention, and the aforementioned storage medium includes: U disk, mobile hard disk, read-only memory (ROM, Read-Only Memory), random access memory (RAM, Random Access Memory), disk or optical disk, etc. Various media that can store program codes.

[0092] So far, the technical solutions of the present invention have been described in conjunction with the preferred embodiments shown in the accompanying drawings. However, it is easy for those skilled in the art to understand that the protection scope of the present invention is obviously not limited to these specific embodiments. Without departing from the principle of the present invention, those skilled in the art can make equivalent changes or substitutions to the relevant technical features, and the technical solutions after these changes or substitutions will fall within the protection scope of the present invention.

Claims

1. A method for encrypting EXCEL data. It is characterized in that include: Step S1, obtaining an EXCEL file to be sent, and classifying each cell according to the reference relationship between the formula and the cell in the EXCEL file, including reference relationship type cells and isolated type cells; Step S2, filtering out referenced cells and referencing cells from the reference relationship class cells, identifying characteristic referenced cells, generating a number of disguised data, and selecting any disguised data to replace the real data in the characteristic referenced cells; Step S3, randomly selecting a number of isolated cell pairs, obtaining position coordinate pairs of the isolated cell pairs, and swapping the positions of the real contents contained in the isolated cell pairs; Step S4, adding a new workbook, randomly storing the remaining disguised data and real data in the new workbook, and determining disguised records, including the position coordinates of the characteristic referenced cells, the position coordinates of the real data in the new workbook, and the position coordinate pairs of isolated cell pairs; Step S5, selecting an encryption algorithm according to the number of characteristic referenced cells, encrypting the disguised record according to the encryption algorithm to obtain encrypted ciphertext, storing the encrypted ciphertext in the ciphertext storage cell of the new workbook, and sending the EXCEL file to the receiving end; Step S6, the receiving end selects a decryption algorithm according to the number of characteristic referenced cells in the EXCEL file, extracts the encrypted ciphertext in the ciphertext storage cell and decrypts it to obtain a disguised record, exchanges the real content in the isolated cell pair according to the disguised record, and extracts the real data in the corresponding cell in the new workbook to replace the disguised data in the characteristic referenced cell; In step S1, if the first preset condition is met, the cell category is a reference relationship cell; if the first preset condition is not met, the cell category is an isolated cell, and the first preset condition is that there is a formula in the cell or the cell is a cell referenced by a formula; In step S2, the process of identifying the characteristic referenced cell includes: Comparing the number of citations with a preset citation number comparison threshold, if the number of citations of a cell is greater than the preset citation number comparison threshold, identifying the cell as a characteristic citation cell; In the step S2, a plurality of disguised data are generated according to the character length of the real data in the characteristic referenced cell, wherein the character length of the disguised data is the same as the character length of the real data; In the step S3, the process of selecting a plurality of isolated cell pairs includes selecting cells with the same text character length as isolated cell pairs, or selecting cells with the same numeric character length as isolated cell pairs, wherein a single isolated cell pair includes two cells; In step S5, an encryption algorithm is selected according to the number of cells referenced by the feature. Matching the quantity with a plurality of quantity intervals one by one, and if the quantity belongs to any of the quantity intervals, selecting an encryption algorithm associated with the quantity interval; There are several encryption algorithms preset, each of which is associated with a unique number interval, and each of which is different.

2. The EXCEL data encryption method according to claim 1, It is characterized in that In the step S3, the number of isolated cell pairs is selected according to the number of isolated cells, wherein the number of isolated cells is positively correlated with the number of isolated cell pairs.

3. The EXCEL data encryption method according to claim 1, It is characterized in that In step S6, the receiving end selects a decryption algorithm according to the number of characteristic referenced cells in the EXCEL file. Matching the number with a number of number intervals one by one, and if the number belongs to any of the number intervals, selecting a decryption algorithm associated with the number interval; There are several decryption algorithms preset, each of which is associated with a unique number interval, and each of which is different.

4. The EXCEL data encryption method according to claim 1, It is characterized in that In step S6, the process of extracting the real data in the corresponding cell in the new workbook to replace the disguised data in the characteristic referenced cell includes: Determine the location coordinates of the real data in the new workbook; Determine the position coordinates of the referenced cell of the characteristic of the disguised data to be replaced; Replace the fake data with real data.

5. The EXCEL data encryption method according to claim 1, It is characterized in that In step S6, the process of exchanging the real content in the isolated cell pair according to the disguised record includes: Determine the position coordinate pairs of isolated cell pairs that exchange real contents; Swap the contents contained in the position coordinate pair.