Method for 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: 2014-06-18
SUZHOU JINGYIHUI INFORMATION TECH
View PDF4 Cites 7 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 inven

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 converting webpage table data into Excel
  • Method for converting webpage table data into Excel
  • Method for 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 invention provides a method for converting webpage table data into Excel. The method includes the following steps of a. browsing a webpage containing table labels through a browser; b. sequentially analyzing TD and TH label related content in the table labels into a cortege matrix data storage unit; c. calling an Excel software interface and sequentially writing content of storing units in the cortege matrix data storage unit into Excel. The method is suitable for information exchange of data tables and Excel in the current webpage, the implementing process is accurate, convenient and rapid, access to a database is not required, and meanwhile, the method is improved on the basis of methods in the prior art so that good user experience is provided.

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
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