Data processing method and device, electronic equipment and storage medium

Abstract

The invention discloses a data processing method and device, electronic equipment and a storage medium. The method comprises the following steps: opening an analysis and test report form file of an oil and gas exploration well in response to triggering of an analysis and test report processing event of the oil and gas exploration well; when a trigger operation of a user on a data extraction button in the analysis and test report form file is detected, displaying a data extraction window in the analysis and test report form file; wherein the data extraction window comprises at least one in-place editing block control, and each in-place editing block control represents different cell data; determining a target control selected by the user from the at least one in-place editing block control, and displaying an interactive interface containing cell data corresponding to the target control; and generating an analysis and test summary sheet according to the click operation of the user on the cell data in the interactive interface. According to the scheme, extraction work of complex oil-gas exploration analysis and test data can be completed only through simple click operation, and the analysis and test summary sheet is generated.

Description

Technical Field

[0001] The present invention relates to the technical field of oil and gas exploration data processing, and in particular to a data processing method, device, electronic equipment and storage medium. Background Art

[0002] In the field of oil and gas exploration, as the number of exploration wells increases, analytical data (thin section identification data, heavy mineral data, mercury injection data, powder particle size, pore characteristics, mercury injection, thin section particle size data, etc.) also increases exponentially. While the massive amount of analytical data brings new discoveries to exploration engineers, it also greatly increases the energy consumed in sorting out the data.

[0003] Since each type of analytical test data will be commissioned to different laboratories for testing, there are not only many types of analytical tests, but also inconsistent formats for the same type of analytical tests: some are Word documents; some are Excel tables; some multiple samples are stored in the same file; some samples are composed of multiple files, each sample occupies a sheet, and each sheet is stored in a separate file; some samples are composed of multiple files, but multiple samples occupy multiple sheets and are stored in multiple files at the same time. Due to the above reasons, the number of original reports of analytical test data is extremely large, the formats are varied, and the difficulty of collating and summarizing data has also increased explosively.

[0004] First-hand data that has not been screened, classified, edited, etc. is often the most comprehensive and accurate data. Exploration work is often carried out with the summary of original report data of analytical test data. At present, manual data copying is inefficient, which makes the processing of original report data of analytical test data take up a lot of working time. Even if the Excel formula method is used, it is necessary to customize the formula for each analytical test in different formats, and the spacing between reports must be completely consistent before batch extraction can be performed. The learning cost of this method of summarizing data through Excel formulas is relatively high and difficult to promote. Summary of the invention

[0005] The present invention provides a data processing method, device, electronic device and storage medium, which do not require users to learn complex operations such as formulas and programming, but only require simple point-and-click operations to complete the extraction of complex oil and gas exploration analysis and testing data and generate an analysis and testing summary table.

[0006] According to one aspect of the present invention, there is provided a data processing method, comprising:

[0007] In response to the oil and gas exploration well analysis and testing report processing event being triggered, opening the oil and gas exploration well analysis and testing report form file;

[0008] When a user triggers a data extraction button in the analysis and test report form file, a data extraction window is displayed in the analysis and test report form file; wherein the data extraction window includes at least one in-place editing block control, and each in-place editing block control represents different cell data;

[0009] Determine a target control selected by a user from the at least one in-place edit block control, and display an interactive interface containing cell data corresponding to the target control;

[0010] According to the user's selection operation on the cell data in the interactive interface, an analysis and test summary table is generated.

[0011] According to another aspect of the present invention, there is provided a data processing device, comprising:

[0012] A report form file opening module, for opening the analysis and testing report form file of the oil and gas exploration well in response to the oil and gas exploration well analysis and testing report processing event being triggered;

[0013] A data extraction window display module is used to display a data extraction window in the analysis and test report form file when a trigger operation of a data extraction button in the analysis and test report form file is detected; wherein the data extraction window includes at least one in-place editing block control, and each in-place editing block control represents different cell data;

[0014] An interactive interface display module, used to determine a target control selected by a user from the at least one in-place editing block control, and display an interactive interface containing cell data corresponding to the target control;

[0015] The analysis and test summary table generation module is used to generate an analysis and test summary table according to the user's selection operation on the cell data in the interactive interface.

[0016] According to another aspect of the present invention, there is provided an electronic device, the electronic device comprising:

[0017] at least one processor; and

[0018] a memory communicatively connected to the at least one processor; wherein,

[0019] The memory stores a computer program that can be executed by the at least one processor, and the computer program is executed by the at least one processor so that the at least one processor can perform the data processing method described in any embodiment of the present invention.

[0020] According to another aspect of the present invention, a computer-readable storage medium is provided, wherein the computer-readable storage medium stores computer instructions, and the computer instructions are used to enable a processor to implement the data processing method described in any embodiment of the present invention when executed.

[0021] The data processing scheme of the embodiment of the present invention, in response to the triggering of the analysis and testing report processing event of the oil and gas exploration well, opens the analysis and testing report form file of the oil and gas exploration well; when the user's triggering operation on the data extraction button in the analysis and testing report form file is detected, the data extraction window is displayed in the analysis and testing report form file; wherein, the data extraction window contains at least one in-place editing block control, each of which represents different cell data; the target control selected by the user is determined from the at least one in-place editing block control, and an interactive interface containing the cell data corresponding to the target control is displayed; according to the user's point selection operation on the cell data in the interactive interface, an analysis and testing summary table is generated. Through the technical scheme provided by the embodiment of the present invention, there is no need for the user to learn complex operations such as formulas and programming, and only simple point selection operations are required to complete the extraction of complex oil and gas exploration analysis and testing data and generate an analysis and testing summary table, which is beneficial for scientific researchers to perform big data analysis, machine learning and other operations.

[0022] It should be understood that the contents described in this section are not intended to identify the key or important features of the embodiments of the present invention, nor are they intended to limit the scope of the present invention. Other features of the present invention will become easily understood through the following description. BRIEF DESCRIPTION OF THE DRAWINGS

[0023] In order to more clearly illustrate the technical solutions in the embodiments of the present invention, the following briefly introduces the drawings required for use in the description of the embodiments. Obviously, the drawings described below are only some embodiments of the present invention. For ordinary technicians in this field, other drawings can be obtained based on these drawings without creative work.

[0024] Figure 1 A flowchart of a data processing method provided in Embodiment 1 of the present invention;

[0025] Figure 2 A schematic diagram of a Word file merge button in a Word type test report file provided by an embodiment of the present invention;

[0026] Figure 3 A schematic diagram of a table file merging button in an Excel type test report file provided by an embodiment of the present invention;

[0027] Figure 4A schematic diagram of a data extraction button in an analysis and test report form file provided by an embodiment of the present invention;

[0028] Figure 5 A schematic diagram of a data extraction window provided by an embodiment of the present invention;

[0029] Figure 6 A schematic diagram of an interactive interface provided by an embodiment of the present invention;

[0030] Figure 7 A schematic diagram showing an analysis and test summary table provided in an embodiment of the present invention;

[0031] Figure 8 A schematic diagram of the structure of a data processing device provided in Embodiment 2 of the present invention;

[0032] Fig. 9 It is a structural schematic diagram of an electronic device for implementing the data processing method of an embodiment of the present invention. DETAILED DESCRIPTION

[0033] In order to enable those skilled in the art to better understand the scheme of the present invention, the technical scheme in the embodiments of the present invention will be clearly and completely described below in conjunction with the drawings in the embodiments of the present invention. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work should fall within the scope of protection of the present invention.

[0034] It should be noted that the terms "first", "second", etc. in the specification and claims of the present invention and the above-mentioned drawings are used to distinguish similar objects, and are not necessarily used to describe a specific order or sequence. It should be understood that the data used in this way can be interchanged where appropriate, so that the embodiments of the present invention described herein can be implemented in an order other than those illustrated or described herein. In addition, the terms "including" and "having" and any variations thereof are intended to cover non-exclusive inclusions, for example, a process, method, system, product or device that includes a series of steps or units is not necessarily limited to those steps or units that are clearly listed, but may include other steps or units that are not clearly listed or inherent to these processes, methods, products or devices.

[0035] Embodiment 1

[0036] Figure 1A flowchart of a data processing method is provided for the first embodiment of the present invention. This embodiment is applicable to the case of processing oil and gas exploration and analysis data. The method can be executed by a data processing device. The data processing device can be implemented in the form of hardware and / or software. The data processing device can be configured in an electronic device. Figure 1 As shown, the method includes:

[0037] S110 , in response to the oil and gas exploration well analysis and testing report processing event being triggered, opening the oil and gas exploration well analysis and testing report form file.

[0038] In an embodiment of the present invention, when an instruction for processing an analysis and test report of an oil and gas exploration well inputted by a user is received, it is determined that an event for processing an analysis and test report of an oil and gas exploration well is triggered. Exemplarily, when an instruction for opening an analysis and test report form file of an oil and gas exploration well inputted by a user is received, the analysis and test report form file of the oil and gas exploration well is opened. The analysis and test report form file is an Excel table file generated by summarizing at least one test report file corresponding to the analysis and test data of the oil and gas exploration well.

[0039] Optionally, in response to the oil and gas exploration well analysis and test report processing event being triggered, before opening the oil and gas exploration well analysis and test report form file, it also includes: obtaining at least one test report file corresponding to the oil and gas exploration well analysis and test data, and determining the file type of each test report file; wherein the file type includes Word files and Excel files; according to the file type and the at least one test report file, generating the oil and gas exploration well analysis and test report form file. The advantage of such a setting is that the analysis and test reports corresponding to the large-scale and diverse oil and gas exploration analysis and test data can be merged to generate a summary form file, which is convenient for the organizer to archive and consult the files.

[0040] In an embodiment of the present invention, a test report file corresponding to various analytical test data of an oil and gas exploration well is obtained, wherein the test report file is a report file obtained by entrusting the analytical test data to different laboratories for testing, and the analytical test data includes thin section identification data, heavy mineral data, mercury injection data, powder particle size, pore characteristics, mercury injection, thin section particle size data and other data. The file type of each test report file is determined, wherein the file type of the test report file is also the storage type of the test report file, and the file type includes Word files and Excel files. According to the file type of the test report file, a processing method for at least one test report file is determined, and at least one test report file is merged based on the processing method to generate an analytical test report form file of the oil and gas exploration well, wherein the analytical test report form file is an Excel form file.

[0041] Optionally, based on the file type and the at least one test report file, an analysis test report form file of the oil and gas exploration well is generated, including: when a user trigger operation on a Word file merge button is detected, a Word file selection dialog box is displayed; a target Word test report file selected by the user in the Word file selection dialog box is determined, and the target Word test report file is merged to generate a summary Word file; the summary Word file is converted into a first Excel table file, and the first Excel table file is used as the analysis test report form file of the oil and gas exploration well. Exemplarily, if at least one test report file contains a Word file, any Word type test report file can be opened according to the user's opening instruction, wherein the test report file add-in contains a Word file merge button, and if a user trigger operation on the Word file merge button is detected, a Word file selection dialog box is displayed. Exemplarily, Figure 2 A schematic diagram of a Word file merge button in a Word type test report file provided by an embodiment of the present invention. Figure 2 The "Merge Word File-CNOOC" button is a Word file merge button. If the user clicks Figure 2 The "Merge Word File - CNOOC" button in the dialog box can detect the user's triggering operation on the Word file merge button. This button can be used through the FileDialog property of the Application object in VBA, and the parameter is msoFileDialogFilePicker to open the Word file selection dialog box. Among them, the Word file selection dialog box contains all Word types of test report file dialog boxes, allowing users to select the Word type of test report files that need to be merged. Determine the target Word test report file selected by the user in the Word file selection dialog box, and connect the selected target Word test report files end to end to generate a summary Word file. Convert the summary Word file into an Excel spreadsheet file. For the convenience of description, the Excel spreadsheet file generated by converting the summary Word file is called the first Excel spreadsheet file, and the first Excel spreadsheet file is used as the analysis test report spreadsheet file of the oil and gas exploration well.

[0042] Optionally, if the target Word test report file contains a large number of images, text boxes and other objects, it will take a long time to merge the target Word test report files and convert the summary Word files into the first Excel spreadsheet file. Therefore, before merging the target Word test report files, the target Word test report files can be backed up and the images, text boxes and other objects in the target Word test report files can be appropriately compressed or deleted. Figure 2 Click the "Delete all pictures and text boxes in this Word file - CNOOC" button to delete the pictures, text boxes and other objects in the target Word test report file. The function of this button is to batch select and delete InlineShape and Shape objects.

[0043] Optionally, based on the file type and the at least one test report file, an analysis test report table file of the oil and gas exploration well is generated, including: when a user trigger operation on a table file merge button is detected, a table file selection dialog box is displayed; the target table test report file selected by the user in the table file selection dialog box is determined, and the target table test report file is merged to generate a summary table file; all Sheet tables in the summary table file are merged into the same Sheet table to generate a second Excel table file, and the second Excel table file is used as the analysis test report table file of the oil and gas exploration well. Exemplarily, if at least one test report file contains an Excel file, any Excel type test report file can be opened according to the user's opening instruction, wherein the test report file add-in contains a table file merge button, and if the user trigger operation on the table file merge button is detected, a table file selection dialog box is displayed. Exemplarily, Figure 3 A schematic diagram of a table file merging button in an Excel type test report file provided by an embodiment of the present invention. Figure 3 The "Merge Table File-CNOOC" button is a table file merge button. If the user clicks Figure 3In the "Merge Spreadsheet File - CNOOC" button, the user's triggering operation on the spreadsheet file merge button can be detected. This button can be used through the FileDialog property of the Application object in VBA, and the parameter is msoFileDialogFilePicker to open the spreadsheet file selection dialog box. Among them, the spreadsheet file selection dialog box contains all table types of test report file dialog boxes, so that users can select the test report files of the table type that need to be merged. Determine the target table test report file selected by the user in the spreadsheet file selection dialog box, and merge the selected target table test report file, that is, merge each Sheet in all the selected target table test report files into a summary Excel document to generate a summary spreadsheet file. Among them, the number of Sheet tables contained in the summary spreadsheet file is the sum of the Sheet tables contained in all target table test report files. When it is detected that the user has triggered the "Merge Spreadsheet File - CNOOC" button, the user can trigger the "Merge Spreadsheet File - CNOOC" button. Figure 3 When the "Merge current file Sheet-CNOOC" button is triggered, all Sheet tables in the summary table file are traversed, the data of all Sheet tables are connected end to end and merged into the same Sheet table, thereby generating a second Excel table file, and the second Excel table file is used as the analysis and testing report table file of the oil and gas exploration well.

[0044] S120. When it is detected that the user triggers the data extraction button in the analysis and test report form file, a data extraction window is displayed in the analysis and test report form file; wherein the data extraction window contains at least one in-place edit block control, and each of the in-place edit block controls represents different cell data.

[0045] In an embodiment of the present invention, after opening the analysis and testing report form file of the oil and gas exploration well, the data add-in item in the analysis and testing report form file includes a data extraction button. Figure 4 A schematic diagram of a data extraction button in a table file of an analysis and test report provided by an embodiment of the present invention. Figure 4 The "Data Extraction-CNOOC" button is a data extraction button. If the user clicks Figure 4 The "Data Extraction-CNOOC" button in the analysis and test report form file can detect the user's triggering operation on the data extraction button in the analysis and test report form file, and then the data extraction window is displayed in the analysis and test report form file. The data extraction window contains at least one in-place edit block control, and each in-place edit block control represents different cell data. For example, Figure 5 A data extraction window diagram provided by an embodiment of the present invention. Figure 5As shown, the data extraction window contains multiple in-place editing block RefEdit controls for data interaction. The control can pass the cells selected by the user to the background so that the background can intelligently analyze the overall structure of the table based on the content. There is a brief text box on each RefEdit control to prompt the user which cell to select for each RefEdit control. That is, each RefEdit control represents different cell data, such as the "Report Title" cell, the "Well Name" cell, the "Depth" cell, and the "Custom" cell, etc. Figure 5 As shown, the data extraction window may also include a brief operation prompt section to help first-time users understand how to use the data extraction window; in addition, the data extraction window may also include a "select complete" button, and when the user clicks the "select complete" button, the data can be intelligently extracted and summarized.

[0046] S130. Determine a target control selected by the user from the at least one in-place edit block control, and display an interactive interface containing cell data corresponding to the target control.

[0047] In the embodiment of the present invention, the data extraction window includes at least one in-place editing block control, from which the user can select Figure 5 Randomly select any one or more in-place edit block controls from all in-place edit block controls shown, determine the in-place edit block control selected by the user from at least one in-place edit block control in the data extraction window, and refer to the in-place edit block control selected by the user as the target control. Figure 5 If the corresponding in-place edit block controls on the right side of the "Report Title" cell, the "Well Name" cell, the "Depth" cell, and the "Custom" cell are activated, an interactive interface containing the cell data corresponding to the target control will be displayed. For example, Figure 6 A schematic diagram of an interactive interface provided by an embodiment of the present invention.

[0048] S140, generating an analysis and test summary table according to the user's selection operation on the cell data in the interactive interface.

[0049] In an embodiment of the present invention, a user can perform a click operation on any one or more cell data in the interactive interface, and generate an analysis and test summary table based on the cell data selected by the user in the interactive interface. It can be understood that the user passes the report title, well name, depth, custom data 1, custom data 2 and other cell data into the interactive interface in sequence through the interaction between the RefEdit control and the user. When the user clicks the "Select Complete" button in the data extraction window, the background recognizes the information and intelligently determines the table structure. At this time, a new Sheet table is automatically created. In the new Sheet table, each row is a test sample point data containing multiple indicators, and each column is the same indicator data of multiple test samples arranged in sequence. Such a combination of rows and columns is an analysis and test summary table. Exemplarily, Figure 7 A schematic diagram showing an analysis and test summary table provided in an embodiment of the present invention.

[0050] Optionally, according to the user's selection operation on the cell data in the interactive interface, generating an analysis and test summary table includes: determining at least one keyword corresponding to the target cell data selected by the user in the interactive interface; extracting the corresponding target data based on the at least one keyword, and generating an analysis and test summary table based on the target data. Exemplarily, determining at least one keyword corresponding to the target cell data selected by the user in the interactive interface, wherein the keyword is generally a title, traversing at least one keyword in the interactive interface, extracting the target data corresponding to the keyword, and summarizing all the extracted target data into an Excel table to generate an analysis and test summary table.

[0051] Optionally, extracting the corresponding target data based on the at least one keyword includes: traversing the at least one keyword, determining the keyword cell position corresponding to the keyword, and extracting the target data corresponding to the keyword at the keyword cell position. Optionally, before traversing the at least one keyword and determining the keyword cell position corresponding to the keyword, it also includes: determining the title corresponding to the target cell data, and determining the title cell position corresponding to the title; traversing the at least one keyword and determining the keyword cell position corresponding to the keyword includes: traversing the at least one keyword and determining the relative position relationship between the keyword and the title; determining the keyword cell position corresponding to the keyword according to the relative position relationship and the title cell position.

[0052] It is understandable that the relative position between the target cell data selected by the user in the interactive interface is determined, and the assay format framework is intelligently judged and analyzed to determine key information such as "indicator content", "cell position", and "relative distance from the title". For example, Table 1 is a key information table provided in an embodiment of the present invention:

[0053] Table 1 Key information table

[0054]

[0055] Traverse the entire Sheet to search for keywords, usually titles. Each time a keyword is traversed, the keyword cell position is determined, and the target data corresponding to the keyword is extracted according to the keyword cell position. Exemplary. Determine the title corresponding to the target cell data selected by the user, and determine the title cell position corresponding to the title. Traverse each keyword, determine the relative position relationship between the keyword and the title, and determine the keyword cell position corresponding to the keyword according to the relative position relationship and the title cell position. For example, the title position is A18, the depth value is Q19, and the relative distance is (16, 1). When traversing the keywords, if the next keyword (title) position is A52, combined with the relative distance (16, 1) in Table 1, it means that the depth value needs to move A52 to the right by 1 column and down by 16 rows. The calculated depth value cell is Q53. Then store the content of cell Q53 in the summary table, so that the summary of one indicator of a report is completed. Repeat until all selected indicators in all reports are summarized.

[0056] The data processing method of the embodiment of the present invention, in response to the triggering of the analysis and testing report processing event of the oil and gas exploration well, opens the analysis and testing report form file of the oil and gas exploration well; when the user's triggering operation on the data extraction button in the analysis and testing report form file is detected, the data extraction window is displayed in the analysis and testing report form file; wherein, the data extraction window contains at least one in-place editing block control, each of which represents different cell data; the target control selected by the user is determined from the at least one in-place editing block control, and an interactive interface containing the cell data corresponding to the target control is displayed; according to the user's point selection operation on the cell data in the interactive interface, an analysis and testing summary table is generated. Through the technical solution provided by the embodiment of the present invention, there is no need for the user to learn complex operations such as formulas and programming, and only simple point selection operations are required to complete the extraction of complex oil and gas exploration analysis and testing data and generate an analysis and testing summary table, which is beneficial for scientific researchers to perform big data analysis, machine learning and other operations.

[0057] Embodiment 2

[0058] Figure 8 This is a schematic diagram of the structure of a data processing device provided in Embodiment 2 of the present invention. Figure 8 As shown, the device comprises:

[0059] The report form file opening module 810 is used to open the analysis and testing report form file of the oil and gas exploration well in response to the oil and gas exploration well analysis and testing report processing event being triggered;

[0060] The data extraction window display module 820 is used to display a data extraction window in the analysis and test report form file when a trigger operation of a data extraction button in the analysis and test report form file is detected; wherein the data extraction window includes at least one in-place editing block control, and each in-place editing block control represents different cell data;

[0061] An interactive interface display module 830, configured to determine a target control selected by a user from the at least one in-place edit block control, and display an interactive interface containing cell data corresponding to the target control;

[0062] The analysis and test summary table generating module 840 is used to generate an analysis and test summary table according to the user's selection operation on the cell data in the interactive interface.

[0063] Optionally, the device further comprises:

[0064] A file type determination module, for, in response to the oil and gas exploration well analysis and test report processing event being triggered, before opening the oil and gas exploration well analysis and test report form file, obtaining at least one test report file corresponding to the oil and gas exploration well analysis and test data, and determining the file type of each test report file; wherein the file types include Word files and Excel files;

[0065] The analysis and testing report form file generating module is used to generate the analysis and testing report form file of the oil and gas exploration well according to the file type and the at least one testing report file.

[0066] Optionally, the analysis and testing report form file generation module is used to:

[0067] When a user triggers the Word file merge button, a Word file selection dialog box is displayed;

[0068] Determine the target Word test report file selected by the user in the Word file selection dialog box, and merge the target Word test report file to generate a summary Word file;

[0069] The summary Word file is converted into a first Excel table file, and the first Excel table file is used as the analysis and testing report table file of the oil and gas exploration well.

[0070] Optionally, the analysis and testing report form file generation module is used to:

[0071] When a user triggers the table file merge button, a table file selection dialog box is displayed;

[0072] Determine the target table test report file selected by the user in the table file selection dialog box, and merge the target table test report file to generate a summary table file;

[0073] All the Sheet tables in the summary table file are merged into the same Sheet table to generate a second Excel table file, and the second Excel table file is used as the analysis and testing report table file of the oil and gas exploration well.

[0074] Optionally, the analysis and testing summary table generating module includes:

[0075] A keyword determination unit, used to determine at least one keyword corresponding to the target cell data selected by the user in the interactive interface;

[0076] The analysis and testing summary table generating unit is used to extract the corresponding target data based on the at least one keyword, and generate the analysis and testing summary table based on the target data.

[0077] Optionally, the analysis and testing summary table generating unit includes:

[0078] The analysis and testing summary table generation subunit is used to traverse the at least one keyword, determine the keyword cell position corresponding to the keyword, and extract the target data corresponding to the keyword at the keyword cell position.

[0079] Optionally, also include:

[0080] A title cell location module, used to determine the title corresponding to the target cell data and determine the title cell location corresponding to the title before traversing the at least one keyword and determining the keyword cell location corresponding to the keyword;

[0081] The analysis and testing summary table generation subunit is used to:

[0082] Traversing the at least one keyword to determine a relative position relationship between the keyword and the title;

[0083] The keyword cell position corresponding to the keyword is determined according to the relative position relationship and the title cell position.

[0084] The data processing device provided in the embodiment of the present invention can execute the data processing method provided in any embodiment of the present invention, and has the corresponding functional modules and beneficial effects of the execution method.

[0085] Embodiment 3

[0086] Fig. 9 A schematic diagram of the structure of an electronic device 10 that can be used to implement an embodiment of the present invention is shown. The electronic device is intended to represent various forms of digital computers, such as laptop computers, desktop computers, workstations, personal digital assistants, servers, blade servers, mainframe computers, and other suitable computers. The electronic device can also represent various forms of mobile devices, such as personal digital processing, cellular phones, smart phones, wearable devices (such as helmets, glasses, watches, etc.) and other similar computing devices. The components shown herein, their connections and relationships, and their functions are merely examples and are not intended to limit the implementation of the present invention described and / or required herein.

[0087] like Fig. 9 As shown, the electronic device 10 includes at least one processor 11, and a memory connected to the at least one processor 11, such as a read-only memory (ROM) 12, a random access memory (RAM) 13, etc., wherein the memory stores a computer program that can be executed by at least one processor, and the processor 11 can perform various appropriate actions and processes according to the computer program stored in the read-only memory (ROM) 12 or the computer program loaded from the storage unit 18 to the random access memory (RAM) 13. In the RAM 13, various programs and data required for the operation of the electronic device 10 can also be stored. The processor 11, the ROM 12, and the RAM 13 are connected to each other through a bus 14. An input / output (I / O) interface 15 is also connected to the bus 14.

[0088] A number of components in the electronic device 10 are connected to the I / O interface 15, including: an input unit 16, such as a keyboard, a mouse, etc.; an output unit 17, such as various types of displays, speakers, etc.; a storage unit 18, such as a disk, an optical disk, etc.; and a communication unit 19, such as a network card, a modem, a wireless communication transceiver, etc. The communication unit 19 allows the electronic device 10 to exchange information / data with other devices through a computer network such as the Internet and / or various telecommunication networks.

[0089] The processor 11 may be a variety of general and / or special processing components with processing and computing capabilities. Some examples of the processor 11 include, but are not limited to, a central processing unit (CPU), a graphics processing unit (GPU), various dedicated artificial intelligence (AI) computing chips, various processors running machine learning model algorithms, a digital signal processor (DSP), and any appropriate processor, controller, microcontroller, etc. The processor 11 performs the various methods and processes described above, such as a data processing method.

[0090] In some embodiments, the data processing method may be implemented as a computer program, which is tangibly contained in a computer-readable storage medium, such as a storage unit 18. In some embodiments, part or all of the computer program may be loaded and / or installed on the electronic device 10 via the ROM 12 and / or the communication unit 19. When the computer program is loaded into the RAM 13 and executed by the processor 11, one or more steps of the data processing method described above may be performed. Alternatively, in other embodiments, the processor 11 may be configured to perform the data processing method in any other appropriate manner (e.g., by means of firmware).

[0091] Various implementations of the systems and techniques described above herein can be implemented in digital electronic circuit systems, integrated circuit systems, field programmable gate arrays (FPGAs), application specific integrated circuits (ASICs), application specific standard products (ASSPs), systems on chips (SOCs), load programmable logic devices (CPLDs), computer hardware, firmware, software, and / or combinations thereof. These various implementations can include: being implemented in one or more computer programs that can be executed and / or interpreted on a programmable system including at least one programmable processor, which can be a special purpose or general purpose programmable processor that can receive data and instructions from a storage system, at least one input device, and at least one output device, and transmit data and instructions to the storage system, the at least one input device, and the at least one output device.

[0092] Computer programs for implementing the methods of the present invention may be written in any combination of one or more programming languages. These computer programs may be provided to a processor of a general-purpose computer, a special-purpose computer, or other programmable data processing device, so that when the computer program is executed by the processor, the functions / operations specified in the flow chart and / or block diagram are implemented. The computer program may be executed entirely on the machine, partially on the machine, partially on the machine and partially on a remote machine as a stand-alone software package, or entirely on a remote machine or server.

[0093] In the context of the present invention, a computer-readable storage medium may be a tangible medium that may contain or store a computer program for use by or in combination with an instruction execution system, device or equipment. A computer-readable storage medium may include, but is not limited to, electronic, magnetic, optical, electromagnetic, infrared, or semiconductor systems, devices or equipment, or any suitable combination of the foregoing. Alternatively, a computer-readable storage medium may be a machine-readable signal medium. A more specific example of a machine-readable storage medium may include an electrical connection based on one or more lines, a portable computer disk, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disk read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing.

[0094] To provide interaction with a user, the systems and techniques described herein may be implemented on an electronic device having: a display device (e.g., a CRT (cathode ray tube) or LCD (liquid crystal display) monitor) for displaying information to the user; and a keyboard and a pointing device (e.g., a mouse or trackball) through which the user can provide input to the electronic device. Other types of devices may also be used to provide interaction with the user; for example, the feedback provided to the user may be any form of sensory feedback (e.g., visual feedback, auditory feedback, or tactile feedback); and input from the user may be received in any form (including acoustic input, voice input, or tactile input).

[0095] The systems and techniques described herein may be implemented in a computing system that includes backend components (e.g., as a data server), or a computing system that includes middleware components (e.g., an application server), or a computing system that includes frontend components (e.g., a user computer with a graphical user interface or a web browser through which a user can interact with implementations of the systems and techniques described herein), or a computing system that includes any combination of such backend components, middleware components, or frontend components. The components of the system may be interconnected by any form or medium of digital data communication (e.g., a communication network). Examples of communication networks include: a local area network (LAN), a wide area network (WAN), a blockchain network, and the Internet.

[0096] A computing system may include a client and a server. The client and the server are generally remote from each other and usually interact through a communication network. The client and server relationship is generated by computer programs running on the corresponding computers and having a client-server relationship with each other. The server may be a cloud server, also known as a cloud computing server or cloud host, which is a host product in the cloud computing service system to solve the defects of difficult management and weak business scalability in traditional physical hosts and VPS services.

[0097] It should be understood that the various forms of processes shown above can be used to reorder, add or delete steps. For example, the steps described in the present invention can be executed in parallel, sequentially or in different orders, as long as the desired results of the technical solution of the present invention can be achieved, and this document does not limit this.

[0098] The above specific implementations do not constitute a limitation on the protection scope of the present invention. It should be understood by those skilled in the art that various modifications, combinations, sub-combinations and substitutions can be made according to design requirements and other factors. Any modification, equivalent substitution and improvement made within the spirit and principle of the present invention should be included in the protection scope of the present invention.

Claims

1. A data processing method, characterized in that: include: In response to the oil and gas exploration well analysis and testing report processing event being triggered, opening the oil and gas exploration well analysis and testing report form file; When a user triggers a data extraction button in the analysis and test report form file, a data extraction window is displayed in the analysis and test report form file; wherein the data extraction window includes at least one in-place editing block control, and each in-place editing block control represents different cell data; Determine a target control selected by a user from the at least one in-place edit block control, and display an interactive interface containing cell data corresponding to the target control; According to the user's selection operation on the cell data in the interactive interface, an analysis and test summary table is generated.

2. The method according to claim 1, characterized in that In response to the oil and gas exploration well analysis and testing report processing event being triggered, before opening the oil and gas exploration well analysis and testing report form file, the method further includes: Obtain at least one test report file corresponding to the analytical test data of the oil and gas exploration well, and determine the file type of each test report file; wherein the file type includes Word files and Excel files; An analysis and testing report form file of the oil and gas exploration well is generated according to the file type and the at least one test report file.

3. The method according to claim 2, characterized in that Generating an analysis and testing report form file of the oil and gas exploration well according to the file type and the at least one test report file, including: When a user triggers the Word file merge button, a Word file selection dialog box is displayed; Determine the target Word test report file selected by the user in the Word file selection dialog box, and merge the target Word test report file to generate a summary Word file; The summary Word file is converted into a first Excel table file, and the first Excel table file is used as the analysis and testing report table file of the oil and gas exploration well.

4. The method according to claim 2, characterized in that: Generating an analysis and testing report form file of the oil and gas exploration well according to the file type and the at least one test report file, including: When a user triggers the table file merge button, a table file selection dialog box is displayed; Determine the target table test report file selected by the user in the table file selection dialog box, and merge the target table test report file to generate a summary table file; All the Sheet tables in the summary table file are merged into the same Sheet table to generate a second Excel table file, and the second Excel table file is used as the analysis and testing report table file of the oil and gas exploration well.

5. The method according to claim 1, characterized in that: According to the user's selection operation on the cell data in the interactive interface, an analysis and test summary table is generated, including: Determine at least one keyword corresponding to the target cell data selected by the user in the interactive interface; Corresponding target data is extracted based on the at least one keyword, and an analysis and testing summary table is generated based on the target data.

6. The method according to claim 5, characterized in that Extracting corresponding target data based on the at least one keyword includes: The at least one keyword is traversed to determine a keyword cell position corresponding to the keyword, and target data corresponding to the keyword is extracted at the keyword cell position.

7. The method according to claim 6, characterized in that Before traversing the at least one keyword and determining the keyword cell position corresponding to the keyword, the method further includes: Determine the title corresponding to the target cell data, and determine the title cell position corresponding to the title; Traversing the at least one keyword to determine a keyword cell position corresponding to the keyword includes: Traversing the at least one keyword to determine a relative position relationship between the keyword and the title; The keyword cell position corresponding to the keyword is determined according to the relative position relationship and the title cell position.

8. A data processing device, characterized in that: include: A report form file opening module, for opening the analysis and testing report form file of the oil and gas exploration well in response to the oil and gas exploration well analysis and testing report processing event being triggered; A data extraction window display module is used to display a data extraction window in the analysis and test report form file when a trigger operation of a data extraction button in the analysis and test report form file is detected; wherein the data extraction window includes at least one in-place editing block control, and each in-place editing block control represents different cell data; An interactive interface display module, used to determine a target control selected by a user from the at least one in-place editing block control, and display an interactive interface containing cell data corresponding to the target control; The analysis and test summary table generation module is used to generate an analysis and test summary table according to the user's selection operation on the cell data in the interactive interface.

9. An electronic device, characterized in that: The electronic device comprises: at least one processor; and a memory communicatively connected to the at least one processor; wherein, The memory stores a computer program executable by the at least one processor, and the computer program is executed by the at least one processor so that the at least one processor can perform the data processing method according to any one of claims 1 to 7.

10. A computer-readable storage medium, characterized in that: The computer-readable storage medium stores computer instructions, and the computer instructions are used to enable a processor to implement the data processing method according to any one of claims 1 to 7 when executed.

Images