CN117236307A - An excel data import method, device, equipment and storage medium - Google Patents

Abstract

The application discloses an excel data importing method, device, equipment and storage medium, and relates to the technical field of data processing. The method comprises the following steps: acquiring an excel file, and analyzing the excel file to extract attribute information from an attribute worksheet of the excel file; converting the attribute information into custom object attributes to obtain attribute objects corresponding to the attribute information, and storing the attribute objects into global array variables according to the sequence number sequence; traversing each row and each column of data of each worksheet in the excel file in a circulating way, and carrying out attribute verification on the data of each cell in the excel file by combining a global array variable; after all the data are verified, each data is converted into a target format object for storage based on an excel file and according to a global array variable. The efficiency of the java developer in developing the excle data import function can be improved.

Description

An excel data import method, device, equipment and storage medium

Technical field

The invention relates to the field of data processing technology, and in particular to an excel data import method, device, equipment and storage medium.

Background technique

At present, to implement Java's import of excel data, it is often necessary to define a fixed import template file for each module in advance and an independent verification rule code for each module. This results in high duplication of acceptance codes, and slight changes in module information require hard-coding to modify the original code to suit. The configuration and scalability are not strong. It is difficult to adapt to changing business application scenarios.

Contents of the invention

In view of this, the purpose of the present invention is to provide an excel data import method, device, equipment and medium, which can improve the efficiency of Java developers in developing excel data import functions. The specific plan is as follows:

In the first aspect, this application discloses a method for importing excel data, including:

Obtain an excel file, and parse the excel file to extract attribute information from the attribute worksheet of the excel file;

Convert the attribute information into custom object attributes to obtain attribute objects corresponding to the attribute information, and store the attribute objects in the global array variable in order of column numbers;

By sequentially looping through the data of each row and column of each worksheet in the excel file, and combining the global array variables to perform attribute verification on the data of each cell in the excel file;

After all data is verified, each row of data is converted into a target format object for storage based on the excel file and the global array variable.

Optionally, the attribute information includes attribute English name, attribute Chinese name, attribute type and attribute verification rules.

Optionally, the attribute type includes a custom administrative region; the custom administrative region includes a name attribute of the string type used to identify the name of the administrative division, a coding attribute of the string type used to identify the administrative region code, and One or more items in the long integer id attribute identifying the administrative region id attribute;

The attribute type includes a custom dictionary; the custom dictionary includes one or more of the long integer id attribute used to mark the dictionary item id, and the display name attribute of the string type used to identify the Chinese value of the dictionary. .

Optionally, by sequentially looping through the data of each row and column of each worksheet in the excel file, and combining the global array variables to perform attribute verification on the data of each cell in the excel file, including :

Loop through each row and column of data in each worksheet in the excel file in sequence, and store each cell data into a two-dimensional array;

Loop through the data in each row and column of the two-dimensional array, and during the traversal process, obtain a verification object with the same column value from the global array variable according to the column value of the currently traversed target data;

The verification object is verified using attribute verification rules.

Optionally, the attribute verification rules include a requirement attribute of Boolean type used to identify whether it is nullable, a type attribute of string type used to identify the attribute data type, and a string used to identify the regular expression verification rule. The regular expression attribute of the type, the maximum and minimum value attributes of the string type used to identify the maximum and minimum values, the format attribute of the string type used to identify the data format, the basic integer used to identify the maximum length and minimum length. One or more of the maximum length and minimum length properties of the type.

Optionally, after performing attribute verification on the data of each cell in the excel file in combination with the global array variable, it also includes:

If the verification fails, an error message is constructed based on the data of the current cell, the verification rules for the current cell, and the attribute information corresponding to the data of the current cell;

Insert the error message into the current cell in the form of a comment, and modify the background color of the current cell.

Optionally, based on the excel file and the global array variable, convert each row of data into a target format object for storage, including:

Loop through the excel file and convert each row of data into a target format object according to the global array variable, using the attribute name of each column as the key of the target format object and the data as the value of the target format object;

The target format object is stored in the database, and a success prompt is fed back after successful storage.

In the second aspect, this application discloses an excel data importing device, including:

An attribute information extraction module is used to obtain an excel file and parse the excel file to extract attribute information from the attribute worksheet of the excel file;

The attribute information conversion module is used to convert the attribute information into custom object attributes to obtain the attribute objects corresponding to the attribute information, and store the attribute objects in the global array variable in order of column numbers;

A verification module, configured to sequentially loop through the data of each row and column of each worksheet in the excel file, and perform attribute verification on the data of each cell in the excel file in combination with the global array variable;

The storage module is used to convert each row of data into a target format object for storage based on the excel file and the global array variable after all data verification.

In a third aspect, this application discloses an electronic device, including:

Memory, used to hold computer programs;

A processor, configured to execute the computer program to implement the aforementioned excel data import method.

In a fourth aspect, this application discloses a computer-readable storage medium for storing a computer program; when the computer program is executed by a processor, the aforementioned excel data import method is implemented.

In this application, an excel file is obtained, and the excel file is parsed to extract attribute information from the attribute worksheet of the excel file; the attribute information is converted into custom object attributes to obtain the attribute information Corresponding attribute objects, and store the attribute objects in global array variables in order of column numbers; by sequentially looping through the data of each row and column of each worksheet in the excel file, and combining the data of the global array variables with The data of each cell in the excel file is subjected to attribute verification; after all data is verified, based on the excel file and the global array variable, each row of data is converted into a target format object for storage. It can be seen that the attribute object is converted according to the attribute information defined in the excel attribute worksheet and stored in the global array variable. The attribute object is subsequently used for verification, instead of directly using the javabean defined in java (a reusable component written in JAVA language, which is used to provide The public method that conforms to the consistent design pattern performs a one-to-one conversion of the internal domain exposed member attributes). Therefore, when validating data, there is no need to define a validation class for each excel file module for validation, but a set of validation logic based on the incoming The verification rules can be applied to the verification of all excel file modules, which can effectively improve the efficiency of java developers in developing excel data import functions. It has strong scalability, and the excel import method scheduling is abstract and flexible, realizing the rapid construction of excel data import functions with low code.

Description of drawings

In order to explain the embodiments of the present invention or the technical solutions in the prior art more clearly, the drawings needed to be used in the description of the embodiments or the prior art will be briefly introduced below. Obviously, the drawings in the following description are only These are embodiments of the present invention. For those of ordinary skill in the art, other drawings can be obtained based on the provided drawings without exerting creative efforts.

Figure 1 is a flow chart of an excel data import method provided by this application;

Figure 2 is a schematic structural diagram of an excel data import device provided by this application;

Figure 3 is a structural diagram of an electronic device provided by this application.

Detailed ways

In order to make the purpose, 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 in conjunction with the drawings in the embodiments of the present invention. Obviously, the described embodiments These are only some embodiments of the present invention, rather than all embodiments. Based on the embodiments of the present invention, all other embodiments obtained by those of ordinary skill in the art without creative efforts fall within the scope of protection of the present invention.

In the existing technology, to implement Java's import of excel data, it is often necessary to define a fixed import template file for each module in advance and an independent verification rule code for each module, resulting in high duplication of the acceptance code and the need for hard-coded modifications if the module information changes slightly. The original code has poor adaptability and scalability. It is difficult to adapt to changing business application scenarios. In order to overcome the above technical problems, this application proposes an excel data import method, which can improve the efficiency of Java developers in developing excel data import functions.

The embodiment of the present application discloses a method for importing excel data, as shown in Figure 1. The method may include the following steps:

Step S11: Obtain an excel file, and parse the excel file to extract attribute information from the attribute worksheet of the excel file.

In this embodiment, the excel file uploaded by the user is first obtained, the corresponding file object is created, and the corresponding file stream is obtained; the file stream is a way of reading data from a file or writing data to a file. In the file stream , the file is transmitted in the form of a stream and can be read and written in the form of bytes or strings.

Wherein, the attribute information includes attribute English name, attribute Chinese name, attribute type and attribute verification rules. Specifically, org.apache.poi technology (Apache POI, Apache Poor Obfuscation Implementation, a concise version of fuzzy implementation) is used to parse the excel file to extract attribute information from the attribute worksheet of the excel file. org.apache.poi is a free and open source cross-platform Java API written in Java. Apache POI provides APIs for Java programs to read and write Microsoft Office format files; it parses the excel data to be imported, specifically from the attribute worksheet ( That is, get all the attribute English names, attribute Chinese names, attribute types, and attribute validation rules from the hidden sheet named bean. Attribute types include custom administrative region (Organization) and custom dictionary (PropertyDict).

In this embodiment, the attribute type includes a custom administrative region; the custom administrative region includes a name attribute of string type (String) used to identify the name of the administrative division, and a string type (String) used to identify the administrative region code. One or more of the encoding attributes and the long integer (Long) id attribute used to identify the administrative region id attribute. That is, the custom administrative region contains a name attribute of String type, used to identify the name of the administrative division, an org_code of String type, used to identify the administrative region code, and an id attribute of Long type, used to identify the administrative region's id attribute. The attribute type includes a custom dictionary; the custom dictionary includes one or more of the long integer id attribute used to mark the dictionary item id, and the display name attribute of the string type used to identify the Chinese value of the dictionary. . That is, PropertyDict contains the id attribute of Long type, which marks the id of the dictionary item; it contains the displayName attribute of String type, which identifies the Chinese value of the dictionary.

Step S12: Convert the attribute information into custom object attributes to obtain attribute objects corresponding to the attribute information, and store the attribute objects in the global array variable in order of column numbers.

In this embodiment, the obtained attribute information is directly converted into custom object attributes to obtain attribute objects corresponding to the attribute information, and the attribute objects are stored in global array variables in order of column numbers. That is, the attribute parameters are converted into custom object attributes: object attributes (AttributeObject), and put into the global array variable (attributeArray) in order of the corresponding column numbers. As a result, the data attributes and validation rules to be imported are stored in the array in the exel definition and echo the data, which is more scalable than the back-end pre-defined bean object. And the data is converted into key-value pair objects such as JSONObject without defining bean objects in advance to improve scalability.

Step S13: Loop through the data of each row and column of each worksheet in the excel file in sequence, and perform attribute verification on the data of each cell in the excel file in combination with the global array variable.

In this embodiment, during verification, each row and column of data in the worksheet are traversed in turn, and the attributes of each cell in the excel file are verified based on the attribute information stored in the global array variable. It can be seen that in this embodiment, after the excel data is obtained, it is not converted one-to-one according to the javabean defined by java, but according to the attribute name and attribute type defined by the excel property page. Different from the conversion of javabean, this implementation When verifying example data, there is no need to define a verification class for each module for verification. A set of verification logic can be applied to all module verifications based on the incoming rules.

In this embodiment, the data of each row and column of each worksheet in the excel file is looped sequentially, and the attributes of each cell data in the excel file are verified in combination with the global array variable. It may include: sequentially looping through each row and each column of data in each worksheet in the excel file, and storing each cell data in a two-dimensional array; looping through each row and each column of data in the two-dimensional array, And during the traversal process, a verification object with the same column value is obtained from the global array variable according to the column value of the currently traversed target data; the verification object is verified using attribute verification rules. That is, get the parameter value of the starting row of data, and then use POI technology to get the data from the starting row of data of the first worksheet (sheet), loop through the data of each row and column, and store each cell data into a two-dimensional For use in the array object (String[][]); loop through the data of each row and column of the two-dimensional array; when traversing to the corresponding column value, obtain the verification object of the same column value from the global array variable, and based on Use the validation rules defined by the CustomValidation object to validate the data.

The above attribute validation rules include a requirement attribute of Boolean type used to identify whether it is nullable, a type attribute of string type used to identify the attribute data type, and a regular expression of string type used to identify the regular expression verification rule. Attributes, the maximum and minimum value attributes of the string type used to identify the maximum and minimum values, the format attribute of the string type used to identify the data format, the maximum length of the basic integer type used to identify the maximum length and minimum length and one or more of the minimum length attributes. That is to say, the above-mentioned custom validation type object CustomValidation: contains the required attribute of boolean type, used to identify whether it can be null, the default is false, which means it can be null, and true means it cannot be null; it also contains the type attribute of String type, which is used To identify the attribute data type, you can fill in the java built-in type and custom type; it also contains the regex attribute of the String type, which is used to identify the regular expression verification rules. It is empty by default. If there is a value, it will be verified accordingly; it also contains the String type. The maxValue and minValue attributes are used to identify the maximum and minimum values, mainly for numbers and date types; they also include the format attribute of String type, which is used to identify the data format. If the number type is 00.00, the date type is 'yyyy-mm-dd hh24 :mi:ss', etc., which are empty by default; it also contains minLengh and maxLengh attributes of type int, which are used to identify the maximum length and minimum length. If they are empty, there is no limit.

Step S14: After all data is verified, based on the excel file and the global array variable, convert each row of data into a target format object for storage.

In this embodiment, if the data attribute verification of the current cell passes, the verification of the next cell can be performed. After all data is verified, or after all data in the current row is verified, based on the excel file and the global array variable, Convert each row of data into a target format object for storage. After that, the target format object is specifically stored in the corresponding database, and after the database is successfully stored, a success prompt will be returned to the front end.

In this embodiment, after the attribute verification of the data of each cell in the excel file is performed in conjunction with the global array variable, it may also include: if the verification fails, based on the data of the current cell, for the current cell The verification rules of the cell and the attribute information corresponding to the data of the current cell are used to construct error prompt information; the error prompt information is inserted into the current cell in the form of annotation, and the background color of the current cell is modified. Specifically, if the data verification fails, the error prompt information is combined with the verification rules, the Chinese name of the verification attribute, and the cell information corresponding to the verification data, and the annotation information is inserted into the corresponding cell and the background color of the error cell is marked red. If an error is marked, that is, the information returned after the verification fails, it will be written directly to the corresponding cell of the original data import file, and the error prompt positioning will be more precise and obvious. When the data verification fails, the data conversion and storage will be skipped, the result information will be returned directly, and the error data table will be provided for download. Specifically, you can mark the original data cells with a red background and add error text to indicate more accurate prompts, and you can directly add errors in the Modify the data on the information table and import it again.

In this embodiment, converting each row of data into a target format object for storage based on the excel file and according to the global array variable may include: looping through the excel file and according to the global array variable, Use the attribute name of each column as the key of the target format object and use the data as the value of the target format object, convert each row of data into a target format object; store the target format object in the database, and feedback success after successful storage hint. That is to say, the data is converted into key-value pairs. Therefore, if you need to add a column of data or delete a column of data, you do not need to modify the code corresponding to the back-end bean object. You only need to modify the excel file, which saves workload and is more flexible. There is no need to re-publish the back-end program, just replace the excel template file.

That is to say, if the data verification passes, loop through all the data, and combine the global array variable (attributeArray) with the corresponding cell attribute name and attribute type to convert each row of data into a target format object. The above target format can be JSON or It can be a Map. Taking JSON as an example, the attribute name of each column is used as the key of the JSONObject object, and the data is used as the value of the JSONObject. Each row of data is converted into a JSONObject data, and the converted json data is relative to the defined bean object. Easier to expand. There is no need to modify the code to add or delete fields. You only need to add a column corresponding to the excel field attributes and data.

As can be seen from the above, in this embodiment, an excel file is obtained, and the excel file is parsed to extract attribute information from the attribute worksheet of the excel file; the attribute information is converted into custom object attributes to obtain The attribute object corresponding to the attribute information is stored in the global array variable in order of column number; by sequentially looping through each row and column data of each worksheet in the excel file, and combining the global The array variable performs attribute verification on the data of each cell in the excel file; after all data verification, based on the excel file and the global array variable, each row of data is converted into a target format object for storage. It can be seen that the attribute object is converted according to the attribute information defined in the excel attribute worksheet and stored in the global array variable. The attribute object is subsequently used for verification, instead of directly using the javabean defined in java (a reusable component written in JAVA language, which is used to provide The public method that conforms to the consistent design pattern performs a one-to-one conversion of the internal domain exposed member attributes). Therefore, when validating data, there is no need to define a validation class for each excel file module for validation, but a set of validation logic based on the incoming The verification rules can be applied to the verification of all excel file modules, which can effectively improve the efficiency of java developers in developing excel data import functions. It has strong scalability, and the excel import method scheduling is abstract and flexible, realizing the rapid construction of excel data import functions with low code.

The embodiment of the present application also discloses an excel data importing device, as shown in Figure 2. The device includes:

The attribute information extraction module 11 is used to obtain an excel file and parse the excel file to extract attribute information from the attribute worksheet of the excel file;

The attribute information conversion module 12 is used to convert the attribute information into custom object attributes to obtain the attribute objects corresponding to the attribute information, and store the attribute objects in the global array variable in order of column numbers;

The verification module 13 is used to sequentially loop through the data of each row and column of each worksheet in the excel file, and perform attribute verification on the data of each cell in the excel file in combination with the global array variable;

The storage module 14 is configured to convert each row of data into a target format object for storage based on the excel file and the global array variable after all data verification.

As can be seen from the above, in this embodiment, an excel file is obtained, and the excel file is parsed to extract attribute information from the attribute worksheet of the excel file; the attribute information is converted into custom object attributes to obtain The attribute object corresponding to the attribute information is stored in the global array variable in order of column number; by sequentially looping through each row and column data of each worksheet in the excel file, and combining the global The array variable performs attribute verification on the data of each cell in the excel file; after all data verification, based on the excel file and the global array variable, each row of data is converted into a target format object for storage. It can be seen that the attribute object is converted according to the attribute information defined in the excel attribute worksheet and stored in the global array variable. The attribute object is subsequently used for verification, instead of directly using the javabean defined in java (a reusable component written in JAVA language, which is used to provide The public method that conforms to the consistent design pattern performs a one-to-one conversion of the internal domain exposed member attributes). Therefore, when validating data, there is no need to define a validation class for each excel file module for validation, but a set of validation logic based on the incoming The verification rules can be applied to the verification of all excel file modules, which can effectively improve the efficiency of java developers in developing excel data import functions. It has strong scalability, and the excel import method scheduling is abstract and flexible, realizing the rapid construction of excel data import functions with low code.

In some specific embodiments, the attribute information may specifically include the English name of the attribute, the Chinese name of the attribute, the attribute type, and the attribute verification rules.

In some specific embodiments, the attribute type may specifically include a custom administrative region; the custom administrative region includes a name attribute of a string type used to identify the administrative division name, a string type used to identify the administrative region code One or more of the encoding attributes and the long integer id attribute used to identify the administrative region id attribute; the attribute type may specifically include a custom dictionary; the custom dictionary includes a id attribute used to mark the dictionary item id One or more of the long integer id attribute and the display name attribute of the string type used to identify the Chinese value of the dictionary.

In some specific embodiments, the verification module 13 may specifically include:

A two-dimensional array construction unit, used to sequentially loop through the data of each row and column of each worksheet in the excel file, and store each cell data into a two-dimensional array;

The verification object acquisition unit is used to loop through the data in each row and column of the two-dimensional array, and during the traversal process, obtain the same column value from the global array variable according to the column value of the currently traversed target data. Verification object;

A verification unit is used to verify the verification object using attribute verification rules.

In some specific embodiments, the attribute verification rules may specifically include a requirement attribute of Boolean type used to identify whether it is nullable, a type attribute of string type used to identify the attribute data type, and a regular expression used to identify Regular expression properties of type string for the validation rule, max and min properties of type string used to identify the maximum and minimum values, format properties of type string used to identify the data format, used to identify the maximum length and One or more of the maximum-length and minimum-length properties of the minimum-length primitive integer type.

In some specific embodiments, the excel data import device may include:

The error message framework unit is used to perform attribute verification on the data of each cell in the excel file in conjunction with the global array variable. If the verification fails, based on the data of the current cell, based on the data of the current cell, The verification rules and the attribute information corresponding to the data of the current cell construct error prompt information;

An annotation unit is used to insert the error prompt information into the current cell in the form of annotation, and modify the background color of the current cell.

In some specific embodiments, the storage module 14 may include:

A data conversion unit configured to loop through the excel file and convert each row of data into a target format according to the global array variable, using the attribute name of each column as the key of the target format object and the data as the value of the target format object. object;

A storage unit is used to store the target format object in the database, and feedback a success prompt after successful storage.

Furthermore, the embodiment of the present application also discloses an electronic device, as shown in Figure 3. The content in the figure cannot be considered as any limitation on the scope of the present application.

FIG. 3 is a schematic structural diagram of an electronic device 20 provided by an embodiment of the present application. The electronic device 20 may specifically include: at least one processor 21, at least one memory 22, a power supply 23, a communication interface 24, an input-output interface 25 and a communication bus 26. The memory 22 is used to store a computer program, and the computer program is loaded and executed by the processor 21 to implement the relevant steps in the excel data import method disclosed in any of the foregoing embodiments.

In this embodiment, the power supply 23 is used to provide working voltage for each hardware device on the electronic device 20; the communication interface 24 can create a data transmission channel between the electronic device 20 and external devices, and the communication protocol it follows can be applicable Any communication protocol of the technical solution of this application is not specifically limited here; the input and output interface 25 is used to obtain external input data or output data to the external world, and its specific interface type can be selected according to specific application needs. Here Not specifically limited.

In addition, the memory 22, as a carrier for resource storage, can be a read-only memory, a random access memory, a magnetic disk, an optical disk, etc. The resources stored thereon include an operating system 221, a computer program 222, and data 223 including attribute information. The method can be temporary storage or permanent storage.

Among them, the operating system 221 is used to manage and control each hardware device and the computer program 222 on the electronic device 20 to realize the calculation and processing of the massive data 223 in the memory 22 by the processor 21. It can be Windows Server, Netware, Unix, Linux etc. In addition to computer programs that can be used to complete the excel data import method executed by the electronic device 20 disclosed in any of the foregoing embodiments, the computer program 222 may further include computer programs that can be used to complete other specific tasks.

Furthermore, embodiments of the present application also disclose a computer storage medium, which stores computer-executable instructions. When the computer-executable instructions are loaded and executed by a processor, any of the foregoing embodiments disclosed Excel data import method steps.

Each embodiment in this specification is described in a progressive manner. Each embodiment focuses on its differences from other embodiments. The same or similar parts between the various embodiments can be referred to each other. As for the device disclosed in the embodiment, since it corresponds to the method disclosed in the embodiment, the description is relatively simple. For relevant details, please refer to the description in the method section.

The steps of the methods or algorithms described in conjunction with the embodiments disclosed herein may be implemented directly in hardware, in software modules executed by a processor, or in a combination of both. Software modules may be located in random access memory (RAM), memory, read-only memory (ROM), electrically programmable ROM, electrically erasable programmable ROM, registers, hard disks, removable disks, CD-ROMs, or anywhere in the field of technology. any other known form of storage media.

Finally, it should be noted that in this article, relational terms such as first and second are only used to distinguish one entity or operation from another entity or operation, and do not necessarily require or imply that these entities or any such actual relationship or sequence between operations. Furthermore, the terms "comprises," "comprises," or any other variations thereof are intended to cover a non-exclusive inclusion such that a process, method, article, or apparatus that includes a list of elements includes not only those elements, but also those not expressly listed other elements, or elements inherent to the process, method, article or equipment. Without further limitation, an element defined by the statement "comprises a..." does not exclude the presence of additional identical elements in a process, method, article, or apparatus that includes the stated element.

The above is a detailed introduction to an excel data import method, device, equipment and medium provided by the present invention. Specific examples are used in this article to illustrate the principles and implementation methods of the present invention. The description of the above embodiments is only for assistance. Understand the method of the present invention and its core idea; at the same time, for those of ordinary skill in the field, there will be changes in the specific implementation and application scope based on the idea of the present invention. In summary, the content of this specification does not It should be understood as a limitation of the invention.

Claims (10)

1. A method for importing excel data, which is characterized by including: Obtain an excel file, and parse the excel file to extract attribute information from the attribute worksheet of the excel file; Convert the attribute information into custom object attributes to obtain attribute objects corresponding to the attribute information, and store the attribute objects in the global array variable in order of column numbers; By sequentially looping through the data of each row and column of each worksheet in the excel file, and combining the global array variables to perform attribute verification on the data of each cell in the excel file; After all data is verified, each row of data is converted into a target format object for storage based on the excel file and the global array variable. 2. The excel data import method according to claim 1, characterized in that the attribute information includes attribute English names, attribute Chinese names, attribute types and attribute verification rules. 3. The excel data import method according to claim 2, characterized in that the attribute type includes a custom administrative region; the custom administrative region includes a name attribute of a string type used to identify the name of an administrative division, and a user-defined administrative region. One or more of the string type encoding attribute used to identify the administrative region code, and the long integer id attribute used to identify the administrative region id attribute; The attribute type includes a custom dictionary; the custom dictionary includes one or more of the long integer id attribute used to mark the dictionary item id, and the display name attribute of the string type used to identify the Chinese value of the dictionary. . 4. The excel data import method according to claim 1, characterized in that the step is to sequentially loop through the data in each row and column of each worksheet in the excel file, and combine the global array variables to The data of each cell in the excel file is subject to attribute verification, including: Loop through each row and column of data in each worksheet in the excel file in sequence, and store each cell data into a two-dimensional array; Loop through the data in each row and column of the two-dimensional array, and during the traversal process, obtain a verification object with the same column value from the global array variable according to the column value of the currently traversed target data; The verification object is verified using attribute verification rules. 5. The excel data import method according to claim 4, characterized in that the attribute verification rules include a Boolean type requirement attribute used to identify whether it can be null, and a string type type used to identify the attribute data type. Attributes, a regular expression attribute of type string used to identify the regular expression validation rule, a maximum and minimum attribute of type string used to identify the maximum and minimum values, a format of type string used to identify the data format Property that identifies one or more of the maximum-length and minimum-length properties of a basic integer type. 6. The excel data import method according to claim 1, characterized in that, after performing attribute verification on the data of each cell in the excel file in combination with the global array variable, it further includes: If the verification fails, an error message is constructed based on the data of the current cell, the verification rules for the current cell, and the attribute information corresponding to the data of the current cell; Insert the error message into the current cell in the form of a comment, and modify the background color of the current cell. 7. The excel data import method according to claim 1, characterized in that, based on the excel file and according to the global array variable, each row of data is converted into a target format object for storage, including: Loop through the excel file and convert each row of data into a target format object according to the global array variable, using the attribute name of each column as the key of the target format object and the data as the value of the target format object; The target format object is stored in the database, and a success prompt is fed back after successful storage. 8. An excel data importing device, characterized in that it includes: An attribute information extraction module is used to obtain an excel file and parse the excel file to extract attribute information from the attribute worksheet of the excel file; The attribute information conversion module is used to convert the attribute information into custom object attributes to obtain the attribute objects corresponding to the attribute information, and store the attribute objects in the global array variable in order of column numbers; A verification module, configured to sequentially loop through the data of each row and column of each worksheet in the excel file, and perform attribute verification on the data of each cell in the excel file in combination with the global array variable; The storage module is used to convert each row of data into a target format object for storage based on the excel file and the global array variable after all data verification. 9. An electronic device, characterized in that it includes: Memory, used to hold computer programs; A processor, configured to execute the computer program to implement the excel data import method according to any one of claims 1 to 7. 10. A computer-readable storage medium, characterized in that it is used to store a computer program; wherein when the computer program is executed by a processor, the excel data import method according to any one of claims 1 to 7 is implemented.