Table derivation method, apparatus, computer device, and storage medium

Abstract

The invention discloses a table deriving method, an apparatus, a computer device and a storage medium. The method comprises the following steps: if the user input request information of the table to be exported for export is received, the number of rows N and the number of columns M of the table to be exported are obtained; if the user input request information of the table to be exported for export is received, the number of rows N and columns M of the table to be exported are obtained. Converting data of cells in a table to be exported into a two-dimensional data table; dividing the two-dimensional data table into a mergeable region and an unmergeable region according to a preset safety row n and a safety column m; judging whether a rectangular region in which the two-dimensional data inall the two-dimensional cells are equal exists in the mergable region of the two-dimensional data table, and merging the two-dimensional cells in the mergable region according to the judging result to obtain the merged two-dimensional data table; exporting the merged two-dimensional data table to an Excel spreadsheet. The table exporting method has good universality, does not need to select the exporting method before exporting the table, and can greatly improve the efficiency of exporting the tables of various styles.

Description

technical field

[0001] The present invention relates to the field of computer technology, in particular to a table export method, device, computer equipment and storage medium. Background technique

[0002] In the process of daily work, it is necessary to export tables of various styles on the webpage to Excel spreadsheets, and save all the tables as spreadsheets in Excel format, which can facilitate users to process spreadsheets in a uniform format.

[0003] In the traditional technical method, a corresponding export method needs to be formulated for a table of a specific style. Therefore, a variety of corresponding export methods must be formulated for a table of various styles to export the table to an Excel spreadsheet. It takes a lot of time to formulate the export method. Human and material resources. And because the traditional technical method contains multiple export methods, it is difficult to maintain and manage the export methods. Before exporting the table, the...

Images