Excel data processing method, system and device

A technology of data processing equipment and processing methods, which is applied in the field of computer information, can solve problems such as inflexibility and heavy workload of Excel data processing, and achieve the effect of flexible data processing and reducing the workload of research and development

Pending Publication Date: 2020-07-10
河南安冉云网络科技有限公司
View PDF6 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] The present invention proposes a processing method, system and equipment for Excel data, which solves the technical problem of heavy and inflexible Excel data processing workload in the prior art

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 processing method, system and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0022] The technical solutions in the embodiments of the present invention will be clearly and completely described below in conjunction with the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are only some of the embodiments of the present invention, not all of them. For The descriptions of these embodiments are used to help the understanding of the present invention, but are not intended to limit the present invention. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without creative efforts fall within the protection scope of the present invention.

[0023] In the description of the present application, it should be understood that the terms "center", "longitudinal", "transverse", "length", "width", "thickness", "upper", "lower", "front", " Orientation indicated by rear, left, right, vertical, horizontal, top, bottom, inside, outside, clockwise, ...

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 the technical field of computer information, and discloses an Excel data processing method, which comprises the following steps of: data acquisition: selecting a file to be processed, and acquiring a file path of the data to be processed; creating a data flow table: obtaining a file header and data from the selected file, and registering the file header and the data as thedata flow table; data preprocessing: configuring a dynamic SQL for data processing, and performing corresponding preprocessing on a header and data of the data flow table; and data import: obtainingthe preprocessed data stream and importing the preprocessed data stream into a relational database. According to the data processing method provided by the invention, when the user demand is changed,the demand can be met only by processing the data flow table formed by the corresponding data by adopting the dynamic sql, so that the research and development workload is greatly reduced, and the data processing is more flexible.

Description

technical field [0001] The invention relates to the field of computer information technology, in particular to a method, system and equipment for processing Excel data. Background technique [0002] With the increasing amount of data, Excel tables can no longer meet the data query processing of millions of levels. It is urgent to process the data in Excel and import them into relational databases. The usual method is to customize and develop a set of Excel data processing programs according to user needs. , but the needs of users are ever-changing. Every change in the data processing method will cause the modification of the program, which will affect the whole body. The workload of data processing is large, and the data processing is not flexible. Contents of the invention [0003] The invention proposes an Excel data processing method, system and equipment, which solves the technical problem of heavy and inflexible Excel data processing workload in the prior art. [000...

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): G06F16/28G06F16/23
CPCG06F16/284G06F16/23
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