Method for converting data table plaintext into binary ciphertext convenient for program to read

Abstract

The invention discloses a method for converting a plaintext of a data table into a binary ciphertext convenient for a program to read, and the method provided by the invention needs to be combined with an open-source Protobuf (version 3.11. X) provided by Google, and is based on a cross-platform programming language Python. Protobuf is an open-source data definition format provided by Google, each column of a data table can be mapped to a specified field in a data structure defined in Protobuf by using Protobuf, a converted binary file is read in a program and converted into an array of a data structure type corresponding to Protobuf, the array is operated, the data hidden in the data table such as the primary key, the maximum value and the minimum value can be packaged, data access can be carried out according to the row number and the column number without reading the Excel file, access can be directly carried out through members of the mapped data structure, and the code readability and the development efficiency are improved.

Description

Technical field[0001]The present invention relates to a method of reading data in an Excel data sheet (XLSX, CSV, etc.), and specifically, the data table is clearly converted to facilitate two-way ciphertexts that can be readable.Background technique[0002]The existing program reads the data in Excel data sheets (XLSX, CSV, etc.) is more messy, because different programming languages ​​are different from the EXCEL data sheet method.[0003]For example, for the C ++ programming language, under the Windows platform, you can use the ODBC to access the specified Excel file, or you can access the specified Excel file via the COM object provided by Excel; first create an ODBC or COM object, open the file, create an Excel object, The way to access the data is to access the line number and the column number. Under the non-Windows platform, such as Linux, you need to install third-party libraries libXLs, similar to the Windows platform. For example, for example, for the Java programming languag...

AI Technical Summary

Problems solved by technology

[0004] Now, the method of reading Excel files for different programming languages ​​and platforms is to parse Excel files through the corresponding library provided by Excel, but for accessing On the unit data, it is accessed through rows and columns; in this way, in the process of program development, it is relatively rigid and will generate a lot of hard coding. If the rows and columns of Excel are changed, the program code also needs to be correspondingly modified. Change; if these data table files are packaged into the corresponding application program, it is a kind of plain text existence, and there is also a certain danger to the security of the application program

Therefore, the existing mainstream method of reading Excel data is not a very friendly way for the demand side and the development side

Images