An office information processing method and device based on user demand

Abstract

The application provides an office information processing method and device based on user demand, the method comprises the following steps: obtaining and defining a demand field, and storing the demand field into a preset first database, and associating the demand field with an office script in the database; identifying office task demand information input by a user, and matching a corresponding demand field in the database, and calling a corresponding office script; the user demand information comprises a task name, a task type, task content and a task execution frequency; the task type comprises collecting specific information, automatically entering data and processing PDF file information; based on the task type, corresponding office tasks are executed through the called office script, and execution results of the office tasks are visually displayed. Through defining the demand field and matching the identified office task demand information, the corresponding script is called, compared with the manual data collection method in the prior art, the application has higher work efficiency and high accuracy.

Description

Technical Field

[0001] This invention relates to the field of office information processing, and more particularly to an office information processing method and apparatus based on user needs. Background Technology

[0002] In daily office work, repetitive data entry and information retrieval are often required due to management, policy, or business development needs. For example, in financial office systems, batch entry of financial data, including office-related expenditure records, is necessary. Current technology primarily relies on manual methods, requiring the entry of information line by line. Information retrieval is then performed using browsers or other external tools outside the office system to identify and filter information. However, this high degree of human intervention in such systems leads to low overall system efficiency, a heavy workload for personnel, and difficulty in ensuring the completeness of entered or retrieved information, resulting in a certain error rate. Summary of the Invention

[0003] This invention provides a method and apparatus for processing office information based on user needs, eliminating the need for manual data collection, thereby addressing the technical problem of how to improve overall work efficiency.

[0004] To address the aforementioned technical problems, embodiments of the present invention provide an office information processing method based on user needs, comprising:

[0005] Obtain and define the requirement fields, store the requirement fields in a preset first database, and associate them with the office scripts in the first database;

[0006] The system identifies the user's input of office task requirements and matches them with the corresponding requirement fields in the first database, then calls the office script associated with the matched requirement fields. The user requirement information includes task name, task type, task content, and task execution frequency. The task type includes collecting specific information, automated data entry, and PDF file information processing.

[0007] Based on the task type, the corresponding office task is executed by calling the office script, and the execution result of the office task is displayed visually.

[0008] The execution of corresponding office tasks based on the task type, through the invoked office script, includes:

[0009] When the task type is to collect specific information, the collection scope is determined based on specific fields in the task content by calling an office script;

[0010] Initiate an HTTP or HTTPS request, collect data within the collection range according to the specific field and the frequency of the task execution, and store the acquired data in a second database.

[0011] As a preferred embodiment, the step of executing the corresponding office task based on the task type by invoking an office script further includes:

[0012] When the task type is automated data entry, the office script is invoked to simulate the corresponding application to log in and recognize the verification code based on the specific information that needs to be entered in the task content.

[0013] Data is read from the third database in a loop according to the task execution frequency. The elements corresponding to each field in the task content are identified by the CSS selector. Based on the element identification results, each field is filled in and verified in the input object.

[0014] As a preferred embodiment, the step of executing the corresponding office task based on the task type by invoking an office script further includes:

[0015] When the task type is PDF file information processing, the PDF document to be processed is entered into the fourth database and converted into a docx file by calling the office script;

[0016] Based on the specific information that needs to be deleted in the task content, the specific information that needs to be deleted in the docx file is deleted through API operation, and the docx file after deletion is converted into a processed PDF file and stored in the fourth database.

[0017] As a preferred embodiment, the visualization of the execution results of the office task is specifically as follows:

[0018] Obtain the keywords of the execution results of the office task, and collect the associated information of the keywords through a web crawler program;

[0019] The associated information is filtered using natural language processing technology;

[0020] The filtered related information is displayed visually.

[0021] As a preferred option, the office script is implemented using Python.

[0022] Accordingly, embodiments of the present invention also provide an office information processing device based on user needs, including a definition module, a calling module, and an execution module; wherein,

[0023] The definition module is used to obtain and define requirement fields, store the requirement fields into a preset first database, and associate them with office scripts in the first database;

[0024] The calling module is used to identify the office task requirement information input by the user, match the corresponding requirement field in the first database, and call the office script associated with the matched requirement field; wherein, the user requirement information includes task name, task type, task content, and task execution frequency; the task type includes collecting specific information, automated data entry, and PDF file information processing;

[0025] The execution module is used to execute corresponding office tasks based on the task type by calling office scripts, and to visualize the execution results of the office tasks.

[0026] The execution module includes a first execution unit, the first execution unit being used for:

[0027] When the task type is to collect specific information, the collection scope is determined based on specific fields in the task content by calling an office script;

[0028] Initiate an HTTP or HTTPS request, collect data within the collection range according to the specific field and the frequency of the task execution, and store the acquired data in a second database.

[0029] As a preferred embodiment, the execution module includes a second execution unit, the second execution unit being used for:

[0030] When the task type is automated data entry, the office script is invoked to simulate the corresponding application to log in and recognize the verification code based on the specific information that needs to be entered in the task content.

[0031] Data is read from the third database in a loop according to the task execution frequency. The elements corresponding to each field in the task content are identified by the CSS selector. Based on the element identification results, each field is filled in and verified in the input object.

[0032] As a preferred embodiment, the execution module includes a third execution unit, which is used for:

[0033] When the task type is PDF file information processing, the PDF document to be processed is entered into the fourth database and converted into a docx file by calling the office script;

[0034] Based on the specific information that needs to be deleted in the task content, the specific information that needs to be deleted in the docx file is deleted through API operation, and the docx file after deletion is converted into a processed PDF file and stored in the fourth database.

[0035] As a preferred embodiment, the execution module visualizes the execution results of the office task, specifically as follows:

[0036] The execution module obtains the keywords of the execution result of the office task and collects the associated information of the keywords through a web crawler program;

[0037] The associated information is filtered using natural language processing technology;

[0038] The filtered related information is displayed visually.

[0039] As a preferred option, the office script is implemented using Python.

[0040] Compared with the prior art, the embodiments of the present invention have the following beneficial effects:

[0041] This invention provides a method and apparatus for processing office information based on user needs. The method includes: acquiring and defining a requirement field, storing the requirement field in a preset first database, and associating it with office scripts in the first database; identifying user-inputted office task requirement information, matching the corresponding requirement field in the first database, and calling the office script associated with the matched requirement field; wherein the user requirement information includes a task name, task type, task content, and task execution frequency; the task type includes collecting specific information, automated data entry, and PDF file information processing; based on the task type, executing the corresponding office task through the called office script, and visually displaying the execution result of the office task; the execution of the corresponding office task based on the task type through the called office script includes: when the task type is collecting specific information, determining the collection scope based on a specific field in the task content through the called office script; initiating an HTTP request or HTTPS request, collecting data within the collection scope according to the specific field and the task execution frequency, and storing the acquired data in a second database. This invention defines requirement fields and matches them with identified office task requirement information, calls corresponding scripts to execute corresponding office tasks, initiates HTTP / HTTPS requests, collects data according to specific fields within the collection range and according to task execution frequency, and stores the acquired data in a second database. Compared with the existing technology that collects data manually, this invention has higher work efficiency, reduces the degree of human intervention, and has higher accuracy. Attached Figure Description

[0042] Figure 1 This is a flowchart illustrating an embodiment of the office information processing method based on user needs provided by the present invention.

[0043] Figure 2 This is a schematic diagram of a custom task interface provided by the present invention.

[0044] Figure 3 This is a schematic diagram of another custom task interface provided by the present invention.

[0045] Figure 4 : A schematic diagram illustrating the principle of an embodiment of the PDF file information processing method provided by the present invention.

[0046] Figure 5 This is a schematic diagram illustrating the effect of one embodiment of the present invention for visualization.

[0047] Figure 6 This is a schematic diagram of an embodiment of the office information processing device provided by the present invention based on user needs. Detailed Implementation

[0048] The technical solutions of the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings. Obviously, the described embodiments are only some embodiments of the present invention, and not all embodiments. Based on the embodiments of the present invention, all other embodiments obtained by those skilled in the art without creative effort are within the scope of protection of the present invention.

[0049] Example 1:

[0050] Please refer to Figure 1 , Figure 1 An office information processing method based on user needs, provided in this embodiment of the invention, can run in the cloud and includes steps S1 to S3, wherein...

[0051] Step S1: Obtain and define the requirement fields, store the requirement fields in a preset first database, and associate them with the office scripts in the first database.

[0052] First, based on user-specified content, custom login fields can be defined on the front end and stored in the first database. These fields are used in step S2 to match the user's office task requirements. These fields are associated with office scripts; this association can be a one-to-one correspondence or multiple fields can be associated with the same office script. The relationship between the fields and the scripts can be determined based on the specific application scenario. All office scripts can be implemented via the cloud.

[0053] Step S2: Identify the office task requirement information input by the user, match it with the corresponding requirement field in the first database, and call the office script associated with the matched requirement field; wherein, the user requirement information includes task name, task type, task content, and task execution frequency; the task type includes collecting specific information, automated data entry, and PDF file information processing.

[0054] In this embodiment, users can customize tasks on the web interface (each task is a data display page, which allows for task execution, data import, and data export; each task is an independent page, and users can access the corresponding page to perform operations). Please refer to [link / reference]. Figure 2 In this embodiment, office task requirements information can be obtained and identified through user-defined tasks. User-defined tasks typically include a task title, task number, task description (remarks), status, path, and creator.

[0055] Furthermore, the office task requirement information also includes task execution frequency, task execution type, and task execution content (for example, if the task execution frequency is once every 30 minutes, refer to...). Figure 3 By matching the user's input of office task requirements with the corresponding requirement fields in the first database, the appropriate office script can be invoked.

[0056] Step S3: Based on the task type, execute the corresponding office task by calling the office script, and visualize the execution result of the office task.

[0057] In this embodiment, specific requirements can be achieved by reading the configuration in the first database using Python, therefore step S3 includes multiple methods.

[0058] For example, as an example of this embodiment, in step S3.1, when the task type is to collect specific information, the user clicks "Execute Now" through the display function on the page. For example, the script corresponds to the "Search Specific Fields and Download Documents" field. Then, the user fills in the downloaded Excel template according to preset rules (e.g., including name, ID number, and phone number), imports the data required by the corresponding office script into the Excel table, and stores it in the database. Then, the office script reads the data from the database, determines the collection scope based on the specific fields in the task content, initiates an HTTP or HTTPS request, collects data within the collection scope according to the specific fields and the task execution frequency, and saves the acquired data in a second database. After collection is completed, the user can view the data or download the data on the current page. If there are errors, they are specially marked so that the user can check and process them accordingly.

[0059] This embodiment also includes a second example, step S3.2: when the task type is automated data entry, based on the user's selection, the "process automation" office script is invoked, or further, the "data entry automation" office script is invoked. Then, the user fills in the downloaded Excel template according to preset rules (e.g., including name, ID number, and phone number), and imports the data required by the corresponding office script into the database. After execution begins, based on the specific information that needs to be entered in the task content, the corresponding application (or browser) is simulated to log in and recognize the verification code.

[0060] The system reads data from the third database in a loop according to the task execution frequency. It uses a CSS selector to identify the elements corresponding to each field in the task content, simulates manual operation, and fills in and verifies each field of the input object according to the element recognition results. The process is completed automatically until the loop ends. Successful data is marked as successful and incorrect data is marked as incorrect, so that users can check and process accordingly. At the same time, the processing results and verification results can be sent to the user terminal.

[0061] Furthermore, this embodiment also includes a third example, step S3.3: when the task type is PDF file information processing, based on the user's selection, the office script for "deleting specific information from PDF" is invoked. PDF documents are imported in batches, execution is confirmed, and the invoked office script processes the imported files according to the order of import. Specifically:

[0062] The PDF document to be processed is entered into the fourth database. The script calls Adobe Acrobat, which uses Win32 API to start Adobe Acrobat and converts the PDF document to a docx file.

[0063] Based on the specific information to be deleted in the task content, the specific information in the docx file is deleted via API operations (such as the .NET API in Microsoft Office Word), and certain cells in the table are merged. The docx file after deletion is converted into a processed PDF file and stored in the fourth database to complete one cycle. After the conversion is complete, the user can view the conversion progress on the current page and download the converted file. If there are any errors, they can be marked for the user to check (see [reference]). Figure 4 In this embodiment, the first database, second database, third database, and fourth database can be the same database or different databases. Implementing this embodiment can automatically perform the collection of specific information, automated data entry, and PDF file information processing (which can be done individually or simultaneously; when there are multiple office task requirements, they can be processed simultaneously), eliminating the need for manual repetitive work, making the application's office system more complete, reducing human and material costs, and saving relevant personnel a significant amount of time; by recognizing the office task requirement information input by the user and matching the corresponding requirement field in the first database, the associated office script of the matched requirement field is called, thus realizing configurable definition, meeting the customization, personalization, and scalability needs of enterprises, and users do not need to use a client during use, allowing for use anytime and anywhere, with high convenience and universal applicability.

[0064] Furthermore, the visualization and keyword analysis of the execution results of the office tasks are specifically implemented as follows:

[0065] Obtain keywords for the execution results of the office task (these keywords can be entered by the user based on their search needs), and collect related information of the keywords through a web crawler program;

[0066] By using natural language processing (NLP) and artificial intelligence technologies, the stored data fields are classified, such as region, time, amount, category, address, and company name, and then the corresponding related information is filtered.

[0067] The filtered related information is visualized, either through data or charts, and the results can be viewed or downloaded (see reference). Figure 5 By implementing the embodiments of this application, the results of task execution can be retrieved, statistically analyzed, and supported in a timely manner, thus providing support for business needs.

[0068] Accordingly, refer to Figure 6This invention also provides an office information processing device based on user needs, including a definition module 101, a calling module 102, and an execution module 103; wherein,

[0069] The definition module 101 is used to obtain and define the requirement fields, store the requirement fields into a preset first database, and associate them with the office scripts in the first database;

[0070] The calling module 102 is used to identify the office task requirement information input by the user, match the corresponding requirement field in the first database, and call the office script associated with the matched requirement field; wherein, the user requirement information includes task name, task type, task content, and task execution frequency; the task type includes collecting specific information, automated data entry, and PDF file information processing;

[0071] The execution module 103 is used to execute the corresponding office task based on the task type by calling the office script, and to visualize the execution result of the office task.

[0072] The execution module includes a first execution unit, the first execution unit being used for:

[0073] When the task type is to collect specific information, the collection scope is determined based on specific fields in the task content by calling an office script;

[0074] Initiate an HTTP or HTTPS request, collect data within the collection range according to the specific field and the frequency of the task execution, and store the acquired data in a second database.

[0075] In a preferred embodiment, the execution module includes a second execution unit, the second execution unit being used for:

[0076] When the task type is automated data entry, the office script is invoked to simulate the corresponding application to log in and recognize the verification code based on the specific information that needs to be entered in the task content.

[0077] Data is read from the third database in a loop according to the task execution frequency. The elements corresponding to each field in the task content are identified by the CSS selector. Based on the element identification results, each field is filled in and verified in the input object.

[0078] In a preferred embodiment, the execution module includes a third execution unit, which is used for:

[0079] When the task type is PDF file information processing, the PDF document to be processed is entered into the fourth database and converted into a docx file by calling the office script;

[0080] Based on the specific information that needs to be deleted in the task content, the specific information that needs to be deleted in the docx file is deleted through API operation, and the docx file after deletion is converted into a processed PDF file and stored in the fourth database.

[0081] In a preferred embodiment, the execution module 103 visualizes the execution result of the office task, specifically as follows:

[0082] The execution module 103 obtains the keywords of the execution result of the office task and collects the associated information of the keywords through a crawler program;

[0083] The associated information is filtered using natural language processing technology;

[0084] The filtered related information is displayed visually.

[0085] As a preferred implementation, the office script is implemented using Python.

[0086] Compared with the prior art, the embodiments of the present invention have the following beneficial effects:

[0087] This invention provides a method and apparatus for processing office information based on user needs. The method includes: acquiring and defining a requirement field, storing the requirement field in a preset first database, and associating it with office scripts in the first database; identifying user-inputted office task requirement information, matching the corresponding requirement field in the first database, and calling the office script associated with the matched requirement field; wherein the user requirement information includes a task name, task type, task content, and task execution frequency; the task type includes collecting specific information, automated data entry, and PDF file information processing; based on the task type, executing the corresponding office task through the called office script, and visually displaying the execution result of the office task; the execution of the corresponding office task based on the task type through the called office script includes: when the task type is collecting specific information, determining the collection scope based on a specific field in the task content through the called office script; initiating an HTTP request or HTTPS request, collecting data within the collection scope according to the specific field and the task execution frequency, and storing the acquired data in a second database. This invention defines requirement fields and matches them with identified office task requirement information, calls corresponding scripts to execute corresponding office tasks, initiates HTTP / HTTPS requests, collects data according to specific fields within the collection range and according to task execution frequency, and stores the acquired data in a second database. Compared with the existing technology that collects data manually, this invention has higher work efficiency, reduces the degree of human intervention, and has higher accuracy.

[0088] The specific embodiments described above further illustrate the purpose, technical solution, and beneficial effects of the present invention. It should be understood that the above descriptions are merely specific embodiments of the present invention and are not intended to limit the scope of protection of the present invention. In particular, it should be noted that any modifications, equivalent substitutions, improvements, etc., made within the spirit and principles of the present invention should be included within the scope of protection of the present invention for those skilled in the art.

Claims

1. A method for processing office information based on user needs, characterized in that, include: Obtain and define the requirement fields, store the requirement fields in a preset first database, and associate them with the office scripts in the first database; The system identifies the office task requirement information input by the user, matches it with the corresponding requirement field in the first database, and calls the office script associated with the matched requirement field. The office task requirement information includes task name, task type, task content, and task execution frequency. The task type includes collecting specific information, automated data entry, and PDF file information processing. Based on the task type, the corresponding office task is executed by calling the office script, and the execution result of the office task is displayed visually. The execution of corresponding office tasks based on the task type, through the invoked office script, includes: When the task type is to collect specific information, the collection scope is determined based on specific fields in the task content by calling an office script; Initiate an HTTP or HTTPS request, collect data within the collection range according to the specific field and the frequency of the task execution, and store the acquired data in a second database; The step of executing the corresponding office task based on the task type by calling the office script further includes: When the task type is automated data entry, the office script is invoked to simulate the corresponding application to log in and recognize the verification code based on the specific information that needs to be entered in the task content. The data in the third database is read cyclically according to the task execution frequency. The elements corresponding to each field in the task content are identified by the CSS selector. Based on the element identification results, the data is filled in and verified field by field in the input object. The step of executing the corresponding office task based on the task type by calling the office script further includes: When the task type is PDF file information processing, the PDF document to be processed is entered into the fourth database and converted into a docx file by calling the office script; Based on the specific information that needs to be deleted in the task content, the specific information that needs to be deleted in the docx file is deleted through API operation, and the docx file after deletion is converted into a processed PDF file and stored in the fourth database.

2. The office information processing method based on user needs as described in claim 1, characterized in that, The visualization of the execution results of the office tasks is specifically as follows: Obtain the keywords of the execution results of the office task, and collect the associated information of the keywords through a web crawler program; The associated information is filtered using natural language processing technology; The filtered related information is displayed visually.

3. The office information processing method based on user needs as described in claim 1, characterized in that, The office script is implemented using Python.

4. An office information processing device based on user needs, characterized in that, It includes a definition module, a calling module, and an execution module; among which, The definition module is used to obtain and define requirement fields, store the requirement fields into a preset first database, and associate them with office scripts in the first database; The calling module is used to identify the office task requirement information input by the user, match the corresponding requirement field in the first database, and call the office script associated with the matched requirement field; wherein, the office task requirement information includes task name, task type, task content, and task execution frequency; the task type includes collecting specific information, automated data entry, and PDF file information processing; The execution module is used to execute corresponding office tasks based on the task type by calling office scripts, and to visualize the execution results of the office tasks. The execution module includes a first execution unit, the first execution unit being used for: When the task type is to collect specific information, the collection scope is determined based on specific fields in the task content by calling an office script; Initiate an HTTP or HTTPS request, collect data within the collection range according to the specific field and the frequency of the task execution, and store the acquired data in a second database; The execution module includes a second execution unit, which is used for: When the task type is automated data entry, the office script is invoked to simulate the corresponding application to log in and recognize the verification code based on the specific information that needs to be entered in the task content. The data in the third database is read cyclically according to the task execution frequency. The elements corresponding to each field in the task content are identified by the CSS selector. Based on the element identification results, the data is filled in and verified field by field in the input object. The execution module includes a third execution unit, which is used for: When the task type is PDF file information processing, the PDF document to be processed is entered into the fourth database and converted into a docx file by calling the office script; Based on the specific information that needs to be deleted in the task content, the specific information that needs to be deleted in the docx file is deleted through API operation, and the docx file after deletion is converted into a processed PDF file and stored in the fourth database.

5. The office information processing device based on user needs as described in claim 4, characterized in that, The execution module visualizes the execution results of the office task, specifically as follows: The execution module obtains the keywords of the execution result of the office task and collects the associated information of the keywords through a web crawler program; The associated information is filtered using natural language processing technology; The filtered related information is displayed visually.

6. The office information processing device based on user needs as described in claim 4, characterized in that, The office script is implemented using Python.

Images