Excel data analysis method and system

A data analysis and data technology, applied in the field of data processing, can solve problems such as the inability to input data into software systems, and achieve the effect of improving development efficiency and reducing development costs

Active Publication Date: 2017-09-15
北京思特奇信息技术股份有限公司
View PDF6 Cites 4 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0002] With the development of software technology, the demand for software in various industries has grown linearly, and the software background needs to process a large amount of data. Excel is a p

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
  • Excel data analysis method and system
  • Excel data analysis method and system
  • Excel data analysis method and system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0038] The principles and features of the present invention are described below in conjunction with the accompanying drawings, and the examples given are only used to explain the present invention, and are not intended to limit the scope of the present invention.

[0039] Such as figure 1 As shown, the present invention provides an excel data analysis method 100, comprising the following steps:

[0040] 101. Convert the excel file into a workbook instance workbook;

[0041] 102. Read and save the configuration file of the excel file, the configuration file includes the configuration information of the excel file;

[0042] 103. Parse the workbook instance workbook into java data according to the configuration information, and encapsulate the java data into a javabean collection;

[0043] 104. Save the javabean collection to a database database.

[0044] Specifically, because the software cannot directly operate Excel files, the Excel file must first be converted into an oper...

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 relates to an excel data analysis method and system. The method comprises the steps of converting an excel file into a workbook instance; reading and storing a configuration file of the excel file, wherein the configuration file contains configuration information of the excel file; analyzing the workbook instance into java data according to the configuration information, and packaging the java data in a javabean set; and storing the javabean set in a database. According to the method and the system, Excel document analysis services are provided for the fields of various industries, so that the development cost is reduced and the development efficiency is improved; and development personnel can perform Excel document analysis only by writing simple xml configuration files, and the data is stored in a software system.

Description

technical field [0001] The invention relates to the field of data processing, in particular to an excel data analysis method and system. Background technique [0002] With the development of software technology, the demand for software in various industries has grown linearly, and the software background needs to process a large amount of data. Excel is a powerful data processing software, but because excel files cannot be directly operated by other software systems, it is impossible to use Excel The data in the file is entered into the software system. Contents of the invention [0003] The purpose of the present invention is to provide Excel document parsing services for various industries, reduce development costs, and improve development efficiency. Developers only need to write a simple xml configuration file to realize the parsing of Excel documents and save the data to the software system. [0004] The technical scheme that the present invention solves the above-m...

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
IPC IPC(8): G06F9/44G06F9/45G06F17/22G06F17/30
CPCG06F8/427G06F8/71G06F16/258G06F40/12
Inventor 黄晓峰阳帆
Owner 北京思特奇信息技术股份有限公司
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