Spreadsheet generation method and system based on cell father grid calculation

Abstract

The invention discloses a spreadsheet generation method and system based on cell father lattice calculation, and the method comprises the steps: designing a table template based on a front-end table template designer, and filling the table template with prepared table page information, table cell attribute information and data information; verifying and analyzing the table template, and generating table basic attribute information; according to the basic attribute information of the table, dynamically calculating a father lattice of each cell; calculating an original data set of each cell according to the basic attribute information of the table; dynamically calculating a cell data set according to the father cell of each cell and the original data set; the cell data set is optimized, data binding of all cells is completed through mapping, and the data size of all the cells is obtained; calculating cell paging information according to the data volume of each cell; calculating the positions of the cells, constructing a table structure, and completing the rendering generation of the table; according to the method, the flexibility and the efficiency of the complex spreadsheet in the generation process can be effectively improved.

Description

Technical Field

[0001] The present invention relates to an electronic table generation method and system, in particular to an electronic table generation method and system based on cell parent cell calculation, belonging to the field of computer software technology. Background Art

[0002] Currently, complex spreadsheets are generated based on the cells of the table. Cells are expanded by configuring the cell's attribute information, such as extended information, dependency information, data information, etc., and the tree structure between cells is constructed by parsing the dependency information. However, the specification of dependency relationships mostly relies on the user's manual configuration. The tree structure constructed in this way is often simple in level. In the case of complex table structures, such as a cell can specify multiple dependencies, or the cell does not specify dependencies, this method cannot solve the problem. At the same time, in the face of complex data display needs, users need to manually aggregate the data of each cell. If the same spreadsheet needs to display data from multiple data sources, this method cannot meet the needs of data aggregation at different granularities. It lacks flexibility and has a single application scenario. Summary of the invention

[0003] Purpose of the invention: The purpose of the present invention is to provide a method and system for generating an electronic table based on cell parent calculation, which can improve the flexibility and efficiency of the electronic table generation process.

[0004] Technical solution: The electronic table generation method based on cell parent cell calculation of the present invention comprises:

[0005] S1: Design a table template based on the front-end table template designer, and fill the prepared table page information, table cell attribute information and data information in the table template;

[0006] S2: verify and parse the table template to generate basic table attribute information, where the basic table attribute information includes table page information, table cell attribute information, and data information converted into JSON format;

[0007] S3: Dynamically calculate the parent cell of each cell according to the basic attribute information of the table;

[0008] S4: Calculate the original data set of each cell according to the basic attribute information of the table;

[0009] S5: dynamically calculate the cell data set according to the parent cell and the original data set of each cell;

[0010] S6: Optimize the cell data set, complete the data binding of each cell through mapping, and obtain the data volume of each cell;

[0011] S7: Calculate cell paging information according to the amount of data in each cell;

[0012] S8: Calculate the cell position, build the table structure, and complete the rendering and generation of the table.

[0013] Furthermore, the table page information in step S1 includes page size information and page background information;

[0014] The table cell attribute information includes cell row and column information, cell style information, cell value type information, cell aggregation type information, cell parent cell information, cell expansion direction information and cell condition attribute information;

[0015] The data information includes data source information and data set information.

[0016] Furthermore, the cell row and column information includes the row and column where the cell is located, the repeated hidden attribute information of the row and column, and the cell name;

[0017] The cell style information includes cell border, background and font information;

[0018] The cell value type information includes text type, data type, image type and expression type;

[0019] The cell aggregation type information includes grouping aggregation mode, list aggregation mode, summation aggregation mode, summary aggregation mode, maximum and minimum value aggregation mode and average value aggregation mode;

[0020] The cell parent cell information includes the cell's no parent cell information, left parent cell information, and upper parent cell information;

[0021] The cell expansion direction information indicates the expansion direction of the data when the cell value is a data value or an expression value, and the expansion direction includes horizontal expansion, vertical expansion and no expansion;

[0022] The cell condition attribute information is mainly used to specify how to process the cell value, including but not limited to filtering, format conversion, filling blank values, and custom display values.

[0023] Furthermore, the step S3 comprises:

[0024] For each cell, the cell parent cell information is obtained according to the converted table basic information. If the cell parent cell information is left parent cell information or upper parent cell information, the parent cell of the cell is determined according to the cell parent cell information.

[0025] If there is no parent cell information, the default parent cell of the cell is calculated according to the default parent cell calculation rule, and the default parent cell calculation rule is as follows: the default left parent cell is the cell in the same row that has the largest number of columns to the left of the current cell and has a vertical expansion direction; the default upper parent cell is the cell in the same column that has the largest number of rows to the upper side of the current cell and has a horizontal expansion direction;

[0026] If it is calculated according to the default parent cell rule that the cell has no default parent cell, the regional parent cell of the cell is calculated according to the regional parent cell calculation rule. In the regional parent cell calculation rule, the region refers to the range of rows and columns between any parent and child cells. Let the row region be [R1, R2), where R1 is the row where the child cell is located, R2 is the row where the parent cell is located, and the column region be [C1, C2), where C1 is the column where the child cell is located, and C2 is the column where the parent cell is located; if the row and column where the cell is located are within a certain regional range, then the left parent cell of the cell is the parent cell constituting the row regional range, and the upper parent cell is the parent cell constituting the column regional range;

[0027] If it is calculated according to the regional parent cell calculation rule that the cell has no regional parent cell, the cell is regarded as a root parent cell, and the cell has neither a left parent cell nor an upper parent cell.

[0028] Furthermore, the step S4 comprises:

[0029] For each cell, the converted data information and the cell value type information in the table cell attribute information are obtained according to the table basic attribute information, all corresponding data are obtained according to the data source information and data set information in the data information, and all data are mapped to the cell through the cell value type information to obtain the original data set of the cell.

[0030] Furthermore, the step S5 comprises:

[0031] S5.1: Obtain the aggregation type information of each cell, the basic attribute information of the parent table, the cell value type information and the original data set;

[0032] S5.2: Determine the cell value type information of each cell and its parent cell. If the corresponding value type is not a data type, it is considered that the cell has no aggregation mode.

[0033] S5.3: The original data set of the cell is processed according to the cell aggregation type information of each cell and its parent cell, to obtain the cell data set and the mapping relationship between the data value of the parent cell and the data value of the child cell.

[0034] Furthermore, the step S6 includes: optimizing the cell data set according to a preset method to obtain valid data of each cell, completing data binding of each cell through mapping, and obtaining data volume of each cell.

[0035] Furthermore, the step S7 includes: calculating the cells that need to be presented on each page according to the data volume of each cell and the table page information.

[0036] Furthermore, the step S8 comprises:

[0037] S8.1: Get all root parent cells, loop through them in row order to determine whether they contain child cells. If no child cells exist, expand new cells according to the bound cell data set, calculate the cell position, and update the cell attribute information;

[0038] S8.2: If the root cell has sub-cells, traverse and process the sub-cells in row order to determine whether the sub-cells contain other parent cells. If so, obtain the basic table attribute information of all parent cells and expand the cell according to the expansion direction of the parent cells and sub-cells. If not, obtain the expansion direction of the current cell and its sub-cells.

[0039] S8.3: Determine whether the sub-grid contains a deeper sub-grid. If so, recursively process according to step S8.2; if not, expand the new cell according to the expansion direction and the mapping relationship between the current cell and the cell data value of its sub-grid, and update the cell position information such as row and column and cell attribute information;

[0040] S8.4: Calculate all expanded cells, build a new table structure according to the paging information, and complete the rendering and generation of the table.

[0041] Based on the same inventive concept, the present invention also provides an electronic table generation system based on cell parent cell calculation, comprising:

[0042] An initialization module is used to design a table template based on a front-end table template designer, and fill the table template with prepared table page information, table cell attribute information, and data information;

[0043] A preprocessing module is used to verify and parse the table template and generate basic table attribute information, wherein the basic table attribute information includes table page information, table cell attribute information and data information converted into JSON format;

[0044] The parent cell calculation module is used to dynamically calculate the parent cell of each cell based on the basic attribute information of the table;

[0045] The data set calculation module is used to calculate the original data set of each cell according to the basic attribute information of the table;

[0046] The data set confirmation module is used to dynamically calculate the cell data set according to the parent cell and the original data set of each cell;

[0047] The optimized binding module is used to optimize the processing of the cell data set, complete the binding of each cell data through mapping, and obtain the data volume of each cell;

[0048] Paging module, used to calculate cell paging information according to the amount of data in each cell;

[0049] The table generation module is used to calculate the cell position, build the table structure, and complete the rendering and generation of the table.

[0050] Beneficial effects: Compared with the prior art, the present invention uses cells as the basic unit of the table, and dynamically calculates the data set and expanded position information of the child cells by calculating the parent cell information of all cells, thereby completing the generation of complex tables, greatly improving the flexibility and ease of complex table production, and improving the efficiency of data analysis, which is of certain help in report production, visual display and other fields. BRIEF DESCRIPTION OF THE DRAWINGS

[0051] Figure 1 is a flow chart of a method according to an embodiment of the present invention;

[0052] Figure 2 A flow chart of parent cell calculation according to an embodiment of the present invention;

[0053] Figure 3 A flowchart for constructing a table structure according to an embodiment of the present invention. DETAILED DESCRIPTION

[0054] In order to enable those skilled in the art to better understand the solution of the present application, the technical solution in the embodiments of the present application will be clearly and completely described below in conjunction with the drawings in the embodiments of the present application.

[0055] As attached Figure 1 As shown, the electronic table generation method based on cell parent cell calculation of this embodiment includes:

[0056] S1: Design a table template based on the front-end table template designer, and fill the prepared table page information, table cell attribute information and data information in the table template;

[0057] S2: verify and parse the table template to generate basic table attribute information, where the basic table attribute information includes table page information, table cell attribute information, and data information converted into JSON format;

[0058] S3: Dynamically calculate the parent cell of each cell according to the basic attribute information of the table;

[0059] S4: Calculate the original data set of each cell according to the basic attribute information of the table;

[0060] S5: dynamically calculate the cell data set according to the parent cell and the original data set of each cell;

[0061] S6: Optimize the cell data set, complete the data binding of each cell through mapping, and obtain the data volume of each cell;

[0062] S7: Calculate cell paging information according to the amount of data in each cell;

[0063] S8: Calculate the cell position, build the table structure, and complete the rendering and generation of the table.

[0064] Specifically, the table template in step S1 of the embodiment of the present invention is implemented based on existing products, mainly a table template designer. The table template designer uses cells as the basic unit. The user fills in the table cell attribute information and data information through the table template designer, and configures the table page information, thereby completing the template design. The table page information that needs to be configured includes the size information of the page and the background information of the page. The size information of the page includes but is not limited to the width and height of the page and the size of the margin of the page. The background information of the page includes but is not limited to the picture background of the page and the color background of the page.

[0065] The cell attribute information that users need to configure includes cell row and column information, cell style information, cell value type information, cell aggregation type information, cell parent cell information, cell expansion direction information, and cell condition attribute information. The cell row and column information refers to the row and column where the cell is located, the repeated hidden attribute information of the row and column, and the cell name. For example, if the cell is in the second row and third column, the name of the cell is C3. The cell style information includes information such as cell borders, backgrounds, and fonts. The cell value type information includes text type, data type, image type, expression type, etc. The cell aggregation type information includes grouping aggregation mode, list aggregation mode, summation aggregation mode, summary aggregation mode, maximum and minimum aggregation mode, and average aggregation mode. The cell parent cell information includes the cell's no parent cell information, left parent cell information, and upper parent cell information. The cell expansion direction information indicates the direction of data expansion when the cell value is a data value or an expression value, which is mainly divided into horizontal expansion, vertical expansion, and no expansion. The cell condition attribute information is mainly used to specify how to further process the cell data set, including but not limited to filtering, format conversion, filling blank values, custom display values, etc.

[0066] The data information that users need to configure includes data source information and data set information.

[0067] In step S2, the embodiment of the present invention verifies and parses the table template to generate basic attribute information of the table, mainly parsing the template designed by the user through the table template designer, and converting the template information into a more easily processed JSON object, whose content mainly includes all the table page information, table cell attribute information and data information of the table.

[0068] In step S3, the embodiment of the present invention mainly calculates the parent cell of each cell and expands the structure of the child cell through the structure of the parent cell, thereby constructing the overall structure of the table. The calculation process of the parent cell is as follows: Figure 2 As shown:

[0069] Step S3.1: For any cell, obtain the cell parent cell information according to the basic information of the table. If it is the left parent cell information and the upper parent cell information, the parent cell of the cell is determined according to the information;

[0070] Step S3.2: If there is no parent cell information, calculate the default parent cell of the cell. The default parent cell calculation rules are as follows: the default left parent cell is the cell in the same row that is the largest number of columns away from the left side of the current cell and has a vertical expansion direction; the default upper parent cell is the cell in the same column that is the largest number of rows away from the upper side of the current cell and has a horizontal expansion direction. For example, if you want to calculate the default parent cell of cell D6, the following cells exist in the same row and column of cell D6: A6-C6, E6-G6, of which C6 has no expansion and the others have vertical expansion. The cells in the same column are D1-D5, D7-D9, of which D5 has no expansion and the others have horizontal expansion. According to the above default parent cell calculation rules, the default left parent cell of D6 is B6, and the default upper parent cell is D4;

[0071] Step S3.3: If the cell has no default parent cell according to the above default parent cell rule, the regional parent cell of the cell needs to be calculated. The regional parent cell calculation rule is as follows: The region refers to the range of rows and columns between any parent and child cells, that is, the row region is [R1, R2), where R1 is the row where the child cell is located, R2 is the row where the parent cell is located, and the column region is [C1, C2), where C1 is the column where the child cell is located, and C2 is the column where the parent cell is located. If the row and column where the cell is located are within a certain regional range, the left parent cell of the cell is the parent cell that constitutes the row regional range, and the upper parent cell is the parent cell that constitutes the column regional range.

[0072] In step S3.4, if it is calculated according to the above regional parent cell rule that the cell has no regional parent cell, the cell is regarded as a root parent cell, that is, the cell has neither a left parent cell nor an upper parent cell.

[0073] In step S4, the original data of the cell proposed in the embodiment of the present invention is mainly obtained by obtaining data information and cell value type information through the basic attribute information of the table, obtaining all data according to the data source information and data set information in the data information, and then mapping the data to the cell through the cell value type information, and the data is regarded as the original data set of the cell. If the data information is in a database environment, the database is connected according to the data source information, that is, the connection information of the database, and then the SQL is executed to obtain the data through the data set information, that is, the specific SQL statement, and then the data set corresponding to the cell is obtained through the cell value type configuration, that is, the field in the data corresponding to the cell value.

[0074] In step S5, the dynamic calculation of the cell data set proposed in the embodiment of the present invention is to calculate the cell data set and the mapping relationship between the cell data set and the parent cell data set through the aggregation type of the parent cell and the original data set of the parent cell. The main steps are as follows:

[0075] Step S5.1: Obtain cell aggregation type information, parent cell table basic attribute information, cell value type information and original data set;

[0076] Step S5.2: Determine the cell value type of the cell and its parent cell. If the value type is not a data type, it is considered that the cell has no aggregation mode.

[0077] Step S5.3: Process the original data set of the cell according to the aggregation type of the cell and its parent cell to obtain the cell data set and the mapping relationship between the data value of the parent cell and the data value of the child cell. The processing rules are as follows: List aggregation refers to traversing the data set. For example, if the original data set is [2,6,2,1,3], it is still [2,6,2,1,3] after list aggregation; Group aggregation refers to grouping the data set. For example, if the original data set is [2,6,2,1,3], it is [2,6,1,3] after group aggregation; Sum, aggregation, Maximum, minimum, and average aggregation refer to the aggregation of data sets. For example, if the original data set is [2,6,2,1,3], the sum after aggregation is 14. The data set of a cell is the result of the dynamic combination and calculation of the original data set of the cell and the original data set of the parent cell according to the aggregation type, and there is a mapping relationship with the data set of its parent cell. For example, the original data set of cell D6 is A1, the original data set of its left parent cell is A2, and the original data set of the upper parent cell is A3. When the aggregation method is list aggregation, the final mapping relationship is […A1,…A2,…A3]. The mapping relationship when the cell aggregation type is list aggregation is shown in Table 1:

[0078] Table 1 List aggregation method cell mapping relationship table

[0079]

[0080]

[0081] In step S6 of this embodiment, the cell data set is processed according to a preset processing method, which is a further processing of the cell data set. The processing method includes: filtering, format type conversion, blank value supplementation, custom display value, etc. The processed data is the valid data of the cell, and then the cell data is bound through mapping to obtain the data amount of each cell.

[0082] In step S7 of this embodiment, when facing a large number of situations, it is necessary to display the table in pages to optimize performance. Calculating cell paging information means calculating the cells that need to be presented on each page based on the cell data volume and table page information.

[0083] The calculation of the cell position and the construction of the table structure proposed in step S8 of this embodiment are as follows: Figure 3 As shown, the steps include:

[0084] Step S8.1: Get all root parent cells, loop through them in row order to determine whether they contain child cells. If no child cells exist, expand new cells according to the bound cell values, calculate the cell positions, and update the cell attribute information.

[0085] Step S8.2: If the root cell has sub-cells, traverse and process the sub-cells in row order to determine whether the sub-cells contain other parent cells. If so, obtain the table basic attribute information of all parent cells and expand the cell according to the expansion direction of the parent cells and sub-cells; if not, obtain the expansion direction of the current cell and its sub-cells;

[0086] Step S8.3: Determine whether the sub-grid contains a deeper sub-grid. If so, recursively process according to step S8.2; if not, expand the new cell according to the expansion direction and the mapping relationship between the current cell and the cell data value of its sub-grid, and update the cell position information such as row and column and cell attribute information;

[0087] Step S8.4: Calculate all expanded cells, and build a new table structure according to the paging information to complete the rendering and generation of the table.

[0088] Based on the same inventive concept, this embodiment also provides an electronic table generation system based on cell parent cell calculation, including:

[0089] An initialization module is used to design a table template based on a front-end table template designer, and fill the table template with prepared table page information, table cell attribute information, and data information;

[0090] A preprocessing module is used to verify and parse the table template and generate basic table attribute information, wherein the basic table attribute information includes table page information, table cell attribute information and data information converted into JSON format;

[0091] The parent cell calculation module is used to dynamically calculate the parent cell of each cell based on the basic attribute information of the table;

[0092] The data set calculation module is used to calculate the original data set of each cell according to the basic attribute information of the table;

[0093] The data set confirmation module is used to dynamically calculate the cell data set according to the parent cell and the original data set of each cell;

[0094] The optimized binding module is used to optimize the processing of the cell data set, complete the binding of each cell data through mapping, and obtain the data volume of each cell;

[0095] Paging module, used to calculate cell paging information according to the amount of data in each cell;

[0096] The table generation module is used to calculate the cell position, build the table structure, and complete the rendering and generation of the table.

[0097] The example of the present invention mainly uses cells as the basic unit of the table, and dynamically calculates the data set and expanded position information of the child cells by calculating the parent cell information to which all cells belong, thereby completing the generation of complex tables, greatly improving the flexibility and ease of complex table production, and improving the efficiency of data analysis, which is of certain help in report production, visual display and other fields.

Claims

1. A method for generating an electronic table based on cell parent calculation, characterized in that: include: S1: Design a table template based on the front-end table template designer, and fill the prepared table page information, table cell attribute information and data information in the table template; S2: verify and parse the table template to generate basic table attribute information, where the basic table attribute information includes table page information, table cell attribute information, and data information converted into JSON format; S3: Dynamically calculate the parent cell of each cell according to the basic attribute information of the table; S4: Calculate the original data set of each cell according to the basic attribute information of the table; S5: dynamically calculate the cell data set according to the parent cell and the original data set of each cell; S6: Optimize the cell data set, complete the data binding of each cell through mapping, and obtain the data volume of each cell; S7: Calculate cell paging information according to the amount of data in each cell; S8: Calculate the cell position, build the table structure, and complete the rendering and generation of the table.

2. The electronic table generation method based on cell parent calculation according to claim 1, characterized in that: Step S1: the table page information includes the size information of the page and the background information of the page; The table cell attribute information includes cell row and column information, cell style information, cell value type information, cell aggregation type information, cell parent cell information, cell expansion direction information and cell condition attribute information; The data information includes data source information and data set information.

3. The electronic table generation method based on cell parent cell calculation according to claim 2 is characterized in that: The cell row and column information includes the row and column where the cell is located, the repeated hidden attribute information of the row and column, and the cell name; The cell style information includes cell border, background and font information; The cell value type information includes text type, data type, image type and expression type; The cell aggregation type information includes grouping aggregation mode, list aggregation mode, summation aggregation mode, summary aggregation mode, maximum and minimum value aggregation mode and average value aggregation mode; The cell parent cell information includes the cell's no parent cell information, left parent cell information, and upper parent cell information; The cell expansion direction information indicates the expansion direction of the data when the cell value is a data value or an expression value, and the expansion direction includes horizontal expansion, vertical expansion and no expansion; The cell condition attribute information is mainly used to specify how to process the cell value, including but not limited to filtering, format conversion, filling blank values, and custom display values.

4. The electronic table generation method based on cell parent cell calculation according to claim 3 is characterized in that: The step S3 comprises: For each cell, the cell parent cell information is obtained according to the converted table basic information. If the cell parent cell information is left parent cell information or upper parent cell information, the parent cell of the cell is determined according to the cell parent cell information. If there is no parent cell information, the default parent cell of the cell is calculated according to the default parent cell calculation rule, and the default parent cell calculation rule is as follows: the default left parent cell is the cell in the same row that has the largest number of columns to the left of the current cell and has a vertical expansion direction; the default upper parent cell is the cell in the same column that has the largest number of rows to the upper side of the current cell and has a horizontal expansion direction; If it is calculated according to the default parent cell rule that the cell has no default parent cell, the regional parent cell of the cell is calculated according to the regional parent cell calculation rule. In the regional parent cell calculation rule, the region refers to the range of rows and columns between any parent and child cells. Let the row region be [R1, R2), where R1 is the row where the child cell is located, R2 is the row where the parent cell is located, and the column region be [C1, C2), where C1 is the column where the child cell is located, and C2 is the column where the parent cell is located; if the row and column where the cell is located are within a certain regional range, then the left parent cell of the cell is the parent cell constituting the row regional range, and the upper parent cell is the parent cell constituting the column regional range; If it is calculated according to the regional parent cell calculation rule that the cell has no regional parent cell, the cell is regarded as a root parent cell, and the cell has neither a left parent cell nor an upper parent cell.

5. The electronic table generation method based on cell parent calculation according to claim 4 is characterized in that: The step S4 comprises: For each cell, the converted data information and the cell value type information in the table cell attribute information are obtained according to the table basic attribute information, all corresponding data are obtained according to the data source information and data set information in the data information, and all data are mapped to the cell through the cell value type information to obtain the original data set of the cell.

6. The electronic table generation method based on cell parent calculation according to claim 5, characterized in that: The step S5 comprises: S5.1: Obtain the aggregation type information of each cell, the basic attribute information of the parent cell, the cell value type information and the original data set; S5.2: Determine the cell value type information of each cell and its parent cell. If the corresponding value type is not a data type, it is considered that the cell has no aggregation mode. S5.3: The original data set of the cell is processed according to the cell aggregation type information of each cell and its parent cell, to obtain the cell data set and the mapping relationship between the data value of the parent cell and the data value of the child cell.

7. The electronic table generation method based on cell parent calculation according to claim 6 is characterized in that: The step S6 includes: optimizing the cell data set according to a preset method to obtain valid data of each cell, completing data binding of each cell through mapping, and obtaining data volume of each cell.

8. The electronic table generation method based on cell parent calculation according to claim 7 is characterized in that: The step S7 includes: calculating the cells that need to be presented on each page according to the data volume of each cell and the table page information.

9. The electronic table generation method based on cell parent cell calculation according to claim 8, characterized in that: The step S8 comprises: S8.1: Get all root parent cells, loop through them in row order to determine whether they contain child cells. If no child cells exist, expand new cells according to the bound cell data set, calculate the cell position, and update the cell attribute information; S8.2: If the root cell has sub-cells, traverse and process the sub-cells in row order to determine whether the sub-cells contain other parent cells. If so, obtain the basic table attribute information of all parent cells and expand the cell according to the expansion direction of the parent cells and sub-cells. If not, obtain the expansion direction of the current cell and its sub-cells. S8.3: Determine whether the sub-grid contains a deeper sub-grid. If so, recursively process according to step S8.2; if not, expand the new cell according to the expansion direction and the mapping relationship between the current cell and the cell data value of its sub-grid, and update the cell position information such as row and column and cell attribute information; S8.4: Calculate all expanded cells, build a new table structure according to the paging information, and complete the rendering and generation of the table.

10. A spreadsheet generation system based on cell parent cell calculation, characterized in that: include: An initialization module is used to design a table template based on a front-end table template designer, and fill the table template with prepared table page information, table cell attribute information, and data information; A preprocessing module is used to verify and parse the table template and generate basic table attribute information, wherein the basic table attribute information includes table page information, table cell attribute information and data information converted into JSON format; The parent cell calculation module is used to dynamically calculate the parent cell of each cell based on the basic attribute information of the table; The data set calculation module is used to calculate the original data set of each cell according to the basic attribute information of the table; The data set confirmation module is used to dynamically calculate the cell data set according to the parent cell and the original data set of each cell; The optimized binding module is used to optimize the processing of the cell data set, complete the binding of each cell data through mapping, and obtain the data volume of each cell; Paging module, used to calculate cell paging information according to the amount of data in each cell; The table generation module is used to calculate the cell position, build the table structure, and complete the rendering and generation of the table.

Images