Check patentability & draft patents in minutes with Patsnap Eureka AI!

A general excel file processing method

An excel, file processing technology, applied in file system management, file system, file system functions, etc., can solve the problems of long development cycle and high technical requirements for maintenance

Inactive Publication Date: 2019-01-29
INSPUR TIANYUAN COMM INFORMATION SYST CO LTD
View PDF8 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] 1. xls version problem: Because the difference between xls and xlsx is not simply a suffix, the encoding 03 of the two files is GBK), 07+ is UTF-8, most people need to deal with them separately, and generally only one version is compatible
[0010] 2) There are repeated compound titles
[0014] The traditional processing method is generally developed by java. For the same type of file, the version needs to be specified, and the title change needs to be recompiled and modified. The development cycle is long and the maintenance requires high technical requirements.

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
  • A general excel file processing method
  • A general excel file processing method
  • A general excel file processing method

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0039] The content of the present invention is described in more detail below:

[0040] The invention provides a general excel file processing method, which includes the objectification method of excel, unified analysis, processing files with inconsistent types, and solving problems such as title changes or type inconsistencies.

[0041] Through the object processing of excel, the properties of excel are described through a configuration file, so as to realize the dynamic analysis of excel with different versions and different title types

[0042] The excel suffixes involved must be entered as xls and xlsx; the title of excel is in the scope of the rules.

[0043] It can compare the analysis difference of the period class before and after the two times.

[0044] Such as figure 1 As shown, the specific operation steps are:

[0045] 1) Load the configuration file, obtain the field list and save it as an array, then obtain the current field information array according to the p...

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 general excel file processing method. The invention relates to the technical field of big data platform network crawler data analysis. The invention realizes the dynamic analysis of different versions and different title types of excel by objectifying the excel and describing the self-attributes of the excel through a configuration file.

Description

technical field [0001] The present invention relates to a large data platform web crawler data analysis technology, in particular to a general excel file processing method. Background technique [0002] At present, China Mobile, China Unicom, Telecom, and China Tower are all building their own data centers. The data sources include standard csv files, such as network management data such as resources, performance, signaling, and billing, and some are for databases, such as alarms. However, there are also many departments that do not have corresponding files or database interfaces due to information security considerations. The provided data needs to be xls manually exported with the account password. In order to reduce manual intervention, the xls automatically exported by the crawler script that simulates login is generally used. For such different types (may be xls, or xlsx), the file titles vary widely (some are non-repeating Chinese titles, there are also repeated compo...

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): G06F16/11G06F16/17
Inventor 邱建波马涛
Owner INSPUR TIANYUAN COMM INFORMATION SYST CO LTD
Features
  • R&D
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More

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

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