CN113988030A - Office tool for automatic form filling - Google Patents

Abstract

The invention relates to the technical field of office automation, in particular to an office tool for automatically filling a form. The invention mainly combines the functions of the selenium and the xlrd modules, leads Python to directly control the browser, actually positions and clicks the link, reads data in the Excel form, writes the data into a page, and simulates user behavior operation to automatically finish the interaction with the page. The filling time is greatly shortened. The errors generated in the data filling process are avoided. The Excel data sequence requirement is low, and the source Excel table format does not need to be changed when the page data item filling position slightly changes or the data item sequence changes.

Description

Office tool for automatic form filling

Technical Field

The invention relates to the technical field of office automation, in particular to an office tool for automatically filling a form.

Background

In the big data era, the energy big data is not only deep application of big data technology in the energy field, but also deep fusion of energy production, consumption, related technical revolution and big data concept, and can accelerate the development of the energy industry and the innovation of business model. In the wind power industry, the distributed wind turbines of the wind power plant are monitored on line, periodic and instantaneous real-time data are collected and analyzed on line, alarms are generated, maintenance personnel are allowed to visualize and manage data, the deployment of a large-scale monitoring system is simplified, and the processing technology of large data cannot be separated everywhere.

While Python provides a large number of libraries for handling large data. In terms of code development, the Python language has many advantages, is simple, efficient, highly portable, a huge standard library and the like, and can process large data by using the Python language faster than any other programming language. This enables developers around the world to view Python as the preferred language for large data items, which is why the technology chooses Python language.

Today, although there are many ways of data collection, there is still a large amount of data that needs to be filled in. With the increasing data collection amount, the demand for processing and filling data is increasing. Although we assist the data statistics filling work by means of Excel table, the tedious manual copying and pasting work still consumes a lot of time and energy, and at the same time, we can not fully guarantee the accuracy of manually input data.

Disclosure of Invention

In response to the problems of the background art, an office tool for automated form filling is provided. And combining a Selenium module and an xlrd module in Python to quickly simulate the behavior operation of a user, and integrating the data reported by each wind field on the same day and then inputting the data into the system. The filling time is greatly shortened. The errors generated in the data filling process are avoided. The Excel data sequence requirement is low, and the source Excel table format does not need to be changed when the page data item filling position slightly changes or the data item sequence changes.

The invention provides an office tool for automatic form filling, which comprises the following steps:

s1, automatically combining Excel tables reported by each wind power plant into one table; the automatic merging process avoids unnecessary errors caused by a manual copying and pasting process, such as wrong line pasting, repeated copying and the like; then, an automatic filling program is operated to sequentially read the data in the combined table and fill the data into the webpage table, so that manual operation is greatly reduced;

s2, starting a Chrome browser, accessing a filled data information official website, and then entering a filling system;

s3, simulating manual operation, and clicking to enter a list page of 'wind turbine generator running condition' by the simplest path;

s4, searching by using a certain area name as a keyword to obtain a report list needing to be filled;

s5, sequentially and circularly reading data information of all wind power plants from the Excel table; the circulation variable i is 1, and the number of the wind fields is recorded as Num;

and S6, when i is less than or equal to Num, automatically positioning the data information of the wind power plant to be filled, filling the data information into a webpage, prompting the filled information, and storing the submitted data.

Preferably, in S2, entering the filling system requires filling in the user name, password and picture verification code, and clicking the "login" button.

Preferably, in S6, the step of performing information filling includes:

s61, opening a daily page;

s62, reading table data;

s63, automatically entering data;

and S64, closing the daily page.

Preferably, the method is combined with Selenium and xlrd modules in Python to simulate the behavior operation of users, and the data reported on the same day of each wind field are integrated and then recorded into the system. The staff is helped to complete the work task quickly, the work efficiency of the staff is improved, and the accuracy of data entry is further guaranteed.

Preferably, the browser is directly controlled through Python, a click link is actually positioned, data in an Excel form is read and written into a page, and user behavior operation is simulated to automatically finish interaction with the page.

Compared with the prior art, the invention has the following beneficial technical effects:

firstly, the filling time is greatly shortened. The report can be completed by shortening the original about one hour to ten minutes;

errors generated in the data filling process are avoided, such as errors in manually reading rows and columns, improper filling format and the like;

and thirdly, the requirement on Excel data sequence is low, and the source Excel table format does not need to be changed when the filling position of the page data item is slightly changed or the data item sequence is changed.

Drawings

FIG. 1 is a workflow diagram of an office tool for automated form filling.

FIG. 2 is a flow chart of an automated filing process for an office tool for automated form filling.

Fig. 3 is a flow chart of conventional fill-in data.

Detailed Description

Example one

As shown in fig. 1-2, the office tool for automatic form filling according to the present invention comprises the following steps:

s1, automatically combining Excel tables reported by each wind power plant into one table; the automatic merging process avoids unnecessary errors caused by a manual copying and pasting process, such as wrong line pasting, repeated copying and the like; then, an automatic filling program is operated to sequentially read the data in the combined table and fill the data into the webpage table, so that manual operation is greatly reduced;

s2, starting a Chrome browser, accessing a filled data information official website, and then entering a filling system; when entering a filling system, a user name, a password and a picture verification code need to be filled in, and a 'login' button is clicked;

s3, simulating manual operation, and clicking to enter a list page of 'wind turbine generator running condition' by the simplest path;

s4, searching by taking a certain area name (such as Mongolian) as a keyword to obtain a report list needing to be filled;

s5, sequentially and circularly reading data information of all wind power plants from the Excel table; the circulation variable i is 1, and the number of the wind fields is recorded as Num;

and S6, when i is less than or equal to Num, automatically positioning the data information of the wind power plant to be filled, filling the data information into a webpage, prompting the filled information, and storing the submitted data. The information filling step comprises the following steps:

s61, opening a daily page;

s62, reading table data;

s63, automatically entering data;

and S64, closing the daily page.

And simulating the behavior operation of a user by combining a Selenium module and an xlrd module in Python, and integrating the data reported by each wind field on the same day and then inputting the data into the system. The staff is helped to complete the work task quickly, the work efficiency of the staff is improved, and the accuracy of data entry is further guaranteed. The browser is directly controlled through Python, a link is actually positioned and clicked, data in the Excel form are read and written into a page, and user behavior operation is simulated to automatically finish interaction with the page.

Example two

A monitoring center of a new energy enterprise manages 29 wind field information collecting and recording systems. The number of wind power plants is large, the filling contents are detailed and various, dozens of parameters including wind field capacity, daily average wind speed, daily electric quantity, running capacity and the like are dozens of parameters, and the filling data status situation is faced by a monitoring center.

Therefore, the monitoring center adopts a unified Excel template statistical data mode, and data are reported by each wind power plant every day. The monitoring center processes and records the reported data form again and submits the processed data form to a reporting system, as shown in fig. 3. In the working process, a large number of manual operation links exist in the existing filling mode, workers need to fill data of each wind power plant into an information input system in sequence, and the operation is time-consuming and labor-consuming and is easy to make mistakes.

According to the work requirement, workers need to complete the daily report of the operation conditions of all wind power plants (29) in charge of the department within a specified time period, wherein about 35 parameters need to be filled in each wind power plant, and about 1000 data items need to be filled in, and the time is about one hour. The office tool for automatic form filling in the invention is operated, and the filling work of pages is completed in about 10 minutes. The procedure is as in example 1, and the results of comparing the conventional filling method with the automated filling method are shown in Table 1.

When the first filling is completed, the data is found to have problems, the automatic filling program can be operated again, and the program has the function of automatically covering filling. For the list with partial filling completion, an automatic filling program can be executed, and the program can help the staff to complete the filling of the remaining report forms and can also help the staff to detect whether omission exists; the user can also select a regional wind power field report list needing to be screened according to the actual situation.

TABLE 1

The embodiments of the present invention have been described in detail with reference to the drawings, but the present invention is not limited thereto, and various changes can be made within the knowledge of those skilled in the art without departing from the gist of the present invention.

Claims (5)

1. An office tool for automated form filling, comprising the steps of:

s1, automatically combining Excel tables reported by each wind power plant into one table;

s2, starting a Chrome browser, accessing a filled data information official website, and then entering a filling system;

s3, simulating manual operation, and clicking to enter a list page of 'wind turbine generator running condition' by the simplest path;

s4, searching by using a certain area name as a keyword to obtain a report list needing to be filled;

s5, sequentially and circularly reading data information of all wind power plants from the Excel table; the circulation variable i is 1, and the number of the wind fields is recorded as Num;

and S6, when i is less than or equal to Num, automatically positioning the data information of the wind power plant to be filled, filling the data information into a webpage, prompting the filled information, and storing the submitted data.

2. An office tool for automated form filling according to claim 1, wherein at S2, entering the filling system requires filling in a user name, password and picture verification code, and clicking a "login" button.

3. An office tool for automated form filling according to claim 1, wherein in S6, the step of performing information filling includes:

s61, opening a daily page;

s62, reading table data;

s63, automatically entering data;

and S64, closing the daily page.

4. The office tool for automatic form filling according to claim 1, wherein a user's behavior operation is simulated by combining with Selenium and xlrd modules in Python, and the daily reported data of each wind field is integrated and then recorded into the system.

5. The office tool for automated form filling according to claim 1, wherein the browser is directly controlled by Python, the click link is actually positioned, data in the Excel form is read and filled into a page, and user behavior operation is simulated to automatically complete interaction with the page.

Images