Data list import method and terminal thereof

Abstract

The invention is suitable for the technical field of data processing, and provides a data list import method and a terminal thereof. The method comprises the following steps of: obtaining a to-be-imported data list sent by a user terminal; obtaining the number N of currently matched columns, extracting headers of any N columns from unsuccessfully matched columns of the data list and matching the headers with a header in a standard list template; if the headers of the any N columns are not successfully matched with the header of the standard list template, subtracting 1 from the numerical valueof N to obtain the number of currently matched columns; and if the headers of the any N columns are successfully matched with the header of the standard list template, respectively importing the successfully matched N columns in the data list into corresponding columns in the standard list template, and determining the number of the currently matched columns according to the number of unsuccessfully matched columns in the data list. According to the method and the terminal, the problem that the error-tolerant rate is relatively low as an import operation only can be carried out by a server when a list format in the data list is completely consistent with the standard list template in the existing data list import technology is solved.

Description

technical field [0001] The invention belongs to the technical field of data processing, and in particular relates to a method for importing a data list and a terminal thereof. Background technique [0002] With the electronicization of various documents, users often need to import local data lists to the server in their daily work and life, so as to integrate, analyze and count relevant information in the future. Therefore, how to accurately It is particularly important to import the data list to the server. With the existing data list import technology, when the server receives the data list to be imported by the user, the list format in the data list must be completely consistent with the standard list template before the import operation can be performed. The position of the table is swapped, or a new column is inserted in the original column or the original column is deleted. The server will not recognize it, and it will be judged as an error table, so the upload or imp...

AI Technical Summary

Problems solved by technology

[0003] In view of this, the embodiment of the present invention provides a data list import method and its terminal to solve the existing data list import technology. When the server receives the data list to be imported by the user, it needs the list format and the standard list The import operation can only be performed if the template is completely consistent. If the user swaps the position of some columns in the table due to personal habits, or inserts a new column into the original column or deletes the original column, the server will not recognize it. It is judged as an error form, so the upload or import fails, and the error tolerance rate is low

Images