CN114218903A

CN114218903A - Table data processing method and device, computer equipment and storage medium

Info

Publication number: CN114218903A
Application number: CN202111474446.4A
Authority: CN
Inventors: 万建新; 王利丹
Original assignee: Kingdee Software China Co Ltd
Current assignee: Kingdee Software China Co Ltd
Priority date: 2021-12-04
Filing date: 2021-12-04
Publication date: 2022-03-22

Abstract

The application relates to a table data processing method, a table data processing device, a computer device, a storage medium and a computer program product. The method comprises the following steps: determining at least one table to be filled in the table sample layer, wherein the table to be filled corresponds to a region symbol, and the region symbol represents a filling range of actual data in the table to be filled; constructing a dimension table in the same range in the data layer according to the range represented by the region symbol, wherein dimension combination information corresponding to the data to be filled in the table to be filled and the relative position of the corresponding cell relative to the region symbol are stored in each cell in the dimension table; and performing association storage on the table sample layer and the dimension table, wherein the table sample layer and the dimension table which are stored in association are used for generating a complete data table. By adopting the method, the storage space can be greatly saved.

Description

Table data processing method and device, computer equipment and storage medium

Technical Field

The present application relates to the field of data processing technologies, and in particular, to a method and an apparatus for processing table data, a computer device, a storage medium, and a computer program product.

Background

In software systems, tabular data is typically presented in a tabular-like form. The form template is provided with a form sample layer, a data layer and the like, and each layer uses an independent two-dimensional form to store information. The cells in the data layer store dimension information of the data, and the cells in the sample layer store sample information.

However, in the conventional technology, no matter how many areas are actually used by the form template, even if only a small area of the form is filled with data, cells in the data layer need to correspond to the form layer one to one, and the form with the same size as the form layer is used, which results in that the data layer occupies a large storage space and consumes a large amount of storage resources.

Disclosure of Invention

In view of the foregoing, it is desirable to provide a table data processing method, apparatus, computer device, computer readable storage medium and computer program product capable of reducing storage resources.

In a first aspect, the present application provides a method for processing tabular data. The method comprises the following steps:

determining at least one table to be filled in a table sample layer, wherein the table to be filled corresponds to a region symbol, and the region symbol represents a filling range of actual data in the table to be filled;

constructing a dimension table in the same range in the data layer according to the range represented by the region symbol, wherein dimension combination information corresponding to the data to be filled in the table to be filled and the relative position of the corresponding cell relative to the region symbol correspond to each cell in the dimension table;

and performing association storage on the table sample layer and the dimension table, wherein the table sample layer and the dimension table which are stored in association are used for generating a complete data table.

In one embodiment, the method comprises:

determining target dimension combination information, and extracting corresponding actual data from a data source according to the target dimension combination information;

determining an actual filling position corresponding to the actual data in a sample layer according to a region symbol corresponding to a target table to be filled corresponding to the target dimension combination information and a relative position of the target dimension combination information in a dimension table;

filling the actual data into a target cell corresponding to the actual filling position;

and generating a complete data table based on the form sample information of the target form to be filled and the actual data filled in the target cells.

In one embodiment, the determining, according to the region identifier corresponding to the target table to be filled corresponding to the target dimension combination information and the relative position of the target dimension combination information in the dimension table, the actual filling position corresponding to the actual data in the table sample layer includes:

determining the initial position of the filling range of the actual data in the target table to be filled according to the region symbol corresponding to the target table to be filled corresponding to the target dimension combination information;

and determining an actual filling position corresponding to the actual data in the sample layer based on the sum of the starting position and the relative position of the target dimension combination information in the dimension table.

In one embodiment, the method further comprises:

receiving a table adjustment instruction, wherein the table adjustment instruction carries a line sequence adjustment amount and/or a column sequence adjustment amount;

updating the region symbol corresponding to each table to be filled in the table sample layer according to the adjustment amount in the table adjustment instruction;

and realizing the row sequence adjustment and/or the column sequence adjustment of the corresponding table to be filled in the table sample layer according to the new filling range represented by the updated region symbol.

In one embodiment, the method further comprises:

when the dimension combination information stored in any cell in the dimension table contains various dimension combinations, determining table rows and/or table columns corresponding to the dimensions in the corresponding table to be filled in the table sample layer according to the dimensions corresponding to the dimension combinations;

and respectively updating the form sample information corresponding to the table rows and/or the table columns into dimension combination information of corresponding dimension combinations.

In one embodiment, the determining at least one table to be filled in the table sample layer includes:

acquiring a region symbol of a form to be filled based on an input operation triggered on a region setting interface, and generating the form to be filled in a corresponding range according to the region symbol; or

Based on the selected operation of at least one cell in the table display interface, determining the starting position and the ending position of the table to be filled, and generating the table to be filled in the corresponding range based on the starting position and the ending position.

In a second aspect, the present application further provides a table data processing apparatus. The device comprises:

In a third aspect, the present application also provides a computer device. The computer device comprises a memory storing a computer program and a processor implementing the following steps when executing the computer program:

In a fourth aspect, the present application further provides a computer-readable storage medium. The computer-readable storage medium having stored thereon a computer program which, when executed by a processor, performs the steps of:

In a fifth aspect, the present application further provides a computer program product. The computer program product comprising a computer program which when executed by a processor performs the steps of:

According to the table data processing method, the table data processing device, the computer equipment, the storage medium and the computer program product, the dimension table in the same range is constructed in the data layer according to the filling range of the actual data of the table to be filled in the table sample layer, the table with the same size as the table sample layer is not required to be used, and then the table sample layer and the dimension table are subjected to associated storage, so that the storage of the table sample of the table and the data area is decoupled, and the total storage space is greatly reduced.

Drawings

FIG. 1 is a flow diagram illustrating a method for processing tabular data in one embodiment;

FIG. 2 is a schematic illustration of a zone setting interface in one embodiment;

FIG. 3 is a flowchart illustrating steps of a terminal generating a complete data table according to an embodiment;

FIG. 4 is a flowchart illustrating steps performed by the terminal to determine actual fill locations in the table sample layer corresponding to actual data in one embodiment;

FIG. 5 is a flowchart illustrating steps of a terminal implementing row sequence adjustment and/or column sequence adjustment of a corresponding table to be filled in a table sample layer according to an embodiment;

FIG. 6 is a flowchart illustrating steps executed by the terminal when dimension combination information stored in any cell in the dimension table includes multiple dimension combinations in one embodiment;

FIG. 7 is a diagram of a table variation in one embodiment;

FIG. 8 is a schematic view of a table sample layer in one embodiment;

FIG. 9 is a diagram of data layers in one embodiment;

FIG. 10 is a diagram of a complete table in one embodiment;

FIG. 11 is a block diagram showing the structure of a table data processing apparatus according to an embodiment;

FIG. 12 is a diagram illustrating an internal structure of a computer device according to an embodiment.

Detailed Description

In order to make the objects, technical solutions and advantages of the present application more apparent, the present application is described in further detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are merely illustrative of the present application and are not intended to limit the present application.

When the table is generated at present, the cells in the table sample layer store table sample information (such as literal description information and background color filling), and the cells in the data layer store dimension information of data (such as organization A subject 1). When the report is displayed, acquiring data (such as 10000) corresponding to the dimension (such as organization A subject 1) from the database according to the dimension information of the data layer, and filling the data into the sample layer for displaying.

In view of the above, the present application provides a table data processing method, apparatus, computer device, storage medium and computer program product, which structurally split a table, and store dimension combination information by using independent tables, so as to decouple the storage of table samples and data areas, thereby greatly reducing the total storage space of the table. Particularly, for a table with a huge data amount or a complex table with a plurality of different data areas, the saved storage resource amount is more significant.

For example, for a table comprising a plurality of content areas and composed of rows a to J, and rows 1 to 10, assume that the starting cell (row 1 of row a) corresponds to a position a1, and the ending cell (row 10 of row J) corresponds to a position J10. Only the area 1 corresponding to the columns a to D, the rows 1 to 3, the area 2 corresponding to the columns a to D, and the rows 8 to 9 store table data (e.g., a header, a row header, and a column header), and the rest of the tables do not store data (or store data unrelated to the tables). In the prior art, a data layer with the same size as the range of A column to J column and 1 row to 10 rows in the sample layer is generated, and then the sample layer and the data layer are stored together. In the prior art, when the size of the storage space is represented by the number of the stored cells, 10 × 10 (table sample layer) +10 × 10 (data layer) needs to be stored as 200 cells. By adopting the method provided by the application, the total storage space is saved by reducing the data amount stored in the data layer. In the present application, the data layer only needs to store the cells corresponding to the area 1 and the area 2, that is, the total number of the stored cells is 10 × 10 (table sample layer) +3 × 3+3 × 2 ═ 115 cells.

In an embodiment, as shown in fig. 1, a form data processing method is provided, and this embodiment is illustrated by applying the method to a terminal, and it is to be understood that the method may also be applied to a server, and may also be applied to a system including a terminal and a server, and is implemented by interaction between the terminal and the server. In this embodiment, the method includes the steps of:

step S102, at least one table to be filled in the table sample layer is determined, wherein the table to be filled corresponds to a region symbol, and the region symbol represents a filling range of actual data in the table to be filled.

The region symbol is used for representing the filling range of the actual data in the table to be filled. The region symbol may be represented by a combination of positions corresponding to a starting cell and a terminating cell, for example, the region symbol C2: F10 represents a filling range formed by C column to F column and 2 row to 10 row, the starting cell is a cell corresponding to C column and 2 row, and the terminating cell is a cell corresponding to F column and 10 row. For another example, the region symbol may be represented by coordinates corresponding to the start cell and the end cell, respectively, e.g., (1,1): (10,10) may represent a filling range included from the first row and the first column to the tenth row and the tenth column. Of course, the present invention is not limited to this, and the above examples may also be used to indicate the sequence of rows by letters, the sequence of columns by numbers, and the like.

In the embodiment of the present application, only one layer of table sample layer is used to store table sample information. The table sample layer and the data layer are a hierarchical structure for storing tables, and the table sample layer is used for storing table sample information, such as title characters, filling colors and the like. The data layer is used for storing dimension combination information, and one type of dimension combination information corresponds to a specific actual data.

Specifically, the terminal determines a table to be filled with data by receiving a trigger operation of a user in the table sample layer, and determines a region symbol of the data to be filled. The triggering operation includes, but is not limited to, input, selection, dragging, touching, and the like. Illustratively, the terminal may provide a visual interface to the user through a display device (e.g., a display screen) for the user to perform input, selection, dragging, and the like in the visual interface so as to define the form to be filled.

In some embodiments, the terminal acquires the region symbol of the form to be filled based on the input operation triggered on the region setting interface, and generates the form to be filled in the corresponding range according to the region symbol. Specifically, the terminal provides a region setting interface for the user to input region symbols by providing the user with the region setting interface, so that the terminal can generate the table to be filled in the corresponding range in the table sample layer according to the input region symbols. In one specific example, as shown in fig. 2, the terminal may provide a region setting interface (e.g., a "data region setting" interface on the right side in the figure) to the user, in which the user may input a region size (e.g., input a region character B5: C10, data start position B5), thereby determining a filling range (i.e., a solid line filling portion in the figure) of the table to be filled and the corresponding actual data in the form layer. The user may also set dimension information on the interface in the data area, which is used to indicate the dimension combination to which each cell belongs, for example, dimension information of department one to department six, subject one to subject two in fig. 2, and the dimension combination corresponding to the corresponding B5 cell is "subject one, department one".

Or, in some embodiments, the terminal determines a start position and an end position of the form to be filled based on the selection operation of the at least one cell in the form display interface, and generates the form to be filled in a corresponding range based on the start position and the end position. Specifically, the terminal provides a table display interface for the user to select one or more cells in the table display interface through clicking, dragging and the like. For example, the user may click on two cells in sequence, and the terminal takes the two cells as a start cell and an end cell, respectively, thereby determining the range of the entire table to be filled and generating the table to be filled accordingly. For another example, the user may drag and select a table area, and the terminal automatically obtains the start cell and the end cell in the area, thereby determining the table to be filled.

In the embodiment, the size of the form to be filled can be automatically determined and the form to be filled can be automatically generated by providing a visual interface for a user and detecting the trigger operation of the user.

And step S104, constructing a dimension table of the same range in the data layer according to the range represented by the region symbol. And dimension combination information corresponding to the data to be filled in the table to be filled and the relative positions of the corresponding cells relative to the region symbols are correspondingly arranged in each cell in the dimension table.

The dimension combination information refers to a combination of two dimensions to which the cell belongs. The dimensions set may be, for example, organization, subject, name, and date, among others. The dimension information is a specific value of a dimension, for example, a plurality of kinds of dimension information such as tissue one, tissue two … …, etc. can be included under the tissue dimension. For a two-dimensional table, a cell usually corresponds to at least one kind of dimension combination information, for example, a certain cell corresponds to two kinds of dimension information, i.e., "organize one" and "subject one". Of course, a cell may also correspond to multiple dimension combination information, for example, a certain cell corresponds to "organize one" and all the department dimension information. In general, dimension information set in table rows may be referred to as row headers, dimension information set in table columns may be referred to as column headers, and so forth.

Specifically, the terminal constructs a dimension table with the same size as the filling range in the data layer according to the filling range of the actual data of the table to be filled represented by the region symbol. Therefore, a data layer with the size equal to that of the complete table sample layer does not need to be stored, only the dimension table with the range size of the relevant actual data is stored, the storage efficiency can be improved, and the storage space can be saved.

In the dimension table, the terminal stores the dimension combination information to which each cell belongs when the cell is mapped to the corresponding cell of the sample layer. For example, for a cell in the first row and the first column of the dimension table, assuming that the table to be filled in the table sample layer corresponding to the cell is H5, and the column title of the H5 cell is "organization one" and the row title is "subject one", the dimension combination information corresponding to the cell in the dimension table is "subject one, organization one". Meanwhile, the data layer is decoupled from the sample layer, and the terminal also stores the relative position of each cell in the dimension table relative to the region symbol of the corresponding table to be filled in the sample layer.

For example, for a cell in the first row and the first column of the dimension table, the terminal stores the position of the cell as (0,0), and the cell stores dimension combination information of "subject one, organization one". Assuming that the region symbol of the corresponding table to be filled is H5: K8, if the table to be filled corresponding to H5: K8 in the table sample layer is moved to another position (e.g., H6: K9), the position of the cell in the dimension table remains unchanged, and the dimension combination information of "subject one, organization one" is stored.

And S106, performing associated storage on the table sample layer and the dimension table, wherein the table sample layer and the dimension table which are stored in the associated way are used for generating a complete data table.

Specifically, the terminal associates and stores the table sample layer and the generated dimension table. Therefore, when a complete data table is generated, the terminal can fill the actual data corresponding to the dimension combination information into the corresponding position of the table to be filled according to the filling range of the actual data of the table to be filled in the table sample layer and the relative position of each cell in the dimension table relative to the filling range, so as to generate the complete data table.

According to the table data processing method, the dimension tables in the same range are constructed in the data layer according to the filling range of the actual data of the tables to be filled in the table sample layer, the tables in the same size as the table sample layer are not needed, and the table sample layer and the dimension tables are stored in a correlation mode, so that the storage of the table samples of the tables and the storage of the data area are decoupled, and the total storage space is greatly reduced.

When generating a complete data table, as shown in fig. 3, the terminal performs the following steps:

step S302, determining target dimension combination information, and extracting corresponding actual data from a data source according to the target dimension combination information.

Step S304, determining an actual filling position corresponding to actual data in the sample layer according to the region symbol corresponding to the target table to be filled corresponding to the target dimension combination information and the relative position of the target dimension combination information in the dimension table.

And step S306, filling the actual data into the target cell corresponding to the actual filling position.

And step S308, generating a complete data table based on the form sample information of the target form to be filled and the actual data filled in the target cells.

And the terminal processes each cell in turn to finally generate a complete data table. Specifically, the terminal first determines what kind of data needs to be filled at this time, that is, the dimension combination information corresponding to the actual data. In order to distinguish the dimension combination information from other unprocessed dimension combination information, dimension combination information corresponding to actual data to be filled at this time is called target dimension combination information, and cells filled corresponding to the actual data are called target cells; in some cases, a plurality of tables to be filled are stored in one table sample layer, and the table to be filled in the current processing is referred to as a target table to be filled. And the terminal extracts actual data corresponding to the target dimension combination information from the data source according to the target dimension combination information. For example, the terminal extracts subject one and organizes actual data corresponding to subject one from the data source as 100. The data source is, for example, a database, or other virtual media storing actual data.

And according to the determined target dimension combination information, the terminal determines a target table to be filled corresponding to the target dimension combination information in the table sample layer and acquires an area symbol corresponding to the target table to be filled. According to the stored relative position of the target dimension combination information and the filling range represented by the region symbol, the terminal can determine the actual filling position corresponding to the actual data in the table sample layer.

After the actual filling position is determined, the terminal fills the actual data into the target cell corresponding to the actual filling position, and the cell completes data filling. And the terminal processes the next cell in sequence until all the cells in the dimension table in the data layer are traversed. Finally, the terminal generates a complete data table based on the sample information (such as row header and column header) of the target table to be filled and the actual data filled in the target cell.

In some embodiments, as shown in fig. 4, determining an actual filling position corresponding to actual data in the sample layer according to the region identifier corresponding to the target table to be filled corresponding to the target dimension combination information and the relative position of the target dimension combination information in the dimension table includes:

step S402, determining the initial position of the filling range of the actual data in the target table to be filled according to the region symbol corresponding to the target table to be filled corresponding to the target dimension combination information.

Step S404, determining an actual filling position corresponding to the actual data in the sample layer based on the sum of the relative positions of the starting position and the target dimension combination information in the dimension table.

Specifically, the terminal determines an area symbol corresponding to the target table to be filled according to the target table to be filled corresponding to the target dimension combination information, so as to determine an initial position of a filling range of the actual data. Then, the terminal calculates a corresponding actual filling position based on the sum of the starting position and the relative position. For example, if the relative coordinate value of the start position represented by the region symbol in the table sample layer of the cells of the dimension table corresponding to the subject 3 organization 4 is (2,3), and the absolute coordinate value of the start position of the corresponding table to be filled is H5 is (7,4), the absolute position (9,7) can be calculated by adding the coordinate values of the dimension member cells, and the actual filling position can be determined to be the position of the cell K7.

In the above embodiment, the absolute position (i.e. the actual filling position) of the actual data in the table sample layer is calculated by using the actual data start position value stored in the table to be filled in the table sample layer and the relative position stored in the dimension table, and the actual data is filled in the actual filling position, so that the complete data table is automatically generated. By splitting the data area into independent table storage dimension information, the table samples are decoupled from the data area storage, and the total storage space is reduced. Meanwhile, because the relative position is stored in the dimension table, when the rows and columns of the table are changed (such as inserting rows and columns), only the region symbol needs to be modified; and because the relative position is unchanged, the dimension table corresponding to the data area does not need to be adjusted, and the efficiency of adjusting the data area is greatly improved.

Because the positions of the table cells of the data layer and the positions of the cells of the table sample layer are consistent in the prior art, the absolute position information of the cells is used for storing and positioning information when the table is displayed. This results in a very inefficient need to move a large number of cells when the location of the data area changes (e.g. the rows and columns can be dynamically inserted between multiple data areas according to the actual data). To this end, in an embodiment, as shown in fig. 5, the table data processing method provided by the present application further includes:

step S502, a table adjustment instruction is received, and the table adjustment instruction carries a line sequence adjustment amount and/or a column sequence adjustment amount.

Step S504, updating the region symbol corresponding to each table to be filled in the table sample layer according to the adjustment amount in the table adjustment instruction.

Step S506, according to the new filling range represented by the updated region symbol, implementing the row sequence adjustment and/or the column sequence adjustment of the corresponding table to be filled in the table sample layer.

Specifically, the terminal obtains a table adjustment instruction by detecting a trigger operation of a user, where the table adjustment instruction carries a row sequence adjustment quantity and/or a column sequence adjustment quantity, and the row sequence adjustment quantity and/or the column sequence adjustment quantity represent the number of rows/columns of the table row and/or the table column that need to be moved. After adjusting one data area, all other data areas are adjusted correspondingly, so the terminal updates the area symbols corresponding to all the tables to be filled in the table sample layer according to the adjustment amount. Therefore, the terminal realizes the row sequence adjustment and/or the column sequence adjustment of the corresponding table to be filled in the table sample layer according to the new filling range represented by the updated region symbol.

For example, if 2 rows of table rows are added to a certain table to be filled, the region symbol of the table to be filled changes correspondingly, and the terminal updates correspondingly. And due to the change of the table to be filled, the whole of the other table to be filled below is shifted downwards by 2 rows. Assuming that the region symbol of another table to be filled is originally H15: K17, the terminal modifies the region symbol into H15: K17+ (0,2) ═ H17: K19 according to the row sequence adjustment amount. And the position in the dimension table in the data layer does not need to be modified at this time.

In the above embodiment, when the position of a table member changes (for example, a table row or a table column is inserted), only the region identifier and the starting position value (absolute position flag) need to be modified, the table corresponding to the data layer does not need to be adjusted (because the relative position does not change), and the efficiency of adjusting the data region is greatly improved.

As mentioned above, a cell may also correspond to a plurality of dimensional combination information. When a complete data table is generated, the multiple kinds of dimension combination information need to be expanded and displayed respectively. To this end, in one embodiment, as shown in fig. 6, the method includes:

step S602, when the dimension combination information stored in any cell in the dimension table contains multiple dimension combinations, determining table rows and/or table columns corresponding to the dimensions in the table to be filled corresponding to the dimension combinations according to the dimensions corresponding to the dimension combinations.

Step S604, respectively updating the table sample information corresponding to the table rows and/or the table columns to the dimension combination information of the corresponding dimension combination.

Specifically, when the dimension combination information stored in a certain cell in the dimension table includes a plurality of dimension combinations, for example, the dimension combination information of "all groups and subject 1 under department 1" includes a plurality of dimension combinations such as a group 1 subject 1 of department 1, a group 2 subject 1 of department 1, a group 1 of department 1 3 subject 1 of department 1, and the like. The terminal determines table rows and table columns which need to be added in the table to be filled in the table sample layer according to the number of the dimensions corresponding to the dimension combination, or the table rows and the table columns need to be added. And then, according to the newly added table rows and/or table columns, dividing the dimension combination into independent dimension combination information, and respectively corresponding to the corresponding table rows and/or table columns. In the table sample layer, the terminal respectively updates the table sample information corresponding to the newly added table rows and/or table columns into the dimension combination information of the corresponding dimension combination. For example, as shown in fig. 7, if the dimension members stored in a certain cell in the dimension table are range values (e.g., 'all lower members' of subject 4 are stored in the cell), then when the table is displayed, a case of line insertion exists according to the range analysis, and if the 'all lower members' of subject 4 are analyzed to become subjects 4-1, subjects 4-2, and subjects 4-3, then 2 lines need to be added below the table line corresponding to the cell to fill in the data corresponding to subjects 4-2 and subjects 4-3.

In the embodiment, addition of table rows and/or table columns can be automatically realized through dimension combination information, and the table processing efficiency is improved.

In order to facilitate a better understanding of the inventive concepts of the present invention, a specific example is illustrated below. In one embodiment, the terminal uses a sample layer to store sample information, i.e., 30 × 17 size tables corresponding to a1: Q30 as shown in fig. 8. Suppose two tables to be filled (i.e. areas to be filled with data) are arranged in the table sample layer, and the corresponding area characters are H5: K8 and H15: K17 respectively. Wherein the start position (e.g., H5 and H15) identifies the start position information of the actual data. Meanwhile, as shown in fig. 9, the terminal constructs two dimension tables having the same size as the region symbol representation ranges in the data layer (e.g., the dimension table corresponding to the region symbol H5: K8 is 4 × 4 — 16 cells, and the dimension table corresponding to the region symbol H15: K17 is 3 × 4 — 12 cells), and the cells in the tables store the dimension combination information.

When a complete data table is generated, the value of the actual data is extracted from a data source (such as a database) by the terminal according to the dimension combination information, for example, the value of the subject 1 organization 1 is 100. Then, the terminal calculates the absolute position of the actual data in the table sample layer, and the starting position of the actual data represented by the region symbol in the table sample layer and the relative position in the dimension table are calculated. For example, the relative coordinate value of the cell of the dimension table corresponding to the subject 1 organization 1 compared with the start position represented by the region symbol in the table sample layer is (0,0), and the absolute coordinate value of the corresponding start position of the table to be filled is H5 cell is (7,4), then the absolute position (7,4) can be calculated by adding the coordinate values of the dimension member cells, and the actual filling position can be determined to be the position of the cell H5. For another example, the relative coordinate value of the start position represented by the area symbol in the dimension table organized by subject 3 and corresponding to subject 3 organization 4 is (2,3), and the absolute coordinate value of the start position represented by the corresponding table to be filled is (7,4) in the H5 cell, then the absolute position (9,7) can be calculated by adding the coordinate values of the dimension member cells, and the actual filling position can be determined to be the position of the cell K7. The terminal fills the actual values extracted from the data source to the actual filling positions, and the final generated complete data table is shown in fig. 10.

In the embodiment of the application, the data area is divided into independent table storage dimension member information, so that the storage of the table sample and the data area is decoupled, and the total storage space is greatly reduced. Taking the table in the foregoing embodiment as an example, if the method provided by the present application is used, the required memory space is: the cell number of the table layer + the data region H5: K8 cell number + the data region H15: K17 cell number is 30 × 17+4 × 4+3 × 4, 538, whereas the cell number of the table layer of at least 2 × 30 × 17 is 1020 in the conventional method, and the difference effect between the data storage amounts of the two methods becomes more significant as the cell number of the table layer increases.

It should be understood that, although the steps in the flowcharts related to the embodiments are shown in sequence as indicated by the arrows, the steps are not necessarily executed in sequence as indicated by the arrows. The steps are not performed in the exact order shown and described, and may be performed in other orders, unless explicitly stated otherwise. Moreover, at least a part of the steps in the flowcharts related to the above embodiments may include multiple steps or multiple stages, which are not necessarily performed at the same time, but may be performed at different times, and the order of performing the steps or stages is not necessarily sequential, but may be performed alternately or alternately with other steps or at least a part of the steps or stages in other steps.

Based on the same inventive concept, the embodiment of the present application further provides a table data processing method apparatus for implementing the above-mentioned table data processing method. The implementation scheme for solving the problem provided by the device is similar to the implementation scheme described in the method, so specific limitations in one or more table data processing method device embodiments provided below can refer to the limitations on the table data processing method in the foregoing, and details are not described herein again.

In one embodiment, as shown in fig. 11, there is provided a table data processing apparatus 1101, including: a determining module 1101, a constructing module 1102 and a storing module 1103, wherein:

the determining module 1101 is configured to determine at least one table to be filled in the table sample layer, where the table to be filled corresponds to a region character, and the region character represents a filling range of actual data in the table to be filled.

A building module 1102, configured to build, according to the range represented by the region identifier, a dimension table in the same range in the data layer, where dimension combination information corresponding to data to be filled in the table to be filled corresponds to each cell in the dimension table, and a relative position of the corresponding cell with respect to the region identifier.

The storage module 1103 is configured to associate and store the table sample layer and the dimension table, where the table sample layer and the dimension table stored in association are used to generate a complete data table.

In one embodiment, the apparatus further includes a generation module, configured to determine target dimension combination information, and extract corresponding actual data from the data source according to the target dimension combination information; determining an actual filling position corresponding to actual data in the sample layer according to a region symbol corresponding to a target table to be filled corresponding to the target dimension combination information and a relative position of the target dimension combination information in the dimension table; filling the actual data into the target cell corresponding to the actual filling position; and generating a complete data table based on the form sample information of the target form to be filled and the actual data filled in the target cells.

In one embodiment, the generating module is further configured to determine, according to the region identifier corresponding to the target table to be filled corresponding to the target dimension combination information, an initial position of a filling range of actual data in the target table to be filled; and determining an actual filling position corresponding to the actual data in the sample layer based on the sum of the relative positions of the starting position and the target dimension combination information in the dimension table.

In one embodiment, the apparatus further includes an adjusting module, where the adjusting module is configured to receive a table adjusting instruction, where the table adjusting instruction carries a row sequence adjustment amount and/or a column sequence adjustment amount; updating the region symbol corresponding to each table to be filled in the table sample layer according to the adjustment amount in the table adjustment instruction; and realizing the row sequence adjustment and/or the column sequence adjustment of the corresponding table to be filled in the table sample layer according to the new filling range represented by the updated region symbol.

In one embodiment, the apparatus further includes an extension module, where the extension module is configured to, when dimension combination information stored in any cell in the dimension table contains multiple dimension combinations, determine, according to a dimension corresponding to the dimension combination, a table row and/or a table column corresponding to each dimension in a corresponding table to be filled in the table sample layer; and respectively updating the form sample information corresponding to the table rows and/or the table columns into dimension combination information of corresponding dimension combinations.

In one embodiment, the determining module is further configured to obtain a region symbol of the form to be filled based on an input operation triggered on the region setting interface, and generate the form to be filled in a corresponding range according to the region symbol; or determining the starting position and the ending position of the table to be filled based on the selected operation of at least one cell in the table display interface, and generating the table to be filled in the corresponding range based on the starting position and the ending position.

The respective modules in the above table data processing apparatus may be wholly or partially implemented by software, hardware, and a combination thereof. The modules can be embedded in a hardware form or independent from a processor in the computer device, and can also be stored in a memory in the computer device in a software form, so that the processor can call and execute operations corresponding to the modules.

In one embodiment, a computer device is provided, which may be a terminal, and its internal structure diagram may be as shown in fig. 12. The computer device includes a processor, a memory, a communication interface, a display screen, and an input device connected by a system bus. Wherein the processor of the computer device is configured to provide computing and control capabilities. The memory of the computer device comprises a nonvolatile storage medium and an internal memory. The non-volatile storage medium stores an operating system and a computer program. The internal memory provides an environment for the operation of an operating system and computer programs in the non-volatile storage medium. The communication interface of the computer device is used for carrying out wired or wireless communication with an external terminal, and the wireless communication can be realized through WIFI, a mobile cellular network, NFC (near field communication) or other technologies. The computer program is executed by a processor to implement a table data processing method. The display screen of the computer equipment can be a liquid crystal display screen or an electronic ink display screen, and the input device of the computer equipment can be a touch layer covered on the display screen, a key, a track ball or a touch pad arranged on the shell of the computer equipment, an external keyboard, a touch pad or a mouse and the like.

Those skilled in the art will appreciate that the architecture shown in fig. 12 is merely a block diagram of some of the structures associated with the disclosed aspects and is not intended to limit the computing devices to which the disclosed aspects apply, as particular computing devices may include more or less components than those shown, or may combine certain components, or have a different arrangement of components.

In one embodiment, a computer device is provided, comprising a memory and a processor, the memory having a computer program stored therein, the processor implementing the following steps when executing the computer program: determining at least one table to be filled in the table sample layer, wherein the table to be filled corresponds to a region symbol, and the region symbol represents a filling range of actual data in the table to be filled; constructing a dimension table in the same range in the data layer according to the range represented by the region symbol, wherein dimension combination information corresponding to the data to be filled in the table to be filled and the relative position of the corresponding cell relative to the region symbol correspond to each cell in the dimension table; and performing association storage on the table sample layer and the dimension table, wherein the table sample layer and the dimension table which are stored in association are used for generating a complete data table.

In one embodiment, the processor, when executing the computer program, further performs the steps of: determining target dimension combination information, and extracting corresponding actual data from a data source according to the target dimension combination information; determining an actual filling position corresponding to actual data in the sample layer according to a region symbol corresponding to a target table to be filled corresponding to the target dimension combination information and a relative position of the target dimension combination information in the dimension table; filling the actual data into the target cell corresponding to the actual filling position; and generating a complete data table based on the form sample information of the target form to be filled and the actual data filled in the target cells.

In one embodiment, the processor, when executing the computer program, further performs the steps of: determining the initial position of the filling range of the actual data in the target table to be filled according to the region symbol corresponding to the target table to be filled corresponding to the target dimension combination information; and determining an actual filling position corresponding to the actual data in the sample layer based on the sum of the relative positions of the starting position and the target dimension combination information in the dimension table.

In one embodiment, the processor, when executing the computer program, further performs the steps of: receiving a table adjustment instruction, wherein the table adjustment instruction carries a line sequence adjustment amount and/or a column sequence adjustment amount; updating the region symbol corresponding to each table to be filled in the table sample layer according to the adjustment amount in the table adjustment instruction; and realizing the row sequence adjustment and/or the column sequence adjustment of the corresponding table to be filled in the table sample layer according to the new filling range represented by the updated region symbol.

In one embodiment, the processor, when executing the computer program, further performs the steps of: when the dimension combination information stored in any cell in the dimension table contains various dimension combinations, determining table rows and/or table columns corresponding to the dimensions in the corresponding table to be filled in the table sample layer according to the dimensions corresponding to the dimension combinations; and respectively updating the form sample information corresponding to the table rows and/or the table columns into dimension combination information of corresponding dimension combinations.

In one embodiment, the processor, when executing the computer program, further performs the steps of: acquiring a region symbol of the form to be filled based on an input operation triggered on a region setting interface, and generating the form to be filled in a corresponding range according to the region symbol; or determining the starting position and the ending position of the table to be filled based on the selected operation of at least one cell in the table display interface, and generating the table to be filled in the corresponding range based on the starting position and the ending position.

In one embodiment, a computer-readable storage medium is provided, having a computer program stored thereon, which when executed by a processor, performs the steps of: determining at least one table to be filled in the table sample layer, wherein the table to be filled corresponds to a region symbol, and the region symbol represents a filling range of actual data in the table to be filled; constructing a dimension table in the same range in the data layer according to the range represented by the region symbol, wherein dimension combination information corresponding to the data to be filled in the table to be filled and the relative position of the corresponding cell relative to the region symbol correspond to each cell in the dimension table; and performing association storage on the table sample layer and the dimension table, wherein the table sample layer and the dimension table which are stored in association are used for generating a complete data table.

In one embodiment, the computer program when executed by the processor further performs the steps of: determining target dimension combination information, and extracting corresponding actual data from a data source according to the target dimension combination information; determining an actual filling position corresponding to actual data in the sample layer according to a region symbol corresponding to a target table to be filled corresponding to the target dimension combination information and a relative position of the target dimension combination information in the dimension table; filling the actual data into the target cell corresponding to the actual filling position; and generating a complete data table based on the form sample information of the target form to be filled and the actual data filled in the target cells.

In one embodiment, the computer program when executed by the processor further performs the steps of: determining the initial position of the filling range of the actual data in the target table to be filled according to the region symbol corresponding to the target table to be filled corresponding to the target dimension combination information; and determining an actual filling position corresponding to the actual data in the sample layer based on the sum of the relative positions of the starting position and the target dimension combination information in the dimension table.

In one embodiment, the computer program when executed by the processor further performs the steps of: receiving a table adjustment instruction, wherein the table adjustment instruction carries a line sequence adjustment amount and/or a column sequence adjustment amount; updating the region symbol corresponding to each table to be filled in the table sample layer according to the adjustment amount in the table adjustment instruction; and realizing the row sequence adjustment and/or the column sequence adjustment of the corresponding table to be filled in the table sample layer according to the new filling range represented by the updated region symbol.

In one embodiment, the computer program when executed by the processor further performs the steps of: when the dimension combination information stored in any cell in the dimension table contains various dimension combinations, determining table rows and/or table columns corresponding to the dimensions in the corresponding table to be filled in the table sample layer according to the dimensions corresponding to the dimension combinations; and respectively updating the form sample information corresponding to the table rows and/or the table columns into dimension combination information of corresponding dimension combinations.

In one embodiment, the computer program when executed by the processor further performs the steps of: acquiring a region symbol of the form to be filled based on an input operation triggered on a region setting interface, and generating the form to be filled in a corresponding range according to the region symbol; or determining the starting position and the ending position of the table to be filled based on the selected operation of at least one cell in the table display interface, and generating the table to be filled in the corresponding range based on the starting position and the ending position.

In one embodiment, a computer program product is provided, comprising a computer program which, when executed by a processor, performs the steps of: determining at least one table to be filled in the table sample layer, wherein the table to be filled corresponds to a region symbol, and the region symbol represents a filling range of actual data in the table to be filled; constructing a dimension table in the same range in the data layer according to the range represented by the region symbol, wherein dimension combination information corresponding to the data to be filled in the table to be filled and the relative position of the corresponding cell relative to the region symbol correspond to each cell in the dimension table; and performing association storage on the table sample layer and the dimension table, wherein the table sample layer and the dimension table which are stored in association are used for generating a complete data table.

It will be understood by those skilled in the art that all or part of the processes of the methods of the embodiments described above can be implemented by hardware related to instructions of a computer program, which can be stored in a non-volatile computer-readable storage medium, and when executed, can include the processes of the embodiments of the methods described above. Any reference to memory, database, or other medium used in the embodiments provided herein may include at least one of non-volatile and volatile memory. The nonvolatile Memory may include Read-Only Memory (ROM), magnetic tape, floppy disk, flash Memory, optical Memory, high-density embedded nonvolatile Memory, resistive Random Access Memory (ReRAM), Magnetic Random Access Memory (MRAM), Ferroelectric Random Access Memory (FRAM), Phase Change Memory (PCM), graphene Memory, and the like. Volatile Memory can include Random Access Memory (RAM), external cache Memory, and the like. By way of illustration and not limitation, RAM can take many forms, such as Static Random Access Memory (SRAM) or Dynamic Random Access Memory (DRAM), among others. The databases referred to in various embodiments provided herein may include at least one of relational and non-relational databases. The non-relational database may include, but is not limited to, a block chain based distributed database, and the like. The processors referred to in the embodiments provided herein may be general purpose processors, central processing units, graphics processors, digital signal processors, programmable logic devices, quantum computing based data processing logic devices, etc., without limitation.

The technical features of the above embodiments can be arbitrarily combined, and for the sake of brevity, all possible combinations of the technical features in the above embodiments are not described, but should be considered as the scope of the present specification as long as there is no contradiction between the combinations of the technical features.

The above-mentioned embodiments only express several embodiments of the present application, and the description thereof is more specific and detailed, but not construed as limiting the scope of the present application. It should be noted that, for a person skilled in the art, several variations and modifications can be made without departing from the concept of the present application, which falls within the scope of protection of the present application. Therefore, the protection scope of the present application shall be subject to the appended claims.

Claims

1. A method of processing tabular data, the method comprising:

2. The method according to claim 1, characterized in that it comprises:

3. The method according to claim 2, wherein the determining an actual filling position corresponding to the actual data in the pattern layer according to the region character corresponding to the target table to be filled corresponding to the target dimension combination information and the relative position of the target dimension combination information in the dimension table comprises:

4. The method of claim 1, further comprising:

5. The method of claim 1, further comprising:

6. The method according to any one of claims 1 to 5, wherein the determining at least one table to be filled in the table-like layer comprises:

7. A tabular data processing apparatus, characterized in that said apparatus comprises:

the device comprises a determining module, a storing module and a processing module, wherein the determining module is used for determining at least one table to be filled in a table sample layer, the table to be filled corresponds to a region symbol, and the region symbol represents a filling range of actual data in the table to be filled;

the building module is used for building a dimension table in the same range in the data layer according to the range represented by the region symbol, wherein dimension combination information corresponding to the data to be filled in the table to be filled and the relative position of the corresponding cell relative to the region symbol correspond to each cell in the dimension table;

and the storage module is used for storing the table sample layer and the dimension table in an associated manner, and the table sample layer and the dimension table stored in the associated manner are used for generating a complete data table.

8. A computer device comprising a memory and a processor, the memory storing a computer program, characterized in that the processor, when executing the computer program, implements the steps of the method of any of claims 1 to 6.

9. A computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, carries out the steps of the method of any one of claims 1 to 6.

10. A computer program product comprising a computer program, characterized in that the computer program realizes the steps of the method of any one of claims 1 to 6 when executed by a processor.