Method for inputting excel file based on xml (extensive markup language) parsing

Abstract

The invention discloses a method for inputting an excel file based on xml (extensive markup language) parsing. The realization process of the method comprises the following steps: taking excel as xml for parsing, parsing every data unit in the xml by comparing header information in the excel, verifying formats and inputting a line with a correct data format into a data table of a corresponding database. Compared with the prior art, the method for inputting the excel file based on xml parsing has the advantages that a large data volume of files are split by setting the matching of the header information, so that the inputting efficiency is improved; a special processing manner is set, so that the flexibility and the usability of data inputting are improved, and the method is strong in practicability, wide in application scope and easy to popularize.

Description

technical field [0001] The invention relates to the field of computer technology, in particular to a method for importing an excel file based on xml analysis with strong practicability. Background technique [0002] As we all know, excel is a common file storage method, but the current storage method is a database, so it is inevitable for data processing and data acquisition to import the data in the excel file into the database. At present, there are many problems in the traditional way of parsing excel, for example: the file cannot be too large (the data cannot exceed 50,000, and each data cannot exceed 10 columns), the number of records in the file in excel exceeds 50,000 (the column of each record When the number exceeds 10 columns), the java virtual machine reports memory overflow and cannot open the data file; excel can only contain one header information, and when there are multiple header information in an excel file, the excel must be split into multiple Import Exc...

AI Technical Summary

Problems solved by technology

At present, there are many problems in the traditional way of parsing excel, for example: the file cannot be too large (the data cannot exceed 50,000, and each data cannot exceed 10 columns), the number of records in the file in excel exceeds 50,000 (the column of each record When the number exceeds 10 columns), the java virtual machine reports memory overflow and cannot open the data file; excel can only contain one header information, and when there are multiple header information in an excel file, the excel must be split into multiple Import Excel with different headers (one header corresponds to one excel data file) one by one; there are some rows in excel that do not belong to any header, but some data in the row needs to be imported as a column information of the header ;For excel data import, it is necessary to perform simple processing on certain columns before importing; cannot automatically generate attachment information, etc.

[0003] For the above problems, the current import method lacks flexibility and ease of use, resulting in the need to waste a lot of manpower and material resources for special processing of data import