Table format customizable Excel table analysis method

An analysis method and excel technology, applied in the field of Excel table analysis, can solve the problems of complex table form, large amount of data, unable to meet the needs of water conservancy business processing, etc., and achieve the effect of maintaining accuracy and data consistency

Inactive Publication Date: 2013-06-12
HOHAI UNIV
View PDF1 Cites 26 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, due to the complex form, large amount of data, and strong professionalism required by water conservancy business, the traditional Excel reporting and analysis method is far from meeting the processing needs of water conservancy business

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Table format customizable Excel table analysis method
  • Table format customizable Excel table analysis method
  • Table format customizable Excel table analysis method

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0020] Below in conjunction with specific embodiment, further illustrate the present invention, should be understood that these embodiments are only used to illustrate the present invention and are not intended to limit the scope of the present invention, after having read the present invention, those skilled in the art will understand various equivalent forms of the present invention All modifications fall within the scope defined by the appended claims of the present application.

[0021] Such as figure 1 As shown, the Excel table parsing method in a customizable table format includes the following steps:

[0022] Step 1: According to the water transfer business requirements, define the configuration file in XML format corresponding to the Excel table to be parsed. There are two types of configuration files: the first type is an index file in XML format, and its basic form of storage is an Excel file name corresponding to multiple target database table names and an XML conf...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

Abstract

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.

Description

technical field [0001] The invention relates to a general Excel table analysis method in a customizable table format, which is used for solving the data analysis problem of the Excel table of the water adjustment business in complex forms and in different formats in combination with the river basin water transfer business, and belongs to the technical field of computer report processing. Background technique [0002] With the rapid development of information technology, the level of water conservancy informatization has also been greatly improved. In daily office work, watershed managers have problems such as incomplete data, outdated office methods, and low office efficiency in terms of water resource decision-making and water volume dispatch management, which have brought a lot of inconvenience to water resource decision-making and water volume dispatch management. In order to ensure that a large amount of water resources data in different river basins can be accurately an...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
Patent Type & Authority Applications(China)
IPC IPC(8): G06F17/30G06F17/24
Inventor 许峰陈亚明叶枫娄渊胜范珂王亚普余霖周远超
Owner HOHAI UNIV
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap