Table display method with header, device, electronic device and computer readable medium

Abstract

The embodiments of the present disclosure disclose a method, device, electronic device and computer-readable medium for displaying a table with a header. A specific implementation of the method includes: in response to detecting a table creation request information, displaying a table header design module; in response to detecting a selection operation acting on any header control, determining the header type corresponding to any header control as the target header type; displaying a header configuration module; in response to detecting a selection operation of any template header information control, displaying an edit operation control set; in response to detecting a selection operation acting on any edit operation control, updating the target template header information group; updating the template header information set; in response to detecting a confirmation generation operation of a table, generating table information with a header according to the target updated header information set and a preset tree structure header generation model; and displaying a table with a header corresponding to the table information with a header. This implementation can simplify user operations.

Description

Technical Field

[0001] Embodiments of the present disclosure relate to the field of computer technology, and in particular to a method, device, electronic device, and computer-readable medium for displaying a table with a header. Background Art

[0002] With the rapid development of computer technology and big data, the design of electronic spreadsheet headers has become increasingly complex in order to meet user needs. At present, when generating a table with a header, the common method is that the user who creates a new table writes a table program according to the needs or designs it layer by layer in the spreadsheet software to generate a table with a header.

[0003] However, in practice, when the above method is used to generate a table with a header, the following technical problems often occur:

[0004] Every time a new table is created, the user needs to rewrite the program or design the table according to the needs. When the table header design to be created is complex, the user's operation becomes cumbersome and it takes a long time to create the table.

[0005] The above information disclosed in this Background section is only for enhancement of understanding of the background of the inventive concept and therefore it may contain information that does not form the prior art that is already known in this country to a person of ordinary skill in the art. Summary of the invention

[0006] The content of this disclosure is used to introduce concepts in a brief form, which will be described in detail in the detailed implementation section below. The content of this disclosure is not intended to identify the key features or essential features of the technical solution claimed for protection, nor is it intended to limit the scope of the technical solution claimed for protection.

[0007] Some embodiments of the present disclosure propose a table display method with a table header, an apparatus, an electronic device, and a computer-readable medium to solve the technical problems mentioned in the above background technology section.

[0008] In a first aspect, some embodiments of the present disclosure provide a method for displaying a table with a header, the method comprising: in response to detecting a table creation request information, displaying a table header design module in a table design interface, wherein the table header design module includes various header controls corresponding to a template header information set, and the template header information in the template header information set includes a header type; in response to detecting a selection operation acting on any header control included in the various header controls, determining the header type corresponding to the any header control as a target header type; displaying a header configuration module corresponding to the target header type, wherein the header configuration module includes a template header information control set corresponding to a target template header information group, and the target template header information in the target template header information group is a template corresponding to the target header type in the template header information set. Header information; in response to detecting a selection operation corresponding to any template header information control included in the above-mentioned template header information control set, displaying an editing operation control set corresponding to the preset operation information set; in response to detecting a selection operation acting on any editing operation control included in the above-mentioned editing operation control set, updating the above-mentioned target template header information group according to the preset operation information corresponding to the above-mentioned any editing operation control included in the above-mentioned preset operation information set to obtain an updated header information group; according to the above-mentioned updated header information group, updating the above-mentioned template header information set to obtain a target updated header information set; in response to detecting a confirmation operation to generate a table, generating table information with header according to the above-mentioned target updated header information set and a preset tree structure header generation model; according to the above-mentioned table information with header, displaying a table with header corresponding to the above-mentioned table information with header.

[0009] In a second aspect, some embodiments of the present disclosure provide a device for displaying a table with a header, the device comprising: a first display unit, configured to display a table header design module in a table design interface in response to detecting table creation request information, wherein the table header design module comprises various header controls corresponding to a template header information set, and the template header information in the template header information set comprises a header type; a determination unit, in response to detecting a selection operation acting on any header control included in the various header controls, determines the header type corresponding to the above arbitrary header control as a target header type; a second display unit, configured to display a header configuration module corresponding to the above target header type, wherein the header configuration module comprises a template header information control set corresponding to a target template header information group, and the target template header information in the target template header information group is the template header information corresponding to the above target header type in the template header information set; and a third display unit, configured to display a table header configuration module corresponding to the above target header type. The device is configured to display an editing operation control set corresponding to a preset operation information set in response to detecting a selection operation on any editing operation control included in the above-mentioned template header information control set; the first updating unit is configured to update the above-mentioned target template header information group according to the preset operation information corresponding to the above-mentioned any editing operation control included in the above-mentioned preset operation information set in response to detecting a selection operation on any editing operation control included in the above-mentioned editing operation control set, so as to obtain an updated header information group; the second updating unit is configured to update the above-mentioned template header information set according to the above-mentioned updated header information group, so as to obtain a target updated header information set; the generating unit is configured to generate a table with header information according to the above-mentioned target updated header information set and a preset tree structure header generating model in response to detecting a confirmation operation to generate a table; the fourth display unit is configured to display a table with header corresponding to the above-mentioned table with header information according to the above-mentioned table with header information.

[0010] In a third aspect, some embodiments of the present disclosure provide an electronic device comprising: one or more processors; a storage device on which one or more programs are stored, and when the one or more programs are executed by the one or more processors, the one or more processors implement the method described in any implementation manner of the above-mentioned first aspect.

[0011] In a fourth aspect, some embodiments of the present disclosure provide a computer-readable medium having a computer program stored thereon, wherein the computer program, when executed by a processor, implements the method described in any implementation manner of the first aspect.

[0012] The above-mentioned embodiments of the present disclosure have the following beneficial effects: through the table display method with a header of some embodiments of the present disclosure, the user operation can be simplified and the time for creating a table can be saved. Specifically, the reason why the user's operation is cumbersome and it takes a long time to create a table is that every time a new table is created, the user needs to start designing and creating again according to the needs. When the table header design to be created is more complicated, the user's operation is cumbersome and it takes a long time to create a table. Based on this, the table display method with a header of some embodiments of the present disclosure, first, in response to detecting the table creation request information, displays the table header design module in the table design interface. Among them, the table header design module includes each header control corresponding to the template header information set. The template header information in the template header information set includes the header type. Thus, each header control of the corresponding table template can be displayed, so that it can be used to modify each header. Secondly, in response to detecting the selection operation acting on any header control included in the above header controls, the header type corresponding to the above any header control is determined as the target header type. Thus, the header type that the user wants to modify can be obtained, so that it can be used to modify the information of each header of the corresponding target header type. Then, the header configuration module corresponding to the above target header type is displayed. Among them, the above header configuration module includes a template header information control set corresponding to the target template header information group. The target template header information in the above target template header information group is the template header information corresponding to the above target header type in the above template header information set. Thus, each control of each header corresponding to the header type that the user wants to modify can be displayed, so that it can be used to modify the header information corresponding to each control. Afterwards, in response to detecting the selection operation of any template header information control included in the above template header information control set, the editing operation control set corresponding to the preset operation information set is displayed. Thus, the editing operation control set that can correspond to each modification operation type can be displayed, so that the template header information can be modified. Then, in response to detecting the selection operation acting on any editing operation control included in the above editing operation control set, according to the preset operation information corresponding to the above any editing operation control included in the above preset operation information set, the above target template header information group is updated and processed to obtain an updated header information group. Thus, each template header information corresponding to the target header type can be modified, so that it can be used to regenerate a table with a header. Next, according to the above-mentioned updated header information group, the above-mentioned template header information set is updated to obtain the target updated header information set. Thus, each modified header information can be obtained, so that it can be used to regenerate a table with a header. Afterwards, in response to detecting the confirmation operation of generating a table, the table information with a header is generated according to the above-mentioned target updated header information set and the above-mentioned preset tree structure header generation model.Therefore, when the user confirms that a table needs to be generated, the information of the table with a header can be automatically generated through the model constructed by the various header information modified by the user and the tree structure, so that the table with a header can be displayed. Finally, according to the above-mentioned table with a header information, the table with a header corresponding to the above-mentioned table with a header information is displayed. In this way, the table with a header can be displayed, thereby shortening the time spent on creating the table with a header. Also, when creating a table, the header information of each level of the corresponding header type can be directly modified through the operation interface, and then the information of the table is automatically generated through the tree model, so that the user does not need to rewrite the program or design the table, thereby simplifying the user operation and shortening the time spent on creating the table. BRIEF DESCRIPTION OF THE DRAWINGS

[0013] The above and other features, advantages and aspects of the embodiments of the present disclosure will become more apparent with reference to the following detailed description in conjunction with the accompanying drawings. Throughout the accompanying drawings, the same or similar reference numerals represent the same or similar elements. It should be understood that the drawings are schematic and that components and elements are not necessarily drawn to scale.

[0014] Figure 1 is a flowchart of some embodiments of the method for displaying a table with a table header according to the present disclosure;

[0015] Figure 2 It is a schematic diagram of the interface of a table header design module according to some embodiments of the method for displaying a table with a table header disclosed in the present invention;

[0016] Figure 3 is a schematic diagram of an interface of a table header configuration module according to some embodiments of the table header display method disclosed herein;

[0017] Figure 4 is a schematic structural diagram of some embodiments of a table display device with a table header according to the present disclosure;

[0018] Figure 5 It is a schematic diagram of the structure of an electronic device suitable for implementing some embodiments of the present disclosure. DETAILED DESCRIPTION

[0019] Embodiments of the present disclosure will be described in more detail below with reference to the accompanying drawings. Although certain embodiments of the present disclosure are shown in the accompanying drawings, it should be understood that the present disclosure can be implemented in various forms and should not be construed as being limited to the embodiments set forth herein. On the contrary, these embodiments are provided to provide a more thorough and complete understanding of the present disclosure. It should be understood that the drawings and embodiments of the present disclosure are only for exemplary purposes and are not intended to limit the scope of protection of the present disclosure.

[0020] It should also be noted that, for ease of description, only the parts related to the invention are shown in the drawings. In the absence of conflict, the embodiments and features in the embodiments of the present disclosure can be combined with each other.

[0021] It should be noted that the concepts such as "first" and "second" mentioned in the present disclosure are only used to distinguish different devices, modules or units, and are not used to limit the order or interdependence of the functions performed by these devices, modules or units.

[0022] It should be noted that the modifications of "one" and "plurality" mentioned in the present disclosure are illustrative rather than restrictive, and those skilled in the art should understand that unless otherwise clearly indicated in the context, it should be understood as "one or more".

[0023] The names of the messages or information exchanged between multiple devices in the embodiments of the present disclosure are only used for illustrative purposes and are not used to limit the scope of these messages or information.

[0024] The present disclosure will be described in detail below with reference to the accompanying drawings and in conjunction with embodiments.

[0025] Figure 1 The flowchart 100 of some embodiments of the method for displaying a table with a table header according to the present disclosure is shown. The method for displaying a table with a table header comprises the following steps:

[0026] Step 101 , in response to detecting a form creation request message, displaying a table header design module in a table design interface.

[0027] In some embodiments, the execution subject (e.g., computing device) of the method for displaying a table with a header may display a table header design module in a table design interface in response to detecting a table creation request information. The table creation request information may represent that the requesting user requests to create a new table. The execution subject may be a terminal of the requesting user. The requesting user may be a user who has a need to create a new table. The table design interface may be an interface for designing a table. The table header design module may be a page module for designing a table header. The table header design module may include, but is not limited to, each header control corresponding to the template header information set. The template header information in the template header information set may correspond one-to-one to the header controls in the above header controls. The template header information in the template header information set may be the information of the header in the table template. The table template may be a template of a table with a header that is pre-set. The template header information in the template header information set may include a header type, and may also include, but is not limited to, a header field, a header level, and an associated header information group. The header type may represent the type to which the position of the header in the table belongs. The above-mentioned header type may be, but not limited to, one of the following: column header, row header. The above-mentioned column header may be the header of each column. The above-mentioned row header may be the header of each row. The above-mentioned header field may be the field of the corresponding header. The above-mentioned header level may be the number of rows or columns in the table where the header of the corresponding header type is located. The smaller the header level, the larger the level. As an example, the header type included in the template header information is a column header, and the number of rows in the table where the header is located is the second row, then the corresponding header level may be 2. The associated header information in the above-mentioned associated header information group may be information of the associated header. The above-mentioned associated header may be a header that has a hierarchical relationship with the corresponding header. The associated header information may include, but not limited to, an associated relationship and an associated header field. The above-mentioned associated relationship may represent the hierarchical relationship between the corresponding header and the associated header. The above-mentioned associated relationship may be, but not limited to, one of the following: a parent node and a child node. The above-mentioned parent node represents that the header level corresponding to the associated header is less than the header level of the corresponding header. The above sub-node indicates that the header level corresponding to the associated header is greater than the header level of the corresponding header. The above associated header field may be a field of the associated header. The header control in each of the above header controls may be a control for selecting the corresponding header. The above header controls may be displayed according to the position of the corresponding headers in the table template, such as Figure 2 In practice, the above execution subject can display the table header design module in the table design interface in various ways.

[0028] As an example, the various header controls displayed in the table header design module 201 are as follows: Figure 2As shown. Among them, the header information of each template corresponding to the header type of list header is "List header, Holiday overtime, first level, {[sub-node, total overtime hours]; [sub-node, monthly overtime hours]}", "List header, Weekday overtime, first level, {[sub-node, total overtime hours]; [sub-node, monthly overtime hours]}", "List header, total overtime hours, second level, {[parent node, holiday overtime]}", "List header, monthly overtime hours, second level, {[parent node, holiday overtime]}", "List header, overtime Total shift hours, second level, {[parent node, overtime on working days]}", "Column header, monthly overtime hours, second level, {[parent node, overtime on working days]}", the corresponding template header information with the header type of row header is "Row header, 12000, first level, {[child node, 12001]; [child node, 12002]}", "Row header, 12001, second level, {[parent node, 12002]}", "Row header, 12002, second level, {[parent node, 12001]}".

[0029] In some optional implementations of some embodiments, the above-mentioned execution subject may display the table header design module in the table design interface through the following steps:

[0030] The first step is to display the form attribute information setting window. Among them, the above-mentioned form attribute information setting window can be a window for users to set form attribute information. The above-mentioned form attribute information can characterize the attributes of the form. The above-mentioned form attribute information can include but is not limited to the form name, form identifier, and form business type. The above-mentioned form name can be the name of the form. The above-mentioned form identifier can be the unique identifier of the form. The above-mentioned form business type can be the business type to which the data to be displayed in the form belongs. The above-mentioned business type can characterize the category of the business. For example, the above-mentioned business type can be an attendance business or a labor value information (salary) business. The above-mentioned form attribute information setting window can include various basic information input boxes and basic information saving controls. The above-mentioned basic information input boxes can be used for users to enter various form basic information. Each basic information input box can correspond to a form basic information. The form basic information can be information of the corresponding information type of the form. The above-mentioned information type can be but is not limited to one of the following: form name, form identifier, form business type. The above-mentioned basic information saving control can be a control for saving various basic information.

[0031] In the second step, in response to detecting a selection operation acting on the basic information saving control, each input table basic information is determined as a table basic information set, and a table design interface is displayed. The table design interface may be an interface for designing a table with a header. The table design interface may include but is not limited to a table header design control. The table header design control may be an interface for jumping to a table header design module.

[0032] The third step is to determine the template header information set according to the table basic information set in response to detecting the selection operation acting on the table header design control. In practice, the execution subject can determine the template header information set according to the table basic information set in response to detecting the selection operation acting on the table header design control in various ways.

[0033] The fourth step is to display the table header design module corresponding to the above template header information set in the above table design interface.

[0034] In some optional implementations of some embodiments, the execution subject may determine the template header information set according to the table basic information set through the following steps:

[0035] In the first step, each table basic information satisfying a preset information condition in the table basic information set is determined as a target table basic information group, wherein the preset information condition may be that the information type corresponding to the table basic information is a table name or a table business type.

[0036] The second step is to obtain the historical header information group set and the historical table basic information group set of the corresponding historical table set. Among them, the historical table in the above historical table set can be a table created in the past period of time. The historical tables in the above historical table set can correspond one-to-one with the historical header information groups in the above historical table header information group set. The historical tables in the above historical table set can correspond one-to-one with the historical table basic information groups in the above historical table basic information group set. The historical header information groups in the above historical header information group set can be the various header information of the corresponding historical tables. The historical table basic information groups in the above historical table basic information group set can be the various table basic information of the corresponding historical tables. In practice, the above execution subject can obtain the historical header information group set and the historical table basic information group set of the corresponding historical table set from the database by wired connection or wireless connection. It should be pointed out that the above wireless connection method can include but is not limited to 3G / 4G connection, WiFi connection, Bluetooth connection, WiMAX connection, Zigbee connection, UWB (ultrawideband) connection, and other wireless connection methods currently known or to be developed in the future.

[0037] Step 3: For each historical table basic information group included in the historical table basic information group set, perform the following steps:

[0038] The first sub-step is to determine each historical table basic information in the historical table basic information group corresponding to the target table basic information group as the target historical table basic information group. The historical table basic information corresponding to the target table basic information group may be: historical table basic information whose corresponding information type is table name or table business type.

[0039] The second sub-step is to perform the following steps on each target table basic information included in the target table basic information group:

[0040] Sub-step 1: determining the target history table basic information corresponding to the target table basic information in the target history table basic information group as the information to be matched. The target history table basic information corresponding to the target table basic information may be: the corresponding information type is the same as the information type of the target table basic information.

[0041] Sub-step two, performs semantic feature extraction processing on the above-mentioned target table basic information to obtain the first semantic feature information. In practice, the above-mentioned execution subject may input the text corresponding to the above-mentioned target table basic information into a pre-trained semantic feature information generation model to obtain the first semantic feature information. Among them, the above-mentioned semantic feature information generation model may be a feature extraction model with text as input and semantic feature information as output. The above-mentioned feature extraction model may be a Transformer model. The above-mentioned semantic feature information may include a semantic feature vector.

[0042] Sub-step three: extracting semantic features from the information to be matched to obtain second semantic feature information. In practice, the execution subject may input the text corresponding to the information to be matched into a pre-trained semantic feature information generation model to obtain the second semantic feature information.

[0043] Sub-step 4: Determine the similarity between the first semantic feature information and the second semantic feature information as the semantic similarity. In practice, the execution subject may determine the cosine similarity between the first semantic feature information and the second semantic feature information as the semantic similarity.

[0044] The third sub-step is to determine the information similarity according to the determined semantic similarities and the preset similarity weight set. Among them, the preset similarity weights in the above-mentioned preset similarity weight set can correspond to the information type one by one. The preset similarity weights in the above-mentioned preset similarity weight set can be the weights of the table basic information of the preset corresponding information type when matching the table. For example, the preset similarity weight corresponding to the information type of the table name is 0.4, for example, the preset similarity weight corresponding to the information type of the table business type is 0.6. In practice, first, for each determined semantic similarity, the above-mentioned execution entity can determine the target similarity by multiplying the above-mentioned semantic similarity and the preset similarity weight corresponding to the above-mentioned semantic similarity in the above-mentioned preset similarity weight set. Among them, the preset similarity weight corresponding to the above-mentioned semantic similarity can be the preset similarity weight of the corresponding information type and the information type corresponding to the above-mentioned semantic similarity. Then, the sum of the determined target similarities is determined as the information similarity.

[0045] In the fourth step, the information similarity satisfying the preset similarity condition among the determined information similarities is determined as the target information similarity. The preset similarity condition may be: the information similarity is the maximum value among the information similarities.

[0046] The fifth step is to determine the historical table basic information groups that correspond to the target information similarity in the historical table basic information groups as matching historical table basic information groups.

[0047] Step 6: determine the historical header information group in the historical header information group set corresponding to the matching historical table basic information group as a template header information set.

[0048] Step 102: in response to detecting a selection operation on any header control included in each header control, determining a header type corresponding to the any header control as a target header type.

[0049] In some embodiments, the execution subject may determine the header type corresponding to any header control included in the above header controls as the target header type in response to detecting a selection operation acting on any header control included in the above header controls. The selection operation may be but is not limited to at least one of the following: click, slide, hover.

[0050] Step 103: Display a header configuration module corresponding to the target header type.

[0051] In some embodiments, the execution entity may display a header configuration module corresponding to the target header type. The header configuration module may be a module for configuring header information. The header configuration module may include but is not limited to a template header information control set corresponding to the target template header information group. The target template header information in the target template header information group may correspond one-to-one to the template header information controls in the template header information control set. The target template header information in the target template header information group may be the template header information corresponding to the target header type in the template header information set. The template header information controls in the template header information control set may be controls for modifying template header information. Each template header information control in the template header information control set may be displayed according to each header level included in the corresponding target template header information group. As an example, the target header type is a column header, and the display method of each template header information control is as follows: Figure 3 shown.

[0052] Step 104 , in response to detecting a selection operation of any template header information control included in the corresponding template header information control set, displaying an edit operation control set corresponding to the preset operation information set.

[0053] In some embodiments, the execution subject may display the editing operation control set corresponding to the preset operation information set in response to detecting the selection operation of any template header information control included in the template header information control set. Among them, the preset operation information in the preset operation information set may be pre-set information representing the operation on the header. The preset operation information may include but is not limited to the operation type. The operation type may be but is not limited to one of the following: adding a child node, adding a root node, adjusting a node element, deleting a current node, moving up the current node, and moving down the current node. The above-mentioned adding a child node may represent adding a header, and the header level of the added header is greater than the header level of the corresponding header, and the difference value of the header level is 1. For example, if the level of the corresponding header is 2, then adding a child node may be adding a header with a level of 3 under the corresponding header, and the corresponding header is the parent node of the newly added header. The above-mentioned adding a root node may represent adding a header with a level of 1. The above-mentioned adjusting a node element may represent modifying the header field of the corresponding header. The above-mentioned deleting the current node may represent deleting the corresponding header. The above-mentioned moving up the current node may represent reducing the position of the corresponding table header in the hierarchy by a preset position. The above-mentioned preset position may be a preset position. For example, the above-mentioned preset position may be 1. The above-mentioned moving down the current node may represent increasing the position of the corresponding table header in the hierarchy by a preset position. The preset operation information in the above-mentioned preset operation information set and the editing operation control in the above-mentioned editing operation control set may correspond one to one. The above-mentioned editing operation control may be a control for performing an editing operation corresponding to the preset operation information.

[0054] Step 105, in response to detecting a selection operation acting on any editing operation control included in the editing operation control set, the target template header information corresponding to any template header information control included in the target template header information group is updated according to the preset operation information corresponding to any editing operation control included in the preset operation information set to obtain updated header information.

[0055] In some embodiments, the execution subject may, in response to detecting a selection operation acting on any edit operation control included in the edit operation control set, update the target template header information group according to the preset operation information corresponding to any edit operation control included in the preset operation information set to obtain an updated header information group. In practice, first, the execution subject may determine the preset operation information corresponding to any edit operation control included in the preset operation information set as the target preset operation information. Then, an operation corresponding to the operation type included in the target preset operation information is executed to update the target template header information group to obtain an updated header information group.

[0056] As an example, if the preset operation information corresponding to any editing operation control includes an operation type of deleting the current node, the target template header information corresponding to any template header information control in the above target template header information group is deleted to obtain an updated header information group.

[0057] As another example, if the operation type included in the preset operation information corresponding to any editing operation control is adding a root node, the newly added header information is added to the above-mentioned target template header information group to obtain an updated header information group. Among them, the header field included in the above-mentioned newly added header information can be a field entered by the user. The header type included in the above-mentioned newly added header information is the above-mentioned target header type. The header level included in the above-mentioned newly added header information is 1.

[0058] As another example, if the preset operation information corresponding to any editing operation control includes an operation type of adjusting node elements, the header field input by the user is updated to the header field included in the target template header information corresponding to any template header information control in the above-mentioned target template header information group to obtain an updated header information group.

[0059] Step 106: Update the template header information set according to the updated header information group to obtain a target updated header information set.

[0060] In some embodiments, the execution subject may update the template header information set according to the update header information group to obtain a target update header information set. The target update header information set may be each header information finally determined by the user. In practice, the execution subject may update each template header information corresponding to the target header type in the template header information set to the update header information group to obtain a target update header information set.

[0061] Step 107 , in response to detecting the confirmation operation of generating a table, generating table information with a header according to the target updated header information set and the preset tree structure header generation model.

[0062] In some embodiments, the execution subject may respond to the detection of the confirmation table generation operation, update the header information set and the preset tree structure header generation model according to the target, and generate the table information with the header. Among them, the confirmation table generation operation may represent the operation of requesting the user to confirm the need to generate a new table. The preset tree structure header generation model may be a tree structure with the header type and the header information of the corresponding header type as input and the table header information as output. The table header information may be the information of the table corresponding to the header. The table header information may include but is not limited to the header position information and the header field. The header position information may represent the position of the corresponding header in the table. The header position information may include but is not limited to the number of header rows, the number of header columns, and the header merge information. The number of header rows may be the number of rows where the header is located. The number of header columns may be the number of columns where the header is located. The header merge information may represent whether the header is a merged row or a merged column. The header merge information may include but is not limited to at least one of the following: merge type, merged row number, and merged column number. The above-mentioned merge type may be, but is not limited to, one of the following: no merge, merge rows, merge columns. The above-mentioned merged rows may represent that the cells corresponding to the header merge at least two rows. The above-mentioned merged columns may represent that the cells corresponding to the header merge at least two columns. The above-mentioned number of merged rows may represent the number of merged rows when the merge type is merged rows. The above-mentioned number of merged columns may represent the number of merged columns when the merge type is merged columns. Each node in the above-mentioned tree structure corresponds to each header information in the same header type. It should be noted that the root node in the above-mentioned tree structure corresponds to the header with the minimum header level. In practice, first, the above-mentioned execution subject may determine the various target update header information in the above-mentioned target update header information set that meets the preset first type condition as the first header information group to be generated. Among them, the above-mentioned preset first type condition may be that the header type included in the target update header information is a column header. Secondly, the various target update header information in the above-mentioned target update header information set that meets the preset second type condition is determined as the second header information group to be generated. Among them, the above-mentioned preset second type condition can be that the header type included in the target updated header information is a row header. Then, the above-mentioned first header information group to be generated and the header type corresponding to the above-mentioned first header information group to be generated are input into the above-mentioned preset tree structure header generation model to obtain the first table header information. After that, the above-mentioned second header information group to be generated and the header type corresponding to the above-mentioned second header information group to be generated are input into the above-mentioned preset tree structure header generation model to obtain the second table header information. Finally, the above-mentioned first table header information and the above-mentioned second table header information are combined to obtain the table information with header. The above-mentioned combination method can be character splicing.

[0063] Step 108 : displaying a table with a header corresponding to the table with a header information according to the table with a header information.

[0064] In some embodiments, the execution subject may display a table with a header corresponding to the table with a header information according to the table with a header information. In practice, for each header field included in the table with a header information, the header field is filled into a cell corresponding to the target header position information in a preset table template to obtain a table with a header. The target header position information may be the header position information of the corresponding header field. The preset table template may be a template of a pre-set table. Then, the table with a header is displayed.

[0065] Optionally, the table header design module may further include various column header controls corresponding to preset column header information groups. The preset column header information included in the preset column header information group may correspond one-to-one to the column header controls in various column header controls. The preset column header information in the preset column header information group may be information of preset column headers. The column header titles may be titles of row headers corresponding to various column headers. The preset column header information may include a title field. The title field may be a field corresponding to the column header title. The column header controls in the various column header controls may be controls for setting information of column header titles.

[0066] Optionally, before step 108, the execution subject may further perform the following steps:

[0067] The first step is to display a title field editing window in response to detecting a selection operation acting on any column header control included in the above-mentioned column header title controls. The above-mentioned title field editing window can be a window for editing title fields. The above-mentioned title field editing window can include but is not limited to a title field input box and an input confirmation control. The above-mentioned title field input box can be used for the user to input the column header title field. The above-mentioned column header title field can be a field corresponding to the column header title. The above-mentioned input confirmation control can be a control for the user to confirm the input column header title field.

[0068] In the second step, the preset column header title information corresponding to any of the above-mentioned column header title controls in the above-mentioned preset column header title information group is determined as the column header title information to be updated.

[0069] The third step is to update the column header title information to be updated according to the column header title field input by the user in response to the detection of the selection operation acting on the input confirmation control, and obtain the updated column header title information. In practice, the execution subject can update the title field included in the column header title information to be updated to the column header title field input by the user in response to the detection of the selection operation acting on the input confirmation control, and obtain the updated column header title information.

[0070] Optionally, the preset column header title information in the preset column header title information group may further include column header title style information. Among them, the column header title style information may characterize the style of the column header title. The column header title style information may include but is not limited to at least one of the following: title color, title column width. The title color may be the color of the cell to which the column header title belongs. The title column width may be the column width of the cell to which the column header title belongs. The title field editing window may further include a title style setting input box. The title style setting input box may be used for the user to input column header title style information.

[0071] In some optional implementations of some embodiments, the execution subject may update the column header title information to be updated according to the column header title style information and the column header title field input by the user to obtain updated column header title information. In practice, the execution subject may update the title field included in the column header title information to be updated to the column header title field input by the user, and update the column header title style information included in the column header title information to be updated to the column header title style information input by the user to obtain updated column header title information.

[0072] In the fourth step, the table information with header is updated according to the updated column header title information to obtain updated information as the table information with header. In practice, the execution subject may add the updated column header title information to the table information with header to obtain updated information as the table information with header.

[0073] Optionally, the table header design module may further include various data table value controls. Among them, the data table value controls in the various data table value controls may be controls for setting the value source of the data in the data cell. The data cell may be a cell corresponding to the data that the user needs to display in the table. Each data table value control corresponds to a data cell in the table.

[0074] Optionally, the above execution entity may further perform the following steps:

[0075] In the first step, in response to detecting a selection operation acting on any of the above-mentioned data table value controls, a value attribute information input window is displayed. The above-mentioned value attribute information input window may be a window for inputting value attribute information. The above-mentioned value attribute information may be information about the attributes of a value-taking activity. The above-mentioned value-taking activity may be an activity for obtaining a numerical value. The above-mentioned value attribute information input window may include, but is not limited to, each value attribute information input box corresponding to each attribute type. Each attribute type corresponds to a value attribute information. The value attribute information input box may be used for a user to input information of the corresponding attribute type. The above-mentioned attribute type may be, but is not limited to, one of the following: a value identification, a value element. The above-mentioned value identification may be a unique identification of the corresponding value-taking activity. For example, the above-mentioned value identification may be a value code. The above-mentioned value element may be a column header to which the value-taking activity belongs. For example, if the column header of a column in a table is "check-in days", the value element may be "check-in days". The above-mentioned value attribute information input window may also include an attribute information confirmation control. The above-mentioned attribute information confirmation control may be used for the user to confirm the input value attribute information.

[0076] In the second step, in response to detecting a selection operation acting on the above-mentioned attribute information confirmation control, a value configuration module is displayed. The above-mentioned value configuration module can be a page module for users to configure query statements for obtaining data. The above-mentioned value configuration module can include but is not limited to a query statement input text box and a save control. The above-mentioned query statement input text box can be used for users to input value query statements. The above-mentioned value query statement can be an SQL query statement for obtaining corresponding cell data. The above-mentioned save control can be a control for saving value query statements.

[0077] In the third step, in response to detecting the selection operation acting on the above-mentioned saving control, the value query statement input by the user is determined as a cell value query statement corresponding to the above-mentioned arbitrary data table value control. Among them, the cell value query statement corresponding to the above-mentioned arbitrary data table value control can be a value query statement corresponding to the cell of the above-mentioned arbitrary data table value control.

[0078] In the process of adopting technical solutions to solve the technical problems in the background technology, the following technical problems are often accompanied: when using a prepared table with a header to query data, how to display the query data that the user is interested in. In response to the above technical problems, the conventional solution is generally: display the query data in the table according to a preset style. However, the above conventional solution still has the following problems: different requesting users have different concerns for each query data in the same query data table, and different users have different marking habits. Using the same style to display query data makes it less convenient for users to view the query data they are interested in, resulting in a poor user experience.

[0079] Considering the problems of the above conventional solutions and combining the advantages of big data, the following solutions can be adopted:

[0080] Optionally, the form creation request information may include a requesting user identifier, wherein the requesting user identifier may be a unique identifier of the requesting user.

[0081] Optionally, the above execution entity may further perform the following steps:

[0082] The first step is to obtain the user authority type corresponding to the above-mentioned requesting user identifier in response to receiving the data query operation corresponding to the above-mentioned table with header. Among them, the above-mentioned data query operation can be an operation that characterizes the query data. The above-mentioned data query request operation can correspond to query condition information. The above-mentioned query condition information can characterize the conditions for querying data entered by the requesting user. The above-mentioned query condition information may include a query condition set. The query conditions in the above-mentioned query condition set can be query conditions entered by the requesting user. The above-mentioned user authority type can characterize whether the above-mentioned requesting user has the authority to query data and the level of authority. The above-mentioned user authority type can be but not limited to one of the following: no authority, first-level authority, second-level authority, and third-level authority. It should be noted that the higher the authority level, the larger the range of data that can be queried. In practice, the above-mentioned execution subject can obtain the user authority type corresponding to the above-mentioned requesting user identifier from the database through a wired connection or a wireless connection in response to receiving the data query request operation corresponding to the above-mentioned table with header.

[0083] In the second step, in response to determining that the above-mentioned user authority type meets the preset authority conditions, the query statements for each cell value corresponding to the above-mentioned table with header are executed according to the above-mentioned query condition information to obtain a query data set. Among them, the above-mentioned preset authority condition may be that the user authority type has authority. The cell value query statements in the above-mentioned cell value query statements may correspond one-to-one to the query data in the above-mentioned query data set. The query data in the above-mentioned query data set may be the data obtained by executing the corresponding cell value query statement according to the above-mentioned query condition information. In practice, the above-mentioned execution subject may, in response to determining that the above-mentioned user authority type meets the preset authority conditions, execute the above-mentioned cell value query statement for each cell value query statement corresponding to the above-mentioned table with header according to the query condition set included in the above-mentioned query condition information to obtain query data. Then, the obtained query data are determined as the query data set.

[0084] The third step is to add the query data set to the table with header to obtain the query data table. In practice, for each query data included in the query data set, the execution entity may add the query data to the cell corresponding to the query data included in the table with header to obtain the query data table.

[0085] The fourth step is to obtain a preset annotation color sequence corresponding to the above-mentioned requesting user identifier. Among them, the above-mentioned preset annotation color sequence can be a sequence of various preset annotation colors preset by the corresponding user arranged in order from high to low according to the data rank range. The preset annotation colors in the preset annotation color sequence can be colors preset by the corresponding user for marking the data in the cell. The preset annotation colors in the above-mentioned preset annotation color sequence correspond to a preset data rank range. The above-mentioned preset data rank range can be a preset data rank range. The above-mentioned data rank can be the rank of the corresponding data in the data sequence. In practice, the above-mentioned execution entity can obtain the preset annotation color sequence corresponding to the above-mentioned requesting user identifier from the database through a wired connection or a wireless connection.

[0086] The fifth step is to determine the user-concerned column header information according to the above-mentioned user authority type, the above-mentioned query condition information and the above-mentioned target update header information set. In practice, the above-mentioned execution subject can input the above-mentioned user authority type, the query condition set included in the above-mentioned query condition information and the various header fields of the corresponding column header included in the above-mentioned target update header information set into a pre-trained user-concerned column header information generation model to obtain the user-concerned column header information. Among them, the above-mentioned user-concerned column header information generation model can be a classification model that takes the user authority type, the query condition set and the various header fields of the corresponding column header as input and takes the user-concerned column header information as output. Among them, the above-mentioned classification model can be a support vector machine or a neural network. The above-mentioned user-concerned column header information can represent the information of the column header that the user is concerned about. The above-mentioned user-concerned column header information can include at least one column header field. The above-mentioned column header field can be a header field of the corresponding column header.

[0087] Step 6: for each list header field included in the at least one list header field, perform the following sub-steps:

[0088] In the first sub-step, each query data corresponding to the column header field in the query data set is determined as a target query data set, wherein the query data corresponding to the column header field can be query data whose column header field of the corresponding cell is the same as the column header field.

[0089] The second sub-step is to determine the data rank of each target query data included in the target query data set. In practice, first, the execution subject may arrange the target query data included in the target query data set in order from large to small or from small to large to obtain a target query data sequence. Then, for each target query data included in the target query data set, the rank of the target query data in the target query data sequence is determined as the data rank of the target query data.

[0090] The third sub-step is to determine, for each determined data rank, the preset annotation color corresponding to the data rank in the preset annotation color sequence as the cell annotation color of the cell corresponding to the data rank. The preset annotation color corresponding to the data rank may be a preset annotation color corresponding to the preset data rank range to which the data rank belongs. The cell annotation color may be the display color of the corresponding cell.

[0091] Step 7, display the query data table according to the determined cell marking colors. In practice, the execution entity may display the cells corresponding to the cell marking colors in the query data table according to the corresponding cell marking colors, and display the remaining cells in the query data table according to preset colors. Among them, the remaining cells in the remaining cells are cells that do not have corresponding cell marking colors in the query data table. The preset color may be a pre-set color. For example, the preset color may be white.

[0092] The above technical solution and its related contents, as an inventive point of the embodiments of the present disclosure, solve the technical problem of "poor user experience". The factors leading to poor user experience are often as follows: different requesting users have different concerns about each query data in the same query data table, and different users have different annotation habits. The query data is displayed in the same style, which makes it less convenient for users to view the query data of interest, resulting in poor user experience. If the above factors are solved, the effect of improving user experience can be achieved. In order to achieve this effect, the method for displaying a table with a header in some embodiments of the present disclosure, first, in response to receiving a data query request operation corresponding to the table with a header, obtains a user permission type corresponding to the requesting user identifier. Among them, the data query request operation corresponds to query condition information. Therefore, when it is necessary to apply the table with a header to query data, the user permission of the requesting user can be obtained, which can be used to determine whether the requesting user has the permission to query data. Secondly, in response to determining that the user permission type meets the preset permission condition, according to the query condition information, the query statement for obtaining the value of each cell corresponding to the table with a header is executed to obtain a query data set. Therefore, when the requesting user has the permission to query data, the query data set can be obtained, which can be used to display to the requesting user. Then, the query data set is added to the table with header to obtain the query data table. Thus, a table including the query data set can be obtained, which can be used for display. After that, a preset annotation color sequence corresponding to the requesting user identifier is obtained. Among them, the preset annotation colors in the preset annotation color sequence correspond to a preset data rank range. Thus, a color sequence for annotating data that the requesting user is accustomed to using can be obtained, which can be used to determine the display color of the cell corresponding to each query data. Next, according to the user permission type, the query condition information and the target update header information set, the user's attention column header information is determined. Among them, the user's attention column header information includes at least one column header field. Thus, the column header to which the query data that the user is interested belongs can be obtained, which can be used to annotate the query data that the user is interested in. Next, for each column header field included in the at least one column header field, the following steps are performed: determine each query data corresponding to the column header field in the query data set as the target query data set; for each target query data included in the target query data set, determine the data rank of the target query data; for each determined data rank, determine the preset annotation color corresponding to the data rank in the preset annotation color sequence as the cell annotation color of the cell corresponding to the data rank. Thus, the annotation color that the user is accustomed to using can be determined as the annotation color of the query data that the user is interested in, so that the user can easily view the query data that he is interested in. Finally, display the query data table according to the determined cell annotation colors.Therefore, when the user queries data, the query data that the user is interested in can be marked according to the user's habits, thereby improving the convenience of the user viewing the query data that the user is interested in, and thus improving the user experience. Also, when displaying the query data, the query data that the user is more interested in can be marked and displayed according to the user's habitual marking color, thereby improving the convenience of the user viewing the query data that the user is interested in, thereby improving the user experience.

[0093] The above-mentioned embodiments of the present disclosure have the following beneficial effects: through the table display method with a header of some embodiments of the present disclosure, the user operation can be simplified and the time for creating a table can be saved. Specifically, the reason why the user's operation is cumbersome and it takes a long time to create a table is that every time a new table is created, the user needs to start designing and creating again according to the needs. When the table header design to be created is more complicated, the user's operation is cumbersome and it takes a long time to create a table. Based on this, the table display method with a header of some embodiments of the present disclosure, first, in response to detecting the table creation request information, displays the table header design module in the table design interface. Among them, the table header design module includes each header control corresponding to the template header information set. The template header information in the template header information set includes the header type. Thus, each header control of the corresponding table template can be displayed, so that it can be used to modify each header. Secondly, in response to detecting the selection operation acting on any header control included in the above header controls, the header type corresponding to the above any header control is determined as the target header type. Thus, the header type that the user wants to modify can be obtained, so that it can be used to modify the information of each header of the corresponding target header type. Then, the header configuration module corresponding to the above target header type is displayed. Among them, the above header configuration module includes a template header information control set corresponding to the target template header information group. The target template header information in the above target template header information group is the template header information corresponding to the above target header type in the above template header information set. Thus, each control of each header corresponding to the header type that the user wants to modify can be displayed, so that it can be used to modify the header information corresponding to each control. Afterwards, in response to detecting the selection operation of any template header information control included in the above template header information control set, the editing operation control set corresponding to the preset operation information set is displayed. Thus, the editing operation control set that can correspond to each modification operation type can be displayed, so that the template header information can be modified. Then, in response to detecting the selection operation acting on any editing operation control included in the above editing operation control set, according to the preset operation information corresponding to the above any editing operation control included in the above preset operation information set, the above target template header information group is updated and processed to obtain an updated header information group. Thus, each template header information corresponding to the target header type can be modified, so that it can be used to regenerate a table with a header. Next, according to the above-mentioned updated header information group, the above-mentioned template header information set is updated to obtain the target updated header information set. Thus, each modified header information can be obtained, so that it can be used to regenerate a table with a header. Afterwards, in response to detecting the confirmation operation of generating a table, the table information with a header is generated according to the above-mentioned target updated header information set and the above-mentioned preset tree structure header generation model.Therefore, when the user confirms that a table needs to be generated, the information of the table with a header can be automatically generated through the model constructed by the various header information modified by the user and the tree structure, so that the table with a header can be displayed. Finally, according to the above-mentioned table with a header information, the table with a header corresponding to the above-mentioned table with a header information is displayed. In this way, the table with a header can be displayed, thereby shortening the time spent on creating the table with a header. Also, when creating a table, the header information of each level of the corresponding header type can be directly modified through the operation interface, and then the information of the table is automatically generated through the tree model, so that the user does not need to rewrite the program or design the table, thereby simplifying the user operation and shortening the time spent on creating the table.

[0094] Further references Figure 4 As an implementation of the methods shown in the above figures, the present disclosure provides some embodiments of a table display device with a table header, and these device embodiments are Figure 1 Corresponding to the method embodiments shown, the device can be specifically applied to various electronic devices.

[0095] like Figure 4As shown, the table display device 400 with a table header in some embodiments includes: a first display unit 401, a determination unit 402, a second display unit 403, a third display unit 404, a first updating unit 405, a second updating unit 406, a generating unit 407 and a fourth display unit 408. Among them, the first display unit 401 is configured to display a table header design module in the table design interface in response to detecting a table creation request information, wherein the above-mentioned table header design module includes various header controls corresponding to the template header information set, and the template header information in the above-mentioned template header information set includes a header type; the determination unit 402 determines the header type corresponding to the above-mentioned arbitrary header control as the target header type in response to detecting a selection operation acting on any header control included in the above-mentioned various header controls; the second display unit 403 is configured to display a header configuration module corresponding to the above-mentioned target header type, wherein the above-mentioned header configuration module includes a template header information control set corresponding to the target template header information group, and the target template header information in the above-mentioned target template header information group is the template header information corresponding to the above-mentioned target header type in the above-mentioned template header information set; the third display unit 404 is configured to display a table header configuration module corresponding to the above-mentioned target header type in response to detecting a selection operation corresponding to the above-mentioned template table The selection operation of any template header information control included in the header information control set displays the editing operation control set corresponding to the preset operation information set; the first updating unit 405 is configured to respond to the detection of the selection operation acting on any editing operation control included in the above-mentioned editing operation control set, and update the above-mentioned target template header information group according to the preset operation information corresponding to the above-mentioned any editing operation control included in the above-mentioned preset operation information set, so as to obtain the updated header information group; the second updating unit 406 is configured to update the above-mentioned template header information set according to the above-mentioned updated header information group, so as to obtain the target updated header information set; the generating unit 407 is configured to respond to the detection of the confirmation operation of generating a table, and generate the table information with header according to the above-mentioned target updated header information set and the preset tree structure header generation model; the fourth display unit 408 is configured to display the table with header corresponding to the above-mentioned table information with header according to the above-mentioned table information with header.

[0096] It is understandable that the units recorded in the table display device 400 with a header are similar to the reference Figure 1 Therefore, the operations, features and beneficial effects described above for the method are also applicable to the device 400 and the units included therein, and will not be described in detail here.

[0097] Reference below Figure 5, which shows a schematic diagram of the structure of an electronic device 500 suitable for implementing some embodiments of the present disclosure. The electronic devices in some embodiments of the present disclosure may include but are not limited to mobile terminals such as mobile phones, laptop computers, digital broadcast receivers, PDAs (personal digital assistants), PADs (tablet computers), PMPs (portable multimedia players), vehicle-mounted terminals (such as vehicle-mounted navigation terminals), etc., and fixed terminals such as digital TVs, desktop computers, etc. Figure 5 The electronic device shown is only an example and should not bring any limitation to the functions and scope of use of the embodiments of the present disclosure.

[0098] like Figure 5 As shown, the electronic device 500 may include a processing device (e.g., a central processing unit, a graphics processing unit, etc.) 501, which can perform various appropriate actions and processes according to a program stored in a read-only memory (ROM) 502 or a program loaded from a storage device 508 into a random access memory (RAM) 503. In the RAM 503, various programs and data required for the operation of the electronic device 500 are also stored. The processing device 501, the ROM 502, and the RAM 503 are connected to each other via a bus 504. An input / output (I / O) interface 505 is also connected to the bus 504.

[0099] Typically, the following devices may be connected to the I / O interface 505: an input device 506 including, for example, a touch screen, a touch pad, a keyboard, a mouse, a camera, a microphone, an accelerometer, a gyroscope, etc.; an output device 507 including, for example, a liquid crystal display (LCD), a speaker, a vibrator, etc.; a storage device 508 including, for example, a magnetic tape, a hard disk, etc.; and a communication device 509. The communication device 509 may allow the electronic device 500 to communicate with other devices wirelessly or by wire to exchange data. Although Figure 5 The electronic device 500 is shown with various devices, but it should be understood that it is not required to implement or possess all the devices shown. More or fewer devices may be implemented or possessed instead. Figure 5 Each block shown in the figure may represent one device, or may represent multiple devices as required.

[0100] In particular, according to some embodiments of the present disclosure, the process described above with reference to the flowchart can be implemented as a computer software program. For example, some embodiments of the present disclosure include a computer program product, which includes a computer program carried on a computer-readable medium, and the computer program includes a program code for executing the method shown in the flowchart. In some such embodiments, the computer program can be downloaded and installed from the network through the communication device 509, or installed from the storage device 508, or installed from the ROM 502. When the computer program is executed by the processing device 501, the above-mentioned functions defined in the method of some embodiments of the present disclosure are executed.

[0101] It should be noted that the computer-readable medium recorded in some embodiments of the present disclosure may be a computer-readable signal medium or a computer-readable storage medium or any combination of the above two. The computer-readable storage medium may be, for example, but not limited to, an electrical, magnetic, optical, electromagnetic, infrared, or semiconductor system, device or device, or any combination of the above. More specific examples of computer-readable storage media may include, but are not limited to: an electrical connection with one or more wires, a portable computer disk, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disk read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the above. In some embodiments of the present disclosure, a computer-readable storage medium may be any tangible medium containing or storing a program that can be used by or in combination with an instruction execution system, device or device. In some embodiments of the present disclosure, a computer-readable signal medium may include a data signal propagated in a baseband or as part of a carrier wave, which carries a computer-readable program code. This propagated data signal may take a variety of forms, including but not limited to electromagnetic signals, optical signals, or any suitable combination of the above. The computer readable signal medium may also be any computer readable medium other than a computer readable storage medium, which may send, propagate or transmit a program for use by or in conjunction with an instruction execution system, apparatus or device. The program code contained on the computer readable medium may be transmitted using any suitable medium, including but not limited to: wires, optical cables, RF (radio frequency), etc., or any suitable combination of the above.

[0102] In some embodiments, the client and the server may communicate using any currently known or future developed network protocol such as HTTP (Hyper Text Transfer Protocol), and may be interconnected with any form or medium of digital data communication (e.g., a communication network). Examples of communication networks include a local area network ("LAN"), a wide area network ("WAN"), an internet (e.g., the Internet), and a peer-to-peer network (e.g., an ad hoc peer-to-peer network), as well as any currently known or future developed network.

[0103] The above-mentioned computer-readable medium may be included in the above-mentioned electronic device; or it may exist independently without being assembled into the electronic device. The above-mentioned computer-readable medium carries one or more programs. When the above-mentioned one or more programs are executed by the electronic device, the electronic device: in response to detecting the form creation request information, displaying a table header design module in the table design interface, wherein the above-mentioned table header design module includes each header control corresponding to the template header information set, and the template header information in the above-mentioned template header information set includes a header type; in response to detecting a selection operation acting on any header control included in the above-mentioned each header control, determining the header type corresponding to the above-mentioned any header control as the target header type; displaying a header configuration module corresponding to the above-mentioned target header type, wherein the above-mentioned header configuration module includes a template header information control set corresponding to the target template header information group, and the target template header information in the above-mentioned target template header information group is the template header information set corresponding to the above-mentioned target template header information set. template header information of a header type; in response to detecting a selection operation corresponding to any template header information control included in the above template header information control set, displaying an editing operation control set corresponding to a preset operation information set; in response to detecting a selection operation acting on any editing operation control included in the above editing operation control set, updating the above target template header information group according to the preset operation information corresponding to the above any editing operation control included in the above preset operation information set to obtain an updated header information group; updating the above template header information set according to the above updated header information group to obtain a target updated header information set; in response to detecting a confirmation operation to generate a table, generating table information with header according to the above target updated header information set and a preset tree structure header generation model; and displaying a table with header corresponding to the above table information with header according to the above table information with header.

[0104] Computer program code for performing the operations of some embodiments of the present disclosure may be written in one or more programming languages ​​or a combination thereof, including object-oriented programming languages ​​such as Java, Smalltalk, C++, and conventional procedural programming languages ​​such as "C" or similar programming languages. The program code may be executed entirely on the user's computer, partially on the user's computer, as a separate software package, partially on the user's computer and partially on a remote computer, or entirely on a remote computer or server. In cases involving a remote computer, the remote computer may be connected to the user's computer via any type of network, including a local area network (LAN) or a wide area network (WAN), or may be connected to an external computer (e.g., via the Internet using an Internet service provider).

[0105] The flow chart and block diagram in the accompanying drawings illustrate the possible architecture, function and operation of the system, method and computer program product according to various embodiments of the present disclosure. In this regard, each square box in the flow chart or block diagram can represent a module, a program segment or a part of a code, and the module, the program segment or a part of the code contains one or more executable instructions for realizing the specified logical function. It should also be noted that in some implementations as replacements, the functions marked in the square box can also occur in a sequence different from that marked in the accompanying drawings. For example, two square boxes represented in succession can actually be executed substantially in parallel, and they can sometimes be executed in the opposite order, depending on the functions involved. It should also be noted that each square box in the block diagram and / or flow chart, and the combination of the square boxes in the block diagram and / or flow chart can be implemented with a dedicated hardware-based system that performs a specified function or operation, or can be implemented with a combination of dedicated hardware and computer instructions.

[0106] The units described in some embodiments of the present disclosure may be implemented by software or by hardware. The described units may also be provided in a processor, for example, may be described as: a processor comprising a first display unit, a determination unit, a second display unit, a third display unit, a first update unit, a second update unit, a generation unit, and a fourth display unit. The names of these units do not, in certain cases, constitute limitations on the units themselves, for example, the first display unit may also be described as "a unit that displays a table header design module in a table design interface in response to detecting a table creation request message".

[0107] The functions described above herein may be performed at least in part by one or more hardware logic components. For example, without limitation, exemplary types of hardware logic components that may be used include: field programmable gate arrays (FPGAs), application specific integrated circuits (ASICs), application specific standard products (ASSPs), systems on chips (SOCs), complex programmable logic devices (CPLDs), and the like.

[0108] The above descriptions are only some preferred embodiments of the present disclosure and an explanation of the technical principles used. Those skilled in the art should understand that the scope of the invention involved in the embodiments of the present disclosure is not limited to the technical solutions formed by a specific combination of the above-mentioned technical features, but should also cover other technical solutions formed by any combination of the above-mentioned technical features or their equivalent features without departing from the above-mentioned inventive concept. For example, the above-mentioned features are replaced with the technical features with similar functions disclosed in the embodiments of the present disclosure (but not limited to) and the technical solutions formed.

Claims

1. A method for displaying a table with a table header, comprising: In response to detecting the form creation request information, displaying a form header design module in the form design interface, wherein the form header design module includes various header controls corresponding to the template header information set, the template header information in the template header information set includes a header type and a header level, and the form creation request information includes a requesting user identifier; In response to detecting a selection operation acting on any header control included in the various header controls, determining a header type corresponding to the any header control as a target header type; Displaying a header configuration module corresponding to the target header type, wherein the header configuration module includes a template header information control set corresponding to a target template header information group, the target template header information in the target template header information group is the template header information corresponding to the target header type in the template header information set, and each template header information control in the template header information control set is displayed according to each header level included in the corresponding target template header information group; In response to detecting a selection operation of any template header information control included in the template header information control set, displaying an edit operation control set corresponding to a preset operation information set; In response to detecting a selection operation acting on any edit operation control included in the edit operation control set, updating the target template header information group according to preset operation information corresponding to the any edit operation control included in the preset operation information set to obtain an updated header information group; According to the update header information group, the template header information set is updated to obtain a target update header information set; In response to detecting a confirmation table generation operation, updating the header information set and a preset tree structure header generation model according to the target, generating table information with a header, wherein the preset tree structure header generation model takes a header type and each header information of the corresponding header type as input, and takes the table header information as output in a tree structure, wherein a root node in the tree structure corresponds to a header with a minimum header level; According to the table information with headers, displaying the table with headers corresponding to the table information with headers; In response to receiving a data query operation corresponding to the table with a header, obtaining a user authority type corresponding to the requesting user identifier, wherein the data query request operation corresponds to query condition information; In response to determining that the user authority type meets the preset authority condition, executing a query statement for obtaining values ​​of each cell of the table with a header according to the query condition information to obtain a query data set; Add the query data set to the table with header to obtain a query data table; Obtaining a preset marking color sequence corresponding to the requesting user identifier; Determine the user concerned column header information according to the user permission type, the query condition information and the target update column header information set, wherein the user concerned column header information includes at least one column header field; For each list header field included in the at least one list header field, perform the following sub-steps: Determine each query data corresponding to the column header field in the query data set as a target query data set; For each target query data included in the target query data set, determining a data rank of the target query data; For each determined data rank, determining the preset marking color corresponding to the data rank in the preset marking color sequence as the cell marking color of the cell corresponding to the data rank; The query data table is displayed according to the determined marking colors of each cell.

2. The method according to claim 1, wherein: The table header design module also includes each column header title control corresponding to the preset column header title information group; and before displaying the header table corresponding to the header table information according to the header table information, the method also includes: In response to detecting a selection operation on any column header control included in the column header controls, displaying a title field editing window, wherein the title field editing window includes a title field input box and an input confirmation control, and the title field input box is used for a user to input a column header title field; Determine the preset column header title information corresponding to the arbitrary column header title control in the preset column header title information group as the column header title information to be updated; In response to detecting a selection operation acting on the input confirmation control, updating the column header title information to be updated according to the column header title field input by the user to obtain updated column header title information; According to the updated column header title information, the table information with header is updated to obtain the updated table information with header as the table information with header.

3. The method according to claim 2, wherein: The preset column header title information in the preset column header title information group includes column header title style information, the title field editing window also includes a title style setting input box, and the title style setting input box is used for the user to input the column header title style information; and the updating process of the column header title information to be updated according to the column header title field input by the user to obtain the updated column header title information includes: According to the column header title style information and the column header title field input by the user, the column header title information to be updated is updated to obtain updated column header title information.

4. The method according to claim 1, wherein: The table header design module also includes various data table value controls, and the method also includes: In response to detecting a selection operation acting on any of the data table value controls, displaying a value attribute information input window, wherein the value attribute information input window includes an attribute information confirmation control; In response to detecting a selection operation acting on the attribute information confirmation control, displaying a value configuration module, wherein the value configuration module includes a query statement input text box and a save control, and the query statement input text box is used for a user to input a value query statement; In response to detecting a selection operation acting on the save control, the value query statement input by the user is determined as a cell value query statement corresponding to the arbitrary data table value control.

5. The method according to claim 1, wherein: The table header design module displayed in the table design interface includes: Displaying a table attribute information setting window, wherein the table attribute information setting window includes various basic information input boxes and basic information saving controls, and the various basic information input boxes are used for the user to input various table basic information; In response to detecting a selection operation acting on the basic information saving control, determining each input table basic information as a table basic information set, and displaying a table design interface, wherein the table design interface includes a table header design control; In response to detecting a selection operation acting on the table header design control, determining a template header information set according to the table basic information set; A table header design module corresponding to the template header information set is displayed in the table design interface.

6. The method according to claim 5, wherein: The step of determining a template header information set according to the table basic information set includes: Determine each piece of table basic information in the table basic information set that meets the preset information condition as a target table basic information group; Obtain the history table header information set and the history table basic information set corresponding to the history table set; For each history table basic information group included in the history table basic information group set, the following steps are performed: Determine each historical table basic information in the historical table basic information group corresponding to the target table basic information group as a target historical table basic information group; For each target table basic information included in the target table basic information group, the following steps are performed: Determining the target history table basic information corresponding to the target table basic information in the target history table basic information group as information to be matched; Performing semantic feature extraction processing on the target table basic information to obtain first semantic feature information; Performing semantic feature extraction processing on the information to be matched to obtain second semantic feature information; Determining the similarity between the first semantic feature information and the second semantic feature information as semantic similarity; Determining information similarity based on the determined semantic similarities and a preset similarity weight set; Determine the information similarity that satisfies the preset similarity condition among the determined information similarities as the target information similarity; Determine the historical table basic information group corresponding to the target information similarity in the historical table basic information group set as a matching historical table basic information group; The historical header information group corresponding to the matching historical table basic information group in the historical header information group set is determined as a template header information set.

7. A table display device with a table header, comprising: A first display unit is configured to display a table header design module in a table design interface in response to detecting table creation request information, wherein the table header design module includes various table header controls corresponding to a template table header information set, the template table header information in the template table header information set includes a table header type and a table header level, and the table creation request information includes a requesting user identifier; a determining unit, in response to detecting a selection operation acting on any header control included in the various header controls, determining a header type corresponding to the any header control as a target header type; A second display unit is configured to display a header configuration module corresponding to the target header type, wherein the header configuration module includes a template header information control set corresponding to a target template header information group, the target template header information in the target template header information group is the template header information corresponding to the target header type in the template header information set, and each template header information control in the template header information control set is displayed according to each header level included in the corresponding target template header information group; A third display unit is configured to display an editing operation control set corresponding to a preset operation information set in response to detecting a selection operation of any template header information control included in the template header information control set; A first updating unit is configured to, in response to detecting a selection operation acting on any editing operation control included in the editing operation control set, update the target template header information group according to the preset operation information corresponding to the any editing operation control included in the preset operation information set to obtain an updated header information group; A second updating unit is configured to update the template header information set according to the update header information group to obtain a target update header information set; A generating unit is configured to, in response to detecting a confirmation table generation operation, generate table information with a header according to the target update header information set and a preset tree structure table header generation model, wherein the preset tree structure table header generation model takes a header type and each header information of the corresponding header type as input, and takes the table header information as output in a tree structure, wherein a root node in the tree structure corresponds to a header with a minimum header level; A fourth display unit is configured to display a table with a header corresponding to the table with a header information according to the table with a header information; In response to receiving a data query operation corresponding to the table with a header, obtaining a user authority type corresponding to the requesting user identifier, wherein the data query request operation corresponds to query condition information; In response to determining that the user authority type meets the preset authority condition, executing a query statement for obtaining values ​​of each cell of the table with a header according to the query condition information to obtain a query data set; Add the query data set to the table with header to obtain a query data table; Obtaining a preset marking color sequence corresponding to the requesting user identifier; Determine the user concerned column header information according to the user permission type, the query condition information and the target update column header information set, wherein the user concerned column header information includes at least one column header field; For each list header field included in the at least one list header field, perform the following sub-steps: Determine each query data corresponding to the column header field in the query data set as a target query data set; For each target query data included in the target query data set, determining a data rank of the target query data; For each determined data rank, determining the preset marking color corresponding to the data rank in the preset marking color sequence as the cell marking color of the cell corresponding to the data rank; The query data table is displayed according to the determined marking colors of each cell.

8. An electronic device, comprising: one or more processors; a storage device having one or more programs stored thereon, When the one or more programs are executed by the one or more processors, the one or more processors implement the method according to any one of claims 1 to 6.

9. A computer readable medium having a computer program stored thereon, wherein: When the computer program is executed by a processor, the method according to any one of claims 1 to 6 is implemented.

Images