CN105549936B

CN105549936B - Data table display method and device

Info

Publication number: CN105549936B
Application number: CN201510967137.9A
Authority: CN
Inventors: 应玉龙
Original assignee: Tencent Technology Shenzhen Co Ltd
Current assignee: Tencent Technology Shenzhen Co Ltd
Priority date: 2015-12-21
Filing date: 2015-12-21
Publication date: 2020-05-19
Anticipated expiration: 2035-12-21
Also published as: CN105549936A

Abstract

The invention discloses a method and a device for displaying a data table. Wherein, the method comprises the following steps: acquiring a display instruction for displaying a data table input through a screen of a terminal, wherein the data table is divided into a plurality of data blocks; determining a partial data block to be displayed in response to the display instruction, wherein the partial data block is matched with the view size on the screen of the terminal; reading data matched with the view size in the partial data block to be displayed; and displaying the read data on a screen of the terminal. The XLS file opening method and device solve the technical problem that the opening speed is low when the XLS file is opened.

Description

Data table display method and device

Technical Field

The invention relates to the field of data processing, in particular to a method and a device for displaying a data table.

Background

With the continuous upgrading of network environment and the continuous improvement of the performance of mobile equipment, working on the mobile equipment becomes the first choice of more and more users. When working on a mobile device, various office documents are required to be opened on the mobile device. Among them, XLS is a worksheet document (i.e., spreadsheet document), a very common spreadsheet format, and is used for storing and displaying various tabular data. On a mobile phone terminal, the XLS document is read by adopting a scheme of open source software POI, namely, firstly, an XLS file is read, the read XLS file is analyzed to generate a POI object, then the POI object is mapped into a Dom object through an HTML converter, the Dom object is stored into an HTML file, and the HTML file is notified to be loaded and displayed by webview.

Through analysis of the existing implementation scheme, the performance of the XLS document opened by the existing technical scheme is very poor, and the XLS document opened by the existing technical scheme is mainly caused by the following three links:

(1) in the existing scheme, in the process of generating a POI object by analyzing an XLS file, the integral POI object is generated by the XLS file at one time, the read-write IO operation is frequently required in the process, and the time consumption for integral reading is long.

(2) In the existing scheme, the whole POI object is completely converted into a Dom object, in the process, not only is the memory frequently allocated, but also a long time is taken for converting the POI object into the Dom object at one time, and the operation mode may cause insufficient memory of the terminal, and possibly cause the terminal application to be blocked or crashed.

(3) In the existing scheme, the whole form needs to be completely converted into a table in a webpage html, and if the form is large, the generated table is also large, and the Webview consumes long time when the large table is displayed.

From the above analysis, the existing implementation scheme needs to occupy a lot of system resources when opening the XLS file with large data capacity, and the opening speed is very slow. For example: if a sheet in an XLS document has about 1000 lines of data, the open time is about 10 seconds, and it takes about 150 seconds to open 10000 lines. Furthermore, an XLS file typically has multiple sheets, and therefore requires more time. When the sheet is switched, because the web view has poor performance on displaying a large table, about 4 seconds is needed for displaying 1000 lines of data. For a document application that is oriented to read functionality, opening an XLS document takes too long and is completely unacceptable to the user.

Aiming at the problem of slow opening speed when the XLS file is opened, no effective solution is provided at present.

Disclosure of Invention

The embodiment of the invention provides a method and a device for displaying a data table, which are used for at least solving the technical problem of low opening speed when an XLS file is opened.

According to an aspect of an embodiment of the present invention, there is provided a method for displaying a data table, the method including: acquiring a display instruction for displaying a data table input through a screen of a terminal, wherein the data table is divided into a plurality of data blocks; determining a partial data block to be displayed in response to the display instruction, wherein the partial data block is matched with the view size on the screen of the terminal; reading data matched with the view size in the partial data block to be displayed; and displaying the read data on a screen of the terminal.

According to another aspect of the embodiments of the present invention, there is also provided a display apparatus of a data table, the apparatus including: a first acquisition unit configured to acquire a display instruction for displaying a data table, which is divided into a plurality of data blocks, input through a screen of a terminal; a response unit, configured to determine, in response to the display instruction, a partial data block to be displayed, which is matched with a view size on a screen of the terminal, from among the plurality of data blocks; the first reading unit is used for reading data matched with the view size in the partial data block to be displayed; and the first display unit is used for displaying the read data on a screen of the terminal.

In the embodiment of the invention, after the display instruction is acquired, a part of data blocks in the data table to be displayed are determined according to the display instruction and the view size on the terminal screen, data matched with the view size in the part of data blocks are read, and the data are displayed on the screen of the terminal. Compared with the scheme of one-time reading, conversion and display in the prior art, the scheme of the application is when displaying the data sheet, the display instruction indicates which part of data block's data is displayed, then the data of this part of data block is read, and display, because the data sheet is divided into a plurality of data blocks, when displaying at every turn, only operate some of them, the data volume of operation is little, it is little to consume system resources, the operating speed is fast, can generally accomplish the display of part of data block in ms rank time, the display speed is fast, the problem of slow opening speed when opening the XLS file in the prior art is solved, the effect of fast displaying the XLS file is realized.

Drawings

The accompanying drawings, which are included to provide a further understanding of the invention and are incorporated in and constitute a part of this application, illustrate embodiment(s) of the invention and together with the description serve to explain the invention without limiting the invention. In the drawings:

FIG. 1 is a diagram illustrating a hardware environment of a terminal according to an embodiment of the present invention;

FIG. 2 is a flow chart of an alternative data table display method according to an embodiment of the present invention;

FIG. 3 is a schematic illustration of an alternative data table versus view size in accordance with embodiments of the present invention;

FIG. 4 is a flow chart of an alternative data table display method according to an embodiment of the present invention;

FIG. 5 is a schematic diagram of an alternative spreadsheet display device according to an embodiment of the present invention;

fig. 6 is a schematic diagram of an internal structure of an alternative terminal according to an embodiment of the present invention.

Detailed Description

First, terms involved in the embodiments of the present invention are explained as follows:

XLS document: XLS is Microsoft Excel worksheet, a very common spreadsheet format. The XLS file can be opened by using Microsoft Excel on the PC side, and is opened by using the scheme of open source software POI on the mobile phone terminal. An XLS form file may contain multiple sheets, each of which is actually a sub-form in the XLS document.

POI: the open source code function library is an open source code function library of an Apache software foundation, is a free source-opening cross-platform function library written by Java, and provides an interface for reading and writing Microsoft OLE2 component document functions such as Excel and WORD for an application program.

Data block: the basic unit of storing data in an XLS document is a data block.

View: the method is a basic class of the android system and is a place used for drawing a graph or an image in the android system. Each View has a canvas for drawing, and the canvas can be arbitrarily expanded.

In order to make the technical solutions of the present invention better understood, the technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.

It should be noted that the terms "first," "second," and the like in the description and claims of the present invention and in the drawings described above are used for distinguishing between similar elements and not necessarily for describing a particular sequential or chronological order. It is to be understood that the data so used is interchangeable under appropriate circumstances such that the embodiments of the invention described herein are capable of operation in sequences other than those illustrated or described herein. Furthermore, the terms "comprises," "comprising," and "having," and any variations thereof, are intended to cover a non-exclusive inclusion, such that a process, method, system, article, or apparatus that comprises a list of steps or elements is not necessarily limited to those steps or elements expressly listed, but may include other steps or elements not expressly listed or inherent to such process, method, article, or apparatus.

Example 1

In accordance with an embodiment of the present invention, there is provided an embodiment of a method for displaying a data table, it should be noted that the steps illustrated in the flowchart of the accompanying drawings may be performed in a computer system such as a set of computer executable instructions, and that while a logical order is illustrated in the flowchart, in some cases the steps illustrated or described may be performed in an order different than that herein.

Alternatively, the above-mentioned data table display method may be applied to a hardware environment formed by the terminal 10 and the server 30 shown in fig. 1, and the terminal may establish a connection with the server through a network. The terminal can be a mobile terminal, such as a smart phone, a tablet computer and a PDA, and other handheld devices.

Such networks include, but are not limited to: a wide area network, a metropolitan area network, or a local area network. Preferably, the network is a local area network.

According to an embodiment of the present invention, there is provided a method for displaying a data table, as shown in fig. 2, the method including:

step S202: a display instruction for displaying a data table, which is divided into a plurality of data blocks, input through a screen of a terminal is acquired.

Step S204: and determining a part of the data blocks to be displayed which is matched with the view size on the screen of the terminal in the plurality of data blocks in response to the display instruction.

Step S206: and reading data matched with the view size in the partial data block to be displayed.

Step S208: the read data is displayed on a screen of the terminal.

By adopting the above embodiment of the present invention, after the display instruction is acquired, a part of data blocks in the data table to be displayed is determined according to the display instruction and the view size on the terminal screen, data in the part of data blocks matching with the view size is read, and the data is displayed on the terminal screen. Compared with the scheme of one-time reading, conversion and display in the prior art, the scheme of the application is when displaying the data sheet, the display instruction indicates which part of data block's data is displayed, then the data of this part of data block is read, and display, because the data sheet is divided into a plurality of data blocks, when displaying at every turn, only operate some of them, the data volume of operation is little, it is little to consume system resources, the operating speed is fast, can generally accomplish the display of part of data block in ms rank time, the display speed is fast, the problem of slow opening speed when opening the XLS file in the prior art is solved, the effect of fast displaying the XLS file is realized.

The data table in the embodiment of the present invention may be an XLS-formatted file, the XLS-formatted file is divided into a plurality of data blocks during storage, the data capacities of the data blocks may be the same or different, if the data capacity of the data block is smaller than a preset capacity, the data blocks adjacent to each other in position may be merged into a new data block, and when a display operation is performed, the merged new data block is taken as an integral data block to perform a reading or rendering operation on the integrated data block.

The terminal in the above embodiment may be a mobile terminal, and the display instruction input through a screen of the mobile terminal may be a touch instruction input by a user operating the screen of the terminal, such as a long-press instruction, a slide instruction, and the like.

The view size on the screen of the terminal may be the size of the screen, and if the partial data block to be displayed is displayed in a split screen manner or in a floating manner on the screen of the terminal, the size of the area displayed in the split screen manner or the size of the area displayed in the floating manner is the view size.

Because the view size is relatively fixed, when a partial data block matched with the view size is obtained, as long as the data block and the area determined by the view size have intersection, the data block is one part of the partial data block to be displayed; when data matched with the view size is acquired, the data of the part where each data block and the area determined by the view size have intersection is acquired.

In an alternative embodiment, before acquiring the display instruction for displaying the data table input through the screen of the terminal, the method may further include: reading attribute information of a data table from an XLS file (such as the data table) of a storage space of a mobile phone (such as a terminal), wherein the attribute information of the data table at least comprises index information of each data block; caching the attribute information of the data table into a memory of the terminal; and reading the position of each data block in the data table from the XLS file by using the cached index information of each data block.

When the data table needs to be opened through the mobile terminal, the attribute information of the data table is loaded into the memory, and the attribute information of the data table is used as cache for repeatedly reading data during subsequent analysis, so that the problem of slow analysis caused by frequent disk I/O operation is solved.

Traversing the whole loaded memory cache, and analyzing the global information of the data table, wherein the global information at least comprises: a style sheet of a data block in the data table, index information of the data block, and the like, and the index information of the data block may be a name of the data block, such as data block a. After the index information is obtained, reading the positioning information of the data block corresponding to each index information from an XLS file in the storage space of the terminal, where the positioning information at least includes: line height, column width, and location information of the data block.

Wherein, the row height is used for indicating the row number included in the data block, and the column width is used for indicating the column number included in the data block, such as row height 8 and column width 4, indicating that the data block includes 8 rows and 4 columns; the position information of the data block is used for indicating the position of the data block in the data table.

Optionally, the location information of the data block may include: the first line memory offset address and the memory offset address of each line of unit cells can determine the position of the data block in the data table through the first line memory offset address and the memory offset address of each line of record items.

As an alternative implementation, the location information of a data block may record a start row, an end row, a start column, an end column, a first row memory offset address, and a memory offset address of each row entry of the data block.

In the above embodiment, only the attribute information of the data table is cached in the memory, so that memory allocation is greatly reduced, all data block information does not need to be analyzed, after the partial data block to be displayed is determined, only the data matched with the view size in the partial data block to be displayed needs to be read from the XLS file in the storage space, the read data amount is verified, the whole preprocessing can be completed in about 1 second for 1.6 ten thousand rows of data, the processing time is greatly shortened, and the processing speed is improved.

According to the above-described embodiment of the present invention, determining a partial data block to be displayed, which matches a view size on a screen of the terminal, among the plurality of data blocks in response to the display instruction may include: determining a display starting position indicated by a display instruction in a data table; determining a record item area to be displayed in the data table according to the display starting position and the view size; and taking the data block which is overlapped with the recording item area in the plurality of data blocks as a partial data block to be displayed.

Specifically, based on a display start position in the data table indicated by the display instruction, the entry area to be displayed in the data table is obtained based on the view size with the display start position as a reference, and the display start position may be a position of a start entry of the entry area to be displayed, where the position of the entry may be indicated by a row and column position of the entry in the data table, and as an entry (1, 1), the entry is indicated as an entry in a first row and a first column in the data table.

After determining the display starting position, acquiring the size of the view, and determining the position of a boundary record item or a vertex record item in the data table based on the size of the view, for example, determining the position of the vertex record item of the record item area to be displayed as follows: (1, 1) (the position of the entry is the display start position), (8, 1), (1, 5) and (8, 5), after determining the boundary or vertex entry of the entry area, the entry area to be displayed can be determined, after determining the entry area to be displayed, the position of each entry in the entry area to be displayed is acquired, the data block overlapping with the position of the entry is acquired from the data table, and the partial data block to be displayed can be acquired.

As shown in fig. 3, the data table at least includes 6 data blocks, which are: the data block (0,0), the data block (0, 1), the data block (0, 2), the data block (1, 0), the data block (1, 1) and the data block (1, 2), and a part of the data block acquired by the display instruction may be four data blocks matching the view size.

In an optional embodiment, the display instruction is a slide instruction, wherein determining the display start position indicated by the display instruction in the data table may include: acquiring a sliding starting position indicated by the sliding instruction in the data table; and determining the display starting position according to the sliding starting position and the sliding displacement amount indicated by the sliding instruction.

Specifically, determining the display start position according to the slide start position and the slide displacement amount indicated by the slide instruction includes: acquiring a sliding operation starting point coordinate and a sliding operation end point coordinate of a display instruction; calculating a difference value between the sliding operation end point coordinate and the sliding operation starting point coordinate to obtain a sliding displacement vector, wherein the sliding displacement comprises the sliding displacement vector; and taking the sum of the coordinates of the sliding initial position and the sliding displacement vector as the coordinates of the display initial position.

As described above, the display instruction may be a slide instruction for dragging an XLS file currently displayed in a view of a screen, and after receiving the slide instruction, acquiring a position of a start entry of data currently displayed on a screen of the terminal, and taking the position of the currently displayed start entry as a slide start position. Then, the coordinates of the start input position (i.e., the coordinates of the start point of the sliding operation in the above-mentioned embodiment) and the coordinates of the end input position (i.e., the coordinates of the end point of the sliding operation in the above-mentioned embodiment) of the sliding instruction are obtained, the sliding displacement vectors corresponding to these two coordinates are calculated, and the sliding displacement vectors are superimposed on the sliding start position, so that the display start position can be determined, and the partial data block to be displayed is determined based on the view size, and the data of the related content is read and displayed.

In another alternative embodiment, determining a portion of the plurality of data blocks to be displayed that matches the view size on the screen of the terminal in response to the display instruction may include: acquiring index information of a data block indicated by a display instruction; and taking a data block corresponding to the index information of the data block in the plurality of data blocks as a partial data block to be displayed.

The user can input the index information of the data block to be displayed through the screen of the terminal, and the processor of the terminal directly reads the data block indicated by the index information from the XLS file of the storage space and directly determines the data block corresponding to the index information as a partial data block to be displayed. The data block can be directly selected by the scheme.

Optionally, the partial data blocks are N data blocks, wherein after the read data is displayed on a screen of the terminal, the method may further include: receiving a switching instruction input through a screen of a terminal; acquiring a target data block in the N data blocks indicated by the switching instruction; reading target data matched with the view size in the target data block; and displaying the read target data on a screen of the terminal.

Under the condition that the number of partial data blocks to be displayed is N (4 in the scheme shown in fig. 3), a user can input a switching instruction through a screen of an operation terminal, the switching instruction may carry a displacement vector, and if the value of the displacement vector is greater than a preset vector value, it is determined that the switching instruction is used for indicating that complete information of a target data block of the N data blocks is displayed on the screen of the terminal, data of the target data block is acquired, and data of the target data block is displayed on the screen of the terminal.

Further optionally, if the area covered by the data of the target data block is larger or much smaller than the view size, the data of the target data block may be displayed in a zoomed manner on the screen of the terminal, so as to improve the user experience.

In the above embodiment of the present invention, the partial data blocks are N data blocks, wherein displaying the read data on the screen of the terminal may include: generating an initial display image of data of each of the N data blocks; splicing the generated N initial display images to obtain spliced images; if the size of the spliced image is larger than the view size, cutting the spliced image according to the view size to obtain a display image; and if the size of the spliced image is not larger than the view size, taking the spliced image as a display image, and displaying the display image on a screen of the terminal after the display image is acquired.

Specifically, in the case where the partial data block is N data blocks, an initial display image of data of each of the N data blocks may be generated, respectively, and one initial display image may also be generated based on the data of the N data blocks. Specifically, style information of entries in the data blocks (the style information may also be a part of the attribute information) may be read from the memory cache, and an initial display image of data of each data block may be rendered (or rendered) based on the style information.

Under the condition that an initial display image is generated for each data block, after the initial display images are obtained, splicing the N initial display images to obtain a spliced image; if the size of the spliced image is larger than the view size, cutting the spliced image according to the view size to obtain a display image; and if the size of the spliced image is not larger than the view size, taking the spliced image as a display image. Alternatively, after the stitched image is obtained, if the size of the stitched image is larger than the view size or smaller than the view size, the stitched image may be scaled within a preset multiple range to obtain a display image, and the display image is displayed on the screen of the terminal.

In the above embodiment, it may be calculated which data chunks need to be displayed (may be displayed in a rendering manner) according to the View size for displaying the XLS file in the screen of the terminal and the display start position of the XLS, and if a data chunk is not yet rendered, the parsing rendering thread is notified to generate an image of the data chunk.

Further, for each data block to be rendered and displayed, firstly, finding out a corresponding data block in the XLS according to the positioning information of the data block (such as a data slice), then analyzing and reading the data therein, and generating an initial display image of each slice; and finally splicing and cutting the slices into an image for rendering and displaying the mobile phone screen according to the position of each slice in the View of the screen of the terminal.

According to the embodiment of the invention, a brand-new XLS document opening and reading scheme is provided by combining the storage structure characteristics of the XLS document; three links influencing the opening performance in the original opening scheme are avoided, the opening speed is greatly improved, and the consumption of resources is reduced. Specifically, in the embodiments of the present invention, by combining the characteristic of blocking storage of data in an XLS document, the original data block in the XLS document is used as a unit for subsequent processing, and unnecessary analysis processing on data inside the data block is avoided in an early stage; and driving a processing flow of a corresponding data block according to the display condition of the XLS document in the screen, and adopting a strategy of real-time analysis and local rendering to quickly open the file.

The above embodiment of the present invention is described in detail with reference to fig. 4, and as shown in fig. 4, the embodiment can be implemented by the following scheme:

step S401: the user selects the XLS document to be opened and starts to open the reading.

Specifically, the user may input a reading instruction on the screen of the terminal.

Step S402: and loading the attribute information of the XLS file into a memory as a cache.

Specifically, after receiving a reading instruction of a user, the attribute information of the XLS file may be loaded into the memory as a cache, and the cache may be used for repeatedly reading data during subsequent parsing, so as to avoid a problem of slow parsing caused by frequent disk I/O operations.

Step S403: and traversing the loaded XLS memory cache to analyze the global information.

Specifically, the global information may include: a style sheet of a cell (the cell may be a data block or a record item in the data block), index information of the data block, and the like.

After acquiring the global information, generating positioning information of a form Sheet in an XLS file based on the global information, wherein the positioning information mainly comprises: the row height, the row width, and the memory location information of the data block to record the initial row, the end row, the first row memory offset address, and the memory offset address of each row of cells.

Step S404: and calculating a partial section to be displayed according to the View size for displaying the XLS in the mobile phone screen and the current display position of the XLS. The partial slice to be displayed is the slice that needs to be further processed.

The XLS document may be logically sliced according to the data capacity of the data chunks before performing this step, e.g., a data chunk with too small a data capacity is merged into a data chunk adjacent to it.

Step S405: and finding the corresponding data block in the memory cache according to the partial slice to be displayed.

Step S406: and analyzing data information in the data block, and generating a sliced image according to information such as an XLS pattern and the like.

Step S407: and splicing each slice image to be rendered and displayed according to the position information, and cutting each slice image into an image for rendering and displaying on the mobile phone screen according to the position of each slice in the View of the mobile phone screen.

By the scheme, the characteristic of data blocking storage in the XLS document is combined, the subsequent processing is carried out by taking the original data block in the XLS document as a unit, and unnecessary analysis processing on the data in the data block is avoided at the early stage; and driving the further processing of the corresponding data block according to the display condition of the XLS document in the screen, and adopting a strategy of real-time analysis and local rendering. The XLS file opening method based on the multi-user interface can greatly improve the XLS file opening speed on the premise of occupying few system resources (including internal memory, CPU and the like), and provides good XLS file reading experience for users.

It should be noted that, for simplicity of description, the above-mentioned method embodiments are described as a series of acts or combination of acts, but those skilled in the art will recognize that the present invention is not limited by the order of acts, as some steps may occur in other orders or concurrently in accordance with the invention. Further, those skilled in the art should also appreciate that the embodiments described in the specification are preferred embodiments and that the acts and modules referred to are not necessarily required by the invention.

Through the above description of the embodiments, those skilled in the art can clearly understand that the method according to the above embodiments can be implemented by software plus a necessary general hardware platform, and certainly can also be implemented by hardware, but the former is a better implementation mode in many cases. Based on such understanding, the technical solutions of the present invention may be embodied in the form of a software product, which is stored in a storage medium (e.g., ROM/RAM, magnetic disk, optical disk) and includes instructions for enabling a terminal device (e.g., a mobile phone, a computer, a server, or a network device) to execute the method according to the embodiments of the present invention.

Example 2

According to an embodiment of the present invention, there is also provided a display apparatus for implementing the display method of the data table, as shown in fig. 5, the apparatus may include: a first acquisition unit 51, a response unit 53, a first reading unit 55, and a first display unit 57.

A first acquiring unit 51 configured to acquire a display instruction for displaying a data table, which is divided into a plurality of data blocks, input through a screen of a terminal;

a response unit 53, configured to determine, in response to the display instruction, a partial data block to be displayed, which is matched with a view size on a screen of the terminal, from among the plurality of data blocks;

a first reading unit 55, configured to read data that matches the view size in the partial data block to be displayed;

and a first display unit 57, configured to display the read data on a screen of the terminal.

According to the above embodiment of the present invention, the apparatus further comprises:

the terminal comprises a first reading unit, a second reading unit and a display unit, wherein the first reading unit is used for reading attribute information of a data table from a data table of a terminal storage space before a display instruction for displaying the data table input through a screen of the terminal is acquired, and the attribute information of the data table at least comprises index information of each data block;

the cache unit is used for caching the attribute information of the data table into a memory of the terminal;

and the third reading unit is used for reading the position of each data block in the data table from the data table by using the cached index information of each data block.

Optionally, the response unit may include: the first determining module is used for determining a display starting position indicated by a display instruction in the data table; the second determining module is used for determining a record item area to be displayed in the data table according to the display starting position and the view size; and the third determining module is used for taking the data block which is overlapped with the recording item area in the plurality of data blocks as a partial data block to be displayed.

In an optional embodiment, the display instruction is a slide instruction, wherein the first determining module includes: the position acquisition submodule is used for acquiring a sliding starting position indicated by the sliding instruction in the data table; and the position determining submodule is used for determining the display starting position according to the sliding starting position and the sliding displacement indicated by the sliding instruction.

Specifically, the position determination submodule includes: the coordinate acquisition submodule is used for acquiring a sliding operation starting point coordinate and a sliding operation end point coordinate of the display instruction; the vector calculation submodule is used for calculating a difference value between the sliding operation end point coordinate and the sliding operation starting point coordinate to obtain a sliding displacement vector, wherein the sliding displacement comprises the sliding displacement vector; and the coordinate determination submodule is used for taking the sum of the coordinate of the sliding initial position and the sliding displacement vector as the coordinate of the display initial position.

Optionally, the response unit may include: the information acquisition module is used for acquiring index information of the data block indicated by the display instruction; and the data block determining module is used for taking the data block corresponding to the index information of the data block in the plurality of data blocks as a partial data block to be displayed.

In another optional embodiment, the partial data block is N data blocks, wherein the apparatus may further include: a receiving unit for receiving a switching instruction input through a screen of the terminal after the read data is displayed on the screen of the terminal; a second obtaining unit, configured to obtain a target data block of the N data blocks indicated by the switching instruction; a fourth reading unit configured to read target data in the target data block that matches the view size; and the second display unit is used for displaying the read target data on a screen of the terminal.

According to the above embodiment of the present invention, the partial data block is N data blocks, wherein the display unit may include: the generating module is used for generating an initial display image of the data of each data block in the N data blocks; the splicing module is used for splicing the generated N initial display images to obtain spliced images; the cutting module is used for cutting the spliced image according to the view size to obtain a display image if the size of the spliced image is larger than the view size; the determining module is used for taking the spliced image as a display image if the size of the spliced image is not larger than the view size; and displaying the display image on a screen of the terminal.

Each module provided in this embodiment is the same as the use method provided in the corresponding step of the method embodiment, and the application scenario may also be the same. Of course, it should be noted that the solution related to the modules may not be limited to the content and the scenario in the above embodiments, and the modules may be executed in a computer terminal or a mobile terminal, and may be implemented by software or hardware.

Example 3

The embodiment of the invention also provides the terminal. Optionally, in this embodiment, the terminal may perform a display method of a data table, and the processing device of the instant messaging message in the embodiment may be disposed on the terminal.

As shown in fig. 6, the terminal includes: one or more processors 201 (only one of which is shown), a memory 203, and a transmission device 205 (such as the transmission device in the above embodiment), as shown in fig. 6, the terminal may further include an input/output device 207.

The memory 203 may be configured to store software programs and modules, such as program instructions/modules corresponding to the method and apparatus for displaying a data table in the embodiment of the present invention, and the processor 201 executes various functional applications and data processing by running the software programs and modules stored in the memory 203, that is, implements the method for displaying a data table. The memory 203 may include high speed random access memory, and may also include non-volatile memory, such as one or more magnetic storage devices, flash memory, or other non-volatile solid-state memory. In some examples, the memory 203 may further include memory located remotely from the processor 201, which may be connected to the terminal over a network. Examples of such networks include, but are not limited to, the internet, intranets, local area networks, mobile communication networks, and combinations thereof.

The transmission device 205 is used for receiving or sending data via a network, and can also be used for data transmission between a processor and a memory. Examples of the network may include a wired network and a wireless network. In one example, the transmission device 205 includes a Network adapter (NIC) that can be connected to a router via a Network cable and other Network devices to communicate with the internet or a local area Network. In one example, the transmission device 205 is a Radio Frequency (RF) module, which is used for communicating with the internet in a wireless manner.

Wherein the memory 203 is specifically used for storing application programs.

The processor 201 may call the application stored in the memory 203 via the transmission means 205 to perform the following steps: acquiring a display instruction for displaying a data table input through a screen of a terminal, wherein the data table is divided into a plurality of data blocks; determining a partial data block to be displayed, which is matched with the view size on the screen of the terminal, in the plurality of data blocks in response to the display instruction; reading data matched with the view size in a part of data blocks to be displayed; the read data is displayed on a screen of the terminal.

Optionally, the specific examples in this embodiment may refer to the examples described in the above embodiments, and this embodiment is not described herein again.

It should be further noted that the register area is a memory of the system and a register in the system processor.

It can be understood by those skilled in the art that the structure shown in fig. 6 is only an illustration, and the terminal may be a terminal device such as a smart phone (e.g., an Android phone, an iOS phone, etc.), a tablet computer, a palm computer, and a Mobile Internet Device (MID), a PAD, etc. Fig. 6 is a diagram illustrating a structure of the electronic device. For example, the terminal may also include more or fewer components (e.g., network interfaces, display devices, etc.) than shown in FIG. 6, or have a different configuration than shown in FIG. 6.

Those skilled in the art will appreciate that all or part of the steps in the methods of the above embodiments may be implemented by a program instructing hardware associated with the terminal device, where the program may be stored in a computer-readable storage medium, and the storage medium may include: flash disks, Read-Only memories (ROMs), Random Access Memories (RAMs), magnetic or optical disks, and the like.

Example 4

The embodiment of the invention also provides a storage medium. Alternatively, in the present embodiment, the storage medium may be used for a program code for executing a display method of a data table.

Optionally, in this embodiment, the storage medium may be located on at least one of a plurality of network devices in a network shown in the above embodiment.

Optionally, in this embodiment, the storage medium is configured to store program code for performing the following steps:

acquiring a display instruction for displaying a data table input through a screen of a terminal, wherein the data table is divided into a plurality of data blocks; determining a partial data block to be displayed, which is matched with the view size on the screen of the terminal, in the plurality of data blocks in response to the display instruction; reading data matched with the view size in a part of data blocks to be displayed; the read data is displayed on a screen of the terminal.

Optionally, in this embodiment, the storage medium may include, but is not limited to: a U-disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a removable hard disk, a magnetic or optical disk, and other various media capable of storing program codes.

The above-mentioned serial numbers of the embodiments of the present invention are merely for description and do not represent the merits of the embodiments.

The integrated unit in the above embodiments, if implemented in the form of a software functional unit and sold or used as a separate product, may be stored in the above computer-readable storage medium. Based on such understanding, the technical solution of the present invention may be embodied in the form of a software product, which is stored in a storage medium and includes several instructions for causing one or more computer devices (which may be personal computers, servers, network devices, etc.) to execute all or part of the steps of the method according to the embodiments of the present invention.

In the above embodiments of the present invention, the descriptions of the respective embodiments have respective emphasis, and for parts that are not described in detail in a certain embodiment, reference may be made to related descriptions of other embodiments.

In the several embodiments provided in the present application, it should be understood that the disclosed client may be implemented in other manners. The above-described embodiments of the apparatus are merely illustrative, and for example, the division of the units is only one type of division of logical functions, and there may be other divisions when actually implemented, for example, a plurality of units or components may be combined or may be integrated into another system, or some features may be omitted, or not executed. In addition, the shown or discussed mutual coupling or direct coupling or communication connection may be an indirect coupling or communication connection through some interfaces, units or modules, and may be in an electrical or other form.

The units described as separate parts may or may not be physically separate, and parts displayed as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the units can be selected according to actual needs to achieve the purpose of the solution of the embodiment.

In addition, functional units in the embodiments of the present invention may be integrated into one processing unit, or each unit may exist alone physically, or two or more units are integrated into one unit. The integrated unit can be realized in a form of hardware, and can also be realized in a form of a software functional unit.

The foregoing is only a preferred embodiment of the present invention, and it should be noted that, for those skilled in the art, various modifications and decorations can be made without departing from the principle of the present invention, and these modifications and decorations should also be regarded as the protection scope of the present invention.

Claims

1. A method for displaying a spreadsheet, comprising:

obtaining a display instruction for displaying a data table, wherein the data table is divided into a plurality of data blocks;

determining a data block which has intersection with an area determined by the view size on the screen of the terminal in response to the display instruction as a partial data block to be displayed;

reading data which is intersected with the area determined by the view size in the partial data block to be displayed;

displaying the read data on a screen of the terminal;

wherein the determining, in response to the display instruction, a data block, which intersects with an area determined by a view size on a screen of the terminal, among the plurality of data blocks as a partial data block to be displayed includes: determining a display starting position indicated by the display instruction in the data table; determining a record item area to be displayed in the data table according to the display starting position and the view size; and taking the data block which is overlapped with the recording item area in the plurality of data blocks as the partial data block to be displayed.

2. The method according to claim 1, wherein the display instruction is a slide instruction, and wherein the determining a display start position indicated by the display instruction in the data table comprises:

acquiring a sliding starting position indicated by the sliding instruction in the data table;

and determining the display starting position according to the sliding starting position and the sliding displacement indicated by the sliding instruction.

3. The method of claim 2, wherein determining the display start position according to the slide start position and the slide displacement amount indicated by the slide instruction comprises:

acquiring a sliding operation starting point coordinate and a sliding operation end point coordinate of the display instruction;

calculating a difference value between the sliding operation end point coordinate and the sliding operation starting point coordinate to obtain the sliding displacement vector, wherein the sliding displacement comprises the sliding displacement vector;

and taking the sum of the coordinate of the sliding initial position and the sliding displacement vector as the coordinate of the display initial position.

4. The method according to any one of claims 1 to 3, wherein before acquiring the display instruction for displaying the data table input through the screen of the terminal, the method further comprises:

reading attribute information of a data table from a data table of a terminal storage space, wherein the attribute information of the data table at least comprises index information of each data block;

caching the attribute information of the data table into a memory of the terminal;

and reading the position of each data block in the data table from the data table by using the cached index information of each data block.

5. The method of claim 4, wherein determining, in response to the display instruction, a data block of the plurality of data blocks that intersects with an area determined by a view size on a screen of the terminal as a partial data block to be displayed comprises:

acquiring index information of the data block indicated by the display instruction;

and taking a data block corresponding to the index information of the data block in the plurality of data blocks as the partial data block to be displayed.

6. The method according to any one of claims 1 to 3, wherein the partial data block is N data blocks, and wherein displaying the read data on the screen of the terminal comprises:

generating an initial display image of data of each of the N data blocks;

splicing the generated N initial display images to obtain spliced images;

if the size of the spliced image is larger than the view size, cutting the spliced image according to the view size to obtain a display image;

if the size of the spliced image is not larger than the view size, taking the spliced image as the display image;

and displaying the display image on a screen of the terminal.

7. The method according to any one of claims 1 to 3, wherein the partial data block is N data blocks, wherein after displaying the read data on a screen of the terminal, the method further comprises:

receiving a switching instruction input through a screen of the terminal;

acquiring a target data block in the N data blocks indicated by the switching instruction;

reading target data matched with the view size in the target data block;

and displaying the read target data on a screen of the terminal.

8. A display device for a data table, comprising:

a first acquisition unit configured to acquire a display instruction for displaying a data table, wherein the data table is divided into a plurality of data blocks;

a response unit, configured to determine, as a partial data block to be displayed, a data block of the plurality of data blocks that intersects with an area determined by a view size on a screen of a terminal, in response to the display instruction;

the first reading unit is used for reading data which is intersected with the area determined by the view size in the partial data block to be displayed;

the first display unit is used for displaying the read data on a screen of the terminal;

wherein the response unit includes: the first determining module is used for determining a display starting position indicated by the display instruction in the data table; the second determining module is used for determining a record item area to be displayed in the data table according to the display starting position and the view size; and a third determining module, configured to use a data block, which overlaps with the entry area, of the plurality of data blocks as the partial data block to be displayed.

9. The apparatus of claim 8, wherein the display instruction is a slide instruction, and wherein the first determining module comprises:

the position acquisition submodule is used for acquiring a sliding starting position indicated by the sliding instruction in the data table;

and the position determining submodule is used for determining the display starting position according to the sliding starting position and the sliding displacement indicated by the sliding instruction.

10. The apparatus of claim 9, wherein the location determination submodule comprises:

the coordinate acquisition submodule is used for acquiring the coordinates of a sliding operation starting point and the coordinates of a sliding operation end point of the display instruction;

the vector calculation submodule is used for calculating a difference value between the sliding operation end point coordinate and the sliding operation starting point coordinate to obtain the sliding displacement vector, wherein the sliding displacement comprises the sliding displacement vector;

and the coordinate determination submodule is used for taking the sum of the coordinate of the sliding initial position and the sliding displacement vector as the coordinate of the display initial position.

11. The apparatus of any one of claims 8 to 10, further comprising:

the caching unit is used for caching the attribute information of the data table into a memory of the terminal;

and a third reading unit, configured to read, from the data table, a position of each data block in the data table by using the cached index information of each data block.

12. The apparatus of claim 11, wherein the response unit comprises:

the information acquisition module is used for acquiring the index information of the data block indicated by the display instruction;

and the data block determining module is used for taking a data block corresponding to the index information of the data block in the plurality of data blocks as the partial data block to be displayed.

13. The apparatus according to any one of claims 8 to 10, wherein the partial data block is N data blocks, and wherein the display unit includes:

a generating module for generating an initial display image of data of each of the N data blocks;

the splicing module is used for splicing the generated N initial display images to obtain spliced images;

the cutting module is used for cutting the spliced image according to the view size to obtain a display image if the size of the spliced image is larger than the view size;

a determining module, configured to take the stitched image as the display image if the size of the stitched image is not larger than the view size;

and displaying the display image on a screen of the terminal.

14. The apparatus according to any one of claims 8 to 10, wherein the partial data block is N data blocks, and wherein the apparatus further comprises:

a receiving unit, configured to receive a switching instruction input through a screen of the terminal after the read data is displayed on the screen of the terminal;

a second obtaining unit, configured to obtain a target data block in the N data blocks indicated by the switching instruction;

a fourth reading unit, configured to read target data in the target data block that matches the view size;

and the second display unit is used for displaying the read target data on a screen of the terminal.

15. A storage medium storing a computer program, characterized in that the computer program executes the method of any of claims 1 to 7 when running.

16. A terminal comprising a memory and a processor, characterized in that the memory has stored therein a computer program, the processor being arranged to execute the method of any of claims 1 to 7 by means of the computer program.