Method, medium and device for performing data verification when excel file is imported

The invention provides a data verification method and medium during excel file import, and the method comprises the following steps: designing an entity class associated with excel file data, the attribute of the entity class corresponding to one column in the excel file data; self-defining an annotation for identifying a corresponding relationship between the attribute and the column, wherein the annotation comprises a serial number and a data type of the column; data types imported into the excel file are numeric types, text types and date types, corresponding annotations are defined, and the corresponding annotations are added to corresponding entity class attributes according to the specific data type of each column of the excel file; when the excel file is imported, after each column of data corresponds to the entity class attribute, verification is carried out according to the self-defined annotation, if verification passes, value assignment is carried out on the data, and if verification fails, error i