Method and device for importing webpage data to EXCEL sheet

A technology of EXCEL and webpage data, which is applied in the field of importing EXCEL table data, can solve problems such as error-prone, time-consuming and labor-intensive, and achieve the effect of reducing the probability of error and improving work efficiency

Inactive Publication Date: 2010-12-08
SHENZHEN WUJU SCI TECH
View PDF3 Cites 19 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] Under the above circumstances, when a large number of EXCEL report documents need to be produced, it is easy for the user to directly enter data into the EXCEL report document, and this method is time-consuming and laborious.

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 and device for importing webpage data to EXCEL sheet
  • Method and device for importing webpage data to EXCEL sheet
  • Method and device for importing webpage data to EXCEL sheet

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0028] In order to make the object, technical solution and advantages of the present invention clearer, the present invention 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 invention, not to limit the present invention.

[0029] like figure 1 As shown, the present invention provides a kind of method that web page data is imported into EXCEL form, comprising:

[0030] Step 1: Open the web page containing the data table on the web browser;

[0031] In this step, the user may directly open the corresponding web page on the web browser, or the computer system may call the web browser to open the corresponding web page after processing the data.

[0032] Step 2: Select the data table in the web page, and the data in the selected data table will be imported into the EXCEL table;

[0033] There may be multiple data tabl...

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 discloses a method and device for importing webpage data to an EXCEL sheet. The method comprises the steps of: opening a webpage containing a data sheet on a webpage browser; selecting a data sheet in the webpage, and importing the data in the selected data sheet to an EXCEL sheet; analyzing marks of the webpage by the webpage browser, and picking the sheet mark of the selected data sheet from the marks to obtain the data of each line and each row under the sheet mark; calling EXCEL software by the webpage browser, and generating a blank EXCEL worksheet webpage; and writing the read data to the generated EXCEL worksheet webpage by the webpage browser. By the invention, the sheet data can be captured dynamically on the webpage of the webpage browser and is imported to the existing EXCEL sheet. The one-push operation from the webpage data to the EXCEL sheet can be realized, the work efficiency of users is greatly increased, and the error rate is reduced.

Description

technical field [0001] The invention relates to an EXCEL form data import technology, in particular to a method and a device for importing web page data into an EXCEL form. Background technique [0002] In the actual business of the company, there are a lot of important data that need to be made into various reports. At present, the most commonly used software for making report documents is EXCEL (electronic form). Now all kinds of complex data calculations are processed by the computer system, and then displayed to the user in the form of a table on the computer browser page, and the user then makes various styles of EXCEL report documents according to the data generated on the browser. [0003] Under the above circumstances, when a large number of EXCEL report documents need to be produced, it is easy for the user to directly enter data into the EXCEL report document, and this method is time-consuming and laborious. Therefore, if the table data in the browser page can be ...

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 Applications(China)
IPC IPC(8): G06F17/30
Inventor 黄海宽
Owner SHENZHEN WUJU SCI 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