CN108153719A - Merge the method and apparatus of electrical form - Google Patents
Merge the method and apparatus of electrical form Download PDFInfo
- Publication number
- CN108153719A CN108153719A CN201611112204.XA CN201611112204A CN108153719A CN 108153719 A CN108153719 A CN 108153719A CN 201611112204 A CN201611112204 A CN 201611112204A CN 108153719 A CN108153719 A CN 108153719A
- Authority
- CN
- China
- Prior art keywords
- row
- column
- title
- merging
- combined
- 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
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/174—Form filling; Merging
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a kind of method and apparatus for merging electrical form.Wherein, this method includes：The request for merging multiple bivariate tables is received, wherein, multiple bivariate tables meet preset merging condition；According to request, the title of row or column to be combined is determined；Obtain row or column identical with the title of row or column to be combined in multiple bivariate tables；Row or column identical with the title of row or column to be combined in multiple bivariate tables is merged, obtain merging rows or merges row；By row or column different from the title of row or column to be combined in multiple bivariate tables and merging rows or merge row and splice, obtain new bivariate table.The present invention solves when multiple bivariate tables are merged in the prior art, needs to carry out matching using formula to cause user's operation inconvenient and the technical issues of experience difference.
Description
Technical field
The present invention relates to computer office field, in particular to a kind of method and apparatus for merging electrical form.
Background technology
At present, in daily life and work, the use of electrical form is more and more frequent, most common spreadsheet software
Such as：Microsoft Excel, Excel are one of components of office software Microsoft office of Microsoft, be by
A trial balance that Microsoft writes and runs for the computer of Windows and Apple Macintoshes is soft
Part.Electrical form can carry out processing, statistical analysis and the aid decision operation of various data, be widely used in management, system
Count the various fields such as finance and economics, finance.
Under normal circumstances, user can make various simple or complicated electronic form document using electrical form, be used for
Information record, statistics etc..User is to electronic form document into during edlin, it is often necessary to perform electrical form
The operation of multiple cell spans.But aforesaid operations are carried out using electrical form in user, multiple bivariate tables are merged
When, the problem of needing to be matched using excel formula, result in inconvenient, poor user experience.
When multiple bivariate tables are merged in for the above-mentioned prior art, need using formula match to lead to user
The problem of inconvenient and experience difference, currently no effective solution has been proposed.
Invention content
An embodiment of the present invention provides a kind of method and apparatus for merging electrical form, at least to solve in the prior art to
When multiple bivariate tables merge, need to carry out the technical issues of matching causes user's operation inconvenient and experiences difference using formula.
One side according to embodiments of the present invention provides a kind of method for merging electrical form, including：It receives and merges
The request of multiple bivariate tables, wherein, multiple bivariate tables meet preset merging condition；According to request, determine row to be combined or
The title of row；Obtain row or column identical with the title of row or column to be combined in multiple bivariate tables；By in multiple bivariate tables with
The row or column that the title of row or column to be combined is identical merges, and obtains merging rows or merges row；By in multiple bivariate tables with
The different row or column of the title of row or column to be combined and merging rows merge row and are spliced, and obtain new bivariate table.
Optionally, row or column identical with the title of row or column to be combined in multiple bivariate tables is merged, obtained
After merging rows or merging row, including：Deduplication operation is carried out to merging rows or the content for merging row.
Optionally, by row or column different from the title of row or column to be combined in multiple bivariate tables and merging rows or merge
Row are spliced, including：By all or part of row or column different from the title of row or column to be combined in multiple bivariate tables with
Merging rows or merging row are spliced.
Optionally, by part row or column different from the title of row or column to be combined in multiple bivariate tables and merging rows or
Before merging row are spliced, including：It determines the title of row or column to be spliced or determines the name of the row or column without splicing
Claim.
Optionally, by row or column different from the title of row or column to be combined in multiple bivariate tables and merging rows or merge
Row are spliced, including：It determines to whether there is in row or column different from the title of row or column to be combined in multiple bivariate tables
The row or column that title is identical and content is data format；The row different from the title of row or column to be combined in multiple bivariate tables
Or in row in the case of row or column of the and content identical there are title for data format, by title is identical and content is data format
Row or column merge, and the content of the row title cell all identical with column name is added.
Another aspect according to embodiments of the present invention additionally provides a kind of device for merging electrical form, including：Receive mould
Block, for receiving the request for merging multiple bivariate tables, wherein, multiple bivariate tables meet preset merging condition；First determining mould
Block, for according to request, determining the title of row or column to be combined；Acquisition module closes for obtaining in multiple bivariate tables with waiting
And row or column the identical row or column of title；Merging module, for by the name with row or column to be combined in multiple bivariate tables
Identical row or column is claimed to merge, obtain merging rows or merges row；Concatenation module, for by multiple bivariate tables with it is to be combined
Row or column the different row or column of title and merging rows or merge row and spliced, obtain new bivariate table.
Optionally, device further includes：Deduplication module carries out deduplication operation for the content to merging rows or merging row.
Optionally, concatenation module, for by whole different from the title of row or column to be combined in multiple bivariate tables or
Part row or column and merging rows merge row and are spliced.
Optionally, device further includes：First determining module, for by multiple bivariate tables with row or column to be combined
The different part row or column of title and merging rows merge before row are spliced, determine row or column to be spliced title or
Determine the title of the row or column without splicing.
Optionally, concatenation module, including：Determination sub-module, for determining row or column in multiple bivariate tables and to be combined
The different row or column of title in and content identical with the presence or absence of title be data format row or column；Merge submodule, be used for
And content identical there are title is data lattice in the row or column different from the title of row or column to be combined in multiple bivariate tables
In the case of the row or column of formula, by title is identical and content is merged for the row or column of data format, and by row title and row
The content of all identical cell of title is added.
In embodiments of the present invention, the request of multiple bivariate tables is merged by receiving, determines to wait to close according to above-mentioned request
And row or column title, in multiple bivariate tables are got after the row or column identical with the title of row or column to be combined, will
The row or column identical with the title of row or column to be combined merges in multiple bivariate tables, obtains merging rows or merges row, and
By row or column different from the title of row or column to be combined in multiple bivariate tables and merging rows or merge row and splice, finally
New bivariate table is obtained, has achieved the purpose that merge bivariate table according to the individual demand of user, it is achieved thereby that improving office
Efficiency and the technique effect of user's operation experience, and then solve when multiple bivariate tables are merged in the prior art, it needs
Carrying out matching using formula leads to the technical issues of user's operation is inconvenient and experience is poor.
Description of the drawings
Attached drawing described herein is used to provide further understanding of the present invention, and forms the part of the application, this hair
Bright illustrative embodiments and their description do not constitute improper limitations of the present invention for explaining the present invention.In the accompanying drawings：
Fig. 1 is a kind of method flow diagram of according to embodiments of the present invention 1 merging electrical form；
Fig. 2 is a kind of structure drawing of device of according to embodiments of the present invention 2 merging electrical form；
Fig. 3 is a kind of according to embodiments of the present invention 2 optional structure drawing of device for merging electrical form；
Fig. 4 is a kind of according to embodiments of the present invention 2 optional structure drawing of device for merging electrical form；And
Fig. 5 is a kind of according to embodiments of the present invention 2 optional structure drawing of device for merging electrical form.
Specific embodiment
In order to which those skilled in the art is made to more fully understand the present invention program, below in conjunction in the embodiment of the present invention
The technical solution in the embodiment of the present invention is clearly and completely described in attached drawing, it is clear that described embodiment is only
The embodiment of a part of the invention, instead of all the embodiments.Based on the embodiments of the present invention, ordinary skill people
Member's all other embodiments obtained without making creative work should all belong to the model that the present invention protects
It encloses.
It should be noted that term " first " in description and claims of this specification and above-mentioned attached drawing, "
Two " etc. be the object for distinguishing similar, and specific sequence or precedence are described without being used for.It should be appreciated that it uses in this way
Data can be interchanged in the appropriate case, so as to the embodiment of the present invention described herein can in addition to illustrating herein or
Sequence other than those of description is implemented.In addition, term " comprising " and " having " and their any deformation, it is intended that cover
Cover it is non-exclusive include, be not necessarily limited to for example, containing the process of series of steps or unit, method, system, product or equipment
Those steps or unit clearly listed, but may include not listing clearly or for these processes, method, product
Or the intrinsic other steps of equipment or unit.
Embodiment 1
According to embodiments of the present invention, a kind of embodiment of the method for merging electrical form is provided, it should be noted that attached
The step of flow of figure illustrates can perform in the computer system of such as a group of computer-executable instructions, though also,
So show logical order in flow charts, but in some cases, can be performed with the sequence being different from herein shown by
Or the step of description.
Fig. 1 is a kind of method flow diagram of merging electrical form according to embodiments of the present invention, as shown in Figure 1, this method
Include the following steps：
Step S102 receives the request for merging multiple bivariate tables, wherein, multiple bivariate tables meet preset merging condition.
Specifically, in above-mentioned steps S102, above-mentioned bivariate table can be any one table that can be merged, example
Such as, excel tables, wps tables etc., above-mentioned preset merging condition can refer to any two or multiple two in multiple bivariate tables
There is the row or column for allowing to merge between dimension table, for example, there is tool in multiple bivariate tables between any two or multiple bivariate tables
Have same names row or column or exist and row or column same names to be combined row or column, that is, exist with it is to be combined
Row of the row with same names is deposited and row of the row with same names to be combined.Wherein, in addition to depositing in each bivariate table
In the row or column identical with row or column title to be combined, that is, exist the row identical with row title to be combined or exist with
The identical row of column name to be combined, there may also be with the different row or column of row or column title to be combined, that is, exist with
The different row of row title to be combined or presence and the different row of column name to be combined.
By bivariate table for for excel tables, in the toolbar of the functional areas of excel tables, merging work can be set
Has area to realize the merging of multiple bivariate tables, user can also add according to individual demand in self-defined quick access toolbar
Merging tool.Any one merged in Accessorial Tools Storage merges tool, can be used for receiving the request that user merges multiple bivariate tables,
User can be, but not limited to send a request to excel tables by clicking the form of mouse, point touching screen, user without using
Excel formula carry out matching operation, improve office efficiency, enhance the interactive experience of user.
Step S104 according to request, determines the title of row or column to be combined.
It, can be further in above-mentioned steps S104 in the case of the request for receiving the multiple bivariate tables of user's merging
The title of row or column to be combined is determined to be merged to multiple bivariate tables.
It is still illustrated using bivariate table as excel tables as example, user clicks the arbitrary of excel tables by mouse
One merges instrumental function key and sends request, and excel tables respond the request of user, pop up corresponding pooling function regional boundary face.
User can be clicked mouse or finger touch by way of selecting, and row or column to be combined is selected in any one bivariate table
Title or input the title of row or column to be combined, determining row or column to be combined in pooling function regional boundary face.
It should be noted that above-mentioned row or column to be combined can be any two or multiple bivariate tables in multiple bivariate tables
In there is the row or column of same names, you can be that there are same names in multiple bivariate tables in any two or multiple bivariate tables
Row or with same names row.
Step S106 obtains row or column identical with the title of row or column to be combined in multiple bivariate tables.
Row or column identical with the title of row or column to be combined in multiple bivariate tables is merged, obtained by step S108
To merging rows or merge row.
Specifically, in technical solution defined in above-mentioned steps S106 to step S108, row to be combined is being determined
Or after the title of row, the title for comparing row or column in multiple bivariate tables can be identified by computer intelligence, chooses and wait to close
And row or column the identical row or column of title, that is, choose the row identical with the title of row to be combined or selection with waiting to close
And row the identical row of title, and row or column identical with the title of row or column to be combined in multiple bivariate tables is closed
And obtain merging rows or merge row, i.e., row identical with the title of row to be combined in multiple bivariate tables is merged, obtained
Merging rows merge row identical with the title of row to be combined in multiple bivariate tables, obtain merging row.
In a kind of optional embodiment, by taking excel tables as an example, above-described embodiment is described in detail.For example, have
Two bivariate tables to be combined of Tables 1 and 2, wherein, the specifying information of Tables 1 and 2 to be combined is as shown below：
Table 1：
| Name | Height | Gender |
| Zhang San | 180 | Man |
| Li Si | 170 | Female |
| King five | 160 | Man |
Table 2：
| Name | Occupation | Weight |
| Zhang San | Student | 120 |
| Li Si | Teacher | 100 |
| King five | Worker | 100 |
User can arrange to select after the request for merging Tables 1 and 2 is sent out by " name " in clicks table 1 or table 2
Merge " name " row, that is, column name to be combined is " name ", is selected from Tables 1 and 2 respectively and " name " column name
Identical row merge, " name " row merged.
Step S110, by row or column different from the title of row or column to be combined in multiple bivariate tables and merging rows or conjunction
Spliced side by side, obtain new bivariate table.
Specifically, in above-mentioned steps S110, merging rows or merging are arranged after determining, it is possible to will be remained in multiple bivariate tables
Remaining row or column and merging rows merge row and are spliced, i.e., can be by row remaining in multiple bivariate tables after merging rows determine
Spliced with merging rows, alternatively, after merging row determine, row remaining in multiple bivariate tables can be spelled with merging row
It connects, finally obtains the new bivariate table after merging.
In a kind of optional embodiment, still by taking Tables 1 and 2 as an example, in Tables 1 and 2, in addition to " name " of merging arranges
Except, " weight " row and " occupation " for there remains in " height " row and " gender " row and table 2 in table 1 arrange, can will be above-mentioned
" height " row, " weight " row, " gender " row and " occupation " row are spliced with " name " row after merging, and obtain one new two
Dimension table table 3, new bivariate table table 3 are as follows：
Table 3：
| Name | Height | Gender | Occupation | Weight |
| Zhang San | 180 | Man | Student | 120 |
| Li Si | 170 | Female | Teacher | 100 |
| King five | 160 | Man | Worker | 100 |
Based on the scheme that above-mentioned steps S102 is provided to step S110, the embodiment of the present invention merges multiple two by receiving
The request of dimension table determines the title of row or column to be combined according to above-mentioned request, is closed in multiple bivariate tables are got with waiting
And row or column the identical row or column of title after, by row identical with the title of row or column to be combined in multiple bivariate tables or
Row merge, and obtain merging rows or merge row, and by row different from the title of row or column to be combined in multiple bivariate tables
Row with merging rows or merges arrange spliced, finally obtain new bivariate table, reached according to the individual demand of user conjunction
And the purpose of bivariate table, it is achieved thereby that improving the technique effect of office efficiency and user's operation experience, and then solve existing
When multiple bivariate tables are merged in technology, need using formula match to lead to the skill that user's operation is inconvenient and experience is poor
Art problem.
Based on the scheme that the above embodiment of the present invention provides, present invention also provides following preferred embodiments：
Optionally, it according to the above embodiment of the present invention, after step S108 is performed, i.e., will be closed in multiple bivariate tables with waiting
And the identical row or column of title of row or column merge, after obtaining merging rows or merging row, this method further includes as follows
Step：
Step 202, deduplication operation is carried out to the content of merging rows or merging row.
Specifically, the content repeated may be had by merging in row or in merging rows, in this case, it is necessary to right
Merging rows or the content progress deduplication operation for merging row.
It in a kind of optional embodiment, is still illustrated by taking Tables 1 and 2 as an example, if row to be combined is entitled
" name ", after column name in two bivariate tables is merged for the row of " name ", due in " name " row in Tables 1 and 2
Content is " Zhang San ", " Li Si ", " king five ", if simple merge without deduplication operation, will appear two " Zhang San ",
Two " Li Sis " and two " king five ", occupied space and are unfavorable for user's use, therefore, the above embodiment of the present invention the step of
In, deduplication operation is carried out by the content to merging rows or merging row, space can be saved, make bivariate table conciser, without
User carries out deduplication operation using excel formula, reduces the troublesome operation of user, enhances the experience of user, improve use
The office efficiency at family.
Optionally, according to the above embodiment of the present invention, in step S110 by multiple bivariate tables with row or column to be combined
The different row or column of title and merging rows or merge row and spliced, include the following steps：
Step S302, by all or part of row or column different from the title of row or column to be combined in multiple bivariate tables with
Merging rows or merging row are spliced.
Specifically, user can select in addition to the remaining whole row or column of row or column to be combined and merging rows or will to merge
Row are spliced, can also self-defined selection in addition to the remaining part row or column of row or column to be combined and merging rows or merge row
Spliced, to realize that the self-defined of bivariate table splices and combines, improve the interactive experience of user.
It as a kind of optional embodiment, is still illustrated by taking Tables 1 and 2 as an example below, is generating merging rows or conjunction
After side by side, it can select in addition to the remaining whole row or column of row or column to be combined and merging rows or will to merge to arrange and splice,
Spliced bivariate table as shown in Table 3 above, can also self-defined selection in addition to the remaining part row of row or column to be combined or
Row and merging rows merge to arrange and are spliced, and in the remaining row or column of self-defined selected section and merging rows or merge to arrange and are spelled
Can filter out the column or row that need to splice when connecing, the column or row for being not required to splicing can also be filtered out.
In a kind of optional embodiment, also by taking Tables 1 and 2 as an example, user can select to merge two according to " name " row
Dimension table, later selection will row whole in " height ", " weight ", " gender " and " occupation " bivariate table with merge arrange " name " arrange into
Row splicing can also select only to splice " height ", " gender " and the row of " occupation " three, not splice " weight " row.It is specifically, self-defined
The splicing result that " weight " row are not spliced in selection is as shown in table 4 below：
Table 4：
| Name | Height | Gender | Occupation |
| Zhang San | 180 | Man | Student |
| Li Si | 170 | Female | Teacher |
| King five | 160 | Man | Worker |
By above-mentioned steps S302, the self-defined splicing of multiple bivariate tables can be realized, reach multiple bivariate tables whole
Splicing or the purpose of part splicing.
Optionally, according to the above embodiment of the present invention, in step S302 by multiple bivariate tables with row to be combined or
The different part row or column of the titles of row and merging rows merge before row are spliced, and further include following steps：
Step S402 determines the title of row or column to be spliced or determines the title of the row or column without splicing.
Specifically, in the step of the above embodiments of the present application, if user's selection by multiple bivariate tables with it is to be combined
The different part row or column of the title of row or column and merging rows merge row and are spliced, then are selected in user by multiple bivariate tables
In the part row or column different from the title of row or column to be combined and merging rows or merge before row are spliced, can basis
The demand of user, the self-defined title of row or column for selecting to be spliced or select do not need to the row spliced or
The title of row.
It should be noted that above-mentioned screening process can be by inputting or clicking the row or column that need to splice or be not required to splicing
Title is realized.Specific embodiment is referred to the embodiment of above-mentioned generation table 4.
In a kind of optional embodiment, perform step S110, i.e., by multiple bivariate tables with row or column to be combined
The different row or column of title and merging rows or when merging row and being spliced, include the following steps：
Step S502 determines to whether there is in row or column different from the title of row or column to be combined in multiple bivariate tables
The row or column that title is identical and content is data format.
Step S504, there are title phases in the row or column different from the title of row or column to be combined in multiple bivariate tables
In the case of row or column of the same and content for data format, row or column title is identical and that content is data format is closed
And and the content of the row title cell all identical with column name is added.
Specifically, in above-mentioned steps S502 to step S504, in addition to the row to be combined with user in multiple bivariate tables
Or in the row or column except row, it is understood that there may be the row or column that title is identical and content is data format, in such a case, it is possible to
By title is identical and content is merged for the row or column of data format, a row or column is formed, i.e., by title is identical and content
Row for data format merges in a row or row title is identical and that content is data format are merged into a row, and should
The content of the row title cell all identical with column name is added in a row or column.
As an alternative embodiment, it is still illustrated by taking excel tables as an example below, for example, having table 5 and table 6
Two bivariate tables to be combined, wherein, the specifying information of bivariate table table 5 to be combined and table 6 is as follows：
Table 5：
| Name | Purchase volume | Gender |
| Zhang San | 10 | Man |
| Li Si | 12 | Female |
| King five | 8 | Man |
Table 6：
| Name | Occupation | Purchase volume |
| Zhang San | Student | 5 |
| Li Si | Teacher | 1 |
| King five | Worker | 3 |
User can select to merge table 5 and table 6 according to " name " row, it can be seen that there are entitled in table 5 and table 6
The row of " purchase volume ", and the content of the row of entitled " purchase volume " is data, it therefore, can be by " purchase entitled in table 5 and table 6
The row of the amount of buying " are merged into a row, and the content of the row title cell all identical with column name is added, for example, in table 5
Column name is that the content of the cell of " purchase volume " row entitled " Zhang San " be " 10 ", and column name is " purchase volume " row name in table 6
Referred to as the content of the cell of " Zhang San " is " 5 ", merges the cell of rank rear entitled " purchase volume " row entitled " Zhang San "
Content is " 15 ", and specific amalgamation result is as shown in table 7 below：
Table 7：
| Name | Purchase volume | Gender | Occupation |
| Zhang San | 15 | Man | Student |
| Li Si | 13 | Female | Teacher |
| King five | 11 | Man | Worker |
The scheme provided by above-mentioned steps S502 and step S504, in multiple bivariate tables with row or column to be combined
In the different row or column of title in the case of row or column of the and content identical there are title for data format, by row title and row name
The data in all identical cell is claimed to be added, is calculated without using excel formula, can realize data in bivariate table
Aggregate-value merges, and makes table more practical, simplifies the operating process of user, enhances the interactive experience of user.
Embodiment 2
According to embodiments of the present invention, a kind of device embodiment for merging electrical form is additionally provided.
Fig. 2 is a kind of schematic device of merging electrical form according to embodiments of the present invention, as shown in Fig. 2, in one kind
In optional embodiment, which includes：Receiving module 30, determining module 32, acquisition module 34, merging module 36, splicing mould
Block 38.
Wherein, receiving module 30, for receiving the request for merging multiple bivariate tables, wherein, multiple bivariate tables meet default
Merging condition；Determining module 32, for according to request, determining the title of row or column to be combined；Acquisition module 34, for obtaining
Take row or column identical with the title of row or column to be combined in multiple bivariate tables；Merging module 36, for by multiple bivariate tables
In the row or column identical with the title of row or column to be combined merge, obtain merging rows or merge row；Concatenation module 38 is used
In by row or column different from the title of row or column to be combined in multiple bivariate tables and merging rows or merging row and splicing, obtain
To new bivariate table.
Based on the scheme that above-described embodiment is provided, the embodiment of the present invention is received by receiving module 30 merges multiple two dimensions
The request of table is determined the title of row or column to be combined by determining module 32 according to above-mentioned request, is obtained in acquisition module 34
Into multiple bivariate tables after the row or column identical with the title of row or column to be combined, merging module 36 by multiple bivariate tables with
The row or column that the title of row or column to be combined is identical merges, and obtains merging rows or merges row, concatenation module 38 will be multiple
The row or column different from the title of row or column to be combined and merging rows or merge row in bivariate table and spliced, finally obtain new
Bivariate table, achieved the purpose that according to the individual demand of user merge bivariate table, it is achieved thereby that improve office efficiency and
The technique effect of user's operation experience, and then solve when multiple bivariate tables are merged in the prior art, it needs to utilize public affairs
Formula, which carries out matching, leads to the technical issues of user's operation is inconvenient and experience is poor.
Herein it should be noted that above-mentioned receiving module 30, determining module 32, acquisition module 34, merging module 36, splicing
Module 38 corresponds to the step S102 to step S110 in embodiment 1, example that above-mentioned module and corresponding step are realized and
Application scenarios are identical, but are not limited to the above embodiments 1 disclosure of that.It should be noted that above-mentioned module is as device
A part can perform in the computer system of such as a group of computer-executable instructions.
Based on the scheme that above device provides, present invention also provides following preferred embodiments：
Optionally, as shown in figure 3, the device further includes deduplication module 40, for merging rows or merge row content into
Row deduplication operation.
Specifically, deduplication module 40 is arranged on after merging module 36, i.e., after merging module 36 has performed its function, call
Deduplication module 40.
Herein it should be noted that above-mentioned deduplication module 40 correspond to embodiment 1 in step S202, above-mentioned module with it is right
The example that the step of answering is realized is identical with application scenarios, but is not limited to the above embodiments 1 disclosure of that.Need what is illustrated
It is that above-mentioned module can be performed as a part of of device in the computer system of such as a group of computer-executable instructions.
Optionally, concatenation module 38 is additionally operable to whole different from the title of row or column to be combined in multiple bivariate tables
Or part row or column and merging rows or merge row and spliced.
Herein it should be noted that above-mentioned concatenation module 38 correspond to embodiment 1 in step S302, above-mentioned module with it is right
The example that the step of answering is realized is identical with application scenarios, but is not limited to the above embodiments 1 disclosure of that.Need what is illustrated
It is that above-mentioned module can be performed as a part of of device in the computer system of such as a group of computer-executable instructions.
Optionally, as shown in figure 4, device further includes the first determining module 60, in concatenation module 38 by multiple two dimensions
The part row or column different from the title of row or column to be combined and merging rows or merge before row are spliced in table, determine to treat
The title of the row or column of splicing or the title for determining the row or column without splicing.
Herein it should be noted that above-mentioned first determining module 60 corresponds to the step S402 in embodiment 1, above-mentioned module
It is identical with the example and application scenarios that corresponding step is realized, but it is not limited to the above embodiments 1 disclosure of that.It needs
Bright, above-mentioned module can be held as a part of of device in the computer system of such as a group of computer-executable instructions
Row.
Optionally, as shown in figure 5, concatenation module 38 includes determination sub-module 70 and merges submodule 72.
Wherein it is determined that submodule 70, for determining row different from the title of row or column to be combined in multiple bivariate tables
Or and content identical with the presence or absence of title is the row or column of data format in row；
Merge submodule 72, for being deposited in different from the title of row or column to be combined row or column in multiple bivariate tables
In title in the case of row or column of the identical and content for data format, by the row or column that title is identical and content is data format
It merges, and the content of the row title cell all identical with column name is added.
Herein it should be noted that above-mentioned determination sub-module 70 and merging submodule 72 correspond to the step in embodiment 1
S502 to step S504, above-mentioned module is identical with example and application scenarios that corresponding step is realized, but is not limited to above-mentioned reality
Apply 1 disclosure of that of example.It should be noted that above-mentioned module can be such as one group of computer can as a part of of device
It is performed in the computer system of execute instruction.
The embodiments of the present invention are for illustration only, do not represent the quality of embodiment.
In the above embodiment of the present invention, all emphasize particularly on different fields to the description of each embodiment, do not have in some embodiment
The part of detailed description may refer to the associated description of other embodiment.
In several embodiments provided herein, it should be understood that disclosed technology contents can pass through others
Mode is realized.Wherein, the apparatus embodiments described above are merely exemplary, such as the division of the unit, Ke Yiwei
A kind of division of logic function, can there is an other dividing mode in actual implementation, for example, multiple units or component can combine or
Person is desirably integrated into another system or some features can be ignored or does not perform.Another point, shown or discussed is mutual
Between coupling, direct-coupling or communication connection can be INDIRECT COUPLING or communication link by some interfaces, unit or module
It connects, can be electrical or other forms.
The unit illustrated as separating component may or may not be physically separate, be shown as unit
The component shown may or may not be physical unit, you can be located at a place or can also be distributed to multiple
On unit.Some or all of unit therein can be selected according to the actual needs to realize the purpose of this embodiment scheme.
In addition, each functional unit in each embodiment of the present invention can be integrated in a processing unit, it can also
That each unit is individually physically present, can also two or more units integrate in a unit.Above-mentioned integrated list
The form that hardware had both may be used in member is realized, can also be realized in the form of SFU software functional unit.
If the integrated unit is realized in the form of SFU software functional unit and is independent product sale or uses
When, it can be stored in a computer read/write memory medium.Based on such understanding, technical scheme of the present invention is substantially
The part to contribute in other words to the prior art or all or part of the technical solution can be in the form of software products
It embodies, which is stored in a storage medium, is used including some instructions so that a computer
Equipment (can be personal computer, server or network equipment etc.) perform each embodiment the method for the present invention whole or
Part steps.And aforementioned storage medium includes：USB flash disk, read-only memory (ROM, Read-Only Memory), arbitrary access are deposited
Reservoir (RAM, Random Access Memory), mobile hard disk, magnetic disc or CD etc. are various can to store program code
Medium.
The above is only the preferred embodiment of the present invention, it is noted that for the ordinary skill people of the art
For member, various improvements and modifications may be made without departing from the principle of the present invention, these improvements and modifications also should
It is considered as protection scope of the present invention.
Claims (10)
- A kind of 1. method for merging electrical form, which is characterized in that including：The request for merging multiple bivariate tables is received, wherein, multiple bivariate tables meet preset merging condition；According to the request, the title of row or column to be combined is determined；Obtain row or column identical with the title of the row or column to be combined in multiple bivariate tables；Row or column identical with the title of the row or column to be combined in multiple bivariate tables is merged, is merged Row merges row；By row or column different from the title of the row or column to be combined in multiple bivariate tables and the merging rows or conjunction Spliced side by side, obtain new bivariate table.
- 2. according to the method described in claim 1, it is characterized in that, by multiple bivariate tables with the row to be combined or The row or column that the title of row is identical merges, after obtaining merging rows or merging row, including：Deduplication operation is carried out to the merging rows or the content for merging row.
- 3. according to the method described in claim 1, it is characterized in that, by multiple bivariate tables with the row to be combined or The different row or column of the titles of row and the merging rows merge row and are spliced, including：By in multiple bivariate tables with institute It states the different all or part of row or column of title of row or column to be combined and the merging rows or merges row and spliced.
- 4. according to the method described in claim 3, it is characterized in that, by multiple bivariate tables with the row to be combined or The different part row or column of the titles of row and the merging rows merge before row are spliced, including：It determines the title of row or column to be spliced or determines the title of the row or column without splicing.
- 5. according to the method described in claim 1, it is characterized in that, by multiple bivariate tables with the row to be combined or The different row or column of the titles of row and the merging rows merge row and are spliced, including：It determines to whether there is title in row or column different from the title of the row or column to be combined in multiple bivariate tables Identical and content is the row or column of data format；In multiple bivariate tables it is identical there are title in the row or column different from the title of the row or column to be combined and In the case of row or column of the content for data format, the row or column title is identical and that content is data format is closed And and the content of the row title cell all identical with column name is added.
- 6. a kind of device for merging electrical form, which is characterized in that including：Receiving module, for receiving the request for merging multiple bivariate tables, wherein, multiple bivariate tables meet preset merging item Part；Determining module, for according to the request, determining the title of row or column to be combined；Acquisition module, for obtaining row or column identical with the title of the row or column to be combined in multiple bivariate tables；Merging module, for row or column identical with the title of the row or column to be combined in multiple bivariate tables to be carried out Merge, obtain merging rows or merge row；Concatenation module, for by row or column different from the title of the row or column to be combined in multiple bivariate tables and institute It states merging rows or merges row and spliced, obtain new bivariate table.
- 7. device according to claim 6, which is characterized in that described device further includes：Deduplication module carries out deduplication operation for the content to the merging rows or merging row.
- 8. device according to claim 6, it is characterised in that：The concatenation module, for by whole different from the title of the row or column to be combined in multiple bivariate tables or Part row or column and the merging rows merge row and are spliced.
- 9. device according to claim 8, which is characterized in that described device further includes：First determining module, for by part row different from the title of the row or column to be combined in multiple bivariate tables Or row and the merging rows or merges before row are spliced, determine the title or determining without spelling of row or column to be spliced The title of the row or column connect.
- 10. device according to claim 6, which is characterized in that the concatenation module, including：Determination sub-module, for determining row or column different from the title of the row or column to be combined in multiple bivariate tables In with the presence or absence of the row or column that title is identical and content is data format；Merge submodule, in different from the title of the row or column to be combined row or column in multiple bivariate tables There are title in the case of row or column of the identical and content for data format, by the title is identical and content is data format Row or column merges, and the content of the row title cell all identical with column name is added.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201611112204.XA CN108153719A (en) | 2016-12-02 | 2016-12-02 | Merge the method and apparatus of electrical form |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201611112204.XA CN108153719A (en) | 2016-12-02 | 2016-12-02 | Merge the method and apparatus of electrical form |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN108153719A true CN108153719A (en) | 2018-06-12 |
Family
ID=62468430
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201611112204.XA Pending CN108153719A (en) | 2016-12-02 | 2016-12-02 | Merge the method and apparatus of electrical form |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN108153719A (en) |
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109325221A (en) * | 2018-09-27 | 2019-02-12 | 郑州云海信息技术有限公司 | The merging method and device of form document |
| CN109359275A (en) * | 2018-09-20 | 2019-02-19 | 郑州云海信息技术有限公司 | A kind of data transfer device and device |
| CN109447134A (en) * | 2018-10-11 | 2019-03-08 | 平安科技（深圳）有限公司 | Data merging method, device, computer equipment and storage medium |
| CN111143355A (en) * | 2019-12-10 | 2020-05-12 | 北京字节跳动网络技术有限公司 | Data processing method and device |
| CN111444689A (en) * | 2020-06-17 | 2020-07-24 | 广州市玄武无线科技股份有限公司 | Data-based table cell merging method and system |
| CN112256685A (en) * | 2020-10-30 | 2021-01-22 | 深圳物讯科技有限公司 | Spreadsheet-based segmentation de-duplication import method and related product |
| CN115630620A (en) * | 2022-10-31 | 2023-01-20 | 中诚智信工程咨询集团股份有限公司 | Method and system for collecting and processing engineering cost analysis data |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7165214B2 (en) * | 2002-09-05 | 2007-01-16 | Beacon Information Technology Inc. | Data management system, method, and recording medium |
| CN101876970A (en) * | 2009-12-22 | 2010-11-03 | 金蝶软件（中国）有限公司 | Method for combining reports and device thereof |
| CN102004787A (en) * | 2010-12-07 | 2011-04-06 | 江西省电力公司信息通信中心 | Method for combining multiple application scene forms based on office software plugins |
| CN102200968A (en) * | 2011-05-30 | 2011-09-28 | 深圳市五巨科技有限公司 | Method and device for removing duplications of EXCEL form data |
| CN104391832A (en) * | 2014-11-18 | 2015-03-04 | 浪潮电子信息产业股份有限公司 | Method for combining data in multiple EXCEL data sheets by using VBA (Visual Basic for Applications) |
-
2016
- 2016-12-02 CN CN201611112204.XA patent/CN108153719A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7165214B2 (en) * | 2002-09-05 | 2007-01-16 | Beacon Information Technology Inc. | Data management system, method, and recording medium |
| CN101876970A (en) * | 2009-12-22 | 2010-11-03 | 金蝶软件（中国）有限公司 | Method for combining reports and device thereof |
| CN102004787A (en) * | 2010-12-07 | 2011-04-06 | 江西省电力公司信息通信中心 | Method for combining multiple application scene forms based on office software plugins |
| CN102200968A (en) * | 2011-05-30 | 2011-09-28 | 深圳市五巨科技有限公司 | Method and device for removing duplications of EXCEL form data |
| CN104391832A (en) * | 2014-11-18 | 2015-03-04 | 浪潮电子信息产业股份有限公司 | Method for combining data in multiple EXCEL data sheets by using VBA (Visual Basic for Applications) |
Non-Patent Citations (1)
| Title |
|---|
| ZHOUHUIZHI: "excel 中如何实现上千学生成绩分类合并", 《CLUB.EXCELHOME.NET/THREAD-873282-1-1.HTML》 * |
Cited By (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109359275A (en) * | 2018-09-20 | 2019-02-19 | 郑州云海信息技术有限公司 | A kind of data transfer device and device |
| CN109359275B (en) * | 2018-09-20 | 2021-10-29 | 郑州云海信息技术有限公司 | Data conversion method and device |
| CN109325221A (en) * | 2018-09-27 | 2019-02-12 | 郑州云海信息技术有限公司 | The merging method and device of form document |
| CN109447134A (en) * | 2018-10-11 | 2019-03-08 | 平安科技（深圳）有限公司 | Data merging method, device, computer equipment and storage medium |
| CN111143355A (en) * | 2019-12-10 | 2020-05-12 | 北京字节跳动网络技术有限公司 | Data processing method and device |
| CN111143355B (en) * | 2019-12-10 | 2023-04-25 | 北京字节跳动网络技术有限公司 | Data processing method and device |
| CN111444689A (en) * | 2020-06-17 | 2020-07-24 | 广州市玄武无线科技股份有限公司 | Data-based table cell merging method and system |
| CN111444689B (en) * | 2020-06-17 | 2020-10-09 | 广州市玄武无线科技股份有限公司 | Data-based table cell merging method and system |
| CN112256685A (en) * | 2020-10-30 | 2021-01-22 | 深圳物讯科技有限公司 | Spreadsheet-based segmentation de-duplication import method and related product |
| 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 |
|---|---|---|
| CN108153719A (en) | Merge the method and apparatus of electrical form | |
| US8601361B2 (en) | Automatically populating and/or generating tables using data extracted from files | |
| CN104731881B (en) | A kind of chat record method and its mobile terminal based on communications applications | |
| CN103119588B (en) | For the method and apparatus for wishing system response is pre-rendered | |
| CN108108821A (en) | Model training method and device | |
| CN103714063B (en) | Data analysing method and its system | |
| CN104487936B (en) | Method and system for carrying out area of computer aided consumption to the information from application data file | |
| CN107918622A (en) | Commending contents, methods of exhibiting, client, server and system | |
| CN101276364A (en) | Method, system and apparatus for combining distributed computational data | |
| CN105100165B (en) | Network service recommends method and apparatus | |
| CN103164804A (en) | Personalized method and personalized device of information push | |
| CN107870927A (en) | File appraisal procedure and device | |
| CN105653545A (en) | Method and device for providing service object information in page | |
| CN107798102A (en) | A kind of page display method and device | |
| CN113238741A (en) | Form configuration method and device, electronic equipment and storage medium | |
| CN107679885A (en) | A kind of ad data acquisition methods and device | |
| CN105868311A (en) | Data analyzing method and device | |
| CN107273391A (en) | Document recommends method and apparatus | |
| CN108171189A (en) | A kind of method for video coding, video coding apparatus and electronic equipment | |
| CN106599857A (en) | Image identification method, apparatus, computer-readable storage medium and terminal device | |
| CN104484165A (en) | Browser favorites data processing method, browser client and system | |
| CN107657030A (en) | Collect method, apparatus, terminal device and storage medium that user reads data | |
| CN102609424A (en) | Method and equipment for extracting assessment information | |
| CN108153781A (en) | The method and apparatus for extracting the keyword of business scope | |
| CN104408193B (en) | The processing method and processing device of data visualization model |
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 | ||
| CB02 | Change of applicant information |
Address after: 100083 No. 401, 4th Floor, Haitai Building, 229 North Fourth Ring Road, Haidian District, Beijing Applicant after: Beijing Guoshuang Technology Co.,Ltd. Address before: 100086 Cuigong Hotel, 76 Zhichun Road, Shuangyushu District, Haidian District, Beijing Applicant before: Beijing Guoshuang Technology Co.,Ltd. |
|
| CB02 | Change of applicant information | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20180612 |
|
| RJ01 | Rejection of invention patent application after publication |