The invention discloses a table format customizable Excel table
analysis method which comprises the steps of defining an
XML (Extensive Makeup Language) format configuration file corresponding to an Excel table to be resolved according to
water diversion business requirements, uploading an Excel file to a
Web server through a browser, resolving the file, obtaining a target data sheet of the file and information of the corresponding
XML configuration file according to a filename of the uploaded file, resolving the configuration file, analyzing contents of the uploaded file through the information of the configuration file, packaging the information to be warehoused into a data object, warehousing data with Hibernate, and uploading a file
backup to the
server. According to the method, general resolution of complicated Excel is realized through the configurable file, the method is particularly applicable to
processing river basin
water diversion business tables, and a precise error information prompt mechanism and a
transaction management mechanism ensures accuracy and consistency of the data of a
database.