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

Spreadsheet file analysis method and device and computer readable storage medium

A spreadsheet and file parsing technology, applied in the computer field, can solve problems such as large memory consumption and parsing time, and achieve the effects of reducing resource occupation, reducing parsing time consumption, and improving parsing efficiency

Pending Publication Date: 2021-06-25
TENCENT TECH (SHENZHEN) CO LTD
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] Based on this, it is necessary to provide a spreadsheet file parsing method, device, computer-readable storage medium and computer equipment for the traditional file parsing method to consume large memory and parsing time.

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
  • Spreadsheet file analysis method and device and computer readable storage medium
  • Spreadsheet file analysis method and device and computer readable storage medium
  • Spreadsheet file analysis method and device and computer readable storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0044] In order to make the purpose, technical solution and advantages of the present application clearer, the present application will be further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described here are only used to explain the present application, and are not intended to limit the present application.

[0045] figure 1 It is an application environment diagram of the spreadsheet file parsing method in one embodiment. refer to figure 1 , the spreadsheet file parsing method can be applied to figure 1 The shown application environment includes the terminal 102 and the server 104, which can be specifically applied to figure 1Server 104 is shown. Wherein, the terminal 102 and the server 104 are connected through a network. The server 104 scans the target extensible markup language file according to the preset data table start tag by extracting the target extensible markup ...

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 a spreadsheet file analysis method and device, a computer readable storage medium and computer equipment, and the method comprises the steps: taking a data table starting tag as a matching starting point of an extracted target extensible markup language file, and recognizing the target extensible markup language file behind the matching starting point; after a preset row start tag is identified, skipping a data block with a preset size to continue identification, when a preset row end tag is identified, obtaining a segmented data block between the row start tag and the row end tag, and drawing a data view of the segmented data block. and taking the row end tag as an updated matching starting point, and repeatedly generating the segmented data blocks until a preset data table end tag is identified. By repeatedly executing the step of generating the segmented data blocks, the multiple segmented data blocks are determined, the data view drawing is drawn while the data blocks are split, the whole spreadsheet file does not need to be completely analyzed at the same time, and the analysis efficiency of the spreadsheet file is improved.

Description

technical field [0001] The present application relates to the field of computer technology, in particular to a method and device for parsing electronic form files, a computer-readable storage medium and computer equipment. Background technique [0002] With the development of computer technology and its widespread application in people's work and life, more and more enterprises adopt business systems that are more suitable for the company's business. In business systems, various documents are often used to realize information collection or data statistics. Among them, spreadsheet files are frequently used, and the number of generated files also increases with time. [0003] In the follow-up work process, due to business requirements, it is often necessary to analyze the spreadsheet file and read the data in the spreadsheet file. Since the spreadsheet file is a compressed package composed of a series of XML files, the parsing work of the file is to analyze the XML files in ...

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/18G06F40/205G06F40/279
CPCY02D10/00
Inventor 金鑫薛平安
Owner TENCENT TECH (SHENZHEN) CO LTD
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