Welcome to Francis Academic Press

Academic Journal of Computing & Information Science, 2024, 7(5); doi: 10.25236/AJCIS.2024.070514.

Automatic Generation Method for Tables with Merged Cells

Author(s)

Maolong Teng1, Zhinan Lin2, Chaoyue Liu3

Corresponding Author:
Zhinan Lin
Affiliation(s)

1Hunan University of Science and Technology, Xiangtan, China

2Hunan Vocational Institute of Technology, Xiangtan, China

3Guizhou Provincial Transportation Planning Survey and Design Research Institute Co., Ltd., Guiyang, China

Abstract

This paper proposes a complex table generation method based on a multi tree structure to address the problems of large data volume, repetitive and cumbersome processes, and inability to automatically adjust the structure according to data content in the current automatic table generation process. This method uses a tree structure to represent data tables, categorizes the nodes in the tree structure in detail, and sets corresponding properties and methods according to different generation requirements. This tree structure is defined as a multi-dimensional relationship oriented table structure tree. In the process of automatic table generation, a method for automatic data query and a method for calculating the number of rows and columns that need to be merged based on the correlation between data are designed. This method improves the efficiency and accuracy of table making, and can effectively adapt to the diversity and complexity of table structures. It can not only adapt to different scenarios and requirements of table generation tasks, but also improve the efficiency and accuracy of table generation.

Keywords

Automatically generate tables, Cell merging, Related relationships

Cite This Paper

Maolong Teng, Zhinan Lin, Chaoyue Liu. Automatic Generation Method for Tables with Merged Cells. Academic Journal of Computing & Information Science (2024), Vol. 7, Issue 5: 109-115. https://doi.org/10.25236/AJCIS.2024.070514.

References

[1] Hu J, Kashi R S, Lopresti D P, et al. Medium-independent table detection[C]//Document Recognition and Retrieval VII. SPIE, 1999, 3967: 291-302.

[2] Aithal S G, Rao A B, Singh S. Automatic question-answer pairs generation and question similarity mechanism in question answering system[J]. Applied Intelligence, 2021: 1-14.

[3] Gottschalk S, Demidova E. Tab2KG: Semantic table interpretation with lightweight semantic profiles [J]. Semantic Web, 2022, 13(3): 571-597.

[4] Li Jinhao. Research and practice of report automatic generation technology based on C # [J]. Modern Computer, 2020, (36): 95-99

[5] Zehra S, Mohsin S F M, Wasi S, et al. Financial knowledge graph based financial report query system [J]. IEEE Access, 2021, 9: 69766-69782.