CN116414778A - File integration method, apparatus, computer device, storage medium and program product - Google Patents
File integration method, apparatus, computer device, storage medium and program product Download PDFInfo
- Publication number
- CN116414778A CN116414778A CN202111644849.9A CN202111644849A CN116414778A CN 116414778 A CN116414778 A CN 116414778A CN 202111644849 A CN202111644849 A CN 202111644849A CN 116414778 A CN116414778 A CN 116414778A
- Authority
- CN
- China
- Prior art keywords
- file
- search
- data information
- information
- data
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 230000010354 integration Effects 0.000 title claims abstract description 76
- 238000000034 method Methods 0.000 title claims abstract description 59
- 238000004590 computer program Methods 0.000 claims abstract description 40
- 230000008676 import Effects 0.000 claims abstract description 24
- 230000006870 function Effects 0.000 claims description 8
- 238000010586 diagram Methods 0.000 description 5
- 238000004891 communication Methods 0.000 description 4
- 238000005516 engineering process Methods 0.000 description 4
- 230000008569 process Effects 0.000 description 4
- 230000004044 response Effects 0.000 description 4
- 238000012545 processing Methods 0.000 description 3
- 230000008859 change Effects 0.000 description 2
- 230000003068 static effect Effects 0.000 description 2
- OKTJSMMVPCPJKN-UHFFFAOYSA-N Carbon Chemical compound [C] OKTJSMMVPCPJKN-UHFFFAOYSA-N 0.000 description 1
- 208000025174 PANDAS Diseases 0.000 description 1
- 208000021155 Paediatric autoimmune neuropsychiatric disorders associated with streptococcal infection Diseases 0.000 description 1
- 240000000220 Panda oleosa Species 0.000 description 1
- 235000016496 Panda oleosa Nutrition 0.000 description 1
- 230000001413 cellular effect Effects 0.000 description 1
- 238000013461 design Methods 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 229910021389 graphene Inorganic materials 0.000 description 1
- 239000004973 liquid crystal related substance Substances 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/10—File systems; File servers
- G06F16/16—File or folder operations, e.g. details of user interfaces specifically adapted to file systems
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/10—File systems; File servers
- G06F16/14—Details of searching files based on file metadata
- G06F16/148—File search processing
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/10—File systems; File servers
- G06F16/16—File or folder operations, e.g. details of user interfaces specifically adapted to file systems
- G06F16/168—Details of user interfaces specifically adapted to file systems, e.g. browsing and visualisation, 2d or 3d GUIs
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
- Y02D10/00—Energy efficient computing, e.g. low power processors, power management or thermal management
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Human Computer Interaction (AREA)
- Library & Information Science (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present application relates to a file integration method, apparatus, computer device, storage medium and computer program product. The method comprises the following steps: after the search interface of the display target search tool detects the triggering operation aiming at the file importing option in the search interface, importing a plurality of files to be processed into the target search tool according to the triggering operation, searching the first data information in each file to be processed according to the search keywords input in the input box in the search interface, obtaining second data information matched with the search keywords, and generating an integrated file according to the second data information. By adopting the method, the integration of a plurality of files to be processed can be realized only by one file import, the integration operation is simplified, the automation of file integration is improved, the integration time is further saved, and the integration efficiency is improved.
Description
Technical Field
The present invention relates to the field of computer technology, and in particular, to a file integration method, apparatus, computer device, storage medium, and computer program product.
Background
With the development of technology, computer office has become a common office mode for people to use in daily office. Word, excel, PPT is a more commonly used file format.
For Excel files, each Excel file may include multiple rows/columns of information, and users often need to integrate the information of multiple Excel files to integrate the required rows/columns of information into one Excel file. In the conventional technology, a user needs to open each Excel file respectively, screen out the required row/column information, copy the information into the middle of a newly built Excel file, and further obtain the Excel file after information integration.
However, the conventional Excel file information integration method is complex in operation and low in efficiency.
Disclosure of Invention
In view of the foregoing, it is desirable to provide a file integrating method, apparatus, computer device, storage medium, and computer program product.
In a first aspect, a method for integrating files is provided, including:
displaying a retrieval interface of a target retrieval tool, wherein the retrieval interface comprises a file importing option and an input box;
after triggering operation for a file importing option is detected, importing a plurality of files to be processed into a target retrieval tool according to the triggering operation, wherein the files to be processed comprise first data information;
Searching the first data information in each file to be processed according to the search keywords input in the input box to obtain second data information matched with the search keywords;
and generating an integrated file according to the second data information.
In the file integration method, the target retrieval tool can integrate a plurality of files to be processed only by one file import, so that the integration operation is simplified, the automation of file integration is improved, the integration time is further saved, and the integration efficiency is improved.
With reference to the first aspect, in one possible implementation manner of the first aspect, the integrating file is a data table file, and generating the integrating file according to the second data information includes:
receiving header information set by a user;
and generating an integrated file according to the header information and the second data information.
In the file integration method, the target retrieval tool receives the header information set by the user, and further generates an integrated file according to the header information and the second data information, so that redundant information is reduced, and the integrated file meeting the information requirement of the user is obtained.
With reference to the first aspect, in one possible implementation manner of the first aspect, the search interface includes a search result display area, and generates an integrated file according to header information and second data information, including:
Displaying the second data information in the search result display area;
receiving an information selection instruction of a user aiming at the second data information based on the search result display area, and determining target data information in the second data information according to the information selection instruction;
and generating an integrated file according to the header information and the target data information.
In the file integration method, the target search tool displays the second data information in the search result display area, receives an information selection instruction aiming at the second data information by a user based on the search result display area, determines the target data information in the second data information according to the information selection instruction, and further generates an integration file according to the header information and the target data information. The autonomous selection of the second data information by the user is realized, and the flexibility of file integration is improved.
With reference to the first aspect, in a possible implementation manner of the first aspect, the search interface further includes a file export option, and the method further includes:
after detecting a triggering operation for the file export option, the integrated file is exported from the target retrieval tool.
In the file integration method, after the target retrieval tool detects the triggering operation for the file export option, the integrated file is exported from the target retrieval tool, so that the reusable integrated file is obtained, and the practical applicability of the file integration method is further improved.
With reference to the first aspect, in one possible implementation manner of the first aspect, the search interface further includes at least one search restriction option, and searches the first data information in each file to be processed according to the search keyword input in the input box, including:
after detecting triggering operation of at least one retrieval limiting option, acquiring a retrieval limiting condition corresponding to the retrieval limiting option, wherein the retrieval limiting condition comprises a case limiting condition or an accuracy limiting condition;
and searching the first data information in each file to be processed according to the search limiting conditions and the search keywords.
In the file integration method, after detecting the triggering operation of at least one search limit option, the target search tool acquires the search limit condition corresponding to the search limit option, and searches the first data information in each file to be processed according to the search limit condition and the search keyword. Wherein the retrieval constraint includes a case constraint or an accuracy constraint. By the method, retrieval with different precision is realized, the retrieval requirements of users on the different precision are met, and the application range is expanded.
With reference to the first aspect, in one possible implementation manner of the first aspect, the file to be processed is a data table file, the first data information is data in a data row, a data column or a data table cell, and the second data information is data in a data row, a data column or a data table cell.
With reference to the first aspect, in one possible implementation manner of the first aspect, the file to be processed includes a plurality of data tables, the search interface further includes a data table selection item, and the searching for the first data information in each file to be processed according to the search keyword input in the input box includes:
determining a target data table in a plurality of data tables included in each file to be processed according to a selection instruction of a user for the data table selection item;
and searching the first data information in the target data table in each file to be processed according to the search keywords.
In the above method for integrating files, the files to be processed are data table files, the files to be processed may include a plurality of data tables, the target retrieval tool determines a target data table from the plurality of data tables included in each file to be processed according to a selection instruction of a user for a data table selection item, and retrieves the first data information in the target data table in each file to be processed according to the retrieval key. The method realizes the retrieval and integration of a plurality of data sheet files, improves the integration efficiency, avoids errors caused by manual integration, and ensures the accuracy of integration.
In a second aspect, a document integration apparatus is provided, including:
The function display module is used for displaying a search interface of the target search tool, wherein the search interface comprises file import options and an input box;
the file importing module is used for importing a plurality of files to be processed into the target retrieval tool according to the triggering operation after the triggering operation for the file importing option is detected, wherein the files to be processed comprise first data information;
the information retrieval module is used for retrieving the first data information in each file to be processed according to the retrieval keywords input in the input box to obtain second data information matched with the retrieval keywords;
and the information integration module is used for generating an integration file according to the second data information.
In a third aspect, a computer device is provided, comprising a memory storing a computer program and a processor implementing the steps of the method of the first aspect or any one of the possible implementations of the first aspect when the computer program is executed.
In a fourth aspect, a computer readable storage medium is provided, on which a computer program is stored which, when executed by a processor, carries out the steps of the method of the first aspect or any one of the possible implementations of the first aspect.
In a fifth aspect, there is provided a computer program product comprising a computer program which, when executed by a processor, implements the steps of the method of the first aspect or any one of the possible implementations of the first aspect.
According to the file integration method, the file integration device, the computer equipment, the storage medium and the computer program product, after the triggering operation of the file importing option in the searching interface is detected through the searching interface of the displaying target searching tool, a plurality of files to be processed are imported into the target searching tool according to the triggering operation, the first data information in each file to be processed is searched according to the searching keyword input in the input box in the searching interface, the second data information matched with the searching keyword is obtained, and the integrated file is further generated according to the second data information. By adopting the method, the integration of a plurality of files to be processed can be realized only by one file import, the integration operation is simplified, the automation of file integration is improved, the integration time is further saved, and the integration efficiency is improved.
Drawings
FIG. 1 is a flow chart of a method of file integration in one embodiment;
FIG. 2 is an interface diagram of a target retrieval tool presentation interface in one embodiment;
FIG. 3 is a flow chart of generating an integrated file according to one embodiment;
FIG. 4 is a flowchart of generating an integrated file according to another embodiment;
FIG. 5 is a flow diagram of triggering a search according to user operation in one embodiment;
FIG. 6 is a flow chart of triggering a search according to a user operation in another embodiment;
FIG. 7 is a flow chart of a method of file integration in another embodiment;
FIG. 8 is a block diagram of a file integration device according to one embodiment;
fig. 9 is an internal structural diagram of a computer device in one embodiment.
Detailed Description
In order to make the objects, technical solutions and advantages of the present application more apparent, the present application will be further described in detail with reference to the accompanying drawings and examples. It should be understood that the specific embodiments described herein are for purposes of illustration only and are not intended to limit the present application.
In one embodiment, as shown in fig. 1, a file integration method is provided, and this embodiment is exemplified by the method being applied to a target retrieval tool installed on a terminal. The terminal may be, but is not limited to, various personal computers, notebook computers, smart phones, tablet computers, internet of things devices, and portable wearable devices. The method comprises the following steps:
S110, displaying a retrieval interface of the target retrieval tool, wherein the retrieval interface comprises a file import option and an input box.
The search interface of the target search tool is a function display interface of the target search tool, so that a user can select different functions, and the target search tool can be obtained by PyQt design.
Optionally, the user opens the target retrieval tool on the terminal, and the target retrieval tool displays a retrieval interface of the target retrieval tool on a display interface of the terminal in response to the opening operation of the user. As shown in fig. 2, the search interface includes a first functional area and a second functional area. The first functional area comprises a file import option for a user to import a file to be processed. The second functional area includes an input box, i.e., a keyword input box, for a user to input a search keyword.
Optionally, referring to fig. 2, the first functional area is located in the upper right corner of the search interface, and an option for implementing an auxiliary search function is displayed. For example, the first functional area displays a file import option, a file export option, or a use hint option. The file import option is used for realizing file import, the file export option is used for realizing file export, the use prompting option is used for prompting the use method of the target retrieval tool, and particularly, a prompting window can be popped up in response to the selection operation of a user on the use prompting option, and videos, pictures and texts or text descriptions for using the target retrieval tool are displayed in the prompting window.
Optionally, with continued reference to fig. 2, the second functional area is located in the upper left corner of the search interface, displaying options for implementing the primary search function. For example, the second functional area is displayed with an input box or a search accuracy option. The input box is used for inputting search keywords, and the search accuracy model selection is used for determining the accuracy degree of search.
The first functional area and the second functional area may be located at any position of the search interface, and the above-mentioned positions of the first functional area and the second functional area on the display surface are merely exemplary, and are not limited thereto.
S120, after triggering operation for the file importing option is detected, importing a plurality of files to be processed into a target retrieval tool according to the triggering operation, wherein the files to be processed comprise first data information.
The triggering operation for the file import option comprises a series of operations that a user selects the file import option, the file import option pops up a file selection window in response to the selection operation, and the user selects a plurality of files to be processed through the file selection window. The first data information is unit granularity information included in the files to be processed, and each file to be processed includes at least one unit granularity information. Alternatively, the unit granularity may be the entire file, or may be a portion of the entire file.
Specifically, after the target retrieval tool detects some column operations, a plurality of files to be processed selected by the user are imported into the target retrieval tool for subsequent retrieval integration by the user.
S130, searching the first data information in each file to be processed according to the search keywords input in the input box, and obtaining second data information matched with the search keywords.
Alternatively, the search keyword may be any character, word or sentence. The form of the search keyword is not particularly limited in this embodiment.
Specifically, after a plurality of files to be processed are imported, a user inputs a search keyword in an input box of a search interface, and a target search tool acquires the search keyword and searches according to first data information of the search keyword in the files to be processed so as to obtain second data information matched with the search keyword.
Optionally, the target retrieval tool may use a corresponding retrieval tool to retrieve according to the type of the file to be processed, so as to obtain second data information matched with the retrieval keyword. When the file to be processed is an excel file, the target retrieval tool may use xlrd libraries, openpyxl, pandas, xlwings and other libraries to retrieve the file to be processed.
And S140, generating an integrated file according to the second data information.
Optionally, the target search tool determines, through the above search process, first data information, that is, the second data information, that matches the search keyword, from the first data information of the plurality of files to be searched, and further integrates all the second data information to generate the integrated file, and may also integrate the second data information selected by the user in response to the selection of the second data information by the user to generate the integrated file.
Optionally, the integration process includes at least one of summarizing, ordering, or deduplicating.
In this embodiment, the terminal displays a search interface of the target search tool, and after detecting a triggering operation for a file import option in the search interface, the target search tool imports a plurality of files to be processed into the target search tool according to the triggering operation, searches the first data information in each file to be processed according to the search keywords input in the input box in the search interface, obtains second data information matched with the search keywords, and generates an integrated file according to the second data information. By adopting the method, the integration of a plurality of files to be processed can be realized only by one file import, the integration operation is simplified, the automation of file integration is improved, the integration time is further saved, and the integration efficiency is improved.
In one embodiment, as shown in fig. 3, the method further includes:
s310, receiving header information set by a user.
Optionally, after the user selects the confirm search button, the search interface pops up the header setting interface for the user to input header information, so as to receive the header information input by the user in the header setting interface.
S320, generating an integration file according to the header information and the second data information.
Optionally, the target retrieval tool acquires second data information matched with the header information input by the user from the second data information according to the header information input by the user, and generates the integrated file according to the matched second data information.
In this embodiment, the target retrieval tool receives header information set by the user, and further generates an integrated file according to the header information and the second data information, so that redundant information is reduced, and an integrated file meeting the information requirement of the user is obtained.
In one embodiment, the search interface includes a search result display area, as shown in fig. 4, the step S320 includes:
and S410, displaying the second data information in the search result display area.
The search result display area is used for displaying the searched data information. Alternatively, as shown in fig. 2, the search result presentation area is located in the middle portion of the search interface.
Specifically, the target retrieval tool responds to the determined retrieval operation of the user, retrieves the first data information of the imported files to be processed, and displays the second data information obtained by retrieval in a result display area of the retrieval interface.
S420, receiving an information selection instruction of a user for the second data information based on the search result display area, and determining target data information in the second data information according to the information selection instruction.
The information selection instruction is used for indicating the second data information selected by the user, namely the target data information.
Specifically, the user may perform a selection operation on the second data information displayed on the search result display interface, and the target search tool receives an information selection instruction of the user for the second data information based on the search result display area, so as to determine the second data information selected by the user, and determine that the second data information selected by the user is the target data information.
Optionally, the selection operation performed by the user on the second data information displayed on the search result display interface may be a click operation of a checkbox preceding each second data information in the search result display area. In this regard, the present embodiment is not particularly limited.
S430, generating an integrated file according to the header information and the target data information.
Specifically, the target retrieval tool acquires target data information of which the header information is matched with the header information input by the user from the target data information according to the header information input by the user, and generates the integrated file according to the matched target data information.
The process of generating the integrated file from the second data information is specifically as follows:
information display: displaying the second data information in the search result display area;
and (3) target selection: receiving a selection operation of second data information displayed in a result display area by a user, and determining the second data information selected by the user as target data information;
information integration: and matching the header information set by the user with the header information of the target data information, extracting the target data information of which the header information is matched with the header information input by the user, obtaining an integrated file after the integration processing, and displaying the integrated file in a search result display area.
In this embodiment, the target search tool displays the second data information in the search result display area, receives an information selection instruction for the second data information from the user based on the search result display area, determines the target data information in the second data information according to the information selection instruction, and further generates the integrated file according to the header information and the target data information. The autonomous selection of the second data information by the user is realized, and the flexibility of file integration is improved.
In one embodiment, the search interface further includes a file export option, and the method further includes:
after detecting a triggering operation for the file export option, the integrated file is exported from the target retrieval tool.
Alternatively, as shown in FIG. 2, the file export option is located in the first functional area of the search interface.
Specifically, after the integrated file is displayed on the search result display interface, the user can trigger the file export option, and after the target search tool detects the triggering operation for the file export option, the integrated file is exported from the target search tool and stored in the local storage space. Wherein, after the integrated file is exported from the target retrieval tool, the integrated file can be renamed.
In this embodiment, after detecting the triggering operation for the file export option, the target retrieval tool exports the integrated file from the target retrieval tool, so as to obtain the reusable integrated file, thereby improving the practical applicability of the file integration method.
In one embodiment, the search interface further includes at least one search restriction option, as shown in fig. 5, where the step S130 of searching the first data information in each to-be-processed file according to the search keyword input in the input box includes:
S510, after detecting triggering operation of at least one retrieval limit option, acquiring a retrieval limit condition corresponding to the retrieval limit option.
Wherein, the search restriction condition is used for restricting the search mode based on the search keyword. The search restriction conditions include case restriction conditions or search accuracy restriction conditions.
Optionally, as shown in fig. 2, the second functional area of the search interface displays two search restriction options, a case restriction option and a search accuracy restriction option. The case limiting options are case conditions for distinguishing the search keywords, and the accuracy limiting options are corresponding to accurate search for the search keywords.
Optionally, if the target retrieval tool detects a user's selection operation of the case restriction option, the corresponding retrieval restriction condition is the case of distinguishing the retrieval keyword; if the target retrieval tool does not detect the selection operation of the user on the case limiting option, the corresponding retrieval limiting condition is that the case of the retrieval keyword is not distinguished; if the target retrieval tool detects the selection operation of the user on the accuracy limiting option, the corresponding retrieval limiting condition is the accurate retrieval aiming at the retrieval keyword; if the target retrieval tool does not detect the selection operation of the user on the accuracy limiting options, the corresponding retrieval limiting conditions are fuzzy retrieval aiming at the retrieval keywords.
S520, searching the first data information in each file to be processed according to the search limiting conditions and the search keywords.
Specifically, the target retrieval tool determines a corresponding retrieval limiting condition based on triggering operation of a user on the retrieval limiting option, and retrieves the first data information in each file to be processed under the corresponding retrieval limiting condition according to the retrieval keyword after determining the retrieval limiting condition.
In this embodiment, after detecting a triggering operation on at least one search restriction option, the target search tool obtains a search restriction condition corresponding to the search restriction option, and searches the first data information in each file to be processed according to the search restriction condition and the search keyword. Wherein the retrieval constraint includes a case constraint or an accuracy constraint. By the method, retrieval with different precision is realized, the retrieval requirements of users on the different precision are met, and the application range is expanded.
In one embodiment, the file to be processed is a data table file, that is, an Excel file, the first data information is data in a data row, a data column or a data table cell, and the second data information is data in a data row, a data column or a data table cell.
Optionally, the to-be-processed files include a plurality of data tables, and the search interface further includes a data table selection item, as shown in fig. 6, and in S130, searching the first data information in each to-be-processed file according to the search keyword input in the input box includes:
s610, determining a target data table from a plurality of data tables included in each file to be processed according to a selection instruction of a user for the data table selection item.
When the imported files to be processed are Excel files, the data table selection items comprise a plurality of data table labels, and each data table label corresponds to one data table. The target data table is the data table in which the corresponding data table label in the plurality of files to be processed is matched with the data table label selected by the user.
Optionally, after the user imports the plurality of files to be processed into the target retrieval tool, the target retrieval tool may obtain the data table labels of the data tables in each file to be processed, and display the data table labels in the drop-down content of the data table selection item. The data table labels may be in default form, such as sheet1, sheet2, etc., and renamed form, such as xxx detail tables, xxx statistics tables, etc. The expression form of the data table label is not limited in this embodiment.
Alternatively, as shown in FIG. 2, the data sheet selection item is located in a second functional area in the search interface. After the target retrieval tool retrieves the data table label selected by the user in the data table selection item, generating a selection instruction carrying the data table label selected by the user, and determining a data table, namely a target data table, of which the corresponding data table label is matched with the data table label selected by the user in each file to be processed based on the selection instruction. For example, 3 Excel files to be processed of the target retrieval tool are imported, and the Excel files to be processed are respectively processed E1, processed E2 and processed E3, wherein the processed E1 comprises 2 data tables, namely data table sheet1 and data table sheet2, the processed E2 comprises 2 data table sheet1, and the processed E3 comprises 1 data table sheet1. When the target retrieval tool detects that the user selects sheet1 in the data table selection item, the data table sheet1 in the to-be-processed E1, the to-be-processed E2 and the to-be-processed E3 is determined to be the target data table.
S620, searching the first data information in the target data table in each file to be processed according to the search keywords.
Specifically, after determining the target data table, the target retrieval tool may retrieve the first data information in the target data table in each file to be processed based on the retrieval keyword. Taking the first data information as data in the data rows as an example, the target retrieval tool retrieves information matched with the retrieval key words in the data of each data row in the target data table, so as to retrieve the data row including the information matched with the retrieval key words in the target data information as the second data information.
In this embodiment, the files to be processed are data table files, the files to be processed may include a plurality of data tables, the target retrieval tool determines a target data table from the plurality of data tables included in each file to be processed according to a selection instruction of a user for a data table selection item, and retrieves first data information in the target data table in each file to be processed according to a retrieval keyword. The method realizes the retrieval and integration of a plurality of data sheet files, improves the integration efficiency, avoids errors caused by manual integration, and ensures the accuracy of integration.
In one embodiment, as shown in fig. 7, the present application further provides a file integration method, which specifically includes:
s710, displaying a retrieval interface of a target retrieval tool; the search interface comprises a file import option, a file export option, a data table selection option, a search limit option, an input box and a search result display area;
s720, after triggering operation for a file importing option is detected, importing a plurality of files to be processed into a target retrieval tool according to the triggering operation, wherein the files to be processed comprise first data information;
s730, determining a target data table from a plurality of data tables included in each file to be processed according to a selection instruction of a user for a data table selection item;
S740, after detecting triggering operation of at least one retrieval limit option, acquiring retrieval limit conditions corresponding to the retrieval limit option, wherein the retrieval limit conditions comprise case limit conditions or accuracy limit conditions;
s750, searching the first data information in the target data table according to the search limiting conditions and the search keywords input in the input box to obtain second data information matched with the search keywords;
s760, displaying the second data information in the search result display area;
s770, receiving an information selection instruction of a user for the second data information based on the search result display area, and determining target data information in the second data information according to the information selection instruction;
s780, generating an integrated file according to header information and target data information set by a user;
s790, after detecting the triggering operation for the file export option, exporting the integrated file from the target retrieval tool.
The specific process of the file integration method can be found in the above related embodiments, and will not be described herein.
It should be understood that, although the steps in the flowcharts related to the embodiments described above are sequentially shown as indicated by arrows, these steps are not necessarily sequentially performed in the order indicated by the arrows. The steps are not strictly limited to the order of execution unless explicitly recited herein, and the steps may be executed in other orders. Moreover, at least some of the steps in the flowcharts described in the above embodiments may include a plurality of steps or a plurality of stages, which are not necessarily performed at the same time, but may be performed at different times, and the order of the steps or stages is not necessarily performed sequentially, but may be performed alternately or alternately with at least some of the other steps or stages.
Based on the same inventive concept, the embodiment of the application also provides a file integrating device for realizing the file integrating method. The implementation of the solution provided by the device is similar to the implementation described in the above method, so the specific limitation in one or more embodiments of the document integration device provided below may refer to the limitation of the document integration method hereinabove, and will not be repeated herein.
In one embodiment, as shown in fig. 8, there is provided a document integration apparatus, including: a function presentation module 801, a file import module 802, an information retrieval module 803, and an information integration module 804, wherein:
the function display module 801 is used for displaying a search interface of the target search tool, wherein the search interface comprises a file import option and an input box;
the file importing module 802 is configured to import a plurality of files to be processed into the target retrieval tool according to the triggering operation after detecting the triggering operation for the file importing option, where the files to be processed include the first data information;
the information retrieval module 803 is configured to retrieve the first data information in each file to be processed according to the retrieval keyword input in the input box, so as to obtain second data information matched with the retrieval keyword;
The information integration module 804 is configured to generate an integration file according to the second data information.
In one embodiment, the integration file is a data table file, and the information integration module 804 is specifically configured to:
receiving header information set by a user; and generating an integrated file according to the header information and the second data information.
In one embodiment, the search interface includes a search result display area, and the information integration module 804 is specifically configured to:
displaying the second data information in the search result display area; receiving an information selection instruction of a user aiming at the second data information based on the search result display area, and determining target data information in the second data information according to the information selection instruction; and generating an integrated file according to the header information and the target data information.
In one embodiment, the search interface further includes a file export option, and the apparatus further includes: and the file export module is used for exporting the integrated file from the target retrieval tool after detecting the triggering operation for the file export option.
In one embodiment, the search interface further comprises at least one search restriction option, and the information search module 803 is further configured to:
after detecting triggering operation of at least one retrieval limiting option, acquiring a retrieval limiting condition corresponding to the retrieval limiting option, wherein the retrieval limiting condition comprises a case limiting condition or an accuracy limiting condition; and searching the first data information in each file to be processed according to the search limiting conditions and the search keywords.
In one embodiment, the file to be processed is a data table file, the first data information is data in a data row, a data column or a data table cell, and the second data information is data in a data row, a data column or a data table cell.
In one embodiment, the file to be processed includes a plurality of data tables, the search interface further includes a data table selection item, and the information search module 803 is further configured to:
determining a target data table in a plurality of data tables included in each file to be processed according to a selection instruction of a user for the data table selection item; and searching the first data information in the target data table in each file to be processed according to the search keywords.
The modules in the file integrating device may be implemented in whole or in part by software, hardware, or a combination thereof. The above modules may be embedded in hardware or may be independent of a processor in the computer device, or may be stored in software in a memory in the computer device, so that the processor may call and execute operations corresponding to the above modules.
In one embodiment, a computer device is provided, which may be a terminal, and the internal structure thereof may be as shown in fig. 9. The computer device includes a processor, a memory, a communication interface, a display screen, and an input device connected by a system bus. Wherein the processor of the computer device is configured to provide computing and control capabilities. The memory of the computer device includes a non-volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system and a computer program. The internal memory provides an environment for the operation of the operating system and computer programs in the non-volatile storage media. The communication interface of the computer device is used for carrying out wired or wireless communication with an external terminal, and the wireless mode can be realized through WIFI, a mobile cellular network, NFC (near field communication) or other technologies. The computer program is executed by a processor to implement a file integration method. The display screen of the computer equipment can be a liquid crystal display screen or an electronic ink display screen, and the input device of the computer equipment can be a touch layer covered on the display screen, can also be keys, a track ball or a touch pad arranged on the shell of the computer equipment, and can also be an external keyboard, a touch pad or a mouse and the like.
It will be appreciated by those skilled in the art that the structure shown in fig. 9 is merely a block diagram of a portion of the structure associated with the present application and is not limiting of the computer device to which the present application applies, and that a particular computer device may include more or fewer components than shown, or may combine some of the components, or have a different arrangement of components.
In one embodiment, a computer device is provided comprising a memory and a processor, the memory having stored therein a computer program, the processor when executing the computer program performing the steps of:
displaying a retrieval interface of a target retrieval tool, wherein the retrieval interface comprises a file importing option and an input box; after triggering operation for a file importing option is detected, importing a plurality of files to be processed into a target retrieval tool according to the triggering operation, wherein the files to be processed comprise first data information; searching the first data information in each file to be processed according to the search keywords input in the input box to obtain second data information matched with the search keywords; and generating an integrated file according to the second data information.
In one embodiment, the integrated file is a data table file, and the processor when executing the computer program further performs the following steps:
Receiving header information set by a user; and generating an integrated file according to the header information and the second data information.
In one embodiment, the search interface includes a search result presentation area, and the processor when executing the computer program further performs the steps of:
displaying the second data information in the search result display area; receiving an information selection instruction of a user aiming at the second data information based on the search result display area, and determining target data information in the second data information according to the information selection instruction; and generating an integrated file according to the header information and the target data information.
In one embodiment, the search interface further includes a file export option, and the processor when executing the computer program further performs the steps of:
after detecting a triggering operation for the file export option, the integrated file is exported from the target retrieval tool.
In one embodiment, the search interface further comprises at least one search restriction option, and the processor when executing the computer program further performs the steps of:
after detecting triggering operation of at least one retrieval limiting option, acquiring a retrieval limiting condition corresponding to the retrieval limiting option, wherein the retrieval limiting condition comprises a case limiting condition or an accuracy limiting condition; and searching the first data information in each file to be processed according to the search limiting conditions and the search keywords.
In one embodiment, the file to be processed is a data table file, the first data information is data in a data row, a data column or a data table cell, and the second data information is data in a data row, a data column or a data table cell.
In one embodiment, the file to be processed includes a plurality of data tables, the search interface further includes data table selection items, and the processor when executing the computer program further implements the steps of:
determining a target data table in a plurality of data tables included in each file to be processed according to a selection instruction of a user for the data table selection item; and searching the first data information in the target data table in each file to be processed according to the search keywords.
In one embodiment, a computer readable storage medium is provided having a computer program stored thereon, which when executed by a processor, performs the steps of:
displaying a retrieval interface of a target retrieval tool, wherein the retrieval interface comprises a file importing option and an input box; after triggering operation for a file importing option is detected, importing a plurality of files to be processed into a target retrieval tool according to the triggering operation, wherein the files to be processed comprise first data information; searching the first data information in each file to be processed according to the search keywords input in the input box to obtain second data information matched with the search keywords; and generating an integrated file according to the second data information.
In one embodiment, the integration file is a data table file, and the computer program when executed by the processor further performs the steps of:
receiving header information set by a user; and generating an integrated file according to the header information and the second data information.
In one embodiment, the search interface includes a search result presentation area, and the computer program when executed by the processor further performs the steps of:
displaying the second data information in the search result display area; receiving an information selection instruction of a user aiming at the second data information based on the search result display area, and determining target data information in the second data information according to the information selection instruction; and generating an integrated file according to the header information and the target data information.
In one embodiment, the search interface further includes a file export option, and the computer program when executed by the processor further performs the steps of:
after detecting a triggering operation for the file export option, the integrated file is exported from the target retrieval tool.
In one embodiment, the search interface further comprises at least one search restriction option, the computer program when executed by the processor further implementing the steps of:
After detecting triggering operation of at least one retrieval limiting option, acquiring a retrieval limiting condition corresponding to the retrieval limiting option, wherein the retrieval limiting condition comprises a case limiting condition or an accuracy limiting condition; and searching the first data information in each file to be processed according to the search limiting conditions and the search keywords.
In one embodiment, the file to be processed is a data table file, the first data information is data in a data row, a data column or a data table cell, and the second data information is data in a data row, a data column or a data table cell.
In one embodiment, the file to be processed comprises a plurality of data tables, the search interface further comprises data table selection items, and the computer program when executed by the processor further performs the steps of:
determining a target data table in a plurality of data tables included in each file to be processed according to a selection instruction of a user for the data table selection item; and searching the first data information in the target data table in each file to be processed according to the search keywords.
In one embodiment, a computer program product is provided comprising a computer program which, when executed by a processor, performs the steps of:
Displaying a retrieval interface of a target retrieval tool, wherein the retrieval interface comprises a file importing option and an input box; after triggering operation for a file importing option is detected, importing a plurality of files to be processed into a target retrieval tool according to the triggering operation, wherein the files to be processed comprise first data information; searching the first data information in each file to be processed according to the search keywords input in the input box to obtain second data information matched with the search keywords; and generating an integrated file according to the second data information.
In one embodiment, the integration file is a data table file, and the computer program when executed by the processor further performs the steps of:
receiving header information set by a user; and generating an integrated file according to the header information and the second data information.
In one embodiment, the search interface includes a search result presentation area, and the computer program when executed by the processor further performs the steps of:
displaying the second data information in the search result display area; receiving an information selection instruction of a user aiming at the second data information based on the search result display area, and determining target data information in the second data information according to the information selection instruction; and generating an integrated file according to the header information and the target data information.
In one embodiment, the search interface further includes a file export option, and the computer program when executed by the processor further performs the steps of:
after detecting a triggering operation for the file export option, the integrated file is exported from the target retrieval tool.
In one embodiment, the search interface further comprises at least one search restriction option, the computer program when executed by the processor further implementing the steps of:
after detecting triggering operation of at least one retrieval limiting option, acquiring a retrieval limiting condition corresponding to the retrieval limiting option, wherein the retrieval limiting condition comprises a case limiting condition or an accuracy limiting condition; and searching the first data information in each file to be processed according to the search limiting conditions and the search keywords.
In one embodiment, the file to be processed is a data table file, the first data information is data in a data row, a data column or a data table cell, and the second data information is data in a data row, a data column or a data table cell.
In one embodiment, the file to be processed comprises a plurality of data tables, the search interface further comprises data table selection items, and the computer program when executed by the processor further performs the steps of:
Determining a target data table in a plurality of data tables included in each file to be processed according to a selection instruction of a user for the data table selection item; and searching the first data information in the target data table in each file to be processed according to the search keywords.
Those skilled in the art will appreciate that implementing all or part of the above described methods may be accomplished by way of a computer program stored on a non-transitory computer readable storage medium, which when executed, may comprise the steps of the embodiments of the methods described above. Any reference to memory, database, or other medium used in the various embodiments provided herein may include at least one of non-volatile and volatile memory. The nonvolatile Memory may include Read-Only Memory (ROM), magnetic tape, floppy disk, flash Memory, optical Memory, high density embedded nonvolatile Memory, resistive random access Memory (ReRAM), magnetic random access Memory (Magnetoresistive Random Access Memory, MRAM), ferroelectric Memory (Ferroelectric Random Access Memory, FRAM), phase change Memory (Phase Change Memory, PCM), graphene Memory, and the like. Volatile memory can include random access memory (Random Access Memory, RAM) or external cache memory, and the like. By way of illustration, and not limitation, RAM can be in the form of a variety of forms, such as static random access memory (Static Random Access Memory, SRAM) or dynamic random access memory (Dynamic Random Access Memory, DRAM), and the like. The databases referred to in the various embodiments provided herein may include at least one of relational databases and non-relational databases. The non-relational database may include, but is not limited to, a blockchain-based distributed database, and the like. The processors referred to in the embodiments provided herein may be general purpose processors, central processing units, graphics processors, digital signal processors, programmable logic units, quantum computing-based data processing logic units, etc., without being limited thereto.
The technical features of the above embodiments may be arbitrarily combined, and all possible combinations of the technical features in the above embodiments are not described for brevity of description, however, as long as there is no contradiction between the combinations of the technical features, they should be considered as the scope of the description.
The above examples only represent a few embodiments of the present application, which are described in more detail and are not to be construed as limiting the scope of the present application. It should be noted that it would be apparent to those skilled in the art that various modifications and improvements could be made without departing from the spirit of the present application, which would be within the scope of the present application. Accordingly, the scope of protection of the present application shall be subject to the appended claims.
Claims (10)
1. A method of document integration, the method comprising:
displaying a retrieval interface of a target retrieval tool, wherein the retrieval interface comprises a file import option and an input box;
after triggering operation for the file import option is detected, importing a plurality of files to be processed into the target retrieval tool according to the triggering operation, wherein the files to be processed comprise first data information;
Searching the first data information in each file to be processed according to the search keywords input in the input box to obtain second data information matched with the search keywords;
and generating an integrated file according to the second data information.
2. The method of claim 1, wherein the integrated file is a data table file, and the generating the integrated file according to the second data information includes:
receiving header information set by a user;
and generating the integrated file according to the header information and the second data information.
3. The method of claim 2, wherein the search interface includes a search result presentation area, and wherein the generating the integrated file according to the header information and the second data information includes:
displaying the second data information in the search result display area;
receiving an information selection instruction of a user for the second data information based on the search result display area, and determining target data information in the second data information according to the information selection instruction;
and generating the integration file according to the header information and the target data information.
4. A method according to any one of claims 1 to 3, wherein the search interface further comprises a file export option, the method further comprising:
and after detecting the triggering operation of the file export option, exporting the integrated file from the target retrieval tool.
5. A method according to any one of claims 1 to 3, wherein the search interface further comprises at least one search restriction option, and the searching the first data information in each of the files to be processed according to the search keyword input in the input box comprises:
after detecting triggering operation of at least one search restriction option, acquiring a search restriction condition corresponding to the search restriction option, wherein the search restriction condition comprises a case restriction condition or an accuracy restriction condition;
and searching the first data information in each file to be processed according to the search limiting conditions and the search keywords.
6. A method according to any one of claims 1 to 3, wherein the files to be processed include a plurality of data tables, the search interface further includes a data table selection item, and the searching the first data information in each of the files to be processed according to the search keyword input in the input box includes:
Determining a target data table in a plurality of data tables included in each file to be processed according to a selection instruction of a user for the data table selection item;
and searching the first data information in the target data table in each file to be processed according to the search keyword.
7. A document integration apparatus, the apparatus comprising:
the function display module is used for displaying a search interface of the target search tool, wherein the search interface comprises file import options and an input box;
the file importing module is used for importing a plurality of files to be processed into the target retrieval tool according to the triggering operation after the triggering operation for the file importing option is detected, wherein the files to be processed comprise first data information;
the information retrieval module is used for retrieving the first data information in each file to be processed according to the retrieval keywords input in the input box to obtain second data information matched with the retrieval keywords;
and the information integration module is used for generating an integration file according to the second data information.
8. A computer device comprising a memory and a processor, the memory storing a computer program, characterized in that the processor implements the steps of the method of any of claims 1 to 6 when the computer program is executed.
9. A computer readable storage medium, on which a computer program is stored, characterized in that the computer program, when being executed by a processor, implements the steps of the method of any of claims 1 to 6.
10. A computer program product comprising a computer program, characterized in that the computer program, when being executed by a processor, implements the steps of the method of any of claims 1 to 6.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111644849.9A CN116414778A (en) | 2021-12-29 | 2021-12-29 | File integration method, apparatus, computer device, storage medium and program product |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111644849.9A CN116414778A (en) | 2021-12-29 | 2021-12-29 | File integration method, apparatus, computer device, storage medium and program product |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN116414778A true CN116414778A (en) | 2023-07-11 |
Family
ID=87058128
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202111644849.9A Pending CN116414778A (en) | 2021-12-29 | 2021-12-29 | File integration method, apparatus, computer device, storage medium and program product |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN116414778A (en) |
-
2021
- 2021-12-29 CN CN202111644849.9A patent/CN116414778A/en active Pending
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11328004B2 (en) | Method and system for intelligently suggesting tags for documents | |
| AU2019202554B2 (en) | Context-aware field value suggestions | |
| AU2016225947B2 (en) | System and method for multimedia document summarization | |
| US20100277424A1 (en) | Electronic device and method for predicting word input | |
| CN105493075A (en) | Retrieval of attribute values based upon identified entities | |
| CN112988980B (en) | Target product query method and device, computer equipment and storage medium | |
| US20120221594A1 (en) | Electronic device and method of displaying design patents | |
| KR20130086621A (en) | System and method for recording and querying original handwriting and electronic device | |
| US20240054284A1 (en) | Spreadsheet table transformation | |
| CN113312265A (en) | Application method of test case and related product | |
| US20210406268A1 (en) | Search result annotations | |
| CN115730596A (en) | Object recommendation method and device and computer equipment | |
| WO2016018682A1 (en) | Processing image to identify object for insertion into document | |
| Lu et al. | Browse-to-search: Interactive exploratory search with visual entities | |
| JP2022530725A (en) | Information push methods, devices, equipment and storage media | |
| TW201523305A (en) | Search system, search criteria setting device, control method for search criteria setting device, program, and information storage medium | |
| KR101934240B1 (en) | Method of displaying a keyword and apparatus thereof | |
| CN116414778A (en) | File integration method, apparatus, computer device, storage medium and program product | |
| CN112329409A (en) | Cell color conversion method and device and electronic equipment | |
| CN114782125A (en) | Product configuration method, device, computer equipment and storage medium | |
| CN111209312B (en) | Page data processing method, device, computer equipment and storage medium | |
| CN113220194A (en) | Information display method and information display device | |
| US20160148095A1 (en) | Electronic calculating apparatus, method thereof and non-transitory machine-readable medium thereof for sensing context and recommending information | |
| CN116700725B (en) | Page generation method, page generation device, computer equipment and storage medium | |
| CN116702024B (en) | Method, device, computer equipment and storage medium for identifying type of stream data |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |