CN113504863A - Method and device for realizing picture screening, computer storage medium and terminal - Google Patents

Method and device for realizing picture screening, computer storage medium and terminal Download PDF

Info

Publication number
CN113504863A
CN113504863A CN202110614398.8A CN202110614398A CN113504863A CN 113504863 A CN113504863 A CN 113504863A CN 202110614398 A CN202110614398 A CN 202110614398A CN 113504863 A CN113504863 A CN 113504863A
Authority
CN
China
Prior art keywords
picture
information
screening
pictures
screened
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CN202110614398.8A
Other languages
Chinese (zh)
Inventor
霍秋桦
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Beijing Kingsoft Office Software Inc
Zhuhai Kingsoft Office Software Co Ltd
Original Assignee
Beijing Kingsoft Office Software Inc
Zhuhai Kingsoft Office Software Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Beijing Kingsoft Office Software Inc, Zhuhai Kingsoft Office Software Co Ltd filed Critical Beijing Kingsoft Office Software Inc
Priority to CN202110614398.8A priority Critical patent/CN113504863A/en
Publication of CN113504863A publication Critical patent/CN113504863A/en
Pending legal-status Critical Current

Links

Images

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F3/00—Input arrangements for transferring data to be processed into a form capable of being handled by the computer; Output arrangements for transferring data from processing unit to output unit, e.g. interface arrangements
    • G06F3/01—Input arrangements or combined input and output arrangements for interaction between user and computer
    • G06F3/048—Interaction techniques based on graphical user interfaces [GUI]
    • G06F3/0481—Interaction techniques based on graphical user interfaces [GUI] based on specific properties of the displayed interaction object or a metaphor-based environment, e.g. interaction with desktop elements like windows or icons, or assisted by a cursor's changing behaviour or appearance
    • G06F3/0482—Interaction with lists of selectable items, e.g. menus
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/50—Information retrieval; Database structures therefor; File system structures therefor of still image data
    • G06F16/54—Browsing; Visualisation therefor
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F3/00—Input arrangements for transferring data to be processed into a form capable of being handled by the computer; Output arrangements for transferring data from processing unit to output unit, e.g. interface arrangements
    • G06F3/01—Input arrangements or combined input and output arrangements for interaction between user and computer
    • G06F3/048—Interaction techniques based on graphical user interfaces [GUI]
    • G06F3/0484—Interaction techniques based on graphical user interfaces [GUI] for the control of specific functions or operations, e.g. selecting or manipulating an object, an image or a displayed text element, setting a parameter value or selecting a range
    • G06F3/04845—Interaction techniques based on graphical user interfaces [GUI] for the control of specific functions or operations, e.g. selecting or manipulating an object, an image or a displayed text element, setting a parameter value or selecting a range for image manipulation, e.g. dragging, rotation, expansion or change of colour
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00—Handling natural language data
    • G06F40/10—Text processing
    • G06F40/166—Editing, e.g. inserting or deleting
    • G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
    • G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets

Abstract

The embodiment of the invention discloses a method, a device, a computer storage medium and a terminal for realizing picture screening, wherein the data of a region to be screened in a table is acquired, and a selection panel aiming at the region to be screened is expanded; acquiring picture information corresponding to each picture in the regional data to be screened according to the regional data to be screened, wherein the picture is a picture inserted into a cell in a table; the method comprises the steps of loading picture information corresponding to each picture in a selection panel, carrying out picture screening according to the loaded picture information corresponding to each picture, and providing data support for improving the picture screening efficiency by loading the picture information on the selection panel with the screening function.

Description

Method and device for realizing picture screening, computer storage medium and terminal
Technical Field
The present disclosure relates to, but not limited to, automated office technologies, and in particular, to a method, an apparatus, a computer storage medium, and a terminal for implementing picture screening.
Background
Spreadsheet (Spreadsheet), also known as a Spreadsheet, is a type of computer program that simulates a computational form on paper, and displays a grid made up of a series of rows and columns. Data such as numerical values, calculation formulas or texts can be stored in the cells of the spreadsheet; with the expansion of the functions of the electronic forms, the function of inserting pictures into the cells is added to the electronic forms.
The screening is a function of screening data written in the electronic form, and after the selection panel is used for checking screening information corresponding to the data to be checked, the electronic form can only load the data corresponding to the checked screening information when executing the screening function, so that a user can check the data more specifically.
Disclosure of Invention
The following is a summary of the subject matter described in detail herein. This summary is not intended to limit the scope of the claims.
The embodiment of the invention provides a method and a device for realizing picture screening, a computer storage medium and a terminal, which can improve the efficiency of screening pictures by a form.
The embodiment of the invention provides a method for realizing picture screening, which comprises the following steps:
acquiring data of a region to be screened in a table, and expanding a selection panel aiming at the region to be screened;
acquiring picture information corresponding to each picture in the regional data to be screened according to the regional data to be screened, wherein the picture is a picture inserted into a cell in the table;
and loading the picture information corresponding to each picture in the selection panel, and screening the pictures according to the loaded picture information corresponding to each picture.
In an exemplary embodiment, the obtaining, according to the to-be-screened area data, the picture information corresponding to each picture in the to-be-screened area data includes:
reading screening information from the data of the area to be screened, wherein the screening information is information for screening pictures generated after the pictures are inserted into the table;
reading a picture corresponding to the screening information in the table according to the screening information;
and acquiring the picture information from the read picture.
In an exemplary embodiment, the picture information includes one or any combination of the following: picture thumbnail, picture format, picture taking time, picture resolution, picture size, picture taking place, and author.
In an exemplary embodiment, the reading, according to the filtering information, the picture corresponding to the filtering information in the table includes:
respectively determining the picture storage address of each picture according to the screening information corresponding to each picture inserted into the table, wherein the screening information comprises the information of the picture storage address;
and reading the pictures stored in the picture storage addresses.
In an exemplary embodiment, after reading the picture stored in the picture storage address, the method further includes:
and displaying the pictures at the front end in a thumbnail mode.
In an exemplary embodiment, after reading the picture stored in the picture storage address, the method further includes:
and displaying the pictures at the front end in a thumbnail mode.
In an exemplary embodiment, the loading the picture information corresponding to each picture in the selection panel and performing picture screening according to the loaded picture information corresponding to each picture includes:
determining the position of the screening information corresponding to each picture displayed on the selection panel;
and loading the picture information of each picture at the position where the screening information corresponding to each picture is displayed, and screening the pictures according to the loaded picture information corresponding to each picture.
In an exemplary embodiment, before the reading, according to the screening information, the picture corresponding to the screening information in the table, the method further includes:
judging whether the same screening information exists or not;
if the same screening information exists, determining that the pictures corresponding to the same screening information are the same pictures;
and merging and displaying the same pictures.
On the other hand, an embodiment of the present invention further provides a computer storage medium, where a computer program is stored in the computer storage medium, and when the computer program is executed by a processor, the method for implementing picture screening is implemented.
In another aspect, an embodiment of the present invention further provides a terminal, including: a memory and a processor, the memory having a computer program stored therein; wherein the content of the first and second substances,
the processor is configured to execute the computer program in the memory;
the computer program, when executed by the processor, implements the method of implementing picture screening as described above.
In another aspect, an embodiment of the present invention further provides an apparatus for implementing picture screening, including: the device comprises an acquisition data unit, an acquisition information unit and a loading unit; wherein the content of the first and second substances,
the acquisition data unit is set as: acquiring data of a region to be screened in a table, and expanding a selection panel aiming at the region to be screened;
the acquisition information unit is set as: acquiring picture information corresponding to each picture in the regional data to be screened according to the regional data to be screened, wherein the picture is a picture inserted into a cell in the table;
the loading unit is arranged as follows: and loading the picture information corresponding to each picture in the selection panel, and screening the pictures according to the loaded picture information corresponding to each picture.
In an exemplary embodiment, the obtaining information unit is configured to:
reading screening information from the data of the area to be screened, wherein the screening information is information for screening pictures generated after the pictures are inserted into the table;
reading a picture corresponding to the screening information in the table according to the screening information;
and acquiring the picture information from the read picture.
In an exemplary embodiment, the obtaining information unit is configured to read, according to the filtering information, a picture corresponding to the filtering information in the table, and includes:
respectively determining the picture storage address of each picture according to the screening information corresponding to each picture inserted into the table, wherein the screening information comprises the information of the picture storage address;
and reading the pictures stored in the picture storage addresses.
In an exemplary embodiment, the load unit is arranged to:
determining the position of the screening information corresponding to each picture displayed on the selection panel;
and loading the picture information of each picture at the position where the screening information corresponding to each picture is displayed, and screening the pictures according to the loaded picture information corresponding to each picture.
The method comprises the steps of obtaining data of an area to be screened in a table, and expanding a selection panel aiming at the area to be screened; acquiring picture information corresponding to each picture in the regional data to be screened according to the regional data to be screened, wherein the picture is a picture inserted into a cell in a table; the method comprises the steps of loading picture information corresponding to each picture in a selection panel, carrying out picture screening according to the loaded picture information corresponding to each picture, and providing data support for improving the picture screening efficiency by loading the picture information on the selection panel with the screening function.
Additional features and advantages of the invention will be set forth in the description which follows, and in part will be obvious from the description, or may be learned by practice of the invention. The objectives and other advantages of the invention will be realized and attained by the structure particularly pointed out in the written description and claims hereof as well as the appended drawings.
Drawings
The accompanying drawings are included to provide a further understanding of the invention and are incorporated in and constitute a part of this specification, illustrate embodiments of the invention and together with the example serve to explain the principles of the invention and not to limit the invention.
FIG. 1 is a flowchart of a method for implementing image screening according to an embodiment of the present invention;
FIG. 2 is a schematic view of an alternative panel according to an embodiment of the present invention;
FIG. 3 is a diagram illustrating screening information according to an embodiment of the present invention;
FIG. 4 is a diagram illustrating encoding of screening information according to an embodiment of the present invention;
FIG. 5 is a table of an embodiment of the present invention;
FIG. 6 is a schematic view of an alternative panel according to an embodiment of the present invention;
FIG. 7 is a schematic diagram of an exemplary screening area for use with the present invention;
FIG. 8 is a diagram illustrating another example of filtering information according to the present invention;
FIG. 9 is a block diagram of an apparatus for implementing image screening according to an embodiment of the present invention;
FIG. 10 is a schematic diagram of a screening panel according to an exemplary embodiment of the present invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the present invention more apparent, embodiments of the present invention will be described in detail below with reference to the accompanying drawings. It should be noted that the embodiments and features of the embodiments in the present application may be arbitrarily combined with each other without conflict.
The steps illustrated in the flow charts of the figures may be performed in a computer system such as a set of computer-executable instructions. Also, while a logical order is shown in the flow diagrams, in some cases, the steps shown or described may be performed in an order different than here.
The inventor of the present application has analyzed and found that although picture screening can be implemented by referring to screening information on a selection panel and performing screening operation, the screening information is encoded information with abstract content, when the number of pictures increases, the screening information of the pictures is difficult to distinguish, and a user is difficult to screen the pictures through the screening information, which affects the efficiency of the user in screening the pictures.
Fig. 1 is a flowchart of a method for implementing picture screening processing according to an embodiment of the present invention, as shown in fig. 1, including:
step 101, acquiring data of an area to be screened in a table, and expanding a selection panel aiming at the area to be screened; here, the selection panel refers to a selection panel of a screening function of the table;
102, acquiring picture information corresponding to each picture in the regional data to be screened according to the regional data to be screened, wherein the picture is a picture inserted into a cell in a table;
103, loading picture information corresponding to each picture in the selection panel, and screening the pictures according to the loaded picture information corresponding to each picture; here, the picture information of each picture may be loaded in the selection panel, respectively.
The method comprises the steps of obtaining data of an area to be screened in a table, and expanding a selection panel aiming at the area to be screened; acquiring picture information corresponding to each picture in the regional data to be screened according to the regional data to be screened, wherein the picture is a picture inserted into a cell in a table; the method comprises the steps of loading picture information corresponding to each picture in a selection panel, carrying out picture screening according to the loaded picture information corresponding to each picture, and providing data support for improving the picture screening efficiency by loading the picture information on the selection panel with the screening function.
In an exemplary embodiment, acquiring picture information corresponding to each picture in the to-be-screened area data according to the embodiment of the present invention includes:
reading screening information from the data of the area to be screened, wherein the screening information is information for screening pictures generated after the pictures are inserted into the table;
reading a picture corresponding to the screening information in the table according to the screening information; reading a picture in a form refers to reading a picture inserted into a form;
acquiring picture information from the read picture, wherein the picture information is information capable of distinguishing picture contents; the picture information may be various information contained in the picture itself, and may be used to distinguish differences between different picture contents in the cells, where the picture information is determined by the photographing device, information contained in different devices may be inconsistent, information contained in the picture itself may be acquired, and information not contained in the picture itself may not be acquired.
In the embodiment of the invention, for the pictures inserted into the cells, the selection panel displays the screening information containing the storage address beginning with the fixed content; fig. 2 is a schematic diagram of a selection panel according to an embodiment of the present invention, as shown in fig. 2, the selection panel enclosed by a frame is displayed in a table, and the screening information of the picture may be encoded information, for example, content beginning with a field "DISPIMG"; the screening information is information in a preset format set by a technician with reference to a relevant protocol for realizing a screening function, and the screening information may be encoded information in other formats set according to the relevant protocol.
In an exemplary embodiment, the picture information of the embodiment of the present invention includes one or any combination of the following items: the picture thumbnail, the picture format, the picture shooting time, the picture resolution, the picture size, the picture shooting place and the author, and the like; the picture format may include a joint image experts group (jpg) format, a portable network graphics (png) format, and the like. The picture information may not be read from the picture, and the picture information can be acquired only when the picture uploaded (inserted) into the cell contains the information, and the information not contained in the picture cannot be acquired by the embodiment of the invention.
In an exemplary example, when the picture information in the embodiment of the present invention includes one or more of a picture taking time, a picture resolution, a picture size, a picture taking place, and an author, the information may be read from attribute information of the picture. According to the embodiment of the invention, the user can select the picture information to be acquired according to the application scene; when the picture information relates to privacy of picture taking places, authors and the like, the embodiment of the invention can delete the picture information related to the privacy from the selectable information.
In the embodiment of the invention, under the condition that the picture information comprises the picture thumbnail, a user can visually look up the content of the picture inserted in the table, and the user can efficiently screen the picture according to the picture thumbnail; when the screening is executed, the pictures inserted into the cells are displayed in the selection panel as screening items, the picture thumbnails are displayed and are consistent with the logic of the screening items, and after the screening is performed and the screening is performed, the screening result is consistent with the check cell pictures.
When the picture information includes more than one of the picture taking time, the picture format, the picture resolution, the picture size, the picture taking place and the author, the user may limit the picture information for picture screening during the process of performing the screening operation, for example, if the user needs to screen a picture of a certain date, the user may directly screen the picture according to the picture taking time. The image information in the embodiment of the present invention may further include other information that can be used to distinguish specific contents of the image, for example, personal information, and the personal information may be displayed by intercepting the avatar of the person.
In one illustrative example, when the picture information includes a picture thumbnail, the acquiring the picture information includes: converting the read picture into a picture thumbnail according to a preset size; the size of the picture thumbnail can be set by a person skilled in the art according to experience, and the generally obtained picture thumbnail can display the main structure of the picture to a certain extent; for example, information of one or any combination of the following in the picture can be displayed: characters, objects, places, and the like; the size of the picture thumbnail may be generally set to 72 pixels by 72 pixels or 108 pixels by 108 pixels; the setting of picture thumbnail size can load the picture thumbnail of certain quantity in the screening panel on the one hand, and on the other hand can also satisfy the demand that the user distinguished the picture.
In an exemplary embodiment, reading a picture corresponding to screening information in a table according to the screening information in an embodiment of the present invention includes:
respectively determining the picture storage address of each picture according to the screening information corresponding to the picture in each inserted table, wherein the screening information comprises the information of the picture storage address;
and reading the pictures stored in the picture storage addresses.
The embodiment of the invention realizes the reading of the picture corresponding to the screening information based on the picture storage address contained in the screening information. In an exemplary example, in a case where different pictures are stored in the same storage area, offset addresses of the different picture storages are different, and thus, picture storage addresses included in filtering information of the different pictures are different from each other. The picture storage address in the embodiment of the invention can be storage path information, and also can be other information of the picture, such as the ID of the picture, and the original picture of the picture can be found in a server for storing the picture according to the ID of the picture; fig. 3 is a schematic diagram of screening information according to an embodiment of the present invention, and as shown in fig. 3, the screening information starts in a DISPIMG fixed form, and the screening information may include picture names and display modes. Fig. 4 is a schematic diagram of encoding of screening information according to an embodiment of the present invention, as shown in fig. 4, in a formula for obtaining screening information by encoding, an ID of a picture in parentheses after DISPIMG may represent a picture name, and the screening information may further include other information including a picture display mode.
In an exemplary example, the picture inserted into the cell in the embodiment of the present invention may be stored in a local terminal that loads the table, or may be stored in a server that establishes a communication connection with the local terminal; the storage location may be different, and a corresponding storage address is generated with reference to the related art when the picture is stored. In an illustrative example, the memory address of the embodiment of the present invention further includes a processed memory address; for example, in order to improve the storage security of a file, the real storage location of a picture is hidden, and a storage address is generated after a certain coding process is performed on the storage address.
In an exemplary embodiment, after reading the picture stored in the picture storage address, the method in the embodiment of the present invention further includes:
the pictures are displayed in the form of thumbnails at the front end.
According to the embodiment of the invention, the front end of the picture returned by the server is drawn in the form of the thumbnail, and the user can quickly verify the picture screening result through the front-end display of the thumbnail.
In an exemplary embodiment, loading picture information corresponding to each picture in a selection panel, and performing picture screening according to the loaded picture information corresponding to each picture according to the embodiment of the present invention includes:
determining the position of the screening information corresponding to each picture displayed on the selection panel;
and loading the picture information of each picture at the position where the screening information corresponding to each picture is displayed, and screening the pictures according to the loaded picture information corresponding to each picture.
In the embodiment of the present invention, the positions of the selection panels displaying the screening information of different pictures are different from each other, for example, the position a displays the screening information of the first picture, the position B displays the screening information of the second picture, and after the picture information is acquired, the image information of the first picture is loaded and displayed at the position a displaying the screening information of the first picture, and the image information of the second picture is loaded and displayed at the position B displaying the screening information of the second picture. On the selection panel, the picture information is loaded at the position where the screening information is displayed, so that a user can execute screening operation on a familiar application interface, and the experience of the user in executing the screening operation is improved.
FIG. 5 is a diagram illustrating a table according to an embodiment of the present invention, and as shown in FIG. 5, a picture is inserted in the cell of column C of the table according to the photo-related technology, and the picture is inserted in the table according to the embodiment of the present invention; fig. 6 is a schematic diagram of a selection panel according to an embodiment of the present invention, and referring to fig. 2, 5 and 6, a position of the filtering information is displayed in the selection panel of fig. 2, a picture thumbnail corresponding to the picture of the table inserted in fig. 5 is loaded in fig. 6 (a position of each piece of the filtering information in the selection panel corresponding to fig. 2, such as a position of the filtering information "═ DISPIMG (XYZ1 …)" displayed in the selection panel of fig. 2), for example, a picture thumbnail of a skirt of the C column, row 2 cell and row three cell in fig. 5 is loaded in the selection panel of fig. 6; the picture thumbnails are directly displayed in the selection panel, so that the pictures of products such as skirts and the like inserted in the table can be visually and efficiently screened; the picture thumbnail in fig. 6 may be replaced with other types of picture information acquired in the embodiment of the present invention, or may be displayed together with other types of picture information, so that when a user performs picture screening, the picture to be screened, which is inserted into a cell, is determined according to different picture related information, thereby meeting different situations and scene requirements. Fig. 7 is a schematic diagram of a filtering area according to an embodiment of the present invention, as shown in fig. 7, when the filtering information is not replaced by the picture information in the selection panel, the filtering information in the fixed format beginning with DISPIMG is displayed in the selection panel, and after the filtering information (DISPIMG (picture name, display mode)) is replaced by the picture information, the loaded picture information is displayed in the selection panel (filtering panel).
In an exemplary embodiment, before reading the picture corresponding to the screening information in the table according to the screening information, the method in the embodiment of the present invention further includes:
judging whether the same screening information exists or not;
if the same screening information exists, determining that the pictures corresponding to the same screening information are the same pictures;
and merging and displaying the same pictures.
In the embodiment of the invention, if the cell pictures are the same formula, the cell pictures are regarded as the same picture in the screening items.
Fig. 8 is a schematic diagram of another screening information according to an embodiment of the present invention, as shown in fig. 8, two pictures of a table are inserted into the diagram, and when the screening information is the same, the two pictures are the same picture; the screening information of the embodiment of the invention is the same and can comprise: the picture names or storage addresses of the pictures in the screening information are the same; in an exemplary example, in the case where the picture storage address is an ID of a picture, and the picture ID in the filtering information is the same, it is determined that the two pictures are the same picture, and at this time, the filtering information of the pictures may be merged. After the filtering information is merged, the total number of each identical picture may be added after the corresponding filtering information of each picture, for example, when two filtering information are identical, a count (2) is added after the picture thumbnail shown in fig. 6, which indicates that there are two pictures corresponding to the picture thumbnail inserted into the table.
In an exemplary embodiment, before reading a picture corresponding to the screening information, the method in the embodiment of the present invention further includes: and reading the screening information of the picture. Here, the filtering information includes: the screening information loaded on the selection panel of the screening function with reference to the related art.
In an exemplary embodiment, after loading the obtained picture information in the selection panel, the method in the embodiment of the present invention further includes: and deleting the screening information of the picture corresponding to the picture information loaded in the selection panel.
After the picture information is loaded, the screening information of the picture is set in a coding mode, so that the effect of performing screening operation through the screening information is not great for a user; after the picture information is loaded, the user can perform picture screening according to the picture information, so that the screening information is deleted in the embodiment of the invention.
In an exemplary example, the method according to the embodiment of the present invention may also establish a mapping relationship between the picture and the screening information in the selection panel according to a mapping relationship between the picture and the screening information established by the related technology; with reference to the processing of image screening executed during screening checking in the related art, after the mapping relationship between the image and the image information is established, the image can be screened through checking the image information.
The embodiment of the invention also provides a computer storage medium, wherein a computer program is stored in the computer storage medium, and when being executed by a processor, the computer program realizes the method for realizing the picture screening.
An embodiment of the present invention further provides a terminal, including: a memory and a processor, the memory having stored therein a computer program; wherein the content of the first and second substances,
the processor is configured to execute the computer program in the memory;
the computer program, when executed by a processor, implements a method of implementing picture screening as described above.
Fig. 9 is a block diagram of a structure of an apparatus for implementing image screening according to an embodiment of the present invention, as shown in fig. 9, including: the device comprises an acquisition data unit, an acquisition information unit and a loading unit; wherein the content of the first and second substances,
the acquisition data unit is set as: acquiring data of a region to be screened in the table, and expanding a selection panel aiming at the region to be screened;
the acquisition information unit is set as: acquiring picture information corresponding to each picture in the regional data to be screened according to the regional data to be screened, wherein the picture is a picture inserted into a cell in a table;
the loading unit is arranged as follows: and loading the picture information corresponding to each picture in the selection panel, and screening the pictures according to the loaded picture information corresponding to each picture.
The method comprises the steps of obtaining data of an area to be screened in a table, and expanding a selection panel aiming at the area to be screened; acquiring picture information corresponding to each picture in the regional data to be screened according to the regional data to be screened, wherein the picture is a picture inserted into a cell in a table; the method comprises the steps of loading picture information corresponding to each picture in a selection panel, carrying out picture screening according to the loaded picture information corresponding to each picture, and providing data support for improving the picture screening efficiency by loading the picture information on the selection panel with the screening function.
In an exemplary example, the obtaining data unit according to an embodiment of the present invention is configured to obtain, according to the area data to be filtered, picture information corresponding to each picture in the area data to be filtered, and includes:
reading screening information from the data of the area to be screened, wherein the screening information is information for screening pictures generated after the pictures are inserted into the table;
reading a picture corresponding to the screening information in the table according to the screening information;
and acquiring picture information from the read picture.
In an exemplary example, the picture information in the embodiment of the present invention includes one or any combination of the following items: picture thumbnail, picture format, picture taking time, picture resolution, picture size, picture taking place, and author.
In one illustrative example, when the picture information includes a thumbnail, the acquiring the picture information includes: converting the read picture into a picture thumbnail according to a preset size; the size of the picture thumbnail can be set by a person skilled in the art according to experience, and the requirement that the obtained picture thumbnail can display the main structure of the picture to a certain extent is met; for example, information of one or any combination of the following in the picture can be displayed: characters, objects, places, and the like; the size of the picture thumbnail can be generally set to 72 pixels by 72 pixels or 108 pixels by 108 pixels, and the setting of the size of the picture thumbnail can load a certain number of picture thumbnails in the screening panel on one hand, and on the other hand, the picture thumbnail can also meet the requirement of distinguishing pictures for users.
In one illustrative example, the picture information includes: when one or more of the picture taking time, the picture resolution, the picture size, the picture taking place, and the author is selected, the information may be read from the attribute information of the picture. According to the embodiment of the invention, the user can select the picture information to be acquired according to the application scene; when the picture information relates to privacy, the embodiment of the invention can delete the picture information relating to privacy from the selectable information.
The data acquisition unit of the embodiment of the invention is set to read the picture corresponding to the screening information in the table according to the screening information, and comprises the following steps:
respectively determining the picture storage address of each picture according to the screening information corresponding to the picture in each inserted table, wherein the screening information comprises the information of the picture storage address;
and reading the pictures stored in the picture storage addresses.
In an exemplary example, the picture inserted into the cell in the embodiment of the present invention may be stored in a local terminal that loads the table, or may be stored in a server that establishes a communication connection with the local terminal; the storage positions can be different, and corresponding storage addresses are generated by referring to the related technology when the pictures are stored; in an illustrative example, the memory address of the embodiment of the present invention further includes a processed memory address; for example, in order to hide the actual storage location of the picture, the address is generated by encoding the storage address by a certain amount.
In an exemplary embodiment, the loading unit of the embodiment of the present invention is further configured to:
after the pictures stored in the picture storage addresses are read, the pictures are displayed at the front end in the form of thumbnails.
In an illustrative example, a load unit according to an embodiment of the present invention is configured to:
determining the position of the screening information corresponding to each picture displayed on the selection panel;
and loading the picture information of each picture at the position where the screening information corresponding to each picture is displayed, and screening the pictures according to the loaded picture information corresponding to each picture.
In an exemplary embodiment, the apparatus of the embodiment of the present invention further includes a merging unit, configured to:
judging whether the same screening information exists or not;
if the same screening information exists, determining that the pictures corresponding to the same screening information are the same pictures;
and merging and displaying the same pictures.
In an exemplary embodiment, the information obtaining unit in the embodiment of the present invention is further configured to:
and reading the screening information.
In an exemplary embodiment, the loading unit of the embodiment of the present invention is further configured to:
and after the acquired picture information is loaded in the selection panel, deleting the screening information of the picture corresponding to the picture information loaded in the selection panel.
The method of the embodiment of the present invention is briefly described by the following application examples, which are only used to illustrate the embodiment of the present invention and are not used to limit the protection scope of the present invention.
Application example
When the application example is used for screening pictures, the cell pictures are displayed in the screening panel as screening items, the picture thumbnails are displayed and are consistent with the logic of the screening items, and after screening is performed and selected, the screening results are consistent with the screening cell pictures;
the implementation logic includes:
in the table shown in fig. 5, when the lower triangle button shown in fig. 10 is clicked to expand the filter panel (the selection panel in the embodiment of the present invention), the server acquires the current filter area data shown in fig. 7, and displays the picture corresponding to the cell content on the filter panel (the selection panel) when the cell content starts with "DISPIMG"; in an exemplary example, inside a selection panel (a filtering panel), when a certain area to be filtered has both pictures and characters, thumbnails of the pictures or formulas can be displayed in the filtering panel together with other characters. The front end of the picture returned by the server is drawn in a thumbnail form; if the cell pictures are the same formula (the codes corresponding to the screening information), the cell pictures are regarded as the same picture in the screening items; for the same picture, after the screening items of the displayed pictures, the application example displays the number of the same pictures inserted into the cell; for example, if picture 1 is inserted into two cells of the table, picture 1 thumbnail will be displayed at the back of (2), indicating that the picture is inserted into two cells of the table.
"one of ordinary skill in the art will appreciate that all or some of the steps of the methods, systems, functional modules/units in the devices disclosed above may be implemented as software, firmware, hardware, and suitable combinations thereof. In a hardware implementation, the division between functional modules/units mentioned in the above description does not necessarily correspond to the division of physical components; for example, one physical component may have multiple functions, or one function or step may be performed by several physical components in cooperation. Some or all of the components may be implemented as software executed by a processor, such as a digital signal processor or microprocessor, or as hardware, or as an integrated circuit, such as an application specific integrated circuit. Such software may be distributed on computer readable media, which may include computer storage media (or non-transitory media) and communication media (or transitory media). The term computer storage media includes volatile and nonvolatile, removable and non-removable media implemented in any method or technology for storage of information such as computer readable instructions, data structures, program modules or other data, as is well known to those of ordinary skill in the art. Computer storage media includes, but is not limited to, RAM, ROM, EEPROM, flash memory or other memory technology, CD-ROM, Digital Versatile Disks (DVD) or other optical disk storage, magnetic cassettes, magnetic tape, magnetic disk storage or other magnetic storage devices, or any other medium which can be used to store the desired information and which can accessed by a computer. In addition, communication media typically embodies computer readable instructions, data structures, program modules or other data in a modulated data signal such as a carrier wave or other transport mechanism and includes any information delivery media as known to those skilled in the art. "

Claims (13)

1. A method for realizing picture screening comprises the following steps:
acquiring data of a region to be screened in a table, and expanding a selection panel aiming at the region to be screened;
acquiring picture information corresponding to each picture in the regional data to be screened according to the regional data to be screened, wherein the picture is a picture inserted into a cell in the table;
and loading the picture information corresponding to each picture in the selection panel, and screening the pictures according to the loaded picture information corresponding to each picture.
2. The method according to claim 1, wherein the obtaining the picture information corresponding to each picture in the to-be-screened area data according to the to-be-screened area data comprises:
reading screening information from the data of the area to be screened, wherein the screening information is information for screening pictures generated after the pictures are inserted into the table;
reading a picture corresponding to the screening information in the table according to the screening information;
and acquiring the picture information from the read picture.
3. The method according to claim 1, wherein the picture information comprises one or any combination of the following: picture thumbnail, picture format, picture taking time, picture resolution, picture size, picture taking place, and author.
4. The method according to claim 2, wherein the reading the picture corresponding to the filtering information in the table according to the filtering information includes:
respectively determining the picture storage address of each picture according to the screening information corresponding to each picture inserted into the table, wherein the screening information comprises the information of the picture storage address;
and reading the pictures stored in the picture storage addresses.
5. The method of claim 4, wherein after reading the picture stored in the picture storage address, the method further comprises:
and displaying the pictures at the front end in a thumbnail mode.
6. The method according to any one of claims 1 to 5, wherein loading the picture information corresponding to each picture in the selection panel and performing picture screening according to the loaded picture information corresponding to each picture comprises:
determining the position of the screening information corresponding to each picture displayed on the selection panel;
and loading the picture information of each picture at the position where the screening information corresponding to each picture is displayed, and screening the pictures according to the loaded picture information corresponding to each picture.
7. The method according to claim 2, 4 or 5, wherein before reading the picture corresponding to the screening information in the table according to the screening information, the method further comprises:
judging whether the same screening information exists or not;
if the same screening information exists, determining that the pictures corresponding to the same screening information are the same pictures;
and merging and displaying the same pictures.
8. A computer storage medium, in which a computer program is stored, which, when being executed by a processor, implements the method for implementing picture screening according to any one of claims 1 to 7.
9. A terminal, comprising: a memory and a processor, the memory having a computer program stored therein; wherein the content of the first and second substances,
the processor is configured to execute the computer program in the memory;
the computer program is used for realizing the method for realizing the picture screening according to any one of claims 1-7 when being executed by the processor.
10. An apparatus for implementing picture screening, comprising: the device comprises an acquisition data unit, an acquisition information unit and a loading unit; wherein the content of the first and second substances,
the acquisition data unit is set as: acquiring data of a region to be screened in a table, and expanding a selection panel aiming at the region to be screened;
the acquisition information unit is set as: acquiring picture information corresponding to each picture in the regional data to be screened according to the regional data to be screened, wherein the picture is a picture inserted into a cell in the table;
the loading unit is arranged as follows: and loading the picture information corresponding to each picture in the selection panel, and screening the pictures according to the loaded picture information corresponding to each picture.
11. The apparatus of claim 10, wherein the means for obtaining information is configured to:
reading screening information from the data of the area to be screened, wherein the screening information is information for screening pictures generated after the pictures are inserted into the table;
reading a picture corresponding to the screening information in the table according to the screening information;
and acquiring the picture information from the read picture.
12. The apparatus according to claim 11, wherein the information obtaining unit is configured to read a picture corresponding to the screening information in the table according to the screening information, and includes:
respectively determining the picture storage address of each picture according to the screening information corresponding to each picture inserted into the table, wherein the screening information comprises the information of the picture storage address;
and reading the pictures stored in the picture storage addresses.
13. The apparatus of any one of claims 10 to 12, wherein the loading unit is configured to:
determining the position of the screening information corresponding to each picture displayed on the selection panel;
and loading the picture information of each picture at the position where the screening information corresponding to each picture is displayed, and screening the pictures according to the loaded picture information corresponding to each picture.
CN202110614398.8A 2021-06-02 2021-06-02 Method and device for realizing picture screening, computer storage medium and terminal Pending CN113504863A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202110614398.8A CN113504863A (en) 2021-06-02 2021-06-02 Method and device for realizing picture screening, computer storage medium and terminal

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202110614398.8A CN113504863A (en) 2021-06-02 2021-06-02 Method and device for realizing picture screening, computer storage medium and terminal

Publications (1)

Publication Number Publication Date
CN113504863A true CN113504863A (en) 2021-10-15

Family

ID=78009283

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202110614398.8A Pending CN113504863A (en) 2021-06-02 2021-06-02 Method and device for realizing picture screening, computer storage medium and terminal

Country Status (1)

Country Link
CN (1) CN113504863A (en)

Citations (7)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN105512255A (en) * 2015-12-01 2016-04-20 上海斐讯数据通信技术有限公司 Picture screening method and device and mobile terminal
CN106055712A (en) * 2016-06-30 2016-10-26 宇龙计算机通信科技(深圳)有限公司 Method and device for screening picture, and terminal
CN107589963A (en) * 2017-09-26 2018-01-16 维沃移动通信有限公司 A kind of image processing method, mobile terminal and computer-readable recording medium
CN108734089A (en) * 2018-04-02 2018-11-02 腾讯科技（深圳）有限公司 Identify method, apparatus, equipment and the storage medium of table content in picture file
CN110287361A (en) * 2019-06-28 2019-09-27 北京奇艺世纪科技有限公司 A kind of personage's picture screening technique and device
WO2020037940A1 (en) * 2018-08-23 2020-02-27 深圳码隆科技有限公司 Method and device for screening image data of character clothing
CN112417822A (en) * 2019-08-05 2021-02-26 珠海金山办公软件有限公司 Method and device for replacing pictures in spreadsheet cells and electronic equipment

Patent Citations (7)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN105512255A (en) * 2015-12-01 2016-04-20 上海斐讯数据通信技术有限公司 Picture screening method and device and mobile terminal
CN106055712A (en) * 2016-06-30 2016-10-26 宇龙计算机通信科技(深圳)有限公司 Method and device for screening picture, and terminal
CN107589963A (en) * 2017-09-26 2018-01-16 维沃移动通信有限公司 A kind of image processing method, mobile terminal and computer-readable recording medium
CN108734089A (en) * 2018-04-02 2018-11-02 腾讯科技（深圳）有限公司 Identify method, apparatus, equipment and the storage medium of table content in picture file
WO2020037940A1 (en) * 2018-08-23 2020-02-27 深圳码隆科技有限公司 Method and device for screening image data of character clothing
CN110287361A (en) * 2019-06-28 2019-09-27 北京奇艺世纪科技有限公司 A kind of personage's picture screening technique and device
CN112417822A (en) * 2019-08-05 2021-02-26 珠海金山办公软件有限公司 Method and device for replacing pictures in spreadsheet cells and electronic equipment

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
FANJY: "EXCEL实战技巧86：从下拉列表中选择并显示相关的图片和文字说明", pages 1 - 4, Retrieved from the Internet <URL:https://mp.weixin.qq.com/> *

Similar Documents

Publication Publication Date Title
US7716605B2 (en) Thumbnail image browsing method in an embedded system
US8548211B2 (en) Indicating a correspondence between an image and an object
US20060224993A1 (en) Digital image browser
US20050240880A1 (en) System and method for displaying stack icons
US10430456B2 (en) Automatic grouping based handling of similar photos
CN106168874B (en) webpage-based multimedia message editing method and device
JP5883843B2 (en) Image evaluation apparatus, image evaluation method, image evaluation program, and recording medium storing the program
US20180324459A1 (en) Method and device for compressing image, and electronic device
US20180018351A1 (en) File management system facilitating the organization of content by using visualizations of the organizational state augmented by a configurable workflow
CN111228801A (en) Rendering method and device of game scene, storage medium and processor
CN107230241B (en) Image-text mixed arrangement implementation method and device
CN114564131B (en) Content publishing method, device, computer equipment and storage medium
CN104216996A (en) File information display method and device
JPH07322183A (en) Image recording/reproducing device
JP5146282B2 (en) Information processing apparatus, display control method, and program
CN111767492A (en) Picture loading method and device, computer equipment and storage medium
CN113504863A (en) Method and device for realizing picture screening, computer storage medium and terminal
CN110456999B (en) Program creation method, program creation device, electronic equipment and computer readable storage medium
CN109089150B (en) Image processing method and electronic device
JP2002112165A (en) Image processing unit, image processing system, image processing method, and storage medium
CN114969089A (en) Data obtaining method and device, electronic equipment and storage medium
CN112632921B (en) Display processing method, device, terminal and storage medium for multimedia data
CN111222065A (en) Information display method and device, electronic equipment and medium
CN110222207B (en) Picture sorting method and device and intelligent terminal
CN111898640B (en) Method and device for pushing pictures by analog snapshot machine, test system and electronic equipment

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination