Device and method for merging cells

Abstract

The invention provides a device for merging cells. The device comprises an on-line analysis unit, a data processing unit and a merge processing unit, wherein the on-line analysis unit is used for performing on-line analysis to a data table through an on-line analysis system, so as to obtain corresponding on-line analysis slice data; the data processing unit is used for fixing dimension members in the data table and the hierarchical relationship among the dimension members according to the on-line analysis slice data; and the merge processing unit is used for performing merge operation to cells of dimension members in the same hierarchy under an identical path. The invention further provides a method for merging cells. By adopting the technical scheme, the cumbersome operation of the manual setting and combining cells by a developer according to cells with same contents is avoided, the time cost of the developer is greatly reduced, and correct data logical relationship among all cells can be guaranteed.

Description

technical field [0001] The present invention relates to the technical field of data processing, in particular to a device for merging cells and a method for merging cells. Background technique [0002] In the prior art, when merging the cells in the data table, it is often necessary to manually combine the cells. Specifically, when merging the data of the database, the data can be output to an Excel table first, Then merge manually, but in the case of a large amount of data, the manual merge operation will be cumbersome and prone to unnoticed errors. At the same time, some software also provides methods for directly merging related cells, but only decides whether the merging operation is based on whether the cell values ​​are the same, and ignores business attributes other than cell values, often resulting in large errors. [0003] Therefore, a new technology for merging cells is needed, which can avoid the tedious operation of manually setting the combined cells for the sa...

AI Technical Summary

Problems solved by technology

[0002] In the prior art, when merging the cells in the data table, it is often necessary to manually combine the cells. Specifically, when merging the data of the database, the data can be output to an Excel table first, Then merge manually, but in the case of a large amount of data, the manual merge operation will be more cumbersome, and it is prone to unnoticed errors

At the same time, some software also provides a method for directly merging related cells, but only determines whether the cell values ​​are the same, and ignores business attributes other than cell values, often resulting in large errors

[0003] Therefore, a new technology for merging cells is needed, which can avoid the tedious operation of manually setting the combined cells for the same content cells, save developers a lot of time and cost, and ensure that the cells are kept correct. data logical relationship

Images