Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

EXCEL data import method

A data import and data technology, applied in the direction of electronic digital data processing, special data processing applications, unstructured text data retrieval, etc., can solve the problem of low import efficiency and achieve the effect of improving efficiency

Inactive Publication Date: 2016-12-21
广州南方仕通网络科技有限公司
View PDF5 Cites 5 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0007] In order to overcome the deficiencies in the prior art, the object of the present invention is to provide a method for importing EXCEL data, which can solve the problem of low import efficiency

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 import method

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0023] Below, in conjunction with accompanying drawing and specific embodiment, the present invention is described further:

[0024] Such as figure 1 Shown, a kind of EXCEL data import method, it comprises the following steps:

[0025] Step S1, read the data in EXCEL according to the preset fields.

[0026] Wherein, the field is a database configuration field or an xml definition field. The data in EXCEL can be read by Apache POI framework. Apache POI is an open source library of the Apache Software Foundation. POI provides an API for Java programs to read and write files in Microsoft Office format.

[0027] Step S2, importing the read data into the non-relational database through the distributed service framework.

[0028] Among them, the distributed service framework of this embodiment is Dubbo. Dubbo is a distributed service framework of Ali Company, dedicated to providing high-performance and transparent RPC remote service invocation solutions and SOA service governan...

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 an EXCEL data import method. The EXCEL data import method comprises the following steps: reading EXCEL data according to preset fields; importing the read data in a non relational database by a distributed service framework; and storing the data imported in the non relational database in a document database according to a preset template. According to the EXCEL data import method disclosed by the invention, the preset template, the distributed service framework, the non relational database and the document database are organically combined to effectively improve the import efficiency.

Description

technical field [0001] The invention relates to an EXCEL data import method. Background technique [0002] Nowadays, when many software products are imported into EXCEL, the data in the table is read and processed, and there are several defects: [0003] 1. Single-threaded processing of imported data does not take into account the collection and correct import and storage of imported historical data, and cannot obtain valid data during subsequent data analysis; [0004] 2. In addition, the customization requirements of the template file are not considered; [0005] 3. Caching technology and decoupling of various links are not considered. [0006] The lack of the above design leads to low processing efficiency of the system when the system imports tables with a large amount of data (usually judged according to the complexity of the business), and multiple sheets are required at the same time. The memory will also increase several times or even ten times. Contents of the ...

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): G06F17/30
CPCG06F16/30
Inventor 刘洪昌
Owner 广州南方仕通网络科技有限公司
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com