Display method, device, equipment and storage medium for table information

Abstract

A method, device, equipment, and storage medium for displaying table information. The method for displaying table information includes: obtaining a row information display instruction of a target table, where the row information display instruction includes information of a target content row; and vertically displaying first information of a header row of the target table and second information of the target content row according to the row information display instruction, where a cell header row where the first information is located and a cell target content row where the second information is located have the same column identifier.

Description

[0001] This application claims the priority of a Chinese patent application with the application number 202010060461.3, filed with the Chinese Patent Office on January 19, 2020. The entire content of this application is incorporated herein by reference. Technical Field

[0002] The present disclosure relates to the display technology of tabular information, for example, to a method, device, equipment and storage medium for displaying tabular information. Background Art

[0003] Spreadsheets are indispensable tools for people to process data in their daily work. With the continuous change of people's needs, since online spreadsheets support multi-person collaboration and save the editing results in the cloud in real time. Therefore, online spreadsheets have been widely used in the market.

[0004] Taking online spreadsheets as an example, in terms of information display, online spreadsheets usually directly display various data in the table area. However, when there is a large amount of data in the online spreadsheet, the display content of the user device is limited, resulting in low efficiency for users to view data. Summary of the Invention

[0005] The present disclosure provides a method, device, equipment and storage medium for displaying tabular information to solve the technical problem of low efficiency for users to view data in the related art.

[0006] A method for displaying tabular information is provided, including:

[0007] Obtaining a row information display instruction of a target table, where the row information display instruction includes information of a target content row;

[0008] According to the row information display instruction, vertically displaying the first information of the header row of the target table and the second information of the target content row, where the cells where the first information is located and the cells where the second information is located have the same column identifier.

[0009] A device for displaying tabular information is also provided, including:

[0010] A first obtaining module configured to obtain a row information display instruction of a target table, where the row information display instruction includes information of a target content row;

[0011] A first display module configured to vertically display the first information of the header row of the target table and the second information of the target content row according to the row information display instruction, where the cells where the first information is located and the cells where the second information is located have the same column identifier.

[0012] An electronic device is also provided, including a memory and a processor. The memory stores a computer program. When the processor executes the computer program, the following steps are implemented:

[0013] Obtain a row information display instruction of a target table, where the row information display instruction includes information of a target content row;

[0014] According to the row information display instruction, vertically display the first information of the header row of the target table and the second information of the target content row, where the cells where the first information is located and the cells where the second information is located have the same column identifier.

[0015] A computer-readable storage medium is also provided, storing a computer program. When the computer program is executed by a processor, the following steps are implemented:

[0016] Obtain a row information display instruction of a target table, where the row information display instruction includes information of a target content row;

[0017] According to the row information display instruction, vertically display the first information of the header row of the target table and the second information of the target content row, where the cells where the first information is located and the cells where the second information is located have the same column identifier. Description of the Drawings

[0018] Figure 1 is a schematic flowchart of a method for displaying table information provided by an embodiment of the present invention;

[0019] Figure 2 is a schematic diagram of a target table provided by an embodiment of the present invention;

[0020] Figure 3 is a schematic diagram after vertically displaying the row information of the target content row provided by an embodiment of the present invention;

[0021] Figure 4 is a schematic flowchart of a method for displaying table information provided by another embodiment of the present invention;

[0022] Figure 5 is a schematic flowchart of a method for displaying table information provided by another embodiment of the present invention;

[0023] Figure 6 is a schematic flowchart of a method for displaying table information provided by another embodiment of the present invention;

[0024] Figure 7 is a schematic flowchart of a method for displaying table information provided by another embodiment of the present invention;

[0025] Figure 8It is a schematic flowchart of a method for displaying tabular information provided by another embodiment of the present invention;

[0026] Figure 9 It is a schematic internal structure diagram of a device for displaying tabular information provided by an embodiment of the present invention;

[0027] Figure 10 It is a schematic internal structure diagram of an electronic device provided by an embodiment of the present invention. Detailed implementation manners

[0028] Embodiments of the present disclosure will be described below with reference to the accompanying drawings. Although some embodiments of the present disclosure are shown in the drawings, the present disclosure can be implemented in various forms and should not be construed as limited to the embodiments set forth herein. The drawings and embodiments of the present disclosure are for illustrative purposes only and are not intended to limit the protection scope of the present disclosure.

[0029] The multiple steps described in the method embodiments of the present disclosure can be executed in different orders and / or in parallel. In addition, the method embodiments may include additional steps and / or omit the steps shown. The scope of the present disclosure is not limited in this regard.

[0030] The term "including" and its variants used herein are open-ended, that is, "including but not limited to". The term "based on" is "at least partially based on". The term "one embodiment" means "at least one embodiment"; the term "another embodiment" means "at least one additional embodiment"; the term "some embodiments" means "at least some embodiments". The relevant definitions of other terms will be given in the following description.

[0031] The concepts such as "first", "second", etc. mentioned in the present disclosure are only used to distinguish different devices, modules or units, and are not used to limit the order of the functions executed by these devices, modules or units or their interdependence. The modifiers "one" and "multiple" mentioned in the present disclosure are illustrative rather than restrictive, and should be understood as "one or more" unless clearly indicated otherwise in the context.

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

[0033] The execution subject of the following method embodiments may be a device for displaying tabular information, and this device can be implemented as part or all of an electronic device in a software, hardware or a combination of software and hardware manner. The following method embodiments are described by taking the execution subject as an electronic device as an example.

[0034] Figure 1Flow diagram of a method for displaying tabular information provided for an embodiment. This embodiment relates to the process of how an electronic device displays row information in a target table. As Figure 1 shown, the method includes: S101 to S102.

[0035] S101. Obtain a row information display instruction for the target table, where the row information display instruction includes information on the target content row.

[0036] In one embodiment, the target content row is the content row for which row information needs to be displayed, and it is a non-header row in the target table. The information of the target content row may include the column identifier of the cell in the target content row and the information in the cell. Among them, the type of the information in the cell can be text, numerical value, picture, link address, etc., and the information obtained by the electronic device in the cell can also include the format of the information such as font type (font types such as bold, underline, strikethrough, font color, and background color, etc.).

[0037] When the user clicks on any content row in the target table, the electronic device takes this content row as the target content row and obtains the row information display instruction for this target content row. The user can also directly input the identifier of one or more target content rows for which row information needs to be displayed, so that the electronic device obtains the row information display instruction for this one or more target content rows.

[0038] S102. According to the row information display instruction, vertically display the first information in the header row of the target table and the second information in the target content row. Among them, the cell where the first information is located and the cell where the second information is located have the same column identifier.

[0039] In one embodiment, taking the column identifiers of the cells in the header row of the target table as A, B, and C as an example, after obtaining the row information display instruction for the target content row, the electronic device vertically displays the first information in the cell with column identifier A in the header row of the target table and the second information in the cell with column identifier A in the target content row, vertically displays the first information in the cell with column identifier B in the header row of the target table and the second information in the cell with column identifier B in the target content row, and vertically displays the first information in the cell with column identifier C in the header row of the target table and the second information in the cell with column identifier C in the target content row.

[0040] When the first information and the second information cannot be fully displayed on the screen of the electronic device, the electronic device can display the un-displayed first information and the un-displayed second information according to the user's up and down sliding operation.

[0041] In practical applications, optionally, the electronic device can vertically display the first information in the cells of the header row of the target table and the second information in the cells of the target content row with the same column identifier on the card. Wherein, the width of the card can match the width of the screen of the electronic device, and the height of the card can be related to the amount of information of the first information and the second information vertically displayed. When vertically displaying the first information and the second information, the vertically displayed first information and second information can still retain the information formats of the original first information and the original second information. For example, the bold, background color, underline, etc. set for the original first information can still be retained. When the type of the second information is a picture, when the picture is vertically displayed, the actual display ratio of the picture can be adaptively adjusted according to the screen size of the electronic device. To conform to the user's reading habit, the first information and the second information can be vertically displayed in the card in a left-aligned manner.

[0042] In one embodiment, the electronic device only needs to vertically display the first information in the cells of the header row of the target table and the second information in the cells of the target content row with the same column identifier. As for the display form after vertical display, it can be set accordingly according to the actual application requirements, and this embodiment does not limit it.

[0043] Take the Figure 2 target table shown below as an example to illustrate the above process of displaying table information. As Figure 2 shown, the target table includes a header row and two content rows. The information in the multiple cells in the header row (i.e., the header information) includes: "Candidate", "Serial Number", "Name", and "Contact Information". The information in the multiple cells in the first content row with the same column identifier as the header row (i.e., the information corresponding to the header information) includes: "xxx", "001", "Male", and "130229". The information in the multiple cells in the second content row with the same column identifier as the header row (i.e., the information corresponding to the header information) includes: "xxx", "002", "Female", and "130225".

[0044] When the electronic device monitors that the user clicks on the second content row, the electronic device can then know that it is necessary to display the row information of the second content row, and obtain the column identifiers of multiple cells in the second content row and the information in multiple cells. The information obtained for the second content row is A-xxx (the information corresponding to column A is xxx), B-002 (the information corresponding to column B is 002), C-female (the information corresponding to column C is female), D-130225 (the information corresponding to column D is 130225). At the same time, the corresponding relationship between the column identifiers of multiple cells in the header row obtained by the electronic device and the information in multiple cells is: A-candidate, B-sequence number, C-gender, D-contact information. The electronic device vertically displays the information "candidate" in the cell of column A in the header row and the information "xxx" in the cell of column A in the second content row, the information "sequence number" in the cell of column B in the header row and the information "002" in the cell of column B in the second content row, the information "gender" in the cell of column C in the header row and the information "female" in the cell of column C in the second content row, and the information "contact information" in the cell of column D in the header row and the information "130225" in the cell of column D in the second content row, so as to obtain the display form as Figure 3 shown.

[0045] The method for displaying table information provided by the embodiment of the present invention, after obtaining the row information display instruction of the target table, the electronic device vertically displays the first information and the second information in the cells with the same column identifier in the header row of the target table and the target content row according to the row information display instruction. Since the electronic device vertically displays the second information in the cells of the target content row in the target table and the first information in the corresponding cells of the header row, in this way, when the user views the information in the cells of the target content row, for example, when viewing the information in the cells of the target content row that is not originally within the display range of the target table, the user can directly view the header row and the target content row of the target table through the row information display instruction, which simplifies the user's operation and improves the efficiency of data viewing.

[0046] In order to be able to display the row information of the target content row, on the basis of the above embodiment, optionally, before the above S101, the method further includes: determining the header row of the target table and obtaining the information of the header row.

[0047] In an embodiment, the information of the header row may include the column identifiers of the cells in the header row and the information in the cells. As an alternative implementation manner, as Figure 4 shown, the process of determining the header row of the above target table may be: S201 to S204.

[0048] S201. When it is determined that the first n rows of the target table have enabled the first setting, select the rows without merged cells from the first n rows as the first target rows.

[0049] In one embodiment, n is a positive integer, and the first setting includes any one of background color, freezing, and filtering. Usually, the user enables background color, freezing, and filtering in the first two rows of the target table. To improve the processing performance of the electronic device, the value of n can be set with reference to the actual enabling habit. Optionally, n can be set to 2.

[0050] S202. Obtain the number of valid columns included in the first target rows, where the valid columns are the columns where the cells containing content are located.

[0051] S203. Compare the number of valid columns included in the first target rows with the number of valid columns included in the reference row.

[0052] Optionally, before S203, the electronic device can select a reference row from all the rows of the target table and obtain the number of valid columns included in the reference row. Among them, the electronic device can use the row with the largest row identifier in all the rows of the target table as the reference row.

[0053] S204. When the number of valid columns included in the first target rows is greater than or equal to the number of valid columns included in the reference row, determine the first target rows as the header rows of the target table.

[0054] Optionally, when the number of the first target rows is greater than or equal to the second preset value, and the number of valid columns included in each of the first target rows is greater than or equal to the number of valid columns included in the reference row, the step of determining the first target rows as the header rows of the target table includes: determining the first target row with the smallest row identifier as the header row of the target table. Exemplarily, taking the above n equal to 2 as an example, when the electronic device determines that each of the first two rows of the target table has no merged cells, and the number of valid columns included in each row is greater than or equal to the number of valid columns included in the reference row, the electronic device determines the first row as the header row of the target table.

[0055] When the number of valid columns included in the first target rows is less than the number of valid columns included in the reference row, on the basis of the above embodiment, optionally, as Figure 5 shown, after the above S203, the following S205 - S207 are further included.

[0056] S205. When the difference between the number of valid columns included in the first target rows and the number of valid columns included in the reference row is equal to the first preset value, obtain the identifiers of the valid columns included in the first target rows.

[0057] S206. Compare the identifiers of the valid columns included in the first target row with the identifiers of the valid columns included in the reference row.

[0058] S207. When the identifier of the first column of the reference row is not included in the identifiers of the valid columns included in the first target row, determine the first target row as the header row of the target table.

[0059] Optionally, when the number of the first target rows is greater than or equal to a second preset value, and the difference between the number of valid columns included in each first target row and the number of valid columns included in the reference row is equal to a first preset value, and the identifier of the first column of the reference row is not included in the identifiers of the valid columns included in each first target row (that is, each first target row only lacks the first column compared to the valid columns included in the reference row), the step of determining the first target row as the header row of the target table includes: determining the first target row with the smallest row identifier as the header row of the target table. Exemplarily, taking n equal to 2, the first preset value equal to 1, and the second preset value equal to 2 as an example, when the electronic device determines that each of the first two rows of the target table only lacks the first column compared to the valid columns included in the reference row, the electronic device determines the first row of the target table as the header row of the target table.

[0060] As another alternative implementation, as Figure 6 shown, the process of determining the header row of the target table may be: S301 to S302.

[0061] S301. Start searching from the first row of the target table for a second target row that meets the preset conditions.

[0062] In one embodiment, the preset conditions are that there are no merged cells in the row and the number of valid columns included in the row is greater than or equal to the number of valid columns included in the reference row, or the preset conditions are that there are no merged cells in the row, the difference between the number of valid columns included in the row and the number of valid columns included in the reference row is equal to a third preset value, and the identifier of the first column of the reference row is not included in the identifiers of the valid columns included in the row, where the valid column is the column where the cell with content is located.

[0063] The electronic device starts from the first row of the target table and determines whether the first row meets the preset conditions. If it meets, the first row is the second target row; if it does not meet, continue to determine whether the next row of the first row meets the preset conditions until a second target row that meets the preset conditions is found.

[0064] S302. Determine the second target row as the header row of the target table.

[0065] In this embodiment, the electronic device can determine the header row from all the rows of the target table through multiple judgment conditions, such as whether the first setting is enabled for the target table, the number of valid columns in the reference row, the identifiers of the valid columns in the reference row, and whether there are merged cells in the rows of the target table. In this way, the accuracy of the determined header row based on multiple judgment conditions is relatively high, thus ensuring the accuracy of subsequent table information display based on the header row.

[0066] In practical applications, there may be a situation where there is no content in the cells of the first column or the first few columns in the header row or the target content row of the target table. To avoid a large area of blank space in the interface after vertical display of information, for this purpose, the process shown as Figure 7 can be referred to for table information display. As Figure 7 shown, the above S102 may include: S401 to S403.

[0067] S401. Obtain the first column identifier of the first cell containing content in the header row and the second column identifier of the first cell containing content in the target content row.

[0068] S402. Use the column identifier with the earlier sorting among the first column identifier and the second column identifier as the starting column identifier for table information display.

[0069] S403. According to the row information display instruction, starting from the starting column identifier, vertically display the first information in the header row of the target table and the second information in the target content row respectively, where the cells where the first information and the second information are located have the same third column identifier, and the value range of the third column identifier is from the starting column identifier to the column identifier corresponding to the last cell containing content in the header row.

[0070] When the first information corresponding to the starting column identifier is empty, when vertically displaying the first information corresponding to the starting column identifier and the second information corresponding to the starting column identifier, use the starting column identifier as the first information and vertically display the starting column identifier and the second information corresponding to the starting column identifier.

[0071] When the second information in the cell of the target content row with the same column identifier as the header row is empty, when vertically displaying the first information and the second information corresponding to this column identifier, display the first information and do not display content below the first information.

[0072] In this embodiment, the electronic device can determine the starting column identifier for displaying table information based on the column identifier of the first cell containing content in the header row and the target content row in the target table, and start vertically displaying the information of the header row and the target content row corresponding to each other from the starting column identifier, so that the information in the cells of the header row and the target content row can be displayed within the screen of the electronic device as much as possible. The user does not need to slide the scroll bar up and down to view the un-displayed information, thereby improving the efficiency of data viewing. At the same time, it also makes there be no large blank area in the interface after vertical display, improving the aesthetics of the human-computer interaction interface.

[0073] In practical applications, due to the large amount of data in the target table, the user only wants to filter the data he / she is concerned about. For this purpose, the electronic device can refer to the process shown in Figure 8 as shown below to display the table information. As Figure 8 shown, this method further includes: S501 to S503.

[0074] S501. Obtain the classification instruction input by the user, where the classification instruction includes classification information.

[0075] In one embodiment, the classification information is a filtering condition, which can be time filtering (such as updated today) or name filtering (related to me), etc.

[0076] S502. Determine the target classification row containing the classification information.

[0077] In one embodiment, filter out the content rows containing the classification information from all the content rows of the target table, and use these content rows as the target classification rows.

[0078] S503. Vertically display the first information in the header row and the third information in the target classification row. Wherein, the cells where the first information and the third information are located have the same column identifier.

[0079] In one embodiment, the process of vertically displaying the first information and the third information in S503 can refer to the process of vertically displaying the first information and the second information in the above embodiment, which will not be elaborated in this embodiment.

[0080] Based on the above embodiments, optionally, this method may further include: The electronic device obtains the folding instruction input by the user, and according to the folding instruction, changes the state of the target folding information from the display state to the hidden state, where the folding instruction includes the target folding information.

[0081] Similarly, the electronic device can also obtain the expansion instruction input by the user, and according to the expansion instruction, change the state of the target expansion information from the hidden state to the display state, where the expansion instruction includes the target expansion information.

[0082] In this embodiment, the electronic device can vertically display the row information of the target classification row containing classification information according to the classification instruction input by the user, and can also fold the vertically displayed second information according to the folding instruction of the user, and expand the folded second information according to the expansion instruction of the user, greatly enriching the operations of human-computer interaction and improving the intelligence of human-computer interaction.

[0083] Figure 9 It is a schematic internal structure diagram of a display device for table information provided in an embodiment. As Figure 9 shown, the device includes: a first acquisition module 10 and a first display module 11.

[0084] In one embodiment, the first acquisition module 10 is configured to acquire a row information display instruction of a target table, and the row information display instruction includes information of a target content row;

[0085] The first display module 11 is configured to vertically display the first information of the header row of the target table and the second information of the target content row according to the row information display instruction, wherein the cells where the first information is located and the cells where the second information is located have the same column identifier.

[0086] For the display device of table information provided by the embodiment of the present invention, after acquiring the row information display instruction of the target table, the electronic device vertically displays the first information in the cell of the header row of the target table and the second information in the cell with the same column identifier in the target content row according to the row information display instruction. Since the electronic device vertically displays the second information in the cell of the target content row in the target table and the first information in the corresponding cell of the header row, in this way, when the user views the information in the cell of the target content row, for example, when viewing the information in the cell of the target content row that is not originally within the display range of the target table, the user can directly view the header row and the target content row of the target table through the row information display instruction, simplifying the user's operation and improving the efficiency of data viewing.

[0087] Based on the above embodiment, optionally, the device further includes a first determination module and a second acquisition module.

[0088] The first determination module is configured to determine the header row of the target table before the first acquisition module 10 acquires the row information display instruction of the target table;

[0089] The second acquisition module is configured to acquire the information of the header row.

[0090] Based on the above embodiment, optionally, the first determination module includes: a selection unit, a first acquisition unit, a comparison unit, and a first determination unit.

[0091] The selection unit is set to, when it is determined that the first n rows of the target table have enabled the first setting, select the rows without merged cells from the first n rows as the first target rows, where n is a positive integer, and the first setting includes any one of background color, freezing, and filtering;

[0092] The first acquisition unit is set to acquire the number of valid columns included in the first target rows, where the valid columns are the columns where the cells containing content are located;

[0093] The comparison unit is set to compare the number of valid columns included in the first target rows with the number of valid columns included in the reference row;

[0094] The first determination unit is set to, when the number of valid columns included in the first target rows is greater than or equal to the number of valid columns included in the reference row, determine the first target rows as the header rows of the target table.

[0095] Based on the above embodiments, optionally, the first acquisition unit is further set to, when the difference between the number of valid columns included in the first target rows and the number of valid columns included in the reference row is equal to the first preset value, acquire the identifiers of the valid columns included in the first target rows;

[0096] The comparison unit is further set to compare the identifiers of the valid columns included in the first target rows with the identifiers of the valid columns included in the reference row;

[0097] The first determination unit is further set to, when the identifiers of the valid columns included in the first target rows do not include the identifier of the first column of the reference row, determine the first target rows as the header rows of the target table.

[0098] Based on the above embodiments, optionally, when the number of the first target rows is greater than or equal to the second preset value, and the number of valid columns included in each of the first target rows is greater than or equal to the number of valid columns included in the reference row, the first determination unit is set to determine the first target row with the smallest row identifier as the header row of the target table.

[0099] Based on the above embodiments, optionally, the first determination module is configured to start searching from the first row of the target table to find a second target row that meets a preset condition; and determine the second target row as the header row of the target table, where the condition is that there are no merged cells in the row, and the number of valid columns included in the row is greater than or equal to the number of valid columns included in the reference row, or the condition is that there are no merged cells in the row, the difference between the number of valid columns included in the row and the number of valid columns included in the reference row is equal to a third preset value, and the identifier of the first column of the reference row is not included in the identifiers of the valid columns included in the row, where the valid column is the column where the cell containing content is located.

[0100] Based on the above embodiments, optionally, the first display module 11 includes a second acquisition unit, a second determination unit, and a display unit.

[0101] The second acquisition unit is configured to acquire the first column identifier of the first cell containing content in the header row and the second column identifier of the first cell containing content in the target content row;

[0102] The second determination unit is configured to use the column identifier that is sorted earlier among the first column identifier and the second column identifier as the starting column identifier for displaying the table information;

[0103] The display unit is configured to, according to the row information display instruction, starting from the starting column identifier, vertically display the first information in the header row of the target table and the second information in the target content row respectively, where the cell where the first information is located and the cell where the second information is located have the same third column identifier, and the value range of the third column identifier is from the starting column identifier to the column identifier corresponding to the last cell containing content in the header row.

[0104] Based on the above embodiments, optionally, when the first information corresponding to the starting column identifier is empty, the display unit is configured to use the starting column identifier as the first information and vertically display the starting column identifier and the second information corresponding to the starting column identifier.

[0105] Based on the above embodiments, optionally, when the second information is empty, the display unit is configured not to display content below the first information.

[0106] Based on the above embodiments, optionally, the device further includes: a third acquisition module, a second determination module, and a second display module.

[0107] The third acquisition module is configured to acquire a classification instruction input by the user, where the classification instruction includes classification information;

[0108] The second determination module is configured to determine a target classification row including the classification information;

[0109] The second display module is configured to vertically display the first information of the header row and the third information of the target classification row, where the cells where the first information is located and the cells where the third information is located have the same column identifier.

[0110] Based on the above embodiments, optionally, the apparatus further includes: a fourth acquisition module and a modification module.

[0111] The fourth acquisition module is configured to acquire a folding instruction input by a user, where the folding instruction includes target folding information;

[0112] The modification module is configured to modify the state of the target folding information from a display state to a hidden state.

[0113] Next, referring to Figure 10 , which shows a schematic structural diagram of an electronic device 600 suitable for implementing embodiments of the present disclosure. The electronic device in the embodiments of the present disclosure may include mobile terminals such as mobile phones, laptop computers, digital broadcast receivers, personal digital assistants (PDAs), tablet computers (PADs), portable multimedia players (PMPs), vehicle terminals (such as vehicle navigation terminals), etc., and fixed terminals such as digital televisions (TVs), desktop computers, etc. Figure 10 The illustrated electronic device is merely an example and should not impose any limitation on the functions and usage scope of the embodiments of the present disclosure.

[0114] As Figure 10 shown, the electronic device 600 may include a processing device (such as a central processing unit, a graphics processing unit, etc.) 601, and the processing device 601 may execute various appropriate actions and processes according to a program stored in a read-only memory (ROM) 602 or a program loaded from a storage device 608 into a random access memory (RAM) 603. In the RAM 603, various programs and data required for the operation of the electronic device 600 are also stored. The processing device 601, the ROM 602, and the RAM 603 are connected to each other through a bus 604. An input / output (I / O) interface 605 is also connected to the bus 604.

[0115] The following devices can be connected to the I / O interface 605: input devices 606 including, for example, a touch screen, a touch pad, a keyboard, a mouse, a camera, a microphone, an accelerometer, a gyroscope, etc.; output devices 607 including, for example, a liquid crystal display (LCD), a speaker, a vibrator, etc.; storage devices 608 including, for example, magnetic tapes, hard disks, etc.; and a communication device 609. The communication device 609 can allow the electronic device 600 to communicate with other devices wirelessly or wiredly to exchange data. Although Figure 10 the electronic device 600 with a variety of devices is shown, it is not required to implement or include all the shown devices, and alternatively, more or fewer devices can be implemented or included.

[0116] According to an embodiment of the present disclosure, the processes described above with reference to the flowcharts can be implemented as computer software programs. For example, an embodiment of the present disclosure includes a computer program product that includes a computer program carried on a non-transitory computer-readable medium, and the computer program includes program codes for performing the methods shown in the flowcharts. In such an embodiment, the computer program can be downloaded and installed from a network through the communication device 609, or installed from the storage device 608, or installed from the ROM 602. When the computer program is executed by the processing device 601, the above functions defined in the methods of the embodiments of the present disclosure are performed.

[0117] The computer-readable medium described above can be a computer-readable signal medium, a computer-readable storage medium, or any combination of the two. A computer-readable storage medium can be, for example, an electrical, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any combination of the above. A computer-readable storage medium can include: an electrical connection having one or more wires, a portable computer disk, a hard disk, a RAM, a ROM, an erasable programmable read-only memory (EPROM), or a flash memory, an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the above. In the present disclosure, a computer-readable storage medium can be any tangible medium that contains or stores a program that can be used by or in conjunction with an instruction execution system, apparatus, or device. In the present disclosure, a computer-readable signal medium can include a data signal propagated in a baseband or as part of a carrier wave, which carries computer-readable program code. Such a propagated data signal can take various forms, including an electromagnetic signal, an optical signal, or any suitable combination of the above. A computer-readable signal medium can also be any computer-readable medium other than a computer-readable storage medium, which can 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 a computer-readable medium can be transmitted using any appropriate medium, including: wires, optical cables, radio frequency (RF), etc., or any suitable combination of the above.

[0118] The above computer-readable medium can be included in the above electronic device; or it can exist separately without being assembled into the electronic device.

[0119] The above computer-readable medium carries one or more programs, and when the one or more programs are executed by the electronic device, the electronic device is caused to: obtain a row information display instruction for a target table, where the row information display instruction includes information on a target content row; and according to the row information display instruction, vertically display first information of a header row of the target table and second information of the target content row, where cells where the first information is located and cells where the second information is located have the same column identifier.

[0120] Computer program code for performing the operations of the present disclosure may be written in one or more programming languages or combinations thereof. The programming languages include object-oriented programming languages such as Java, Smalltalk, C++, and also include conventional procedural programming languages such as the "C" language or similar programming languages. The program code may be executed entirely on the user's computer, partially on the user's computer, executed as a stand-alone software package, partially on the user's computer and partially on a remote computer, or entirely on a remote computer or server. In the case of a remote computer, the remote computer may be connected to the user's computer through any kind of network, including a local area network (LAN) or a wide area network (WAN), or it may be connected to an external computer (e.g., through the Internet using an Internet service provider).

[0121] The flowcharts and block diagrams in the accompanying drawings illustrate the possible architectures, functions, and operations of systems, methods, and computer program products according to various embodiments of the present disclosure. In this regard, each block in the flowchart or block diagram may represent a module, a segment of a program, or a part of code that contains one or more executable instructions for implementing a specified logical function. In some alternative implementations, the functions noted in the blocks may occur in a different order than noted in the accompanying drawings. For example, two consecutive blocks shown may actually be executed substantially in parallel, or they may sometimes be executed in the reverse order, depending on the functions involved. Each block in the block diagrams and / or flowcharts, and combinations of blocks in the block diagrams and / or flowcharts, may be implemented by a dedicated hardware-based system for performing the specified functions or operations, or may be implemented by a combination of dedicated hardware and computer instructions.

[0122] The units described in the embodiments of the present disclosure may be implemented in software or in hardware. Among them, the name of the unit does not constitute a limitation on the unit itself.

[0123] The functions described above in this document can be performed, at least in part, by one or more hardware logic components. For example, without limitation, exemplary types of hardware logic components that can be used include: Field Programmable Gate Array (FPGA), Application Specific Integrated Circuit (ASIC), Application Specific Standard Parts (ASSP), System-on-a-Chip (SOC), Complex Programmable Logic Device (CPLD), and so on.

[0124] The display device, equipment, and storage medium for the table information provided in the above embodiments can execute the table information display method provided in any embodiment of the present application, and have the corresponding functional modules and effects for executing this method. For technical details not described in the above embodiments, reference can be made to the table information display method provided in any embodiment of the present application.

[0125] According to one or more embodiments of the present disclosure, a method for displaying table information is provided, including:

[0126] Obtain a row information display instruction for a target table, where the row information display instruction includes information of a target content row;

[0127] According to the row information display instruction, vertically display the first information of the header row of the target table and the second information of the target content row, where the cells where the first information is located and the cells where the second information is located have the same column identifier.

[0128] According to one or more embodiments of the present disclosure, the above method for displaying table information further includes: determining the header row of the target table and obtaining the information of the header row.

[0129] According to one or more embodiments of the present disclosure, a method for displaying the above table information is provided, further including: when it is determined that the first n rows of the target table have a first setting enabled, selecting the rows without merged cells from the first n rows as the first target rows, where n is a positive integer, and the first setting includes any one of background color, freezing, and filtering; obtaining the number of valid columns included in the first target rows, where the valid columns are the columns where the cells containing content are located; comparing the number of valid columns included in the first target rows with the number of valid columns included in the reference row; when the number of valid columns included in the first target rows is greater than or equal to the number of valid columns included in the reference row, determining the first target rows as the header rows of the target table.

[0130] According to one or more embodiments of the present disclosure, a method for displaying the above table information is provided, further including: when the difference between the number of valid columns included in the first target rows and the number of valid columns included in the reference row is equal to a first preset value, obtaining the identifiers of the valid columns included in the first target rows; comparing the identifiers of the valid columns included in the first target rows with the identifiers of the valid columns included in the reference row; when the identifiers of the valid columns included in the first target rows do not include the identifier of the first column of the reference row, determining the first target rows as the header rows of the target table.

[0131] When the number of the first target rows is greater than or equal to a second preset value, and the number of valid columns included in each of the first target rows is greater than or equal to the number of valid columns included in the reference row, according to one or more embodiments of the present disclosure, a method for displaying the above table information is provided, further including: determining the first target row with the smallest row identifier as the header row of the target table.

[0132] According to one or more embodiments of the present disclosure, a method for displaying the above table information is provided, further including: starting from the first row of the target table, searching for a second target row that meets a preset condition, where the condition is that there are no merged cells in the row, and the number of valid columns included in the row is greater than or equal to the number of valid columns included in the reference row, or the condition is that there are no merged cells in the row, the difference between the number of valid columns included in the row and the number of valid columns included in the reference row is equal to a third preset value, and the identifiers of the valid columns included in the row do not include the identifier of the first column of the reference row, where the valid columns are the columns where the cells containing content are located; determining the second target row as the header row of the target table.

[0133] According to one or more embodiments of the present disclosure, a method for displaying the above table information is provided, further including: obtaining a first column identifier of the first cell containing content in the header row and a second column identifier of the first cell containing content in the target content row; using the column identifier with a prior sorting order among the first column identifier and the second column identifier as the starting column identifier for displaying the table information; according to the row information display instruction, starting from the starting column identifier, vertically displaying the first information and the second information in the cells with the same third column identifier in the header row and the target content row of the target table respectively, where the value range of the third column identifier is from the starting column identifier to the column identifier corresponding to the last cell containing content in the header row.

[0134] When the first information corresponding to the starting column identifier is empty, according to one or more embodiments of the present disclosure, a method for displaying the above table information is provided, further including: using the starting column identifier as the first information, and vertically displaying the starting column identifier and the second information corresponding to the starting column identifier.

[0135] When the second information is empty, according to one or more embodiments of the present disclosure, a method for displaying the above table information is provided, further including: not displaying any content below the first information.

[0136] According to one or more embodiments of the present disclosure, a method for displaying the above table information is provided, further including: obtaining a classification instruction input by a user, where the classification instruction includes classification information; determining a target classification row containing the classification information; vertically displaying the first information in the header row and the third information in the target classification row, where the cells where the first information and the third information are located have the same column identifier.

[0137] According to one or more embodiments of the present disclosure, a method for displaying the above table information is provided, further including: obtaining a folding instruction input by a user, where the folding instruction includes target folding information; modifying the state of the target folding information from a display state to a hidden state.

[0138] According to one or more embodiments of the present disclosure, a display device for table information is provided, including:

[0139] A first acquisition module, configured to acquire a row information display instruction of a target table, where the row information display instruction includes information of a target content row;

[0140] A first display module, configured to vertically display the first information in the header row and the second information in the target content row of the target table according to the row information display instruction, where the cells where the first information and the second information are located have the same column identifier.

[0141] According to one or more embodiments of the present disclosure, an electronic device is provided, including a memory and a processor. A computer program is stored in the memory, and when the processor executes the computer program, the following steps are implemented:

[0142] Obtain a row information display instruction of a target table, where the row information display instruction includes information of a target content row;

[0143] According to the row information display instruction, vertically display first information of a header row of the target table and second information of the target content row, where cells where the first information is located and cells where the second information is located have the same column identifier.

[0144] According to one or more embodiments of the present disclosure, a computer-readable storage medium is provided, storing a computer program, and when the computer program is executed by a processor, the following steps are implemented:

[0145] Obtain a row information display instruction of a target table, where the row information display instruction includes information of a target content row;

[0146] According to the row information display instruction, vertically display first information of a header row of the target table and second information of the target content row, where cells where the first information is located and cells where the second information is located have the same column identifier.

[0147] In addition, although various operations are depicted in a particular order, this should not be construed as requiring that the operations be performed in the particular order shown or in sequential order. In certain circumstances, multitasking and parallel processing may be advantageous. Similarly, although implementation details are included in the above discussion, these should not be construed as limiting the scope of the present disclosure. Some features described in the context of separate embodiments may also be implemented combinatorially in a single embodiment. Conversely, various features described in the context of a single embodiment may also be implemented separately or in any suitable sub-combination in multiple embodiments.

Claims

1. A method for displaying table information, comprising: Obtaining a row information display instruction for a target table, where the row information display instruction includes information of a target content row; According to the row information display instruction, vertically displaying first information of a header row of the target table and second information of the target content row, where a cell where the first information is located and a cell where the second information is located have the same column identifier; Wherein, the vertically displaying first information of the header row of the target table and second information of the target content row according to the row information display instruction includes: Obtaining a first column identifier of the first cell containing content in the header row and a second column identifier of the first cell containing content in the target content row; Taking the column identifier with a prior sorting among the first column identifier and the second column identifier as a starting column identifier for displaying table information; According to the row information display instruction, starting from the starting column identifier, vertically displaying first information of the header row of the target table and second information of the target content row respectively, where a cell where the first information is located and a cell where the second information is located have the same third column identifier, and the value range of the third column identifier is from the starting column identifier to the column identifier corresponding to the last cell containing content in the header row; The vertically displaying first information of the header row of the target table and second information of the target content row according to the row information display instruction further includes: Vertically displaying the first information and the second information on a card, where the width of the card matches the width of the screen of the electronic device, and the height of the card is related to the amount of information of the first information and the second information vertically displayed.

2. The method according to claim 1, wherein, Before obtaining the row information display instruction for the target table, it further includes: Determining the header row of the target table and obtaining the information of the header row.

3. The method according to claim 2, wherein, The determining the header row of the target table includes: When it is determined that the first n rows of the target table have a first setting enabled, selecting a row without merged cells from the first n rows as a first target row, where n is a positive integer, and the first setting includes any one of background color, freezing, and filtering; Obtaining the number of valid columns included in the first target row, where the valid column is a column where a cell containing content is located; Comparing the number of valid columns included in the first target row with the number of valid columns included in a reference row; When the number of valid columns included in the first target row is greater than or equal to the number of valid columns included in the reference row, determining the first target row as the header row of the target table.

4. The method according to claim 3, further comprising: When the difference between the number of valid columns included in the first target row and the number of valid columns included in the reference row is equal to a first preset value, obtaining the identifiers of the valid columns included in the first target row; Comparing the identifiers of the valid columns included in the first target row with the identifiers of the valid columns included in the reference row; In the case that the identifier of the first column of the reference row is not included in the identifiers of the valid columns included in the first target row, determine the first target row as the header row of the target table.

5. The method according to claim 3, wherein, In the case that the number of the first target rows is greater than or equal to a second preset value, and the number of valid columns included in each first target row is greater than or equal to the number of valid columns included in the reference row, the step of determining the first target row as the header row of the target table includes: Determine the first target row with the smallest row identifier as the header row of the target table.

6. The method according to claim 2, wherein The step of determining the header row of the target table includes: Start searching from the first row of the target table to find a second target row that meets the preset conditions, where the preset conditions are that there are no merged cells in the row, and the number of valid columns included in the row is greater than or equal to the number of valid columns included in the reference row, or the preset conditions are that there are no merged cells in the row, the difference between the number of valid columns included in the row and the number of valid columns included in the reference row is equal to a third preset value, and the identifier of the first column of the reference row is not included in the identifiers of the valid columns included in the row, where the valid column is the column where the cell containing content is located; Determine the second target row as the header row of the target table.

7. The method according to claim 1, wherein In the case that the first information corresponding to the start column identifier is empty, according to the row information display instruction, the step of vertically displaying the first information of the header row of the target table and the second information of the target content row includes: Use the start column identifier as the first information, and vertically display the start column identifier and the second information corresponding to the start column identifier.

8. The method according to claim 1, wherein, In the case that the second information is empty, according to the row information display instruction, the step of vertically displaying the first information of the header row of the target table and the second information of the target content row includes: Do not display content below the first information.

9. The method according to any one of claims 1 to 8, further comprising: Obtain a classification instruction input by a user, where the classification instruction includes classification information; Determine a target classification row that includes the classification information; Vertically display the first information of the header row and the third information of the target classification row, where the cells where the first information is located and the cells where the third information is located have the same column identifier.

10. The method according to any one of claims 1 to 8, further comprising: Obtain a folding instruction input by a user, where the folding instruction includes target folding information; Modify the state of the target folding information from the display state to the hidden state.

11. A display device for table information, comprising: A first acquisition module configured to acquire a row information display instruction of a target table, where the row information display instruction includes information of a target content row; A first display module configured to vertically display the first information of the header row of the target table and the second information of the target content row according to the row information display instruction, where the cells where the first information is located and the cells where the second information is located have the same column identifier; Among them, the first display module is configured to obtain the first column identifier of the first cell containing content in the header row and the second column identifier of the first cell containing content in the target content row; Use the column identifier with a higher sorting order among the first column identifier and the second column identifier as the starting column identifier for displaying table information; According to the row information display instruction, starting from the starting column identifier, vertically display the first information in the header row of the target table and the second information in the target content row respectively, where the cells where the first information is located and the cells where the second information is located have the same third column identifier, and the value range of the third column identifier is from the starting column identifier to the column identifier corresponding to the last cell containing content in the header row; The first display module is further configured to vertically display the first information and the second information on a card, the width of the card matches the width of the screen of the electronic device, and the height of the card is related to the amount of information of the first information and the second information vertically displayed.

12. An electronic device, including a memory and a processor, the memory stores a computer program, and when the processor executes the computer program, it implements the table information display method according to any one of claims 1 to 10.

13. A computer-readable storage medium stores a computer program, and when the computer program is executed by a processor, it implements the table information display method according to any one of claims 1 to 10.

Images