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

Method for automatically analyzing and processing Excel files of industrial internet

An industrial Internet, parsing and processing technology, applied in the field of automatic parsing and processing of industrial Internet Excel files, can solve the problems of large data volume, time-consuming and labor-intensive, and various types of EXCEL files, and achieve the effect of reducing labor costs and improving parsing efficiency.

Pending Publication Date: 2022-02-15
杭州玖欣物联科技有限公司
View PDF0 Cites 1 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

The above method has the following problems: there are many types of EXCEL files in the Industrial Internet, and the amount of data is large. Each time a single file analysis program needs to be developed, which is time-consuming and labor-intensive. An automatic analysis tool is urgently needed to reduce the cost of developers. Now, an industrial Internet Excel file is proposed. Methods for Automating Parsing Processing

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
  • Method for automatically analyzing and processing Excel files of industrial internet

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0024] This method is based on the current industry characteristics and pain points, not only related to enterprise development efficiency, but also can effectively reduce development costs. Effective automatic analysis of EXCEL files requires the process decomposition of processing EXCEL file links. The specific methods are as follows:

[0025] refer to figure 1 , the present invention a kind of method for automatic parsing and processing of Industrial Internet Excel files, comprising the following steps:

[0026] S1. Configure the configuration file for parsing. In order to parse the EXCEL file, you need to write a configuration file to provide information. The content that needs to be filled in the configuration file includes the following columns: EXCEL file name, EXCEL SHEET name, database name, database table name, column name, Column data type, rule, type, column collection, row collection, column progression, row progression 12 fields, wherein, the EXCEL file name and...

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 provides a method for automatically analyzing and processing Excel files of an industrial internet. The method comprises the following steps: S1, configuring an analyzed configuration file; S2, acquiring an original file and configuration file data according to the configuration file; S3, traversing all rules in the configuration file to obtain column field names; S4, traversing all types according to column field names, obtaining corresponding single-column data, traversing all columns, obtaining all column data, traversing all rules, and obtaining data under all rules; S5, merging all the data obtained in the step S4, and transposing to form a data set; and S6, inserting the data set in the step S5 into a database. The method is suitable for large and miscellaneous scenes of industrial internet industry small files, is simple and practical, and provides an effective solution for batch processing of the Excel small files. And moreover, the research and development labor cost of an enterprise can be reduced, and the analysis efficiency of the small Excel file is improved.

Description

【Technical field】 [0001] The invention relates to the technical field of the Industrial Internet, in particular to a method for automatic parsing and processing of an Excel file in the Industrial Internet. 【Background technique】 [0002] In the prior art, different types of industrial gateways are used to collect EXCEL data according to a certain frequency configuration. There are many types of such data, and the collected data is finally aggregated to the data processing platform. The data processing platform extracts, converts, and loads this type of data for analysis and processing. stored in the destination database. The above method has the following problems: there are many types of EXCEL files in the Industrial Internet, and the amount of data is large. Each time a single file analysis program needs to be developed, which is time-consuming and labor-intensive. An automatic analysis tool is urgently needed to reduce the cost of developers. Now, an industrial Internet E...

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): G06F40/12G06F16/25
CPCG06F40/12G06F16/25
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