CN110969000A - Data merging processing method and device - Google Patents
Data merging processing method and device Download PDFInfo
- Publication number
- CN110969000A CN110969000A CN201811161949.4A CN201811161949A CN110969000A CN 110969000 A CN110969000 A CN 110969000A CN 201811161949 A CN201811161949 A CN 201811161949A CN 110969000 A CN110969000 A CN 110969000A
- Authority
- CN
- China
- Prior art keywords
- data
- merged
- merging
- cells
- cell
- 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.)
- Granted
Links
- 238000003672 processing method Methods 0.000 title claims abstract description 30
- 238000000034 method Methods 0.000 claims abstract description 26
- 238000012545 processing Methods 0.000 claims description 21
- 238000006243 chemical reaction Methods 0.000 claims description 4
- 238000007596 consolidation process Methods 0.000 claims description 3
- 238000005516 engineering process Methods 0.000 abstract description 9
- 238000010586 diagram Methods 0.000 description 9
- 230000000694 effects Effects 0.000 description 4
- 230000008878 coupling Effects 0.000 description 3
- 238000010168 coupling process Methods 0.000 description 3
- 238000005859 coupling reaction Methods 0.000 description 3
- 238000004422 calculation algorithm Methods 0.000 description 2
- 238000004364 calculation method Methods 0.000 description 2
- 238000004891 communication Methods 0.000 description 2
- 238000005034 decoration Methods 0.000 description 2
- 230000007547 defect Effects 0.000 description 2
- 230000006870 function Effects 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 238000004590 computer program Methods 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
Images
Abstract
The invention discloses a data merging processing method and device. Wherein, the method comprises the following steps: receiving a table merging request, wherein the table merging request carries data to be merged and field names of the data to be merged; converting the data to be merged into formatted data in a preset format; positioning the cells corresponding to the data to be merged according to the data to be merged and the field names, and merging the positioned cells to obtain merged cells; the formatted data is presented in a merge cell. The method and the device solve the technical problem that the merging operation efficiency of the table is low due to the fact that the process of merging the table is complex in the related technology.
Description
Technical Field
The invention relates to the technical field of data processing, in particular to a data merging processing method and device.
Background
Column-row combination is the basic operation of the table, but when the tables are combined, the requirements are different, so that the uniform data mode cannot be exported to the required table format, in the prior art, generally, only the mode of manually making a < table > tag can be adopted, or the column-row coordinates (such as element-ui) needing to be combined are provided by using a calculation mode. However, the prior art schemes require a large amount of data, and the whole processing procedure is also very complicated. For example, to merge the values 1 and 6 in table 1, coordinate values like (a, 1) and (a, 2) need to be provided to let the computation template know which values need to be merged, but this is not problematic in case of small data size, and if the data size is large, the process is very complicated.
TABLE 1
TABLE 2
In addition, the existing component cannot satisfy the requirement of separately acquiring single data after merging, for example, clicking the F-1 (i.e., column F, row 1) cell "operation" in table 2, the data that the user wants to acquire should be: 6-1, 2,3,4,5, while the architecture of the existing components does not support acquisition that can only acquire a full set of data, such as: 6-1, 2,3,4,5,7,8,9, 10, which cannot satisfy the user's operation on a single line of data, and also affects the merging effect.
Aiming at the problem that the table merging operation efficiency is low due to the fact that the table merging process in the related technology is complex, an effective solution is not provided at present.
Disclosure of Invention
The embodiment of the invention provides a data merging processing method and device, which are used for at least solving the technical problem of low table merging operation efficiency caused by a complex table merging process in the related technology.
According to an aspect of the embodiments of the present invention, there is provided a data merging processing method, including: receiving a table merging request, wherein the table merging request carries data to be merged and a field name of the data to be merged; converting the data to be merged into formatted data in a preset format; positioning the cells corresponding to the data to be merged according to the data to be merged and the field names, and merging the positioned cells to obtain merged cells; displaying the formatted data in the merge cell.
Optionally, before the cell corresponding to the data to be merged is located according to the data to be merged and the field name, the processing method for merging the data further includes: identifying a data structure of a table where the data to be merged are located; the data structure for identifying the table where the data to be merged is located comprises the following steps: identifying all fields of the table where the data to be merged are located; and traversing the table on the basis of a predetermined path corresponding to each field in all the fields, and identifying the data structure of the table in which the data to be merged is located.
Optionally, traversing the table based on the predetermined path corresponding to each of the all fields includes: judging whether all the fields have fields with operable attributes to obtain a judgment result; and adding an operation attribute to the cell corresponding to the field with the attribute being operable when the judgment result shows that the field with the attribute being operable exists in all the fields.
Optionally, the positioning the cell corresponding to the data to be merged according to the data to be merged and the field name includes: determining a traversal path corresponding to the field name, wherein the traversal path is a path along a non-field direction of the table; traversing by taking each data in the data to be merged as a clue in sequence along the traversal path to obtain coordinates of the data to be merged; and positioning the cell of each data to be merged in the data to be merged according to the coordinate of the data to be merged.
Optionally, before merging the located cells, the processing method for merging data further includes: judging whether the cell corresponding to the data to be merged is an adjacent cell or not according to the coordinate of the data to be merged; and merging the positioned cells under the condition that the cell corresponding to the data to be merged is the adjacent cell according to the judgment result.
Optionally, merging the located cells to obtain a merged cell includes: deleting the data in the cells of the data to be merged to obtain a plurality of empty cells; and merging the empty cells to obtain merged cells.
According to another aspect of the embodiments of the present invention, there is provided a data merging processing apparatus, including: the device comprises a receiving unit, a merging unit and a merging unit, wherein the receiving unit is used for receiving a table merging request, and the table merging request carries data to be merged and field names of the data to be merged; the conversion unit is used for converting the data to be merged into formatted data in a preset format; the merging unit is used for positioning the cells corresponding to the data to be merged according to the data to be merged and the field names and merging the positioned cells to obtain merged cells; and the display unit is used for displaying the formatted data in the merging cells.
Optionally, the processing apparatus for data merging further includes: the identification unit is used for identifying the data structure of the table where the data to be merged is located before the cell corresponding to the data to be merged is located according to the data to be merged and the field name; wherein the identification unit includes: the identification subunit is used for identifying all fields of the table where the data to be merged are located; and the first traversal subunit is used for traversing the table on the basis of the predetermined path corresponding to each field in all the fields, and identifying the data structure of the table in which the data to be merged is located.
Optionally, the first traversal subunit includes: the judging module is used for judging whether the fields with the operable attributes exist in all the fields to obtain a judging result; and the adding module is used for adding the operation attribute to the cell corresponding to the field with the attribute being operable under the condition that the judging result is that the field with the attribute being operable exists in all the fields.
Optionally, the merging unit includes: a determining subunit, configured to determine a traversal path corresponding to the field name, where the traversal path is a path along a non-field direction of the table; the second traversal subunit is configured to sequentially traverse the data to be merged along the traversal path by using each data in the data to be merged as a clue, so as to obtain coordinates of the data to be merged; and the positioning subunit is used for positioning the cell of each data to be merged in the data to be merged according to the coordinates of the data to be merged.
Optionally, the processing apparatus for data merging further includes: the judging subunit is used for judging whether the cell corresponding to the data to be merged is an adjacent cell or not according to the coordinate of the data to be merged before merging the positioned cells; and the merging subunit is used for merging the positioned cells under the condition that the judgment result shows that the cell corresponding to the data to be merged is the adjacent cell.
Optionally, the merging unit includes: a deleting subunit, configured to delete the data in the cell of the data to be merged to obtain a plurality of empty cells; and the obtaining subunit is used for merging the plurality of empty cells to obtain merged cells.
According to another aspect of the embodiment of the present invention, there is also provided a storage medium including a stored program, wherein the program is the data merging processing method described in any one of the above.
According to another aspect of the embodiment of the present invention, there is further provided a processor, wherein the processor is configured to execute a program, and the program executes to perform the processing method for merging data described in any one of the above.
In the embodiment of the invention, a table merging request is received, wherein the table merging request carries data to be merged and field names of the data to be merged; converting the data to be merged into formatted data in a preset format; positioning the cells corresponding to the data to be merged according to the data to be merged and the field names, and merging the positioned cells to obtain merged cells; the formatted data is presented in a merge cell. The data merging processing method provided by the embodiment of the invention can realize the purpose of executing merging of the data to be merged according to the data to be merged and the field names, achieves the technical effect of improving the efficiency of data merging, further solves the technical problem of lower efficiency of table merging operation caused by more complex process of merging the tables in the related technology, and improves the user experience.
Drawings
The accompanying drawings, which are included to provide a further understanding of the invention and are incorporated in and constitute a part of this application, illustrate embodiment(s) of the invention and together with the description serve to explain the invention without limiting the invention. In the drawings:
FIG. 1 is a flow diagram of a processing method of data consolidation according to an embodiment of the present invention;
FIG. 2 is a block diagram of a table structure according to an embodiment of the invention;
FIG. 3 is a block diagram of a processing method of data merging according to an embodiment of the present invention;
FIG. 4 is a schematic diagram of a processing method of data merging according to an embodiment of the invention; and
fig. 5 is a schematic diagram of a processing apparatus for data merging according to an embodiment of the present invention.
Detailed Description
In order to make the technical solutions of the present invention better understood, the technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
It should be noted that the terms "first," "second," and the like in the description and claims of the present invention and in the drawings described above are used for distinguishing between similar elements and not necessarily for describing a particular sequential or chronological order. It is to be understood that the data so used is interchangeable under appropriate circumstances such that the embodiments of the invention described herein are capable of operation in sequences other than those illustrated or described herein. Furthermore, the terms "comprises," "comprising," and "having," and any variations thereof, are intended to cover a non-exclusive inclusion, such that a process, method, system, article, or apparatus that comprises a list of steps or elements is not necessarily limited to those steps or elements expressly listed, but may include other steps or elements not expressly listed or inherent to such process, method, article, or apparatus.
Example 1
In accordance with an embodiment of the present invention, there is provided a method embodiment of a processing method for data consolidation, it is noted that the steps illustrated in the flowchart of the figure may be performed in a computer system such as a set of computer executable instructions, and that while a logical order is illustrated in the flowchart, in some cases the steps illustrated or described may be performed in an order different than here.
Fig. 1 is a flowchart of a processing method for data merging according to an embodiment of the present invention, and as shown in fig. 1, the processing method for data merging includes the following steps:
step S102, a table merging request is received, wherein the table merging request carries data to be merged and field names of the data to be merged.
Step S104, converting the data to be merged into formatted data with a preset format.
For example, data 1 and data 6 in table 2 need to be merged, then data 1 and data 6 are data to be merged, and data structure of data to be merged can be changed to merge data 6 and 1 into 1-6 in advance, so that a program can know which part of data needs to be merged through the data structure, thereby greatly reducing use difficulty in using components, simplifying manual operation, providing fool use experience for users, and specifically realizing the data through the following codes:
the data structure refers to a manner in which a computer stores and organizes data.
And S106, positioning the cells corresponding to the data to be merged according to the data to be merged and the field names, and merging the positioned cells to obtain merged cells.
And step S108, displaying the formatted data in the merging cells.
Through the steps, a table merging request can be received at first, wherein the table merging request carries the data to be merged and the field names of the data to be merged; then converting the data to be merged into formatted data with a preset format; positioning the corresponding cells of the data to be merged according to the data to be merged and the field names, and merging the positioned cells to obtain merged cells; and presenting the formatted data in the merge cell. Compared with the defects that the merging process is complex and the efficiency is low easily caused by the mode adopted when the tables are merged in the related technology, the data merging processing method provided by the embodiment of the invention can realize the purpose of merging the data to be merged according to the data to be merged and the field names, achieves the technical effect of improving the efficiency of data merging, further solves the technical problem that the merging process of the tables is complex and the efficiency of the table merging operation is low in the related technology, and improves the user experience.
As an optional embodiment of the present invention, in order to enable the program for data merging to identify the table where the data to be merged is located, in the embodiment of the present invention, before locating the cell corresponding to the data to be merged according to the data to be merged and the field name, the processing method for data merging may further include: identifying a data structure of a table where data to be merged are located; the data structure for identifying the table where the data to be merged is located comprises the following steps: identifying all fields of a table where data to be merged are located; and traversing the table on the basis of the preset path corresponding to each field in all the fields, and identifying the data structure of the table where the data to be merged is located.
For example, taking the merge type that needs to be performed on the data to be merged as a row merge, a data structure of a table needs to be defined first, and the data structure may include: a header (i.e., a field), and body data (data in a column corresponding to each header), and may include: an operation column. At this point, identifying the table in which the data to be merged is located may traverse the table using the table header of the table. Specifically, the header needs to be configured first, and the header configuration may be performed by the following codes:
the main body data structure:
in the data presentation and the header configuration, the value of the obtained prop attribute is the same as the value of a name (queue) in the main data structure, so that the header of the table corresponds to the main data without disordering the sequence, that is, the header and the table data can be aligned by the above method. Specifically, traversal refers to making one and only one access to each node in the tree along a route. Fig. 2 is a structural diagram of a table structure according to an embodiment of the present invention, and as shown in fig. 2, the data structure of the table may be divided into: header, body data, and operation column.
Preferably, traversing the table based on the predetermined path corresponding to each of the fields may include: judging whether all the fields have fields with operable attributes to obtain a judgment result; and adding the operation attribute to the cell corresponding to the field with the attribute being operable when the judgment result is that the field with the attribute being operable exists in all the fields. That is, when there is a field with an attribute being operable in all fields, an operation attribute, such as viewing, selecting, modifying, etc., may be added to the cell corresponding to the field with the attribute being operable according to the function corresponding to the operable field.
Specifically, in the case of an operation column, for example, when traversing the header, when prop is identified as "options", special processing is performed, that is, the following configuration needs to be written when writing the header configuration:
in step S106, locating the cell corresponding to the data to be merged according to the data to be merged and the field name may include: determining a traversal path corresponding to the field name, wherein the traversal path is a path along a non-field direction of the table; traversing sequentially by taking each data in the data to be merged as a clue along the traversal path to obtain the coordinates of the data to be merged; and positioning each cell of the data to be merged in the data to be merged according to the coordinates of the data to be merged.
For example, when it is determined that row merging is required to be performed on the data to be merged, the column corresponding to the field name may be used as a traversal path, and traversal is performed sequentially with each data in the data to be merged as a clue along the traversal path, so that a coordinate of each data to be merged may be obtained, and then, a cell of each data to be merged in the data to be merged may be located according to the coordinate of the data to be merged.
In addition, before merging the located cells, the processing method for merging data may further include: judging whether the cell corresponding to the data to be merged is an adjacent cell or not according to the coordinate of the data to be merged; and merging the positioned cells under the condition that the cell corresponding to the data to be merged is the adjacent cell according to the judgment result.
As an alternative embodiment, merging the located cells to obtain a merged cell includes: deleting data in the cells of the data to be merged to obtain a plurality of empty cells; and merging the empty cells to obtain merged cells.
For example, the data to be merged performs a row merging operation, and if two rows of data need to be merged, an algorithm may be used to display the data in the first row, and delete the merged data, so as to ensure that the row and column data of the table are the same, as shown in table 3 below:
TABLE 3
When (A, 7) and (A, 7) need to be merged, one less cell of the table is actually needed, so the data of (A, 7) needs to be positioned out by an algorithm in a calculation mode and deleted, and the normal display of the table can be ensured.
As an alternative embodiment, after table row merging is performed according to the row merging table template, the table row merging processing method further includes: acquiring data in the merged combined parallel, wherein the data comprises: a single line of data and body data containing the single line of data.
Fig. 3 is a block diagram of a processing method for merging data according to an embodiment of the present invention, and as shown in fig. 3, each line of data in the table may be generated through multiple passes, where a first pass generates one main data and a second pass generates three lines of data, so that, when a view button is clicked, a single line of table data may be returned and contain main data in a single line of data, which are three cells in a merged "intentional harm crime" and include a prosecution comment, doc "," a preposition document, doc "," a prosecution comment, doc ". That is, as shown in table 4, when the viewing operation of the first line is clicked, the user can know that the line of the prosecution book is clicked, and can provide all three lines of data, that is, can support the one-line operation.
TABLE 4
In addition, in the embodiment of the present invention, the number of rows to be merged or the number of columns to be merged may be determined according to the length (i.e., length attribute) of the data in the main data in the table in which the data to be merged is located. Fig. 4 is a schematic diagram of a processing method for data merging according to an embodiment of the present invention, and as shown in fig. 4, a case main body "casetile" is used to indicate a certain amount of theft; wherein, the data includes: "title": "petition book, doc", "title": "preceding document, doc", "title": doc ", then it can be found which rows need to be combined.
The embodiment of the invention can realize the traversal of the combined and parallel table data, reduces the configuration required by a developer, and can lead in the component to complete the realization of the combined and parallel table only by providing the key value of the element to be combined.
Example 2
According to the embodiment of the present invention, a data merging processing apparatus is further provided, and it should be noted that the data merging processing apparatus according to the embodiment of the present invention may be used to execute the data merging processing method according to the embodiment of the present invention. The following describes a processing apparatus for merging data according to an embodiment of the present invention.
Fig. 5 is a schematic diagram of a data merging processing device according to an embodiment of the present invention, and as shown in fig. 5, the data merging processing device includes: a receiving unit 51, a converting unit 53, a merging unit 55 and a presenting unit 57. The processing device for merging data will be described in detail below.
The receiving unit 51 is configured to receive a table merging request, where the table merging request carries data to be merged and a field name of the data to be merged.
A conversion unit 53, configured to convert the data to be merged into formatted data in a predetermined format.
And the merging unit 55 is configured to locate a cell corresponding to the data to be merged according to the data to be merged and the field name, and merge the located cell to obtain a merged cell.
And a presentation unit 57, configured to present the formatted data in the merge cell.
It should be noted that the receiving unit 51 in this embodiment may be configured to execute the step S102 in this embodiment of the present invention, the converting unit 53 in this embodiment may be configured to execute the step S104 in this embodiment of the present invention, the merging unit 55 in this embodiment may be configured to execute the step S106 in this embodiment of the present invention, and the displaying unit 57 in this embodiment may be configured to execute the step S108 in this embodiment of the present invention. The modules are the same as the corresponding steps in the realized examples and application scenarios, but are not limited to the disclosure of the above embodiments.
In this embodiment, a table merging request may be received by the receiving unit, where the table merging request carries data to be merged and a field name of the data to be merged; then, converting the data to be combined into formatted data in a preset format by using a conversion unit; positioning the corresponding cell of the data to be merged by utilizing the merging unit according to the data to be merged and the field name, and merging the positioned cells to obtain a merged cell; and the presentation unit is used for presenting the formatted data in the merging cells. Compared with the defects that the merging process is complex and the efficiency is low easily caused by the mode adopted when the tables are merged in the related technology, the data merging processing device provided by the embodiment of the invention can realize the purpose of merging the data to be merged according to the data to be merged and the field names, achieves the technical effect of improving the efficiency of data merging, further solves the technical problem that the merging process of the tables is complex and the merging operation efficiency of the tables is low in the related technology, and improves the user experience.
As an alternative embodiment, the data merging processing device may further include: the identification unit is used for identifying the data structure of the table where the data to be merged is located before the cell corresponding to the data to be merged is located according to the data to be merged and the field name; wherein, the recognition unit includes: the identification subunit is used for identifying all fields of the table where the data to be merged are located; and the first traversal subunit is used for traversing the table on the basis of the predetermined path corresponding to each field in all the fields and identifying the data structure of the table in which the data to be merged is located.
As an alternative embodiment, the first traversal subunit may include: the judging module is used for judging whether the fields with the operable attributes exist in all the fields to obtain a judging result; and the adding module is used for adding the operation attribute to the cell corresponding to the field with the operable attribute under the condition that the judging result is that the field with the operable attribute exists in all the fields.
As an alternative embodiment, the merging unit may include: the determining subunit is used for determining a traversal path corresponding to the field name, wherein the traversal path is a path along a non-field direction of the table; the second traversal subunit is used for sequentially traversing by taking each data in the data to be merged as a clue along the traversal path to obtain the coordinates of the data to be merged; and the positioning subunit is used for positioning each cell of the data to be merged in the data to be merged according to the coordinates of the data to be merged.
As an alternative embodiment, the data merging processing device may further include: the judging subunit is used for judging whether the cell corresponding to the data to be merged is an adjacent cell or not according to the coordinate of the data to be merged before merging the positioned cells; and the merging subunit is used for merging the positioned cells under the condition that the judgment result is that the cell corresponding to the data to be merged is the adjacent cell.
As an alternative embodiment, the merging unit may include: the deleting subunit is used for deleting the data in the cells of the data to be merged to obtain a plurality of empty cells; and the obtaining subunit is used for merging the plurality of empty cells to obtain merged cells.
According to another aspect of the embodiment of the present invention, there is also provided a storage medium including a stored program, wherein the program is a processing method for data merging in any one of the above.
According to another aspect of the embodiments of the present invention, there is further provided a processor, wherein the processor is configured to execute a program, and when the program runs, the method for processing data merging in any one of the above is performed.
The processing device for merging data further includes a processor and a memory, the receiving unit 51, the converting unit 53, the merging unit 55, the displaying unit 57, and the like are all stored in the memory as program units, and the processor executes the program units stored in the memory to implement corresponding functions.
The processor comprises a kernel, and the kernel calls a corresponding program unit from the memory. The kernel can be set to be one or more than one, the cell corresponding to the data to be merged is positioned according to the data to be merged and the field name by adjusting the kernel parameters, and the positioned cells are merged to obtain a merged cell; the formatted data is presented in a merge cell.
The memory may include volatile memory in a computer readable medium, Random Access Memory (RAM) and/or nonvolatile memory such as Read Only Memory (ROM) or flash memory (flash RAM), and the memory includes at least one memory chip.
According to another aspect of the embodiments of the present invention, there is also provided a storage medium including a stored program, wherein the program executes the processing method of data merging of any one of the above.
According to another aspect of the embodiments of the present invention, there is provided a processor, where the processor is configured to execute a program, where the program executes a processing method for data merging in any one of the above.
The embodiment of the present invention further provides an apparatus, which includes a processor, a memory, and a program stored in the memory and executable on the processor, and when the processor executes the program, the following steps are implemented: receiving a table merging request, wherein the table merging request carries data to be merged and field names of the data to be merged; converting the data to be merged into formatted data in a preset format; positioning the cells corresponding to the data to be merged according to the data to be merged and the field names, and merging the positioned cells to obtain merged cells; the formatted data is presented in a merge cell.
There is also provided in an embodiment of the invention a computer program product adapted to perform a program for initializing the following method steps when executed on a data processing device: receiving a table merging request, wherein the table merging request carries data to be merged and field names of the data to be merged; converting the data to be merged into formatted data in a preset format; positioning the cells corresponding to the data to be merged according to the data to be merged and the field names, and merging the positioned cells to obtain merged cells; the formatted data is presented in a merge cell.
The above-mentioned serial numbers of the embodiments of the present invention are merely for description and do not represent the merits of the embodiments.
In the above embodiments of the present invention, the descriptions of the respective embodiments have respective emphasis, and for parts that are not described in detail in a certain embodiment, reference may be made to related descriptions of other embodiments.
In the embodiments provided in the present application, it should be understood that the disclosed technology can be implemented in other ways. The above-described embodiments of the apparatus are merely illustrative, and for example, the division of the units may be a logical division, and in actual implementation, there may be another division, for example, multiple units or components may be combined or integrated into another system, or some features may be omitted, or not executed. In addition, the shown or discussed mutual coupling or direct coupling or communication connection may be an indirect coupling or communication connection through some interfaces, units or modules, and may be in an electrical or other form.
The units described as separate parts may or may not be physically separate, and parts displayed as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of units. Some or all of the units can be selected according to actual needs to achieve the purpose of the solution of the embodiment.
In addition, functional units in the embodiments of the present invention may be integrated into one processing unit, or each unit may exist alone physically, or two or more units are integrated into one unit. The integrated unit can be realized in a form of hardware, and can also be realized in a form of a software functional unit.
The integrated unit, if implemented in the form of a software functional unit and sold or used as a stand-alone product, may be stored in a computer readable storage medium. Based on such understanding, the technical solution of the present invention may be embodied in the form of a software product, which is stored in a storage medium and includes instructions for causing a computer device (which may be a personal computer, a server, or a network device) to execute all or part of the steps of the method according to the embodiments of the present invention. And the aforementioned storage medium includes: a U-disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a removable hard disk, a magnetic or optical disk, and other various media capable of storing program codes.
The foregoing is only a preferred embodiment of the present invention, and it should be noted that, for those skilled in the art, various modifications and decorations can be made without departing from the principle of the present invention, and these modifications and decorations should also be regarded as the protection scope of the present invention.
Claims (10)
1. A processing method for data merging is characterized by comprising the following steps:
receiving a table merging request, wherein the table merging request carries data to be merged and a field name of the data to be merged;
converting the data to be merged into formatted data in a preset format;
positioning the cells corresponding to the data to be merged according to the data to be merged and the field names, and merging the positioned cells to obtain merged cells;
displaying the formatted data in the merge cell.
2. The method according to claim 1, before locating the cell corresponding to the data to be merged according to the data to be merged and the field name, further comprising:
identifying a data structure of a table where the data to be merged are located;
the data structure for identifying the table where the data to be merged is located comprises the following steps:
identifying all fields of the table where the data to be merged are located;
and traversing the table on the basis of a predetermined path corresponding to each field in all the fields, and identifying the data structure of the table in which the data to be merged is located.
3. The method of claim 2, wherein traversing the table based on the predetermined path corresponding to each of the fields comprises:
judging whether all the fields have fields with operable attributes to obtain a judgment result;
and adding an operation attribute to the cell corresponding to the field with the attribute being operable when the judgment result shows that the field with the attribute being operable exists in all the fields.
4. The method of claim 1, wherein locating the cell corresponding to the data to be merged according to the data to be merged and the field name comprises:
determining a traversal path corresponding to the field name, wherein the traversal path is a path along a non-field direction of the table;
traversing by taking each data in the data to be merged as a clue in sequence along the traversal path to obtain coordinates of the data to be merged;
and positioning the cell of each data to be merged in the data to be merged according to the coordinate of the data to be merged.
5. The method of claim 4, further comprising, prior to merging the located cells:
judging whether the cell corresponding to the data to be merged is an adjacent cell or not according to the coordinate of the data to be merged;
and merging the positioned cells under the condition that the cell corresponding to the data to be merged is the adjacent cell according to the judgment result.
6. The method of claim 1, wherein merging the located cells to obtain a merged cell comprises:
deleting the data in the cells of the data to be merged to obtain a plurality of empty cells;
and merging the empty cells to obtain merged cells.
7. A data merge processing apparatus, comprising:
the device comprises a receiving unit, a merging unit and a merging unit, wherein the receiving unit is used for receiving a table merging request, and the table merging request carries data to be merged and field names of the data to be merged;
the conversion unit is used for converting the data to be merged into formatted data in a preset format;
the merging unit is used for positioning the cells corresponding to the data to be merged according to the data to be merged and the field names and merging the positioned cells to obtain merged cells;
and the display unit is used for displaying the formatted data in the merging cells.
8. The apparatus of claim 7, further comprising:
the identification unit is used for identifying the data structure of the table where the data to be merged is located before the cell corresponding to the data to be merged is located according to the data to be merged and the field name;
wherein the identification unit includes:
the identification subunit is used for identifying all fields of the table where the data to be merged are located;
and the first traversal subunit is used for traversing the table on the basis of the predetermined path corresponding to each field in all the fields, and identifying the data structure of the table in which the data to be merged is located.
9. A storage medium characterized by comprising a stored program, wherein the program executes the processing method for data consolidation according to any one of claims 1 to 6.
10. A processor, characterized in that the processor is configured to execute a program, wherein the program executes the processing method of data merging according to any one of claims 1 to 6.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811161949.4A CN110969000B (en) | 2018-09-30 | Data merging processing method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811161949.4A CN110969000B (en) | 2018-09-30 | Data merging processing method and device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN110969000A true CN110969000A (en) | 2020-04-07 |
| CN110969000B CN110969000B (en) | 2024-05-03 |
Family
ID=
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111723560A (en) * | 2020-07-15 | 2020-09-29 | 金蝶软件（中国）有限公司 | Dynamic adjustment method, system and related equipment for table parallel display area |
| CN114077466A (en) * | 2020-08-12 | 2022-02-22 | 北京智邦国际软件技术有限公司 | Automatic layout algorithm for multiple rows and multiple columns of fields in Web interface form |
| CN115630620A (en) * | 2022-10-31 | 2023-01-20 | 中诚智信工程咨询集团股份有限公司 | Method and system for collecting and processing engineering cost analysis data |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20090024667A1 (en) * | 2005-01-12 | 2009-01-22 | Masatsugu Noda | Information processing device, file data merging method, file naming method, and file data output method |
| CN101388028A (en) * | 2008-09-19 | 2009-03-18 | 金蝶软件（中国）有限公司 | Method and apparatus for combining cells |
| CN103279455A (en) * | 2013-06-28 | 2013-09-04 | 中国农业银行股份有限公司 | Spreadsheet style processing method and device |
| US20140372851A1 (en) * | 2013-06-15 | 2014-12-18 | Microsoft Corporation | Conversion of Data Ranges to Table Objects |
| CN106709032A (en) * | 2016-12-29 | 2017-05-24 | 深圳市华傲数据技术有限公司 | Method and device for extracting structured information from spreadsheet document |
| CN108133007A (en) * | 2017-12-22 | 2018-06-08 | 北京明朝万达科技股份有限公司 | A kind of method of data synchronization and system |
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20090024667A1 (en) * | 2005-01-12 | 2009-01-22 | Masatsugu Noda | Information processing device, file data merging method, file naming method, and file data output method |
| CN101388028A (en) * | 2008-09-19 | 2009-03-18 | 金蝶软件（中国）有限公司 | Method and apparatus for combining cells |
| US20140372851A1 (en) * | 2013-06-15 | 2014-12-18 | Microsoft Corporation | Conversion of Data Ranges to Table Objects |
| CN103279455A (en) * | 2013-06-28 | 2013-09-04 | 中国农业银行股份有限公司 | Spreadsheet style processing method and device |
| CN106709032A (en) * | 2016-12-29 | 2017-05-24 | 深圳市华傲数据技术有限公司 | Method and device for extracting structured information from spreadsheet document |
| CN108133007A (en) * | 2017-12-22 | 2018-06-08 | 北京明朝万达科技股份有限公司 | A kind of method of data synchronization and system |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111723560A (en) * | 2020-07-15 | 2020-09-29 | 金蝶软件（中国）有限公司 | Dynamic adjustment method, system and related equipment for table parallel display area |
| CN111723560B (en) * | 2020-07-15 | 2024-04-19 | 金蝶软件（中国）有限公司 | Dynamic adjustment method, system and related equipment for parallel display area of table |
| CN114077466A (en) * | 2020-08-12 | 2022-02-22 | 北京智邦国际软件技术有限公司 | Automatic layout algorithm for multiple rows and multiple columns of fields in Web interface form |
| CN115630620A (en) * | 2022-10-31 | 2023-01-20 | 中诚智信工程咨询集团股份有限公司 | Method and system for collecting and processing engineering cost analysis data |
| CN115630620B (en) * | 2022-10-31 | 2023-12-26 | 中诚智信工程咨询集团股份有限公司 | Method and system for collecting and processing engineering cost analysis data |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US8601361B2 (en) | Automatically populating and/or generating tables using data extracted from files | |
| CN107025239B (en) | Sensitive word filtering method and device | |
| US9411839B2 (en) | Index configuration for searchable data in network | |
| CN102902688A (en) | Method and device for displaying results of keyword search | |
| CN107402950A (en) | Divide the document handling method and device of table based on point storehouse | |
| CN106095816B (en) | Information delivery method and device | |
| CN109960554A (en) | Show method, equipment and the computer storage medium of reading content | |
| US11429660B2 (en) | Photo processing method, device and computer equipment | |
| CN110222046B (en) | List data processing method, device, server and storage medium | |
| CN112784529A (en) | Mobile terminal sorting table based on BetterScroll and construction method thereof | |
| US20170171128A1 (en) | Method and electronic device for email processing | |
| CN110969000A (en) | Data merging processing method and device | |
| WO2019085591A1 (en) | Intelligent hardware device, intelligent disk data processing method, and storage medium | |
| CN109800273A (en) | A kind of method, apparatus of data processing, computer storage medium and terminal | |
| CN110969000B (en) | Data merging processing method and device | |
| CN113742529A (en) | Multi-table front-end processing method and device | |
| CN106933896B (en) | Shortest access path identification method and device | |
| CN113778996A (en) | Large data stream data processing method and device, electronic equipment and storage medium | |
| US20200005436A1 (en) | Method and apparatus for image processing | |
| CN105740272B (en) | Resource file searching method and system | |
| CN111352917B (en) | Information input method and device, electronic equipment and storage medium | |
| CN103902178A (en) | Multi-media file processing method and device based on Android system | |
| CN115545008B (en) | Spectrogram file analyzing method, device, equipment and storage medium | |
| CN111858994A (en) | Character retrieval method and device | |
| CN116450669A (en) | Data query method, device, computer equipment and storage medium |
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 | ||
| GR01 | Patent grant |