Batch processing method and system for multiple tabs

Abstract

The present invention discloses a batch processing method and system for multiple tabs, the method comprising the following steps: S1: according to the contract price list import instruction, determine and display at least one contract price list with multiple tabs to be imported; S2: according to the change instruction of the header under a tab in the contract price list, match the header under the tab; S3: according to the batch processing instruction, apply the matched header to other tabs in the contract price list to unify the headers of multiple tabs in the contract price list. By implementing the present invention, batch processing of multi-source, non-standard, and complex EXCEL data is performed and converted into usable data with preset specifications, which greatly facilitates subsequent data processing.

Description

Technical Field

[0001] The present invention relates to the technical field of nuclear power plant project pricing, and in particular to a multi-tab batch processing method and system. Background Art

[0002] A nuclear power project includes multiple contracts, and one contract includes multiple unit projects (such as a building). Each contract corresponds to a complete set of multi-tab EXCEL tables (contract price lists). Each contract price list has different tabs, and each tab corresponds to a unit project. In each tab, the header of the table column data is also different. When importing a multi-tab EXCEL table using the conventional method, you need to select each tab first, and then match the header of the tab data table one by one. After that, the table can be imported in a fixed format. This method is cumbersome and time-consuming. Summary of the invention

[0003] The technical problem to be solved by the present invention is to provide a batch processing method and system for multiple tabs in view of at least one defect in the prior art.

[0004] The technical solution adopted by the present invention to solve the technical problem is: constructing a batch processing method for multiple tabs, comprising the following steps:

[0005] S1: According to the contract price list import instruction, at least one contract price list with multiple tabs to be imported is determined and displayed;

[0006] S2: According to the modification instruction of the table header under a page tab in the contract price table, the table header under the page tab is matched;

[0007] S3: According to the batch processing instruction, the matched table header is applied to other tabs of the contract price table to unify the table headers of multiple tabs in the contract price table.

[0008] Preferably, in the batch processing method for multiple tabs of the present invention, step S2 comprises:

[0009] S21: receiving a user's selection of an attribute column to be matched in the table header under the tab, and displaying the names of the attribute columns that can be matched through a drop-down menu;

[0010] S22: modifying the attribute column name to be matched to the attribute column name selected by the user in the drop-down menu;

[0011] S23: Repeat steps S21 and S22 to complete the matching of the table headers under a page in the contract price table.

[0012] Preferably, in the batch processing method for multiple tabs of the present invention, step S3 comprises:

[0013] S31: Record the identification rule of the currently matched header according to the batch processing instruction;

[0014] S32: Apply the identification rule to the headers of other tabs in the contract price list to unify the headers of other tabs in the contract price list.

[0015] Preferably, in the batch processing method for multiple tabs of the present invention, the identification rule is the attribute column name identified according to the attribute column order of the table header;

[0016] The step S32 comprises:

[0017] Apply the attribute column names identified according to the attribute column order of the table header to the table headers of other tabs of the contract price table to unify the table headers of other tabs of the contract price table;

[0018] Alternatively, the attribute column names identified according to the attribute column order of the table header are compared with the attribute column names of the table headers of other tabs in the contract price table. If they are inconsistent, the attribute column names of the table headers of other tabs in the contract price table are modified to the identified attribute column names to unify the table headers in other tabs in the contract price table.

[0019] Preferably, in the batch processing method of multiple tabs of the present invention, the tabs include unit engineering codes and names;

[0020] The method further comprises:

[0021] S4: according to the data import instruction, obtain the unit engineering code of each page of the unified contract price list;

[0022] S5: According to the unit project code, the table data under the page tab is stored in the corresponding unit project database.

[0023] The present invention also constructs a multi-tab batch processing system, including:

[0024] An import module, used to determine and display at least one contract price list with multiple tabs to be imported according to a contract price list import instruction;

[0025] A matching module, used for matching a header under a tab page in the contract price table according to a change instruction of the header under the tab page;

[0026] The batch processing module is used to apply the matched table headers to other tabs of the contract price table according to the batch processing instructions to unify the table headers of multiple tabs in the contract price table.

[0027] Preferably, in the multi-tab batch processing system of the present invention, the matching module includes:

[0028] A selection module is used to receive a user's selection of an attribute column to be matched in the table header under the tab, and display the names of the attribute columns that can be matched through a drop-down menu;

[0029] The modification module is used to modify the attribute column name that needs to be matched to the attribute column name selected by the user in the drop-down menu.

[0030] Preferably, in the multi-tab batch processing system of the present invention, the batch processing module includes:

[0031] The recording module is used to record the identification rules of the currently matched header according to the batch processing instructions;

[0032] The application module is used to apply the identification rule to the headers of other tabs in the contract price list to unify the headers in other tabs in the contract price list.

[0033] Preferably, in the multi-tab batch processing system of the present invention, the identification rule is the attribute column name identified according to the attribute column order of the table header;

[0034] The step of applying the identification rule to the headers of other tabs of the contract price table to unify the headers of other tabs of the contract price table includes:

[0035] Apply the attribute column names identified according to the attribute column order of the table header to the table headers of other tabs of the contract price table to unify the table headers of other tabs of the contract price table;

[0036] Alternatively, the attribute column names identified according to the attribute column order of the table header are compared with the attribute column names of the table headers of other tabs in the contract price table. If they are inconsistent, the attribute column names of the table headers of other tabs in the contract price table are modified to the identified attribute column names to unify the table headers in other tabs in the contract price table.

[0037] Preferably, in the multi-tab batch processing system of the present invention, the tab includes a unit engineering code and name;

[0038] The system further comprises:

[0039] The storage module is used to obtain the unit engineering code of each tab in the unified contract price list according to the data import instruction, and store the table data under the tab into the corresponding unit engineering database according to the unit engineering code.

[0040] By implementing the present invention, the following beneficial effects are achieved:

[0041] The present invention determines and displays at least one contract price list with multiple tabs to be imported according to the contract price list import instruction; matches the header under a tab according to the change instruction of the header under the tab in the contract price list; applies the matched header to other tabs in the contract price list according to the batch processing instruction to unify the headers of multiple tabs in the contract price list, thereby batch processing multi-source, non-standard and complex EXCEL data and converting them into usable data with preset specifications, which greatly facilitates subsequent data processing. BRIEF DESCRIPTION OF THE DRAWINGS

[0042] The present invention will be further described below with reference to the accompanying drawings and embodiments, in which:

[0043] Figure 1 This is a schematic diagram of the batch processing method of multiple tabs of the present invention. Figure 1 ;

[0044] Figure 2 This is a schematic diagram of the batch processing method of multiple tabs of the present invention. Figure 2 ;

[0045] Figure 3 This is a schematic diagram of the contract price list of the present invention in the user interface Figure 1 ;

[0046] Figure 4 This is a schematic diagram of the contract price list of the present invention in the user interface Figure 2 ;

[0047] Figure 5 It is a module schematic diagram of the batch processing system of multiple tabs of the present invention. DETAILED DESCRIPTION

[0048] In order to have a clearer understanding of the technical features, purposes and effects of the present invention, specific embodiments of the present invention are now described in detail with reference to the accompanying drawings.

[0049] It should be noted that the flowcharts shown in the accompanying drawings are only exemplary and do not necessarily include all the contents and operations / steps, nor do they have to be executed in the order described. For example, some operations / steps can be decomposed, while some operations / steps can be combined or partially combined, so the actual execution order may change according to actual conditions.

[0050] The block diagrams shown in the accompanying drawings are merely functional entities and do not necessarily correspond to physically independent entities. That is, these functional entities may be implemented in software form, or in one or more hardware modules or integrated circuits, or in different networks and / or processor devices and / or microcontroller devices.

[0051] like Figure 1As shown, the present invention discloses a batch processing method for multiple tabs, comprising the following steps:

[0052] Step S1: According to the contract price list import instruction, at least one contract price list with multiple tabs to be imported is determined and displayed.

[0053] Specifically, there is an operation button for batch importing the contract price list of the project on the software interface. When the import instruction is received, a set of contract price lists to be imported can be identified and entered into the operation interface. The user can select a single or multiple contract price lists to be imported. After selection, the software interface will display the imported contract price lists. The contract price list includes multiple tabs, each of which has a corresponding EXCEL table. Each tab includes a unit engineering code and name, such as Figure 3 and 4 As mentioned above, "1BAX" and "1BDA BDU" are unit project codes, and "entering and exiting the factory building" and "emergency diesel generator building A / SB0 diesel generator building A" are unit project names.

[0054] Step S2: According to the modification instruction of the table header under a tab in the contract price table, the table header under the tab is matched;

[0055] Further, the step S2 includes:

[0056] Step S21: receiving the user's selection of the attribute column to be matched in the table header under the page tab, and displaying the names of the attribute columns that can be matched through a drop-down menu;

[0057] Step S22: modify the attribute column name to be matched to the attribute column name selected by the user in the drop-down menu;

[0058] Step S23: Repeat steps S21 and S22 to complete the matching of the table headers under a page in the contract price table.

[0059] Specifically, since the table header in the Excel spreadsheet under the tab may not conform to the specification, the user needs to click each attribute column to modify it. Figure 3 In the table, when the user needs to modify the name of the attribute column behind the "Code" column, the user can click on the attribute column. The candidate names in the drop-down menu include "Code", "Name", "Project Quantity"... "Remarks", etc. The options marked with "√" have been used in the table. The user can click on the option to be selected to modify the attribute column. For example, if the user clicks on "Total Price", the attribute column will be modified to "Total Price". Similarly, the table header in the table can meet the preset specifications.

[0060] Step S3: According to the batch processing instruction, the matched table header is applied to other tabs of the contract price table to unify the table headers of multiple tabs in the contract price table.

[0061] Further, step S3 includes:

[0062] Step S31: Record the identification rule of the currently matched header according to the batch processing instruction;

[0063] Step S32: Apply the identification rule to the headers of other tabs in the contract price table to unify the headers of other tabs in the contract price table.

[0064] In some embodiments, the identification rule is the attribute column name identified according to the attribute column order of the table header; accordingly, step S32 includes:

[0065] Apply the attribute column names identified according to the attribute column order of the table header to the table headers of other tabs of the contract price table to unify the table headers of other tabs of the contract price table;

[0066] Alternatively, compare the attribute column names identified according to the attribute column order of the table header with the attribute column names of the table headers of other tabs in the contract price table. If they are inconsistent, modify the attribute column names of the table headers of other tabs in the contract price table to the identified attribute column names to unify the table headers in other tabs in the contract price table; if they are consistent, skip them.

[0067] Specifically, there are many contract price tables to be imported. If the table headers are matched one by one, the efficiency is very low. The user interface displays a control called "Apply the current tab header to all tabs". After the user clicks it, the matched table header can be applied to other tabs of the contract price table. This operation can be applied to all tabs, or you can choose to specify the tabs to apply, not all tabs.

[0068] In this implementation, the tab includes the unit project code and name, such as Figure 2 As shown, the method also includes:

[0069] Step S4: according to the data import instruction, obtain the unit engineering code of each page in the unified contract price list;

[0070] Step S5: According to the unit project code, the table data under the page tab is stored in the corresponding unit project database.

[0071] Specifically, the codes for the unit projects of nuclear power projects are unified. The EXCEL table data (contract price data) under all tabs of this plan are indexed by the code and then stored in the corresponding unit project name database. In this way, an association between the unit project and the contract price data is established, which can be used for the subsequent calculation of the unit project price.

[0072] When importing the contract price list, you can import all the data corresponding to all attribute columns, or you can import part of it to reduce redundant data. That is, the data import instruction is an instruction to import the data corresponding to all attribute columns or an instruction to import the data corresponding to some attribute columns. For example, the data corresponding to the attribute column with an identifier ("Remarks") set by default is not imported. After the data is imported, there is no Remarks column in the data table. The attribute column can also correspond to a selection control that displays "Whether to Import". If the user clicks the "Import" option of the control, it means that the data corresponding to the attribute column needs to be imported. Otherwise, it means that the data in this column does not need to be imported.

[0073] like Figure 5 As shown, the present invention discloses a multi-tab batch processing system, including an import module, a matching module and a batch processing module.

[0074] The import module is used to determine and display at least one contract price list with multiple tabs to be imported according to the contract price list import instruction.

[0075] Specifically, there is an operation button for batch importing the contract price list of the project on the software interface. When the import instruction is received, a set of contract price lists to be imported can be identified and entered into the operation interface. The user can select a single or multiple contract price lists to be imported. After selection, the software interface will display the imported contract price lists. The contract price list includes multiple tabs, each of which has a corresponding EXCEL table. Each tab includes a unit engineering code and name, such as Figure 3 and 4 As mentioned above, "1BAX" and "1BDA BDU" are unit project codes, and "entering and exiting the factory building" and "emergency diesel generator building A / SB0 diesel generator building A" are unit project names.

[0076] The matching module is used to match the header under a page tab in the contract price table according to the change instruction of the header under the page tab;

[0077] Furthermore, the matching module includes:

[0078] The selection module is used to receive the user's selection of the attribute column that needs to be matched in the table header under the tab, and display the names of the attribute columns that can be matched through a drop-down menu;

[0079] Modification module, used to modify the names of the attribute columns to be matched to the attribute column names selected by the user in the drop-down menu.

[0080] Specifically, since the table headers in the EXCEL table under the page tab may not meet the specifications, the user needs to click on each attribute column to make modifications. For example Figure 3 In [example], when the user needs to modify the name of the attribute column in the column immediately following the "Code" column, the user can click on the position of this attribute column. The candidate names in the drop-down menu include "Code", "Name", "Engineering Quantity"... "Remarks", etc. Among them, the options marked with "√" indicate that they have been used in this table. The user can click on the option to be selected to correct this attribute column. For example, if the user clicks on "Total Price", then this attribute column is corrected to "Total Price", and so on, so that the table headers in the table meet the preset specifications.

[0081] Batch processing module, used to apply the matched table headers to other page tabs of the contract price table according to the batch processing instruction, in order to unify the table headers of multiple page tabs in the contract price table.

[0082] Furthermore, this batch processing module includes:

[0083] Recording module, used to record the recognition rules of the currently matched table headers according to the batch processing instruction;

[0084] Application module, used to apply the recognition rules to the table headers of other page tabs of the contract price table, in order to unify the table headers in other page tabs of the contract price table.

[0085] In some embodiments, the recognition rule is the attribute column names recognized in the order of the attribute columns of the table header;

[0086] Correspondingly, applying the recognition rules to the table headers of other page tabs of the contract price table to unify the table headers in other page tabs of the contract price table includes:

[0087] Applying the attribute column names recognized in the order of the attribute columns of the table header to the table headers of other page tabs of the contract price table to unify the table headers in other page tabs of the contract price table;

[0088] Or, comparing the attribute column names recognized in the order of the attribute columns of the table header with the attribute column names of the table headers in other page tabs of the contract price table. If they are inconsistent, then modify the attribute column names of the table headers in other page tabs of the contract price table to the recognized attribute column names to unify the table headers in other page tabs of the contract price table.

[0089] Specifically, there are many contract price tables to be imported. If the table headers are matched one by one, the efficiency is very low. The user interface displays a control called "Apply the current tab header to all tabs". After the user clicks it, the matched table header can be applied to other tabs of the contract price table. This operation can be applied to all tabs, or you can choose to specify the tabs to apply, not all tabs.

[0090] In this embodiment, the tab includes the unit project code and name, and the system also includes:

[0091] The storage module is used to obtain the unit engineering code of each tab in the unified contract price list according to the data import instruction, and store the table data under the tab in the corresponding unit engineering database according to the unit engineering code.

[0092] Specifically, the codes for the unit projects of nuclear power projects are unified. The EXCEL table data (contract price data) under all tabs of this plan are indexed by the code and then stored in the corresponding unit project name database. In this way, an association between the unit project and the contract price data is established, which can be used for the subsequent calculation of the unit project price.

[0093] When importing the contract price list, you can import all the data corresponding to all attribute columns, or you can import part of it to reduce redundant data. That is, the data import instruction is an instruction to import the data corresponding to all attribute columns or an instruction to import the data corresponding to some attribute columns. For example, the data corresponding to the attribute column with an identifier ("Remarks") set by default is not imported. After the data is imported, there is no Remarks column in the data table. The attribute column can also correspond to a selection control that displays "Whether to Import". If the user clicks the "Import" option of the control, it means that the data corresponding to the attribute column needs to be imported. Otherwise, it means that the data in this column does not need to be imported.

[0094] By implementing the present invention, the following beneficial effects are achieved:

[0095] The present invention determines and displays at least one contract price list with multiple tabs to be imported according to the contract price list import instruction; matches the header under a tab according to the change instruction of the header under the tab in the contract price list; applies the matched header to other tabs in the contract price list according to the batch processing instruction to unify the headers of multiple tabs in the contract price list, thereby batch processing multi-source, non-standard and complex EXCEL data and converting them into usable data with preset specifications, which greatly facilitates subsequent data processing.

[0096] It can be understood that the above embodiments only express the preferred implementation modes of the present invention, and the descriptions thereof are relatively specific and detailed, but they cannot be understood as limiting the patent scope of the present invention. It should be pointed out that, for ordinary technicians in this field, the above technical features can be freely combined without departing from the concept of the present invention, and several deformations and improvements can be made, which all belong to the protection scope of the present invention. Therefore, all equivalent changes and modifications made to the scope of the claims of the present invention should belong to the coverage of the claims of the present invention.

Claims

1. A batch processing method for multiple tabs, It is characterized in that The following steps are involved: S1: According to the contract price list import instruction, at least one contract price list with multiple tabs to be imported is determined and displayed; S2: According to the modification instruction of the table header under a page tab in the contract price table, the table header under the page tab is matched; S3: According to the batch processing instruction, the matched table header is applied to other tabs of the contract price table to unify the table headers of multiple tabs in the contract price table; Wherein, the step S3 comprises: S31: Record the identification rule of the currently matched header according to the batch processing instruction; S32: applying the identification rule to the headers of other tabs in the contract price table to unify the headers of other tabs in the contract price table; The tab includes the unit project code and name; The method further comprises: S4: according to the data import instruction, obtain the unit engineering code of each page of the unified contract price list; S5: According to the unit project code, the table data under the page tab is stored in the corresponding unit project database.

2. The batch processing method for multiple tabs according to claim 1, It is characterized in that The step S2 comprises: S21: receiving a user's selection of an attribute column to be matched in the table header under the tab, and displaying the names of the attribute columns that can be matched through a drop-down menu; S22: modifying the attribute column name to be matched to the attribute column name selected by the user in the drop-down menu; S23: Repeat steps S21 and S22 to complete the matching of the table header under a page in the contract price table.

3. The batch processing method for multiple tabs according to claim 1, It is characterized in that The identification rule is the attribute column name identified according to the attribute column order of the table header; The step S32 comprises: Apply the attribute column names identified according to the attribute column order of the table header to the table headers of other tabs of the contract price table to unify the table headers of other tabs of the contract price table; Alternatively, the attribute column names identified according to the attribute column order of the table header are compared with the attribute column names of the table headers of other tabs in the contract price table. If they are inconsistent, the attribute column names of the table headers of other tabs in the contract price table are modified to the identified attribute column names to unify the table headers in other tabs in the contract price table.

4. A multi-tab batch processing system, It is characterized in that include: An import module, used to determine and display at least one contract price list with multiple tabs to be imported according to a contract price list import instruction; A matching module, used for matching a header under a tab page in the contract price table according to a change instruction of the header under the tab page; A batch processing module, used for applying the matched table headers to other tabs of the contract price table according to the batch processing instructions, so as to unify the table headers of multiple tabs in the contract price table; Wherein, the batch processing module includes: The recording module is used to record the identification rules of the currently matched header according to the batch processing instructions; An application module, used for applying the identification rule to the headers of other tabs in the contract price table to unify the headers in other tabs in the contract price table; The tab includes the unit project code and name; The system further comprises: The storage module is used to obtain the unit engineering code of each tab in the unified contract price list according to the data import instruction, and store the table data under the tab into the corresponding unit engineering database according to the unit engineering code.

5. The multi-tab batch processing system according to claim 4, It is characterized in that The matching module comprises: A selection module is used to receive a user's selection of an attribute column to be matched in the table header under the tab, and display the names of the attribute columns that can be matched through a drop-down menu; The modification module is used to modify the attribute column name that needs to be matched to the attribute column name selected by the user in the drop-down menu.

6. The multi-tab batch processing system according to claim 4, It is characterized in that The identification rule is the attribute column name identified according to the attribute column order of the table header; The step of applying the identification rule to the headers of other tabs of the contract price table to unify the headers of other tabs of the contract price table includes: Apply the attribute column names identified according to the attribute column order of the table header to the table headers of other tabs of the contract price table to unify the table headers of other tabs of the contract price table; Alternatively, the attribute column names identified according to the attribute column order of the table header are compared with the attribute column names of the table headers of other tabs in the contract price table. If they are inconsistent, the attribute column names of the table headers of other tabs in the contract price table are modified to the identified attribute column names to unify the table headers in other tabs in the contract price table.

Images