A method of converting webpage table data into excel

An excel and conversion technology, applied in the field of converting webpage Table data into Excel, can solve the problem of displaying in other cells

Active Publication Date: 2016-11-30
SUZHOU JINGYIHUI INFORMATION TECH
View PDF4 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

But, through research, there is certain defective in this invention, if the data form in the webpage does not comprise Colspan or Rowspan attribute, then this invention can really achieve effect; When parsing Table to Excel, there will be a problem of displaying the row and column contents of the original table in other cells

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 method of converting webpage table data into excel
  • A method of converting webpage table data into excel
  • A method of converting webpage table data into excel

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0023] In order to make the method for converting webpage Table data into Excel mentioned in the present invention and its advantages clearer, the present invention will be further described in detail with reference to the accompanying drawings.

[0024] figure 1 It is a flowchart of an embodiment of a method for converting web page Table data into Excel provided by the present invention. Such as figure 1 As shown, the main flow of the method is as follows:

[0025] Step 1, browse the web page containing the Table tag.

[0026] The user browses to the relevant Table page through the browser.

[0027] Step 2, parse the relevant content of the TD and TH tags in the Table tag to the row-column matrix data memory.

[0028] The browser first parses and counts the number of rows and columns of the Table, and dynamically generates a row and column matrix data storage with the same number of rows and columns as the Table; initializes the row and column matrix data storage, and uni...

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 present invention proposes a kind of method that webpage Table data is converted into Excel, described method comprises the following steps: a. browse the webpage that contains Table label by browser; B. TD and TH label relevant content in Table label Parse to the row-column matrix data memory; c. call the Excel software interface, and write the contents of the storage cells in the row-column matrix data memory to Excel in sequence. The present invention is suitable for exchanging information between the data table in the current web page and Excel, and the realization process is accurate and convenient without accessing the database; meanwhile, as an improvement to the prior art, the present invention provides better user experience.

Description

technical field [0001] The invention relates to the technical field of computers, in particular to a method for converting webpage Table data into Excel. Background technique [0002] The Internet, an international computer network composed of certain communication protocols, is the most widely used and popular aspect of computers today. Web pages are based on the Internet, and no matter where the web page files are stored, they can be accessed from all over the world through the Internet. [0003] Microsoft Excel is one of Microsoft's office software. It is a spreadsheet software written and run by Microsoft for computers with Windows and Apple Macintosh operating systems. Excel is an important part of Microsoft Office suite software. It can process various data, perform statistical analysis and assist decision-making operations, and is widely used in many fields such as management, statistics, finance, and finance. [0004] It is very common for users to browse valuable ...

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 Patents(China)
IPC IPC(8): G06F17/22
Inventor 牟春林
Owner SUZHOU JINGYIHUI INFORMATION TECH
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