CN113778306A - Table data processing method, device, equipment and storage medium - Google Patents
Table data processing method, device, equipment and storage medium Download PDFInfo
- Publication number
- CN113778306A CN113778306A CN202111043191.6A CN202111043191A CN113778306A CN 113778306 A CN113778306 A CN 113778306A CN 202111043191 A CN202111043191 A CN 202111043191A CN 113778306 A CN113778306 A CN 113778306A
- Authority
- CN
- China
- Prior art keywords
- displayed
- display area
- loading
- row
- column
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F3/00—Input arrangements for transferring data to be processed into a form capable of being handled by the computer; Output arrangements for transferring data from processing unit to output unit, e.g. interface arrangements
- G06F3/01—Input arrangements or combined input and output arrangements for interaction between user and computer
- G06F3/048—Interaction techniques based on graphical user interfaces [GUI]
- G06F3/0484—Interaction techniques based on graphical user interfaces [GUI] for the control of specific functions or operations, e.g. selecting or manipulating an object, an image or a displayed text element, setting a parameter value or selecting a range
- G06F3/0485—Scrolling or panning
- G06F3/04855—Interaction with scrollbars
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/103—Formatting, i.e. changing of presentation of documents
- G06F40/106—Display of layout of documents; Previewing
Abstract
The embodiment of the invention discloses a table data processing method, a table data processing device, table data processing equipment and a storage medium. The method comprises the steps that a form display area in a form to be displayed is determined according to position information of a rolling shaft in a display page; wherein the scroll axes include a row scroll axis and a column scroll axis; if the form to be displayed meets the preset lazy loading condition, expanding the form display area along the movable direction of the rolling shaft to obtain a form loading area; and loading and rendering the table loading area in the table to be displayed, and displaying the cell data in the table display area in the table to be displayed. According to the technical scheme of the embodiment of the invention, the loading and rendering efficiency is improved, the conditions of loading delay or blank display and fault display are avoided, and the use experience of a user is improved.
Description
Technical Field
The embodiment of the invention relates to the technical field of big data, in particular to a table data processing method, a table data processing device, table data processing equipment and a storage medium.
Background
With the continuous development of the internet, the world is facing a big data era nowadays, and the huge data volume leads people to need a better method for processing data.
In the prior art, for the display of a front-end table with a large data volume, modes such as paging display and delayed loading are generally adopted, and the table is loaded by methods such as paging display of data, display of a fixed amount of data on each page, and the like. However, the above scheme has low data loading efficiency, and a fault display condition also occurs.
Disclosure of Invention
The invention provides a table data processing method, a table data processing device, table data processing equipment and a storage medium, which are used for improving data loading efficiency and avoiding display fault conditions.
In a first aspect, an embodiment of the present invention provides a table data processing method, including:
determining a table display area in a table to be displayed according to the position information of the rolling shaft in the display page; wherein the scroll axes include a row scroll axis and a column scroll axis;
if the form to be displayed meets the preset lazy loading condition, expanding the form display area along the movable direction of the rolling shaft to obtain a form loading area;
and loading and rendering the table loading area in the table to be displayed, and displaying the cell data in the table display area in the table to be displayed.
In a second aspect, an embodiment of the present invention further provides a table data processing apparatus, including:
the display area determining module is used for determining a table display area in the table to be displayed according to the position information of the rolling shaft in the display page; wherein the scroll axes include a row scroll axis and a column scroll axis;
the loading area expansion module is used for expanding the table display area along the movable direction of the rolling shaft to obtain a table loading area if the table to be displayed meets a preset lazy loading condition;
and the loading display module is used for loading and rendering the table loading area in the table to be displayed and displaying the cell data in the table display area in the table to be displayed.
In a third aspect, an embodiment of the present invention further provides an electronic device, including:
one or more processors;
a memory for storing one or more programs;
when the one or more programs are executed by the one or more processors, the one or more processors implement any one of the table data processing methods provided by the embodiments of the first aspect of the present invention.
In a fourth aspect, an embodiment of the present invention further provides a computer-readable storage medium, on which a computer program is stored, where the computer program, when executed by a processor, implements any one of the table data processing methods provided in the embodiment of the first aspect of the present invention.
According to the technical scheme of the embodiment of the invention, the form display area is determined according to the position information of the rolling shaft, the form display area is expanded by a lazy loading method to obtain the form loading area, and data in the form loading area is loaded and rendered. According to the technical scheme, the table display process adopts a lazy loading method, the loading and rendering range of the table to be displayed is expanded, and the table to be displayed is not limited to the table display area loading and rendering, so that the overall loading and rendering efficiency of the browsing process of the table to be displayed is improved. Meanwhile, the form loading area changes in real time along with the browsing of the user, and simultaneously, the changed form data content is loaded and rendered in real time, so that the situation of waiting for loading or displaying blank can not occur when the user browses the form, and the use experience of the user is improved.
Drawings
Fig. 1 is a flowchart of a table data processing method according to an embodiment of the present invention;
fig. 2A is a flowchart of a table data processing method according to a second embodiment of the present invention;
fig. 2B is a schematic diagram of a table to be displayed according to a second embodiment of the present invention;
fig. 2C is a schematic diagram illustrating a display process of a table to be displayed according to a second embodiment of the present invention;
fig. 2D is a schematic diagram illustrating a displaying process of another table to be displayed according to the second embodiment of the present invention;
fig. 2E is a schematic diagram illustrating a displaying process of another table to be displayed according to the second embodiment of the present invention;
fig. 2F is a schematic diagram of a display process of another table to be displayed according to a second embodiment of the present invention;
fig. 2G is a schematic diagram of a display process of another table to be displayed according to the second embodiment of the present invention;
fig. 2H is a schematic diagram illustrating a displaying process of another table to be displayed according to a second embodiment of the present invention;
fig. 2I is a schematic diagram illustrating a display process of another table to be displayed according to a second embodiment of the present invention;
fig. 2J is a schematic diagram illustrating a displaying process of another table to be displayed according to a second embodiment of the present invention;
fig. 3 is a flowchart of a table data processing method according to a third embodiment of the present invention;
fig. 4 is a structural diagram of a table data processing apparatus according to a fourth embodiment of the present invention;
fig. 5 is a structural diagram of an electronic device according to a fifth embodiment of the present invention
Detailed Description
The present invention will be described in further detail with reference to the accompanying drawings and examples. It is to be understood that the specific embodiments described herein are merely illustrative of the invention and are not limiting of the invention. It should be further noted that, for the convenience of description, only some of the structures related to the present invention are shown in the drawings, not all of the structures.
Example one
Fig. 1 is a flowchart of a form data processing method according to an embodiment of the present invention, where the present embodiment is applicable to a case where data in a form is displayed according to whether a lazy loading condition is met, and the method may be executed by a form data processing apparatus, and the apparatus may be implemented by software and/or hardware and is specifically configured in an electronic device.
Referring to the table data processing method shown in fig. 1, the method specifically includes the following steps:
s110, determining a table display area in a table to be displayed according to the position information of the rolling shaft in the display page; wherein the scroll axes include a row scroll axis and a column scroll axis.
The presentation page is a display page of a big data table, wherein the presentation page may contain display information, an operation menu, a scroll axis, and the like. The presentation page may be understood as a window display interface of a computer. The form to be displayed contains the form whose data content is required to be displayed.
The scroll axis is a virtual operation axis for controlling display information in the presentation page to move up and down or left and right, and may be, for example, a scroll axis on the right side or below in a window of an excel table. The rolling axes are divided into a row rolling axis and a column rolling axis, wherein the row rolling axis controls the display information to move up and down, and the column rolling axis controls the display information to move left and right.
The scroll bar where the scroll axis is located is related to the positions of all data information in the table, wherein the row scroll axis is related to the row where the data information in the table is located, and the column scroll axis is related to the column where the data information in the table is located. And the position information of the scroll axis, namely the specific position of the scroll axis in the scroll bar, has an association relation with the table display area in the display page.
Therefore, the table display area associated with the position information can be determined according to the current position information of the scroll axis.
And S120, if the form to be displayed meets a preset lazy loading condition, expanding the form display area along the movable direction of the rolling shaft to obtain a form loading area.
The form to be presented refers to the entire form. Lazy loading is a data loading method that stores data to be loaded in a cache in advance so that a user can call the data quickly. A lazy load condition refers to a condition under which a table can perform a lazy load operation. Optionally, the lazy loading condition may be set manually, or may be preset inside the table data processing apparatus, for example, the row height and/or column width of the table to be displayed may be greater than the row height and/or column width of the display page. The table loading area refers to an area where table contents are loaded or rendered, and the table loading area is larger than the table display area. Alternatively, the table display area may change as the user drags the scroll axis, while the table load area may change as the table display area changes.
Specifically, if the form to be displayed meets the preset lazy loading condition, the form display area is expanded in all movable directions according to the movable direction (namely, transverse movement and/or longitudinal movement) of the rolling shaft on the basis of the size of the form display area, so that the form loading area is obtained. Alternatively, the size of the expansion may be determined manually, or may be an expansion based on the balanced load rendering time obtained from a number of experiments, for example, 25% of the height and/or width of the column of the expanded table display area.
S130, loading and rendering the table loading area in the table to be displayed, and displaying cell data in the table display area in the table to be displayed.
The cells are basic constituent units of the table, and the cell data is data content described in each cell. Alternatively, the cell attributes of the cells may be the same or different. Note that, for convenience of control, the cell attributes of the respective cells are usually set to be the same. Wherein the cell attributes include a cell width and a cell height.
Specifically, after the position and the size of the table loading area are determined in the foregoing steps, the cell data in the table loading area is loaded and rendered, and only the cell data in the table display area is displayed.
It can be understood that, since the table loading area is larger than the table displaying area, the loaded and rendered cell data cannot be completely displayed. But when the user drags the scroll axis, the loaded and rendered cell data can be exposed directly without waiting.
According to the technical scheme of the embodiment of the invention, the form display area is determined according to the position information of the rolling shaft, the form display area is expanded by a lazy loading method to obtain the form loading area, and data in the form loading area is loaded and rendered. According to the technical scheme, a lazy loading method is adopted in the table display process, the loading and rendering range of the table to be displayed is expanded, and the table to be displayed is not limited to the table loading and rendering display area, so that the loading and rendering efficiency is improved. Meanwhile, the table loading area changes in real time along with the browsing of the user, and simultaneously, the changed table data content is loaded and rendered in real time, so that the conditions of loading delay or blank display and fault display do not occur when the user browses the table, and the use experience of the user is improved.
In an optional implementation manner, the presenting the cell data in the table presentation area in the table to be presented may include: determining index information of each cell to be displayed in the table display area in the table to be displayed; and acquiring corresponding cell data according to the index information of each cell to be displayed, and displaying each cell data.
The index information of the cell refers to information for addressing the cell, and may include, for example, coordinate information of the cell, such as a row index and a column index of the cell, and the like.
Specifically, after the table display area is determined, index information of all cells in the area is obtained, corresponding cell data is found in a database according to the index information, and the cell data is displayed in the corresponding cells.
It can be understood that, according to the technical scheme, the data corresponding to the cell is acquired according to the index information of the cell to be displayed, the data is displayed, the mode of determining the cell data through the index information is simple and quick, and the loading and rendering efficiency is improved.
Example two
Fig. 2A is a flowchart of a table data processing method according to a second embodiment of the present invention. The embodiment of the invention optimizes the determination operation of the table display area on the basis of the technical scheme of the embodiment so as to perfect the determination mechanism of the table display area.
Referring to fig. 2A, a table data processing method specifically includes the following steps:
s210, determining index information of a starting form of the form display area according to the position information of the rolling shaft and the attribute information of a standard form; wherein the index information includes a row index and a column index.
The standard table refers to a cell in a default state, and the attribute information of the standard table may include, but is not limited to, a line height and a column width of the standard table. Therefore, according to the position information of the scroll axis and the attribute information of the standard table, the row index and the column index of the table at the beginning of the table display area can be known. Wherein the starting table can be understood as the table in the upper left corner of the table display area.
In an alternative embodiment, the determining index information of the starting table of the table display area according to the position information of the scroll axis and the attribute information of the standard table may include: determining a column index of a starting table of the table display area according to the position information of the row rolling axis and the column width of a standard table; and determining the row index of the initial table of the table display area according to the position information of the column rolling axis and the height of the standard table row.
Optionally, the row index of the starting table of the table display area may be determined according to the position of the row scroll axis in the row scroll bar, and the column index of the starting table of the table display area may be determined according to the position of the column scroll axis in the column scroll bar, that is, the position information of the starting table in the whole table is obtained.
For example, the row index and column index of the starting table may be determined based on the position information of the scroll axis and the row and column widths of the standard table. Fig. 2B is a schematic diagram of a table to be displayed according to a second embodiment of the present invention, where the size and the number of the table are only examples, and fig. 2B is labeled with a table to be displayed 201, a table loading area 202, a table displaying area 203, and a starting table 204, respectively. As shown in fig. 2B, assuming that the row height and the column width of each standard table in the table to be displayed 201 are H and W, the distance between the end point of the current row scroll axis above the row scroll bar is ScrH, the distance between the head and/or the end point of the current column scroll axis in the column scroll bar and the left side is ScrW, and dividing ScrH by H to obtain the number of cells between the head and/or the end point of the starting table above the distance, which is used as the row index; similarly, dividing ScrW by W to obtain the number of cells between the starting table and the left end point, and using the number as the column index, thereby obtaining the index information (row index, column index) of the starting table 204 of the table display area 203.
According to the technical scheme, the index information of the initial table is determined according to the position information of the rolling axis and the row width of the line height of the standard table, so that the position of the initial table in the whole table is determined, and a foundation is laid for subsequently determining the position of the table display area in the whole table.
S220, determining a table display area in the table to be displayed according to the index information of the initial table and the display area of the display page.
And after the index information of the initial table is obtained in the previous step, positioning the table display area according to the display area of the display page by taking the position of the initial table as a reference. The display area can be set manually or can be automatically adapted according to the size of the display equipment, and the size of the display area of the table display page is not limited in the embodiment of the invention.
And S230, if the form to be displayed meets the preset lazy loading condition, expanding the form display area along the movable direction of the rolling shaft to obtain a form loading area.
S240, loading and rendering the table loading area in the table to be displayed, and displaying cell data in the table display area in the table to be displayed.
In an alternative embodiment, the expanding the table showing areas along the movable direction of the rolling axis may include: if the row rolling shaft is located at a row rolling end point position, expanding the table display area along a transverse direction and a direction far away from the row rolling end point; if the column rolling shaft is located at a column rolling end point position, expanding the table display area along the longitudinal direction and the direction far away from the column rolling end point; and if the row rolling shaft is positioned at a non-row rolling end point position and the column rolling shaft is positioned at a non-column rolling end point position, expanding the table display area along the transverse direction and the longitudinal direction by taking the table display area as the center.
The scrolling end points are two end points of the scroll bar, the row scrolling end point is the end point of the row scroll bar, and the column scrolling end point is the end point of the column scroll bar.
It will be appreciated that when the scroll axis is located at the end of the scroll bar, the current form presentation area also reaches the corresponding boundary of the overall form. Therefore, when the row scroll axis is located at the row scroll endpoint position, the table presentation area is expanded in the transverse direction (i.e., the direction in which the row scroll axis can be dragged) toward the direction away from the row scroll endpoint; similarly, when the column scroll axis is located at the column scroll end point, the table display area is expanded in the longitudinal direction (i.e., the direction in which the column scroll axis can be dragged) toward the direction away from the column scroll end point.
Referring to fig. 2C-2J, a display process diagram of each table to be displayed is shown, where the illustrated table is the whole table to be displayed, a bold solid line part is a table display area, and a bold dashed line part is an expanded area.
As shown in fig. 2C, when the table display area is expanded to the left side, but the expansion area exceeds the range of the table to be displayed, the table to be displayed is expanded only to the left edge of the table to be displayed, until the displayed content includes the left edge of the table to be displayed, and the table to be displayed does not need to be expanded to the left side.
As shown in fig. 2D, when the table display area is expanded to the right side, but the expansion area exceeds the range of the table to be displayed, the table display area is expanded only to the right edge of the table to be displayed, until the displayed content includes the right edge of the table to be displayed, and the table display area does not need to be expanded to the right side.
As shown in fig. 2E, when the table display area is expanded to the upper side, but the expansion area exceeds the range of the table to be displayed, the table to be displayed is expanded only to the upper side edge of the table to be displayed, until the displayed content includes the upper side edge of the table to be displayed, and the table to be displayed does not need to be expanded to the upper side.
As shown in fig. 2F, when the table display area is expanded to the lower side, but the expansion area exceeds the range of the table to be displayed, the table to be displayed is expanded only to the lower side edge of the table to be displayed until the displayed content includes the right side edge of the table to be displayed, and the expansion does not need to be continued to the lower side.
As shown in fig. 2G, when the table display area is expanded to the left and the upper side, but the expansion area exceeds the range of the table to be displayed, the table to be displayed is expanded only to the left edge and the upper edge of the table to be displayed, until the displayed content includes the left edge and the upper edge of the table to be displayed, and the expansion does not need to be continued to the left and the upper side.
As shown in fig. 2H, when the table display area is expanded to the right and the upper side, but the expansion area exceeds the range of the table to be displayed, the table display area is expanded only to the right edge and the upper edge of the table to be displayed, until the displayed content includes the right edge and the upper edge of the table to be displayed, and the expansion to the right and the upper side is not required to be continued.
As shown in fig. 2I, when the table display area is expanded to the left and the lower side, but the expansion area exceeds the range of the table to be displayed, the table to be displayed is expanded only to the left edge and the lower edge of the table to be displayed, until the displayed content includes the left edge and the lower edge of the table to be displayed, and the expansion does not need to be continued to the left and the lower side.
As shown in fig. 2J, when the table display area is expanded to the right and the lower side, but the expansion area exceeds the range of the table to be displayed, the table to be displayed is expanded only to the right edge and the lower edge of the table to be displayed, until the displayed content includes the right edge and the lower edge of the table to be displayed, and the expansion to the right and the lower side is not required to be continued.
And when the row rolling axis and the column rolling axis are not positioned at the rolling end points, expanding the table display area along the transverse direction and the longitudinal direction respectively. That is, when no edge of the table display area reaches one end of the table to be displayed, the table display area is expanded in four directions, i.e., up, down, left and right, as shown in fig. 2B.
In the optional embodiment, the position of the table display area in the whole table is determined according to the position information of the rolling axis, the table display area is used as the center and is expanded to the periphery, when the table display area is only close to the side edge or the corner of the whole table, the table display area is expanded to other directions capable of being continuously expanded, and a simple and reliable expansion mode lays a foundation for subsequently determining the table loading area.
According to the technical scheme of the embodiment of the invention, the position information of the table display area is determined by determining the position information of the rolling shaft, so that the expanded table loading area is obtained, the position of each area in the whole table is determined quickly and efficiently before table data content is loaded and rendered, and the speed and the display efficiency of the whole data display process are improved.
EXAMPLE III
Fig. 3 is a flowchart of a table data processing method according to a third embodiment of the present invention. On the basis of the technical scheme of the embodiment, the embodiment of the invention adds the table data processing operation to realize the determination that the table to be displayed accords with the preset lazy loading condition.
Referring to fig. 3, a table data processing method specifically includes the following steps:
s310, determining a table display area in the table to be displayed according to the position information of the rolling shaft in the display page; wherein the scroll axes include a row scroll axis and a column scroll axis.
S320, determining the number of the row tables and the number of the column tables of the table to be displayed.
S330, if the number of the row tables exceeds the number of the standard row tables of the display page, or the number of the column tables exceeds the number of the standard column tables of the display page, determining that the table to be displayed meets a preset lazy loading condition.
The standard row table number of the display page is the row table number which can be displayed at most at the same time; similarly, the standard column table number is the number of column tables that can be presented at most simultaneously on the presentation page. Therefore, if the number of the row tables of the table to be displayed exceeds the number of the standard column tables, or the number of the list tables of the table to be displayed exceeds the number of the standard column tables, the table to be displayed is considered to meet a preset lazy loading condition, that is, the table to be displayed can be loaded and rendered in a lazy loading mode.
The standard row table number and the standard column table number can be set by technicians according to needs or experience values, and can also be determined according to the size of the display page. For example, the number of standard row tables may be the maximum row number of the table displayed on the preset standard display page; the standard list table number may be the maximum column number of the table displayed on the preset standard display page. The standard display page may be a default display page set in a fixed manner, or may be a display page closed last time.
For example, the number of row tables exceeding the standard number of row tables of the presentation page, or the number of column tables exceeding the standard number of column tables of the presentation page may be: the length of the table to be displayed is larger than that of the display page, or the width of the table to be displayed is larger than that of the display page.
And S340, if the form to be displayed meets the preset lazy loading condition, expanding the form display area along the movable direction of the rolling shaft to obtain a form loading area.
S350, loading and rendering the table loading area in the table to be displayed, and displaying cell data in the table display area in the table to be displayed.
In an optional implementation, the table data processing method may further include: if the table to be displayed does not accord with the preset lazy loading condition, loading and rendering the table display area in the table to be displayed; and displaying the cell data in the table display area in the table to be displayed.
The table to be displayed does not meet the preset lazy loading condition, and optionally, the number of the row tables of the table to be displayed is smaller than the number of the standard row tables, and the number of the list tables of the table to be displayed is smaller than the number of the standard column tables. At the moment, the cell display area in the display interface is directly loaded and rendered, and the data information in each cell is directly displayed.
It can be understood that the form which is not in accordance with the lazy loading condition is directly displayed without other processing, so that the processing speed of the form display process is increased, and the efficiency of the form data processing process is improved.
According to the technical scheme of the embodiment of the invention, whether the table to be displayed accords with the preset lazy loading condition is verified according to the comparison of the number of rows and columns of the table to be displayed and the number of standard rows and columns of the display page, so that a judgment mechanism for judging whether the preset lazy loading condition is met is perfected, the expansion opportunity of the table display area is determined, the display efficiency of the table to be displayed with large data volume is improved, and the use experience of a user is improved.
Example four
Fig. 4 is a structural diagram of a table data processing apparatus according to a fourth embodiment of the present invention, where the apparatus according to the fourth embodiment of the present invention is applicable to a case where data in a table is displayed according to whether a lazy loading condition is met, and the apparatus may be implemented by software and/or hardware, and may be configured in an electronic device. As shown in fig. 4, the apparatus may include: a presentation area determination module 410, a load area expansion module 420, and a load presentation module 430. Wherein the content of the first and second substances,
the display area determining module 410 is configured to determine a table display area in a table to be displayed according to the position information of the scroll axis in the display page; wherein the scroll axes include a row scroll axis and a column scroll axis;
a loading area expansion module 420, configured to expand the table display areas along the movable direction of the rolling axis respectively to obtain table loading areas if the table to be displayed meets a preset lazy loading condition;
the loading and displaying module 430 is configured to load and render the table loading area in the table to be displayed, and display cell data in the table displaying area in the table to be displayed.
According to the technical scheme of the embodiment of the invention, the form display area is determined according to the position information of the rolling shaft, the form display area is expanded by a lazy loading method to obtain the form loading area, and data in the form loading area is loaded and rendered. According to the technical scheme, the table display process adopts a lazy loading method, the loading and rendering range of the table to be displayed is expanded, and the table to be displayed is not limited to the table display area, so that the loading and rendering efficiency is improved. Meanwhile, the form loading area changes in real time along with the browsing of the user, and simultaneously, the changed form data content is loaded and rendered in real time, so that the situation of waiting for loading or displaying blank can not occur when the user browses the form, and the use experience of the user is improved.
In an alternative embodiment, the presentation area determining module 410 may include:
the index information determining unit is used for determining the index information of the initial form of the form display area according to the position information of the rolling shaft and the attribute information of the standard form; wherein the index information comprises a row index and a column index;
and the display area determining unit is used for determining the table display area in the table to be displayed according to the index information of the initial table and the display area of the display page.
In an optional implementation, the index information determining unit may include:
the column index determining subunit is configured to determine a column index of a starting table of the table display area according to the position information of the row rolling axis and a standard table column width;
and the row index determining subunit is used for determining the row index of the initial table of the table display area according to the position information of the column rolling axis and the standard table row height.
In an alternative embodiment, the loading area expansion module 420 may include:
the transverse expansion unit is used for expanding the table display area along the transverse direction and the direction far away from the row rolling endpoint if the row rolling shaft is positioned at the row rolling endpoint position;
the longitudinal expansion unit is used for expanding the table display area along the longitudinal direction and the direction far away from the column rolling endpoint if the column rolling shaft is positioned at the column rolling endpoint;
and the transverse and longitudinal reaming unit is used for expanding the table display area along the transverse direction and the longitudinal direction by taking the table display area as the center if the row rolling shaft is positioned at a non-row rolling end point position and the column rolling shaft is positioned at a non-column rolling end point position.
In an optional implementation, the table data processing apparatus may further include:
the table quantity determining module is used for determining the quantity of the row tables and the quantity of the list tables of the table to be displayed;
and the lazy loading condition module is used for determining that the table to be displayed accords with a preset lazy loading condition if the number of the row tables exceeds the number of the standard row tables of the display page, or the number of the column tables exceeds the number of the standard column tables of the display page.
In an optional implementation, the table data processing apparatus may further include:
the loading and rendering module is used for loading and rendering the table display area in the table to be displayed if the table to be displayed does not accord with a preset lazy loading condition;
and the data display module is used for displaying the cell data in the table display area in the table to be displayed.
In an alternative embodiment, the data presentation module may include:
the index determining unit is used for determining the index information of each cell to be displayed in the table display area in the table to be displayed;
and the data display unit is used for acquiring corresponding cell data according to the index information of each cell to be displayed and displaying each cell data.
The table data processing device can execute the table data processing method provided by any embodiment of the invention, and has the functional modules and the beneficial effects corresponding to the execution of each table data processing method.
EXAMPLE five
Fig. 5 is a structural diagram of an electronic device according to a fifth embodiment of the present invention. FIG. 5 illustrates a block diagram of an exemplary electronic device 512 that may be suitable for use in implementing embodiments of the present invention. The electronic device 512 illustrated in fig. 5 is only an example and should not bring any limitations to the functionality and scope of use of the embodiments of the present invention.
As shown in fig. 5, electronic device 512 is in the form of a general purpose computing device. Components of the electronic device 512 may include, but are not limited to: one or more processors or processing units 516, a system memory 528, and a bus 518 that couples the various system components including the system memory 528 and the processing unit 516.
The system memory 528 may include computer system readable media in the form of volatile memory, such as Random Access Memory (RAM)530 and/or cache memory 532. The electronic device 512 may further include other removable/non-removable, volatile/nonvolatile computer system storage media. By way of example only, storage system 534 may be used to read from and write to non-removable, nonvolatile magnetic media (not shown in FIG. 5, commonly referred to as a "hard drive"). Although not shown in FIG. 5, a magnetic disk drive for reading from and writing to a removable, nonvolatile magnetic disk (e.g., a "floppy disk") and an optical disk drive for reading from or writing to a removable, nonvolatile optical disk (e.g., a CD-ROM, DVD-ROM, or other optical media) may be provided. In these cases, each drive may be connected to bus 518 through one or more data media interfaces. Memory 528 may include at least one program product having a set (e.g., at least one) of program modules that are configured to carry out the functions of embodiments of the invention.
A program/utility 540 having a set (at least one) of program modules 542, including but not limited to an operating system, one or more application programs, other program modules, and program data, may be stored in, for example, the memory 528, each of which examples or some combination may include an implementation of a network environment. The program modules 542 generally perform the functions and/or methods of the described embodiments of the invention.
The electronic device 512 may also communicate with one or more external devices 514 (e.g., keyboard, pointing device, display 524, etc.), with one or more devices that enable a user to interact with the electronic device 512, and/or with any devices (e.g., network card, modem, etc.) that enable the electronic device 512 to communicate with one or more other computing devices. Such communication may occur via input/output (I/O) interfaces 522. Also, the electronic device 512 may communicate with one or more networks (e.g., a Local Area Network (LAN), a Wide Area Network (WAN), and/or a public network, such as the internet) via the network adapter 520. As shown, the network adapter 520 communicates with the other modules of the electronic device 512 via the bus 518. It should be appreciated that although not shown, other hardware and/or software modules may be used in conjunction with the electronic device 512, including but not limited to: microcode, device drivers, redundant processing units, external disk drive arrays, RAID systems, tape drives, and data backup storage systems, among others.
The processing unit 516 executes various functional applications and data processing, for example, implementing a table data processing method provided by an embodiment of the present invention, by running at least one of other programs stored in the system memory 528.
EXAMPLE six
The sixth embodiment of the present invention further provides a computer-readable storage medium, on which a computer program (or referred to as computer-executable instructions) is stored, where the computer program is used for executing, when executed by a processor, a table data processing method provided by the sixth embodiment of the present invention: determining a table display area in a table to be displayed according to the position information of the rolling shaft in the display page; wherein the scroll axes include a row scroll axis and a column scroll axis; if the form to be displayed meets the preset lazy loading condition, expanding the form display area along the movable direction of the rolling shaft to obtain a form loading area; and loading and rendering the table loading area in the table to be displayed, and displaying the cell data in the table display area in the table to be displayed.
Computer storage media for embodiments of the invention may employ any combination of one or more computer-readable media. The computer readable medium may be a computer readable signal medium or a computer readable storage medium. A computer readable storage medium may be, for example, but not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any combination of the foregoing. More specific examples (a non-exhaustive list) of the computer readable storage medium would include the following: an electrical connection having one or more wires, a portable computer diskette, 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 disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing. In the context of this document, a computer readable storage medium may be any tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device.
A computer readable signal medium may include a propagated data signal with computer readable program code embodied therein, for example, in baseband or as part of a carrier wave. Such a propagated data signal may take many forms, including, but not limited to, electro-magnetic, optical, or any suitable combination thereof. A computer readable signal medium may also be any computer readable medium that is not a computer readable storage medium and that can communicate, propagate, or transport a program for use by or in connection with an instruction execution system, apparatus, or device.
Program code embodied on a computer readable medium may be transmitted using any appropriate medium, including but not limited to wireless, wireline, optical fiber cable, RF, etc., or any suitable combination of the foregoing.
Computer program code for carrying out operations for embodiments of the present invention may be written in any combination of one or more programming languages, including an object oriented programming language such as Java, Smalltalk, C + +, and conventional procedural programming languages, such as the "C" programming language or similar programming languages. The program code may execute entirely on the user's computer, partly on the user's computer, as a stand-alone software package, partly on the user's computer and partly on a remote computer or entirely on the remote computer or server. In the case of a remote computer, the remote computer may be connected to the user's computer through any type of network, including a Local Area Network (LAN) or a Wide Area Network (WAN), or the connection may be made to an external computer (for example, through the Internet using an Internet service provider).
It is to be noted that the foregoing is only illustrative of the preferred embodiments of the present invention and the technical principles employed. It will be understood by those skilled in the art that the present invention is not limited to the particular embodiments described herein, but is capable of various obvious changes, rearrangements and substitutions as will now become apparent to those skilled in the art without departing from the scope of the invention. Therefore, although the present invention has been described in greater detail by the above embodiments, the present invention is not limited to the above embodiments, and may include other equivalent embodiments without departing from the spirit of the present invention, and the scope of the present invention is determined by the scope of the appended claims.
Claims (10)
1. A method for processing tabular data, comprising:
determining a table display area in a table to be displayed according to the position information of the rolling shaft in the display page; wherein the scroll axes include a row scroll axis and a column scroll axis;
if the form to be displayed meets the preset lazy loading condition, expanding the form display area along the movable direction of the rolling shaft to obtain a form loading area;
and loading and rendering the table loading area in the table to be displayed, and displaying the cell data in the table display area in the table to be displayed.
2. The method according to claim 1, wherein the determining a table display area in the table to be displayed according to the position information of the scroll axis in the display page comprises:
determining index information of a starting table of the table display area according to the position information of the rolling shaft and the attribute information of a standard table; wherein the index information comprises a row index and a column index;
and determining a table display area in the table to be displayed according to the index information of the initial table and the display area of the display page.
3. The method according to claim 2, wherein the determining index information of the starting form of the form display area according to the position information of the scroll axis and the attribute information of the standard form comprises:
determining a column index of a starting table of the table display area according to the position information of the row rolling axis and the column width of a standard table; and the number of the first and second groups,
and determining the row index of the initial table of the table display area according to the position information of the column rolling axis and the height of the standard table row.
4. The method of claim 1, wherein the expanding the form presentation areas along the movable direction of the scroll axis respectively comprises:
if the row rolling shaft is located at a row rolling end point position, expanding the table display area along a transverse direction and a direction far away from the row rolling end point;
if the column rolling shaft is located at a column rolling end point position, expanding the table display area along the longitudinal direction and the direction far away from the column rolling end point;
and if the row rolling shaft is positioned at a non-row rolling end point position and the column rolling shaft is positioned at a non-column rolling end point position, expanding the table display area along the transverse direction and the longitudinal direction by taking the table display area as the center.
5. The method of claim 1, further comprising:
determining the number of row tables and the number of list tables of the table to be displayed;
and if the number of the row tables exceeds the number of the standard row tables of the display page, or the number of the column tables exceeds the number of the standard column tables of the display page, determining that the table to be displayed meets a preset lazy loading condition.
6. The method of claim 1, further comprising:
if the table to be displayed does not accord with the preset lazy loading condition, loading and rendering the table display area in the table to be displayed;
and displaying the cell data in the table display area in the table to be displayed.
7. The method according to any one of claims 1 to 6, wherein the displaying the cell data in the table display area in the table to be displayed comprises:
determining index information of each cell to be displayed in the table display area in the table to be displayed;
and acquiring corresponding cell data according to the index information of each cell to be displayed, and displaying each cell data.
8. A form data processing apparatus, comprising:
the display area determining module is used for determining a table display area in the table to be displayed according to the position information of the rolling shaft in the display page; wherein the scroll axes include a row scroll axis and a column scroll axis;
the loading area expansion module is used for expanding the table display area along the movable direction of the rolling shaft to obtain a table loading area if the table to be displayed meets a preset lazy loading condition;
and the loading display module is used for loading and rendering the table loading area in the table to be displayed and displaying the cell data in the table display area in the table to be displayed.
9. An electronic device, comprising:
one or more processors;
a memory for storing one or more programs;
when executed by the one or more processors, cause the one or more processors to implement a method of table data processing as claimed in any one of claims 1 to 7.
10. A computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, carries out a table data processing method according to any one of claims 1 to 7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111043191.6A CN113778306A (en) | 2021-09-07 | 2021-09-07 | Table data processing method, device, equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111043191.6A CN113778306A (en) | 2021-09-07 | 2021-09-07 | Table data processing method, device, equipment and storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN113778306A true CN113778306A (en) | 2021-12-10 |
Family
ID=78841568
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202111043191.6A Pending CN113778306A (en) | 2021-09-07 | 2021-09-07 | Table data processing method, device, equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113778306A (en) |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6373497B1 (en) * | 1999-05-14 | 2002-04-16 | Zight Corporation | Time sequential lookup table arrangement for a display |
| US20130332811A1 (en) * | 2012-06-07 | 2013-12-12 | Microsoft Corporation | Progressive loading for web-based spreadsheet applications |
| US20160321230A1 (en) * | 2015-04-29 | 2016-11-03 | Facebook, Inc. | Generating a data table |
| CN107704576A (en) * | 2017-09-30 | 2018-02-16 | 厦门海迈科技股份有限公司 | data display optimization method, device, terminal device and storage medium |
| CN111339463A (en) * | 2020-02-19 | 2020-06-26 | 望海康信(北京)科技股份公司 | List data display method and device and electronic equipment |
| CN111797603A (en) * | 2020-07-02 | 2020-10-20 | 北京字节跳动网络技术有限公司 | Method and device for browsing table in document, electronic equipment and storage medium |
-
2021
- 2021-09-07 CN CN202111043191.6A patent/CN113778306A/en active Pending
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6373497B1 (en) * | 1999-05-14 | 2002-04-16 | Zight Corporation | Time sequential lookup table arrangement for a display |
| US20130332811A1 (en) * | 2012-06-07 | 2013-12-12 | Microsoft Corporation | Progressive loading for web-based spreadsheet applications |
| US20160321230A1 (en) * | 2015-04-29 | 2016-11-03 | Facebook, Inc. | Generating a data table |
| CN107704576A (en) * | 2017-09-30 | 2018-02-16 | 厦门海迈科技股份有限公司 | data display optimization method, device, terminal device and storage medium |
| CN111339463A (en) * | 2020-02-19 | 2020-06-26 | 望海康信(北京)科技股份公司 | List data display method and device and electronic equipment |
| CN111797603A (en) * | 2020-07-02 | 2020-10-20 | 北京字节跳动网络技术有限公司 | Method and device for browsing table in document, electronic equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US8384726B1 (en) | Selective rendering of off-screen content | |
| WO2021068331A1 (en) | Web page adaptive layout method, server and computer-readable storage medium | |
| US8959431B2 (en) | Low resolution placeholder content for document navigation | |
| US20120096344A1 (en) | Rendering or resizing of text and images for display on mobile / small screen devices | |
| US20130339830A1 (en) | Optimized document views for mobile device interfaces | |
| US9569004B2 (en) | Swipe toolbar to switch tabs | |
| CN107341016B (en) | Focus state implementation method and device under split screen mechanism, terminal and storage medium | |
| US9633410B2 (en) | Compositor support for graphics functions | |
| CN112882678B (en) | Image-text processing method, image-text processing display method, image-text processing device, image-text processing equipment and storage medium | |
| EP3572954A1 (en) | Browser page display method and device, storage medium, and terminal | |
| CN113626743A (en) | Method and device for determining target display page, electronic equipment and storage medium | |
| CN113204401B (en) | Browser rendering method, terminal and storage medium | |
| US20140223291A1 (en) | System and method for restructuring content on reorientation of a mobile device | |
| US20130016108A1 (en) | Information processing apparatus, information processing method, and program | |
| CN113778306A (en) | Table data processing method, device, equipment and storage medium | |
| CN108259958B (en) | Remote control key response method, device, equipment and storage medium | |
| US11604849B2 (en) | Rendering method, electronic device and storage medium | |
| CN113626120A (en) | Method and device for determining display page, electronic equipment and storage medium | |
| CN111782121B (en) | Page rolling control method and device, readable storage medium and electronic equipment | |
| CN115390976A (en) | Layout method of interface design, display method of interface and related equipment | |
| CN113779449A (en) | Page loading method and device, electronic equipment and storage medium | |
| CN114528509A (en) | Page display processing method and device, electronic equipment and storage medium | |
| CN113885998A (en) | Page rendering method and device, electronic equipment and storage medium | |
| CN114356475A (en) | Display processing method, device, equipment and storage medium | |
| CN113779321A (en) | Electronic whiteboard file saving method and device, electronic whiteboard and storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |