Unlock instant, AI-driven research and patent intelligence for your innovation.

Storage and extraction method and system of Excel data tables

A data storage and excel technology, applied in the field of database storage, can solve problems such as low efficiency and heavy development tasks

Active Publication Date: 2014-06-25
STATE GRID CORP OF CHINA +3
View PDF2 Cites 15 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] However, due to the wide variety of Excel data sheets and the diversity of header forms, developers need to design corresponding header recognition programs for each Excel data sheet, which leads to heavy development tasks and low 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
  • Storage and extraction method and system of Excel data tables
  • Storage and extraction method and system of Excel data tables
  • Storage and extraction method and system of Excel data tables

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0056] In order to make the object, technical solution and advantages of the present invention clearer, the present invention will be described in further detail below with reference to the accompanying drawings and preferred embodiments. However, it should be noted that many of the details listed in the specification are only for readers to have a thorough understanding of one or more aspects of the present invention, and these aspects of the present invention can be implemented even without these specific details.

[0057] As used herein, terms such as "module" and "system" are intended to include computer-related entities such as, but not limited to, hardware, firmware, a combination of hardware and software, software, or software in execution. For example, a module may be, but is not limited to being limited to being, a process running on a processor, a processor, an object, an executable, a thread of execution, a program, and / or a computer. For example, both an applicatio...

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 storage and extraction method and system of Excel data tables. The method includes for an Excel data table to be stored, storing the content of the data regions of the data table into data regions of data tables relevant to the name of the data table in a database; if the data table provided with a horizontal header is determined, adding the content in each cell in the horizontal header into each corresponding node in a horizontal header tree structure of a name-mixed tree structural template; storing data in each node in the horizontal header tree structure into horizontal header data tables relevant to the name of the data table; if the data table is provided with a longitudinal header, adding the content of each cell in the longitudinal header into each node in a each node in a longitudinal header tree structure of the template; adding data of each node in the longitudinal header tree structure into the longitudinal header data tables relevant to the name of the data table. By applying the method, development efficiency of developers can be improved.

Description

technical field [0001] The invention relates to database storage technology, in particular to a method and system for storing and extracting Excel data sheets. Background technique [0002] At present, after the existing data storage system receives the data, it will be entered into the database for storage. When the data received by the data storage system is an Excel (electronic form) data sheet, since the data storage system cannot recognize the header of the Excel data sheet, it will convert the entire Excel data sheet into a PDF (Portable Document Format, which can be Transplant document format) or JPEG (joint photographic experts group, Joint Photographic Experts Group) commonly used picture format, and save the converted data in the database. However, the data in PDF or image format not only greatly occupies the memory of the database, but also the data in the required fields cannot be extracted from the data in PDF or image format and displayed on the web page or UI...

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/30
CPCG06F16/258
Inventor 邓春宇刘道新胡航海张健李季江流长
Owner STATE GRID CORP OF CHINA