CN115639935A

CN115639935A - Table operation method and device and readable storage medium

Info

Publication number: CN115639935A
Application number: CN202211598105.2A
Authority: CN
Inventors: 梁慧军; 梁韩旭; 韩斌
Original assignee: Elane Inc
Current assignee: Elane Inc
Priority date: 2022-12-14
Filing date: 2022-12-14
Publication date: 2023-01-24
Anticipated expiration: 2042-12-14
Also published as: CN115639935B

Abstract

The invention provides a form operation method, a form operation device and a readable storage medium, and belongs to the technical field of webpage front-end interaction. The table operation method comprises the following steps: under the condition that the table data are displayed on the webpage display interface, first coordinate information of the table data in the webpage display interface is acquired, and the first coordinate information is associated with pixel information of the table data; responding to a first input to the webpage display interface, and acquiring second coordinate information of the first input in the webpage display interface; under the condition that the second coordinate information is matched with the first coordinate information, adding a target mark to target data in the form data according to the second coordinate information; and executing target operation on the target data according to the target mark, wherein the target operation comprises a selection operation and/or a deselection operation.

Description

Table operation method and device and readable storage medium

Technical Field

The invention belongs to the technical field of webpage front-end interaction, and particularly relates to a form operation method, a form operation device and a readable storage medium.

Background

Business systems developed on the basis of a web (global wide area network) front end often use data tables to display business data, and there are a large number of interactive operations performed on the data tables by users.

In the related art, when a user performs an operation on a data table, a mouse event is added to the data table, and the data table is framed and selected based on whether a corresponding mouse event exists in the data table. In the case that a user selects data in a data table in a large range, a large number of mouse events need to be added to the data table, resulting in a problem of event loss.

Disclosure of Invention

The present invention is directed to solving one of the technical problems of the prior art or the related art.

To this end, a first aspect of the invention proposes a table manipulation method.

A second aspect of the present invention proposes a form manipulation apparatus.

A third aspect of the present invention provides a table operating apparatus.

A fourth aspect of the invention proposes a readable storage medium.

In view of the above, a method for operating a table according to a first aspect of the present invention includes: under the condition that the table data are displayed on the webpage display interface, first coordinate information of the table data in the webpage display interface is acquired, and the first coordinate information is associated with pixel information of the table data; responding to a first input to the webpage display interface, and acquiring second coordinate information of the first input in the webpage display interface; under the condition that the second coordinate information is matched with the first coordinate information, adding a target mark to target data in the table data according to the second coordinate information; and executing target operation on the target data according to the target mark, wherein the target operation comprises a selection operation and/or a deselection operation.

The form operation method provided by the invention is applied to the electronic equipment, and when the electronic equipment accesses the web data, the electronic equipment displays corresponding contents on a webpage display interface at the front end.

In the technical scheme, the first coordinate information is coordinate information of table data in a webpage display interface. When the table data is displayed in the webpage display interface, the electronic equipment can determine first coordinate information of the table data in the webpage display interface. The first coordinate information is coordinate information of the content corresponding to the table data in the whole webpage display interface. The table data is displayed in the webpage display interface in a target table form, and the first coordinate information can be determined according to the positions of pixel points of the target table.

In the technical scheme, the second coordinate information is coordinate information of the first input executed by the user on the webpage display interface. The second coordinate information can be obtained according to the start point location and the end point location of the first input. The first input is used for controlling the electronic device to select the form data in the webpage display interface, and the first input can be a first operation.

It should be noted that, the first input includes, but is not limited to: the user may specifically determine the touch input to the electronic device through a touch device such as a finger or a stylus pen according to the actual use requirement, which is not specifically limited in this embodiment.

In the technical scheme, the electronic device needs to judge whether the second coordinate information is matched with the first coordinate information or not when receiving the first input, and whether the first input executed by the user is the input executed for the form data or not can be determined according to whether the second coordinate information is matched with the first coordinate information or not. Upon detecting that the second coordinate information matches the first coordinate information, it is determined that the first input performed by the user is an input performed on the form data. Upon detecting that the second coordinate information does not match the first coordinate information, it is determined that the first input performed by the user is not an input performed on the form data. Whether the second coordinate information is matched with the first coordinate information or not is detected, whether the first input executed by the user is the input executed on the form data or not can be accurately judged, and the user is prevented from touching mistakenly.

In the technical scheme, the target mark is a mark added to the target data in the form data by the electronic device in response to the first input, so that the user can select the target data in the form data by executing the first input.

In the technical scheme, after the target mark is added to the target data through the electronic equipment, the electronic equipment can execute corresponding target operation on the target data added with the target mark, and the target operation comprises but is not limited to a selection operation and a deselection operation.

Specifically, when the target data is not added with the target mark by the first input and is in the unselected state, the electronic device can perform the selection operation on the target data in response to the first input. When the target data is not added with the target mark by the first input and is already in the selection state, the electronic equipment can execute deselection operation on the target data in response to the first input.

In addition, in the selected state of the target data, the target data is copied in response to a copy input by a user, or the target data is deleted in response to a deletion input by the user, or the target data is edited in response to an editing input by the user.

According to the technical scheme, the electronic equipment detects the first coordinate information of the form data in the webpage display interface and the second coordinate information of the first input in the webpage display interface, the input position of the first input and the position of the form data are achieved, the target data framed and selected by the first input are calculated, the electronic equipment does not need to add a large number of mouse events to the form in the process of framing and selecting the form by a user, the target data selected by the first input can be accurately identified only according to the form data and the corresponding coordinate information of the first input, the problem that events caused by the input speed and the input range of the first input are lost is effectively solved, and the effectiveness and the accuracy of target data selection are improved.

In addition, according to the table operation method in the above technical solution provided by the present invention, the following additional technical features may also be provided:

in the above technical solution, obtaining first coordinate information of the form data in the web page display interface includes: identifying first pixel information of a first display area and second pixel information of a second display area in a webpage display interface, wherein the first display area comprises table data, and the second display area is a background area of the table data; first coordinate information of the table data is determined based on the first pixel information and the second pixel information.

According to the technical scheme, the first coordinate information of the tabular data can be obtained according to the first pixel information of the first display area where the tabular data is located and the second pixel information of the second display area where the non-tabular data is located in the webpage display interface, and the first coordinate information corresponding to the tabular data can be accurately identified according to the pixel information in the webpage display interface.

In the technical scheme, the first display area is a display area where table data are located in the webpage display interface, and the second display area is a display area where non-table data are located in the webpage display interface. From the first pixel information and the second pixel information, a pixel range of the table data can be determined, thereby determining first coordinate information of the table data.

It should be noted that the first coordinate information corresponding to the table data includes a plurality of pieces of sub-coordinate information, and each piece of sub-coordinate information corresponds to one data row in the table data. Specifically, the table data includes a plurality of rows of tables, each row of tables is written as a data row, and the row height of each data row is a fixed row height. The electronic equipment can obtain the sub-coordinate information corresponding to each data line in the table data and the first coordinate information corresponding to the whole table data through the pixel identification data.

According to the technical scheme, when the electronic equipment displays the webpage display interface comprising the tabular data, the pixel identification can be carried out on the webpage display interface, so that first pixel information corresponding to the tabular data and second pixel information corresponding to the non-tabular data are obtained, the first coordinate information of the tabular data is determined based on the first pixel information and the second pixel information, and the identification accuracy of the first coordinate information is improved.

In any of the above technical solutions, the first input includes a first sub-input and a second sub-input, where the first sub-input is used to indicate a start point location of the first input, and the second sub-input is used to indicate an end point location of the first input; acquiring second coordinate information of the first input in a webpage display interface, wherein the second coordinate information comprises: acquiring a first coordinate point of a first sub input in a webpage display interface, a second coordinate point of a second sub input in the webpage display interface and an input track between the first sub input and the second sub input; and determining second coordinate information according to the first coordinate point, the second coordinate point and the input track.

In the technical scheme, the second coordinate information corresponding to the first input executed by the user can be determined by detecting the starting point position, the ending point position and the input track of the first input executed by the user.

In the technical scheme, the first input executed by the user on the webpage display interface comprises a first sub-input and a second sub-input, and the first sub-input and the second sub-input are respectively the triggering starting corresponding input of the first input and the triggering ending corresponding input. The first coordinate point is a coordinate point of a first sub-input in the webpage display interface, the second coordinate point is a coordinate point of a second sub-input in the webpage display interface, and the input track is an input track between the first sub-input and the second sub-input, namely the input track of the first input.

In the technical scheme, the electronic equipment can determine the second coordinate information of the first input in the webpage display interface through the first coordinate point, the second coordinate point and the input track.

According to the technical scheme, under the condition that the electronic equipment receives the first input, the electronic equipment can determine the second coordinate information corresponding to the first input through the first coordinate point corresponding to the first sub-input, the second coordinate point corresponding to the second sub-input and the input track of the first input, the accuracy of the second coordinate information is guaranteed, and the accuracy of judging whether the user executes operation input judgment on form data according to the first coordinate information and the second coordinate information is improved.

In any of the above technical solutions, adding a target mark to target data in the table data according to the second coordinate information includes: acquiring a document object model corresponding to the form data; determining a target model element in the document object model through the first coordinate point and the second coordinate point under the condition that the input track meets a preset condition; adding a target mark to the target model element.

In the technical scheme, after the electronic device acquires the second coordinate information corresponding to the first input, the electronic device can determine a target model element (Dom element) where the position of the first input is located by corresponding a document object model (Dom) with form data. The target model element is the target data in the table data, and a target mark is added to the target data.

In this technical solution, before selecting a target model element through a first coordinate point and a second coordinate point, it is necessary to determine whether a user performs a frame selection operation on form data through an input trajectory. And under the condition that the input track is detected to meet the preset condition, determining that the user performs the frame selection operation on the form data, and under the condition that the input track is detected not to meet the preset condition, determining that the user does not perform the frame selection operation on the form data. The preset condition may be that the input trajectory matches a trajectory shape of the preset trajectory, and the preset condition may also be that the input trajectory matches a trajectory moving direction of the preset trajectory.

According to the technical scheme, the electronic equipment screens target model elements according to a first coordinate point and a second coordinate point through a document object model. Specifically, the electronic device can determine a starting data row framed in the table data according to a first coordinate point of the first sub-input, can determine an ending data row framed in the table data according to a second coordinate point of the second sub-input, and determine all data between the starting data row and the ending data row as target data, i.e., the starting data row, the ending data row, and data rows therebetween as target model elements.

According to the technical scheme, the electronic equipment can judge whether the user performs framing operation on the form data or not through the input track in the second coordinate information, and when the input track is detected to meet the preset condition, the user is determined to perform corresponding framing operation on the form data. And selecting a target model element according to the first coordinate point and the second coordinate point in the second coordinate information, and then adding a corresponding target mark to the target model element, so that the effect that the electronic equipment can screen target data in the form data through the second coordinate information corresponding to the first input of the user is achieved, and after all the target data are obtained through screening, the corresponding target mark is added to the target data.

In any of the above technical solutions, determining a target model element in the document object model by using the first coordinate point and the second coordinate point includes: determining a first model element corresponding to the first coordinate point and determining a second model element corresponding to the second coordinate point; and determining the first model element, the second model element and the model element between the first model element and the second model element as the target model element.

In the technical scheme, the corresponding first model element and the second model element can be respectively found through the first coordinate point and the second coordinate point, namely, the initial data line and the final data line framed and selected in the table data are determined. The initial data line, the final data line and the data line between the initial data line and the final data line are used as target model elements to be marked, so that the effect of accurately screening the target data in the table data through the first coordinate point and the second coordinate point is achieved.

In this solution, the first model element corresponds to the first coordinate point, and the second model element corresponds to the second coordinate point. Specifically, a first model element can be determined from a first coordinate point in the second coordinate information, the first model element corresponding to a starting data row framed in the table data, and a second model element can be determined from a second coordinate point in the second coordinate information, the second model element corresponding to an ending data row framed in the table data. Since the first input is used to perform range selection on the target data in the form data, all model elements between the first model element and the second model element are taken as target model elements.

According to the technical scheme, the electronic equipment can acquire the first model element corresponding to the first coordinate point and the second model element corresponding to the second coordinate point through recording the obtained first coordinate point and the second coordinate point, all target model elements are selected by taking the two model elements as the constraint range, the effect of accurately screening the target data in the form data is achieved, and the accuracy and the effectiveness of the target data selected through the first input frame are guaranteed.

In any of the above technical solutions, determining a target model element in the document object model by using the first coordinate point and the second coordinate point includes: determining third coordinate information corresponding to each model element through the document object model; screening target coordinate information in the third coordinate information based on the first coordinate point and the second coordinate point; and determining the model element corresponding to the target coordinate information as a target model element.

In the technical scheme, third coordinate information corresponding to each model element can be obtained through the document object model, and the third coordinate information corresponds to the model elements one to one. According to a first coordinate point corresponding to the first sub-input and a second coordinate point corresponding to the second sub-input, traversing and judging a plurality of pieces of third coordinate information, so as to judge the third coordinate information corresponding to the first coordinate point and the second coordinate point, thereby obtaining target coordinate information, wherein the target coordinate information comprises two pieces of third coordinate information corresponding to the first coordinate point and the second coordinate point, and all pieces of third coordinate information between the two pieces of third coordinate information corresponding to the first coordinate point and the second coordinate point. And taking all model elements corresponding to the target coordinate information as target model elements.

According to the technical scheme, the third coordinate information corresponding to each model element can be obtained through the document object model, all target coordinate information corresponding to the first coordinate point and the second coordinate point can be found through a traversing judgment mode, the model element of the target coordinate information epitome is used as the target model element, the position relation of each model element in the first input and table data is achieved, the target data in the table data is determined, and the accuracy of selecting the target data in the table data is further improved.

In any of the above technical solutions, in a case that the second coordinate information matches the first coordinate information, before adding the target mark to the target data in the table data according to the second coordinate information, the method further includes: and determining that the second coordinate information is matched with the first coordinate information under the condition that the second coordinate information is located in the range of the first coordinate information.

In the technical scheme, according to the first coordinate information and the second coordinate information, a range corresponding to the first coordinate information and a range corresponding to the second coordinate information can be determined. The range corresponding to the first coordinate information is a first coordinate range of the table data in the webpage display interface, and the second coordinate information is a second coordinate range of the first input in the webpage display interface.

Specifically, upon detecting that the second coordinate range is within the first coordinate range, it is determined that the first inputs performed by the user are all within the display range of the form data, i.e., target data in the form data is selected by the first inputs. When it is detected that at least part of the second coordinate range is within the first coordinate range, that is, the first coordinate range does not include the second coordinate range, it is determined that the first input performed by the user is at least partially outside the display range of the form data, and it is determined that the first input is not an input for framing the form data.

According to the technical scheme, the electronic equipment can judge whether the first input executed by the user is the framing input executed by the form data or not according to the first coordinate information and the second coordinate information, so that the error identification of the framing target data by the electronic equipment is avoided, and the accuracy of the framing target data is further improved.

According to a second aspect of the present invention, there is provided a table manipulation apparatus comprising:

the acquisition module is used for acquiring first coordinate information of the table data in the webpage display interface under the condition that the table data is displayed on the webpage display interface, wherein the first coordinate information is associated with pixel information of the table data;

the acquisition module is used for responding to a first input to the webpage display interface and acquiring second coordinate information of the first input in the webpage display interface;

the marking module is used for adding a target mark to target data in the table data according to the second coordinate information under the condition that the second coordinate information is matched with the first coordinate information;

and the processing module is used for executing target operation on the target data according to the target mark, wherein the target operation comprises selection operation and/or deselection operation.

According to a third aspect of the present invention, there is provided a table operating apparatus comprising: a memory having a program or instructions stored therein; the processor, which executes the program or the instruction stored in the memory to implement the steps of the table operation method in any one of the first aspect, has all the beneficial technical effects of the table operation method in any one of the first aspect, and will not be described in detail herein.

According to a fourth aspect of the present invention, a readable storage medium is provided, on which a program or instructions are stored, which when executed by a processor implement the steps of the table manipulation method according to any one of the above-mentioned first aspect. Therefore, the table operation method in any of the above technical solutions of the first aspect has all the beneficial technical effects, and will not be described in detail herein.

Additional aspects and advantages of the invention will be set forth in part in the description which follows, and in part will be obvious from the description, or may be learned by practice of the invention.

Drawings

The above and/or additional aspects and advantages of the present invention will become apparent and readily appreciated from the following description of the embodiments, taken in conjunction with the accompanying drawings of which:

FIG. 1 illustrates one of the schematic flow diagrams of a table manipulation method provided in some embodiments of the present invention;

FIG. 2 illustrates a second schematic flow chart diagram of a method of table manipulation provided in some embodiments of the present invention;

FIG. 3 illustrates a third schematic flow chart of a method of table manipulation provided in some embodiments of the present invention;

FIG. 4 illustrates a fourth schematic flow chart of a table manipulation method provided in some embodiments of the present invention;

FIG. 5 illustrates a fifth schematic flow chart of a table manipulation method provided in some embodiments of the present invention;

FIG. 6 illustrates a sixth schematic flow chart of a table manipulation method provided in some embodiments of the present invention;

FIG. 7 illustrates a seventh schematic flow chart of a table manipulation method provided in some embodiments of the present invention;

FIG. 8 illustrates an eighth schematic flow chart of a table manipulation method provided in some embodiments of the present invention;

FIG. 9 illustrates a ninth schematic flow chart of a method of table manipulation provided in some embodiments of the present invention;

FIG. 10 illustrates one of the block diagrams of the structure of a table manipulation apparatus provided in some embodiments of the present invention;

fig. 11 shows a second block diagram of the structure of the table manipulation apparatus provided in some embodiments of the present invention.

Detailed Description

In order that the above objects, features and advantages of the present invention can be more clearly understood, a more particular description of the invention will be rendered by reference to the appended drawings. It should be noted that the embodiments of the present invention and features of the embodiments may be combined with each other without conflict.

In the following description, numerous specific details are set forth in order to provide a thorough understanding of the present invention, however, the present invention may be practiced in other ways than those specifically described herein, and therefore the scope of the present invention is not limited by the specific embodiments disclosed below.

Table operation methods, apparatuses, and readable storage media according to some embodiments of the present invention are described below with reference to fig. 1 to 11.

According to an embodiment of the present invention, as shown in fig. 1, there is provided a table operation method including:

102, acquiring first coordinate information of table data in a webpage display interface under the condition that the table data is displayed on the webpage display interface;

wherein the first coordinate information is associated with pixel information of the table data;

104, responding to a first input to the webpage display interface, and acquiring second coordinate information of the first input in the webpage display interface;

106, under the condition that the second coordinate information is matched with the first coordinate information, adding a target mark to target data in the form data according to the second coordinate information;

and step 108, executing target operation on the target data according to the target mark.

Wherein the target operation comprises a selection operation and/or a deselection operation.

The form operation method provided by the embodiment is applied to the electronic equipment, and when the electronic equipment accesses the web data, the electronic equipment displays corresponding content on a webpage display interface at the front end.

In this embodiment, the first coordinate information is coordinate information of the table data in the web page display interface. When the table data is displayed in the webpage display interface, the electronic equipment can determine first coordinate information of the table data in the webpage display interface. The first coordinate information is coordinate information of the content corresponding to the table data in the whole webpage display interface. The table data is displayed in the webpage display interface in a target table form, and the first coordinate information can be determined according to the positions of pixel points of the target table.

The electronic equipment can perform image recognition on the webpage display interface so as to obtain all pixel information in the webpage display interface, wherein the pixel information comprises the pixel information of the webpage data displayed on the webpage display interface and the pixel information of the background area of the webpage display interface, and the first coordinate information of the table data in the webpage display interface can be obtained by performing calculation processing on the pixel information.

In this embodiment, the second coordinate information is coordinate information of the first input performed by the user on the web page display interface. The second coordinate information can be determined according to the start point location and the end point location of the first input. The first input is used for controlling the electronic device to select the form data in the webpage display interface, and the first input can be a first operation.

It should be noted that the first input includes, but is not limited to: the user may specifically determine the touch input to the electronic device through a touch device such as a finger or a stylus pen according to the actual use requirement, which is not specifically limited in this embodiment.

Illustratively, when the first input is an operation input of a user to a webpage display interface through a mouse, the electronic device listens for a mouse event, wherein the mouse event comprises: a mouse left button down event (mouse down), a mouse left button up event (mouse up), and a mouse move event (mouse move). The electronic equipment can determine the first input second coordinate information according to the coordinate point corresponding to the mouse event.

In this embodiment, in the case where the electronic device receives the first input, it needs to determine whether the second coordinate information matches the first coordinate information, and it can be determined whether the first input performed by the user is an input performed on the form data by determining whether the second coordinate information matches the first coordinate information. Upon detecting that the second coordinate information matches the first coordinate information, it is determined that the first input performed by the user is an input performed on the form data. Upon detecting that the second coordinate information does not match the first coordinate information, it is determined that the first input performed by the user is not an input performed on the form data. Whether the second coordinate information is matched with the first coordinate information or not is detected, whether the first input executed by the user is the input executed on the form data or not can be accurately judged, and the user is prevented from touching mistakenly.

In this embodiment, the target mark is a mark added to the target data in the form data by the electronic device in response to the first input, so that the user can select the target data in the form data by executing the first input.

Exemplarily, the target mark is in a visible state, and after the electronic device marks the target data through the target mark, a display screen of the electronic device covers the target data in a display area corresponding to the target data with a colored selection frame or a semi-transparent selection frame, so that the user can know the target data selected by the first input in time.

In this embodiment, after the target mark is added to the target data by the electronic device, the electronic device can perform a corresponding target operation on the target data added with the target mark, and the target operation includes, but is not limited to, a select operation and a deselect operation.

In the embodiment of the application, the electronic equipment detects the first coordinate information of the form data in the webpage display interface and the second coordinate information of the first input in the webpage display interface, so that the input position of the first input and the position of the form data are calculated, the target data framed and selected by the first input are calculated, the electronic equipment does not need to add a large number of mouse events to the form in the process of framing and selecting the form by a user, the target data selected by the first input can be accurately identified only according to the form data and the corresponding coordinate information of the first input, the problem of event loss caused by the input speed and the input range of the first input is effectively solved, and the effectiveness and the accuracy of target data selection are improved.

As shown in fig. 2, in the above embodiment, acquiring first coordinate information of the form data in the web page display interface includes:

step 202, identifying first pixel information of a first display area and second pixel information of a second display area in a webpage display interface;

the first display area comprises table data, and the second display area is a background area of the table data;

step 204, determining first coordinate information of the table data according to the first pixel information and the second pixel information.

In the embodiment, the first coordinate information of the tabular data can be obtained according to the first pixel information of the first display area where the tabular data is located and the second pixel information of the second display area where the non-tabular data is located in the webpage display interface, so that the first coordinate information corresponding to the tabular data can be accurately identified according to the pixel information in the webpage display interface.

In this embodiment, the first display area is a display area where tabular data is located in the web page display interface, and the second display area is a display area where non-tabular data is located in the web page display interface. From the first pixel information and the second pixel information, a pixel range of the table data can be determined, thereby determining first coordinate information of the table data.

In the embodiment of the application, when the electronic device displays the webpage display interface comprising the tabular data, the electronic device can perform pixel identification on the webpage display interface, so that first pixel information corresponding to the tabular data and second pixel information corresponding to the non-tabular data are obtained, the first coordinate information of the tabular data is determined based on the first pixel information and the second pixel information, and the identification accuracy of the first coordinate information is improved.

In any of the above embodiments, as shown in fig. 3, the first input includes a first sub-input and a second sub-input, wherein the first sub-input is used for indicating a start point location of the first input, and the second sub-input is used for indicating an end point location of the first input;

acquiring second coordinate information of the first input in a webpage display interface, wherein the second coordinate information comprises:

step 302, acquiring a first coordinate point of a first sub input in a webpage display interface, a second coordinate point of a second sub input in the webpage display interface, and an input track between the first sub input and the second sub input;

and step 304, determining second coordinate information according to the first coordinate point, the second coordinate point and the input track.

In this embodiment, by detecting the start point location, the end point location, and the input trajectory of the first input performed by the user, the second coordinate information corresponding to the first input performed by the user can be determined.

In this embodiment, the first input performed by the user on the web page display interface includes a first sub-input and a second sub-input, and the first sub-input and the second sub-input are respectively a trigger start corresponding input of the first input and a trigger end corresponding input. The first coordinate point is a coordinate point of a first sub-input in the webpage display interface, the second coordinate point is a coordinate point of a second sub-input in the webpage display interface, and the input track is an input track between the first sub-input and the second sub-input, namely the input track of the first input.

Illustratively, the first input is input performed by a user on the web page display interface through a mouse, the first sub-input is input corresponding to mouse pressing, and the second sub-input is input corresponding to mouse lifting. When the user presses the left button of the mouse in the process of selecting the form data through the mouse, the electronic equipment records the coordinate point clicked by the user through the left button of the mouse and records the coordinate point as a first coordinate point. And the user keeps the pressing state of the left mouse button and drags the mouse until the user lifts the left mouse button, at the moment, the electronic equipment records the dragging track of the mouse dragged by the user as an input track, records the coordinate point corresponding to the left mouse button lifted by the user as a second coordinate point.

In this embodiment, through the first coordinate point, the second coordinate point and the input trajectory, the electronic device can determine the second coordinate information of the first input in the web page display interface.

Illustratively, according to the first coordinate point, the second coordinate point and the input track, a rectangular selection frame can be generated in the webpage display interface, and the coordinate information corresponding to the rectangular selection frame is recorded as the second coordinate information. The first coordinate point and the second coordinate point are located at the top point of the rectangular selection frame, and the first coordinate point and the second coordinate point are located on the diagonal line of the rectangular selection frame, so that the track point in the input track is located in the rectangular selection frame.

In the embodiment of the application, under the condition that the electronic device receives the first input, the electronic device can determine the second coordinate information corresponding to the first input through the first coordinate point corresponding to the first sub-input, the second coordinate point corresponding to the second sub-input and the input track of the first input, so that the accuracy of the second coordinate information is ensured, and the accuracy of judging whether the user executes operation input judgment on form data according to the first coordinate information and the second coordinate information is improved.

As shown in fig. 4, in any of the above embodiments, adding a target mark to target data in the table data according to the second coordinate information includes:

step 402, obtaining a document object model corresponding to the form data;

step 404, determining a target model element in the document object model through the first coordinate point and the second coordinate point under the condition that the input track meets a preset condition;

at step 406, a target tag is added to the target model element.

In this embodiment, after acquiring the second coordinate information corresponding to the first input, the electronic device can determine a target model element (Dom element) where the position of the first input is located by using the form data to correspond to a document object model (Dom). The target model element is the target data in the table data, and a target mark is added to the target data.

Illustratively, the target model element may be a certain data row of the table data, i.e., a certain row of data in the table data. In the storage process of the table data, the line number of each data line is recorded, and after the data line corresponding to the target model element is determined, the electronic equipment can record the line number of the data line and add a target mark to the data line.

In this embodiment, before selecting a target model element by the first coordinate point and the second coordinate point, it is necessary to determine whether the user performs a box selection operation on the form data by inputting a trajectory. And under the condition that the input track is detected to meet the preset condition, determining that the user performs the framing operation on the form data, and under the condition that the input track is detected not to meet the preset condition, determining that the user does not perform the framing operation on the form data. The preset condition may be that the input trajectory matches a trajectory shape of the preset trajectory, and the preset condition may also be that the input trajectory matches a trajectory moving direction of the preset trajectory.

Illustratively, when the input track is detected to be matched with the track shape of the preset track, the user is determined to perform the frame selection operation on the form data.

Illustratively, when the input track is detected to be matched with the track moving direction of the preset track, determining that the user performs the frame selection operation on the form data.

In this embodiment, the electronic device filters the target model element according to the first coordinate point and the second coordinate point through the document object model. Specifically, the electronic device can determine a starting data row framed in the table data according to a first coordinate point of the first sub-input, can determine an ending data row framed in the table data according to a second coordinate point of the second sub-input, and determine all data between the starting data row and the ending data row as target data, i.e., the starting data row, the ending data row, and data rows therebetween as target model elements.

In the embodiment of the application, the electronic device can judge whether the user performs the framing operation on the form data through the input track in the second coordinate information, and when the input track is detected to meet the preset condition, the electronic device determines that the user performs the corresponding framing operation on the form data. And selecting a target model element according to the first coordinate point and the second coordinate point in the second coordinate information, and then adding a corresponding target mark to the target model element, so that the effect that the electronic equipment can screen target data in the form data through the second coordinate information corresponding to the first input of the user is achieved, and after all the target data are obtained through screening, the corresponding target mark is added to the target data.

As shown in fig. 5, in any of the above embodiments, determining the target model element in the document object model by the first coordinate point and the second coordinate point includes:

step 502, determining a first model element corresponding to the first coordinate point and determining a second model element corresponding to the second coordinate point;

step 504, the first model element, the second model element, and the model element between the first model element and the second model element are determined as the target model element.

In this embodiment, the first coordinate point and the second coordinate point can respectively find the corresponding first model element and second model element, i.e. determine the starting data line and the ending data line framed in the table data. The initial data line, the final data line and the data line between the initial data line and the final data line are used as target model elements to be marked, so that the effect of accurately screening the target data in the table data through the first coordinate point and the second coordinate point is achieved.

In this embodiment, the first model element corresponds to the first coordinate point and the second model element corresponds to the second coordinate point. Specifically, a first model element can be determined from a first coordinate point in the second coordinate information, the first model element corresponding to a starting data row framed in the table data, and a second model element can be determined from a second coordinate point in the second coordinate information, the second model element corresponding to an ending data row framed in the table data. Since the first input is used to perform range selection on the target data in the form data, all model elements between the first model element and the second model element are taken as target model elements.

For example, when the mouse is pressed down or lifted up, the corresponding Dom element (i.e., data row) where the position of the mouse is located may be acquired from the corresponding Web front end Dom, and a data identifier (a row number or other unique identifier) may be acquired, that is, the corresponding data row may be determined by the first coordinate point and the second coordinate point, and all data rows between the two data rows are determined as the target data row, and a target mark is added to the target data row.

In the embodiment of the application, the electronic device can acquire the first model element corresponding to the first coordinate point and the second model element corresponding to the second coordinate point by recording the obtained first coordinate point and the second coordinate point, and selects all target model elements by taking the two model elements as the constraint range, so that the effect of accurately screening the target data in the form data is realized, and the accuracy and the effectiveness of the target data selected through the first input frame are ensured.

As shown in fig. 6, in any of the above embodiments, determining the target model element in the document object model by the first coordinate point and the second coordinate point includes:

step 602, determining third coordinate information corresponding to each model element through a document object model;

step 604, screening target coordinate information in the plurality of pieces of third coordinate information based on the first coordinate point and the second coordinate point;

step 606, determining the model element corresponding to the target coordinate information as a target model element.

In this embodiment, the third coordinate information corresponding to each model element can be obtained through the document object model, and the third coordinate information corresponds to the model elements one to one. According to a first coordinate point corresponding to the first sub-input and a second coordinate point corresponding to the second sub-input, traversing and judging a plurality of pieces of third coordinate information, so as to judge the third coordinate information corresponding to the first coordinate point and the second coordinate point, thereby obtaining target coordinate information, wherein the target coordinate information comprises two pieces of third coordinate information corresponding to the first coordinate point and the second coordinate point, and all pieces of third coordinate information between the two pieces of third coordinate information corresponding to the first coordinate point and the second coordinate point. And taking all model elements corresponding to the target coordinate information as target model elements.

For example, when the mouse is pressed down or lifted up, the pixel positions of the mouse, namely the first coordinate point and the second coordinate point, can be obtained. The pixel range where each data row in the table data is located can also be obtained by Dom, that is, the third coordinate information corresponding to each model element. And judging whether the pixel position of the mouse is in the position range of a certain data row by traversing, and taking the first coordinate point and the second coordinate point corresponding to the two data rows and all the data rows between the two data rows as target model elements.

It should be noted that the model element may be a data row in the table data.

Illustratively, the coordinates of the first coordinate point are (x 1, y 1), y2 is the ordinate of the top of the first data line, and y3 is the ordinate of the bottom of the first data line. And under the condition that y1 is larger than or equal to y2 and y1 is smaller than or equal to y3, determining the data row corresponding to the first sub-input as a first data row.

Illustratively, each data line is correspondingly provided with a corresponding line number, the line number can be read out through Dom, after the data line is detected, the line number of the data line is obtained, and the data line is found according to the line number.

Illustratively, the data rows are not provided with corresponding row numbers, and the row heights of the data rows are fixed. The electronic device can calculate the line number n of the data line corresponding to the mouse position y4 at the coordinate points of the line height h, the mouse position y4, the table position y5, and the title line y 6. The specific calculation formula is as follows:

n＝（y4-y5-y6）/h；

the mouse position y4 is the ordinate of the first coordinate point or the ordinate of the second coordinate point, the table position y5 is the ordinate of the bottom of the table data, and the heading line y6 is the ordinate of the top of the table data.

In the embodiment of the application, the third coordinate information corresponding to each model element can be acquired through the document object model, all target coordinate information corresponding to the first coordinate point and the second coordinate point can be found through a traversal judgment mode, the model element of the target coordinate information epitome is used as the target model element, the position relation of each model element in the first input and the table data is realized, the target data in the table data is determined, and the accuracy of selecting the target data in the table data is further improved.

In any of the above embodiments, in a case where the second coordinate information matches the first coordinate information, before adding the target mark to the target data in the table data according to the second coordinate information, the method further includes: and determining that the second coordinate information is matched with the first coordinate information under the condition that the second coordinate information is located in the range of the first coordinate information.

In this embodiment, according to the first coordinate information and the second coordinate information, a range corresponding to the first coordinate information and a range corresponding to the second coordinate information can be determined. The range corresponding to the first coordinate information is a first coordinate range of the table data in the webpage display interface, and the second coordinate information is a second coordinate range of the first input in the webpage display interface.

In the embodiment of the application, the electronic device can judge whether the first input executed by the user is the framing input executed by the form data according to the first coordinate information and the second coordinate information, so that the error identification of the framing target data by the electronic device is avoided, and the accuracy of the framing target data is further improved.

As shown in fig. 7, in any of the above embodiments, the first input is a frame selection input in which the user selects target data in the form data by mouse dragging. The table operation method comprises the following steps:

step 702, initializing table data;

step 704, pressing down the event (mouse down) by the left mouse button;

at step 706, a mouse left button up event (mouse up).

In the embodiment, the table data is displayed on a webpage display interface, the table data is initialized, and mouse events including a mouse left button pressing event, a mouse left button lifting event and a mouse position are synchronously monitored. In the process of initializing the form data, the electronic equipment acquires first coordinate information of the form data. The electronic equipment monitors the pressing event of the left mouse button and the lifting event of the left mouse button to respectively execute different processing procedures.

As shown in fig. 8, the left mouse button pressing event includes:

step 802, emptying the global flag;

step 804, judging whether the mouse position is in the table data range, if so, executing step 806, and if not, ending;

step 806, set global flag: mouse down, mouse down position.

In this embodiment, when the left mouse button is pressed, the global flag is initialized for the web page display interface, that is, the event flag in the current web page display interface is cleared. When the current mouse position (the first coordinate point) is detected to be in the table data range (the first coordinate information range), determining that the input is probably the frame selection input executed by the user on the table data, recording the first coordinate point pressed by the mouse at this time, ending the event of pressing the left mouse button, and entering the event of lifting the left mouse button. And when the current mouse position is detected to be out of the table data range, determining that the input is not the frame selection input executed by the user on the table data, and ending the mouse frame selection operation process.

As shown in fig. 9, the left mouse button up event includes:

step 902, judging whether the mouse position is in the table data range, if so, executing step 904, otherwise, ending;

step 904, set global flag: mouse up, mouse up position.

Step 906, judging whether the mouse is dragged and selected, if so, executing step 908, and if not, ending;

step 908, calculating data rows in the framing range according to the row height, the mouse pressing starting position and the mouse pressing ending position, and returning row identifiers;

in step 910, target operations (e.g., select operation, deselect operation) are performed.

In this embodiment, when it is detected that the current mouse position (the second coordinate point) is within the table data range (the first coordinate information range), it is determined that the input may be a frame selection input performed by the user on the table data, the second coordinate point pressed by the mouse this time is recorded, and a step of determining whether the input is a mouse dragging selection is performed, in this step, the electronic device can determine whether the input is a mouse dragging selection according to a dragging track, specifically, the step of determining whether the input track meets a preset condition in any of the above embodiments. And when the current mouse position is detected to be out of the form data range or the input track does not meet the preset condition, determining that the input is not the frame selection input executed by the user on the form data, and ending the mouse frame selection operation process. And when the input track meets the preset condition, determining that the current operation input is the data of the frame selection table dragged by the user through the mouse. The electronic equipment calculates a data line (target model element) in the framing range through the line height, the mouse pressing start position (first coordinate point) and the mouse pressing end position (second coordinate point), returns a line identification of the data line, adds a target mark to the data line corresponding to the line identification, and performs corresponding selection operation and deselection operation on the data line added with the target mark. The method and the device realize calculation of the framed data line through the sliding position of the mouse, effectively avoid the problem of event loss caused by the problems of the sliding speed of the mouse and the like, and improve the interactive experience and the operation effectiveness of the user.

According to an embodiment of the present invention, as shown in fig. 10, there is provided a table operating apparatus 1000 including:

the obtaining module 1002 is configured to, in a case that the web page display interface displays the tabular data, obtain first coordinate information of the tabular data in the web page display interface, where the first coordinate information is associated with pixel information of the tabular data;

the obtaining module 1002 is configured to obtain, in response to a first input to the web page display interface, second coordinate information of the first input in the web page display interface;

a marking module 1004, configured to add a target mark to target data in the table data according to the second coordinate information when the second coordinate information matches the first coordinate information;

the processing module 1006 is configured to perform a target operation on the target data according to the target mark, where the target operation includes a selection operation and/or a deselection operation.

In the above embodiment, the table manipulation apparatus 1000 includes:

the identification module is used for identifying first pixel information of a first display area and second pixel information of a second display area in the webpage display interface, the first display area comprises table data, and the second display area is a background area of the table data;

the processing module 1006 is configured to determine first coordinate information of the table data according to the first pixel information and the second pixel information.

In any of the above embodiments, the first input includes a first sub-input and a second sub-input, where the first sub-input is used to indicate a start point location of the first input, and the second sub-input is used to indicate an end point location of the first input;

the obtaining module 1002 is configured to obtain a first coordinate point of a first sub-input in a web page display interface, a second coordinate point of a second sub-input in the web page display interface, and an input trajectory between the first sub-input and the second sub-input;

the processing module 1006 is configured to determine second coordinate information according to the first coordinate point, the second coordinate point, and the input track.

In any of the above embodiments, the obtaining module 1002 is configured to obtain a document object model corresponding to table data;

the processing module 1006 is configured to determine a target model element in the document object model through the first coordinate point and the second coordinate point when the input trajectory meets a preset condition;

a tagging module 1004 for adding a target tag to the target model element.

In any of the above embodiments, the processing module 1006 is configured to determine a first model element corresponding to the first coordinate point, and determine a second model element corresponding to the second coordinate point;

a processing module 1006, configured to determine the first model element, the second model element, and a model element between the first model element and the second model element as a target model element.

In any of the above embodiments, the processing module 1006 is configured to determine, through the document object model, third coordinate information corresponding to each model element;

a processing module 1006, configured to filter target coordinate information from the multiple pieces of third coordinate information based on the first coordinate point and the second coordinate point;

the processing module 1006 is configured to determine a model element corresponding to the target coordinate information as a target model element.

In any of the above embodiments, the processing module 1006 is configured to determine that the second coordinate information matches the first coordinate information if the second coordinate information is within the range of the first coordinate information.

According to an embodiment of the present invention, as shown in fig. 11, there is provided a table manipulation apparatus 1100, including: a processor 1102 and a memory 1104, the memory 1104 having programs or instructions stored therein; the processor 1102 and the processor 1102 execute the program or the instructions stored in the memory 1104 to implement the steps of the table operation method in any embodiment of the first aspect, so that all the beneficial technical effects of the table operation method in any embodiment of the first aspect are achieved, and redundant description is not repeated herein.

According to an embodiment of the present invention, a readable storage medium is proposed, on which a program or instructions are stored, which when executed by a processor implement the steps of the table manipulation method as in any of the embodiments of the first aspect described above. Therefore, all the advantageous technical effects of the table operation method in any embodiment of the first aspect are achieved, and no redundant description is provided herein.

It is to be understood that, in the claims, the specification and the drawings of the specification of the present invention, the term "plurality" means two or more, unless explicitly defined otherwise, the terms "upper", "lower" and the like indicate orientations or positional relationships based on those shown in the drawings, and are used only for the purpose of describing the present invention more conveniently and simplifying the description, and are not used to indicate or imply that the device or element referred to must have the specific orientation described, be constructed in a specific orientation, and be operated, and thus the description should not be construed as limiting the present invention; the terms "connect," "mount," "secure," and the like are to be construed broadly, and for example, "connect" may refer to a fixed connection between multiple objects, a removable connection between multiple objects, or an integral connection; the multiple objects may be directly connected to each other or indirectly connected to each other through an intermediate. The specific meanings of the above terms in the present invention can be understood by those of ordinary skill in the art based on the above data.

In the claims, specification, and drawings that follow the present disclosure, the description of the terms "one embodiment," "some embodiments," "specific embodiments," and so forth, means that a particular feature, structure, material, or characteristic described in connection with the embodiment or example is included in at least one embodiment or example of the present disclosure. In the claims, specification and drawings of the specification, schematic representations of the terms used above do not necessarily refer to the same embodiment or example. Furthermore, the particular features, structures, materials, or characteristics described may be combined in any suitable manner in any one or more embodiments or examples.

The above is only a preferred embodiment of the present invention, and is not intended to limit the present invention, and various modifications and changes will occur to those skilled in the art. Any modification, equivalent replacement, or improvement made within the spirit and principle of the present invention should be included in the protection scope of the present invention.

Claims

1. A method of table manipulation, comprising:

under the condition that a webpage display interface displays table data, acquiring first coordinate information of the table data in the webpage display interface, wherein the first coordinate information is associated with pixel information of the table data;

responding to a first input to the webpage display interface, and acquiring second coordinate information of the first input in the webpage display interface;

under the condition that the second coordinate information is matched with the first coordinate information, adding a target mark to target data in the table data according to the second coordinate information;

and executing target operation on the target data according to the target mark, wherein the target operation comprises a selection operation and/or a deselection operation.

2. The form manipulation method of claim 1, wherein the obtaining first coordinate information of the form data in the web page display interface comprises:

identifying first pixel information of a first display area and second pixel information of a second display area in the webpage display interface, wherein the first display area comprises the table data, and the second display area is a background area of the table data;

determining the first coordinate information of the table data according to the first pixel information and the second pixel information.

3. A form manipulation method as claimed in claim 1 wherein said first input comprises a first sub-input and a second sub-input, wherein said first sub-input is indicative of a start point location of said first input and said second sub-input is indicative of an end point location of said first input;

the acquiring second coordinate information of the first input in the webpage display interface comprises:

acquiring a first coordinate point of the first sub-input in the webpage display interface, a second coordinate point of the second sub-input in the webpage display interface, and an input track between the first sub-input and the second sub-input;

and determining the second coordinate information according to the first coordinate point, the second coordinate point and the input track.

4. A table manipulation method according to claim 3 wherein said adding a target mark to target data in said table data according to said second coordinate information comprises:

acquiring a document object model corresponding to the table data;

determining a target model element in the document object model through the first coordinate point and the second coordinate point under the condition that the input track meets a preset condition;

adding the target mark to the target model element.

5. A form operation method as claimed in claim 4, wherein said determining a target model element in the document object model from the first coordinate point and the second coordinate point comprises:

determining a first model element corresponding to the first coordinate point and determining a second model element corresponding to the second coordinate point;

determining the first model element, the second model element, and a model element between the first model element and the second model element as the target model element.

6. A form operation method as claimed in claim 4, wherein said determining a target model element in the document object model from the first coordinate point and the second coordinate point comprises:

determining third coordinate information corresponding to each model element through the document object model;

screening target coordinate information in a plurality of pieces of third coordinate information based on the first coordinate point and the second coordinate point;

and determining the model element corresponding to the target coordinate information as the target model element.

7. The table manipulation method according to any one of claims 1 to 6, wherein, in a case where the second coordinate information matches the first coordinate information, before adding a target mark to target data in the table data according to the second coordinate information, further comprising:

and determining that the second coordinate information is matched with the first coordinate information under the condition that the second coordinate information is located in the range of the first coordinate information.

8. A form manipulation apparatus, comprising:

the system comprises an acquisition module, a display module and a display module, wherein the acquisition module is used for acquiring first coordinate information of table data in a webpage display interface under the condition that the webpage display interface displays the table data, and the first coordinate information is associated with pixel information of the table data;

9. A form manipulation apparatus, comprising:

a memory having a program or instructions stored thereon;

a processor for implementing the steps of the table manipulation method of any one of claims 1 to 7 when executing said program or instructions.

10. A readable storage medium on which a program or instructions are stored, characterized in that the program or instructions, when executed by a processor, implement the steps of the table manipulation method according to any one of claims 1 to 7.