CN110807054A - Method, system and terminal for displaying classified data - Google Patents
Method, system and terminal for displaying classified data Download PDFInfo
- Publication number
- CN110807054A CN110807054A CN201810796911.8A CN201810796911A CN110807054A CN 110807054 A CN110807054 A CN 110807054A CN 201810796911 A CN201810796911 A CN 201810796911A CN 110807054 A CN110807054 A CN 110807054A
- Authority
- CN
- China
- Prior art keywords
- data
- characteristic value
- displaying
- class
- class data
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Landscapes
- User Interface Of Digital Computer (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a method, a system and a terminal for displaying classified data, wherein the method comprises the following steps: determining a characteristic value of class data to be viewed; looking up class data with the characteristic value in a data table; and marking and displaying the class data with the characteristic value in the data table. The invention can realize automatic highlighting of the same kind of data.
Description
Technical Field
The present invention relates to data display technologies, and in particular, to a method, a system, and a terminal for displaying classified data.
Background
When the spreadsheet is used for checking a list with large data volume, if the data volume is large, the checked data is easy to see wrong rows, and in order to conveniently check the data, the data can be classified, and the classified required data is marked prominently.
If the detailed data of each sales order is viewed, the data of the sales orders are classified according to the current viewing mode, such as classifying according to date, classifying according to sold commodities, classifying according to sales order numbers, and the like, and the data required to be viewed is selected from the classified data to be highlighted, for example, one or more data required to be viewed are marked with different colors from other data: or select one or more data to be viewed with a mouse/keyboard to distinguish from other data. As shown in fig. 1, an excel table containing a plurality of sales orders is classified by sales order number, and if data corresponding to a certain sales order number (e.g., S _0008) is to be viewed, the data to be viewed can be highlighted by selecting the data to be viewed with a mouse to distinguish it from other data in order to avoid serial viewing.
The operation needs manual intervention, and is complex and inefficient.
Disclosure of Invention
In order to solve the technical problem, the invention provides a method, a system and a terminal for displaying classified data, which can realize automatic highlighting of the same kind of data.
To achieve the object of the present invention, the present invention provides a method of displaying classified data, the method comprising:
determining a characteristic value of class data to be viewed;
looking up class data with the characteristic value in a data table;
and marking and displaying the class data with the characteristic value in the data table.
As an optional implementation manner, the labeling and displaying the class data with the characteristic value in the data table includes one or more of the following:
class data having the characteristic value is colored in a data table.
As an alternative embodiment, there are multiple eigenvalues of the class data.
As an optional implementation, the determining a feature value of class data to be viewed includes:
receiving a characteristic value of class data to be viewed input through an input device; or
Receiving one piece of data in the class data to be viewed selected through an input device, and determining the characteristic value of the class data according to the characteristic value of the data.
The invention also provides a system for displaying classified data, comprising:
the classification module is used for determining a characteristic value of class data to be viewed;
the searching module is used for searching the class data with the characteristic value in the data table;
and the display module is used for marking and displaying the class data with the characteristic value in the data table.
As an optional embodiment, the display module is configured to implement label display on class data with the characteristic value in the data table by one or more of the following ways:
class data having the characteristic value is colored in a data table.
As an alternative embodiment, the classification module is configured to determine a feature value of class data to be viewed, and includes:
receiving a characteristic value of class data input through an input device; or
Receiving one piece of data in the class data to be viewed selected through an input device, and determining the characteristic value of the class data according to the characteristic value of the data.
The present invention also provides a computer-readable storage medium having stored thereon computer-executable instructions which, when executed by a processor, carry out the steps of the method of displaying assortment data as described above.
The invention also provides a terminal for displaying the classified data, which comprises:
a memory to store instructions;
a processor for executing the instructions to perform the steps of the method of displaying assortment data as described above.
Compared with the prior art, the method comprises the steps of determining the characteristic value of class data to be viewed; looking up class data with the characteristic value in a data table; and marking and displaying the class data with the characteristic value in the data table. The embodiment of the invention can realize the purpose of automatically highlighting the same kind of data.
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 diagram of a conventional data sheet showing classification data;
FIG. 2 is a flowchart of a method for displaying classification data according to an embodiment of the present invention;
FIG. 3 is a diagram illustrating classification data displayed dynamically according to an exemplary application of the present invention;
FIG. 4 is a block diagram of a system for displaying classification data according to an 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.
An embodiment of the present invention provides a method for displaying classified data, as shown in fig. 2, the method includes:
s201, determining a characteristic value of class data to be viewed;
the class data is a set of data with common characteristics, the characteristic value of the class data is the value of the common characteristics, and the common characteristics of the class data can be 1 or more; a single piece of data may also be a piece of class data;
an excel table containing a plurality of sales orders is shown in FIG. 1, and the 7 th to 10 th data in the table have the following common characteristics: the date and the sales order number, wherein the collection of the 7 th to 10 th data is a class data;
s202, searching class data with the characteristic value in a data table;
s203, the class data with the characteristic value in the data table is labeled and displayed.
As an optional implementation manner of the embodiment of the present invention, step S201 may be implemented by:
receiving a characteristic value of class data to be viewed input through an input device, wherein the input device can be a keyboard or a mouse; for example, the characteristic value of the class data input by a keyboard is received through a dialog box, or the characteristic value of the class data selected by clicking or double clicking a mouse is received;
alternatively, the first and second electrodes may be,
receiving one piece of data in class data to be viewed selected through an input device, and determining a characteristic value of the class data according to the characteristic value of the data;
as an optional implementation manner of the embodiment of the present invention, step S203 may be implemented by one or more of the following manners:
class data having the characteristic value is colored in a data table.
By coloring the selected class data, the selected class data can be distinguished from other data, and the data is convenient to look up.
The embodiment of the invention can realize the purpose of automatically highlighting the same kind of data.
The embodiments of the present invention are further explained below by specific application examples.
Take an excel table with a plurality of sales orders as an example, as shown in fig. 1.
Application example 1
Classifying data (sales orders) in the excel table by sales order numbers, wherein each data comprises { number of commodities of the date sales order number and the amount of remarks } attribute; suppose that the user wants to view all sales orders with sales order number "S _ 0008";
receiving a characteristic value of class data input by clicking a sales order number S _0008 by a user through a mouse;
looking up the sales order with the sales order number of 'S _ 0008' in the data table;
after the sales order with the sales order number of S _0008 is found, the found sales order is highlighted in a coloring mode.
And when the sales order numbers of other values are received, continuously searching the sales orders with the sales order numbers of other values in the data table, and coloring and highlighting the found sales orders after finding the corresponding sales orders.
The effects presented to the user are: when the user selects the cell (B8), the data (items 7 to 10) identical to the sales order number (S _0008) of the data corresponding to the cell are marked. When the user newly selects the cell (B11), the data (the 11 th data) identical to the sales order number (S _0009) of the data corresponding to the cell is marked.
Application example 2
Classifying data (sales orders) in the excel table by sales order numbers, wherein each data comprises { number of commodities of the date sales order number and the amount of remarks } attribute; suppose that the user wants to view all sales orders with sales order number "S _ 0008";
receiving common characteristics of the sales order to be viewed, which is input by a user through a keyboard: a sales order number;
when detecting that a user clicks a cell of an excel table through a mouse, inquiring data corresponding to the cell, and inquiring that the numerical value of a sales order number in the data is S _ 0008;
looking up the sales order with the sales order number of 'S _ 0008' in the data table;
after finding the sales order with the sales order number "S _ 0008", the found sales order is color-highlighted as shown in FIG. 3.
The effects presented to the user are: when the user selects the cell (C8), the data (items 7 to 10) identical to the sales order number (S _0008) of the data corresponding to the cell are marked. When the user newly selects the cell (C11), the data (the 11 th data) identical to the sales order number (S _0009) of the data corresponding to the cell is marked. The highlighted class data can dynamically change along with the change of the cell selected by the user, and dynamic classified browsing is realized.
An embodiment of the present invention further provides a system for displaying classified data, as shown in fig. 4, the system includes:
a classification module 401, configured to determine a feature value of class data to be viewed;
the class data is a set of data with common characteristics, the characteristic value of the class data is the value of the common characteristics, and the common characteristics of the class data can be 1 or more; a single piece of data may also be a piece of class data;
an excel table containing a plurality of sales orders is shown in FIG. 1, and the 7 th to 10 th data in the table have the following common characteristics: the date and the sales order number, wherein the collection of the 7 th to 10 th data is a class data;
a searching module 402, configured to search the class data having the feature value in the data table;
and a display module 403, configured to label and display the class data with the characteristic value in the data table.
As an optional implementation manner of the embodiment of the present invention, the classification module 401 is configured to determine a feature value of class data to be viewed, and includes:
receiving a characteristic value of class data input through an input device; or
Receiving one piece of data in the class data to be viewed selected through an input device, and determining the characteristic value of the class data according to the characteristic value of the data.
As an optional implementation manner of the embodiment of the present invention, the displaying module 403 is configured to implement labeling and displaying the class data having the feature value in the data table in one or more of the following manners, including:
class data having the characteristic value is colored in a data table.
By coloring the selected class data, the selected class data can be distinguished from other data, and the data is convenient to look up.
The embodiment of the invention can realize the purpose of automatically highlighting the same kind of data.
Embodiments of the present invention further provide a computer-readable storage medium, which stores computer-executable instructions, and when executed by a processor, the computer-executable instructions implement the following steps of a method for displaying classified data:
determining a characteristic value of class data to be viewed;
looking up class data with the characteristic value in a data table;
and marking and displaying the class data with the characteristic value in the data table.
As an optional implementation manner of the embodiment of the present invention, when executed by a processor, the computer-executable instructions implement the following steps of displaying class data with the feature value in a data table by labeling:
class data having the characteristic value is colored in a data table.
As an alternative implementation of the embodiment of the present invention, the computer executable instructions, when executed by the processor, implement the following steps of determining a feature value of class data to be viewed:
receiving a characteristic value of class data input through an input device; or
Receiving one piece of data in the class data to be viewed selected through an input device, and determining the characteristic value of the class data according to the characteristic value of the data.
The embodiment of the invention also provides a terminal for displaying the classified data, which comprises:
a memory to store instructions;
a processor for executing the instructions to perform the steps of the method for displaying assortment data as described in the previous embodiment.
It will be understood by those of ordinary skill in the art 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 (9)
1. A method of displaying assortment data, comprising:
determining a characteristic value of class data to be viewed;
looking up class data with the characteristic value in a data table;
and marking and displaying the class data with the characteristic value in the data table.
2. The method for displaying classified data according to claim 1, wherein the labeling and displaying the class data with the characteristic value in the data table comprises one or more of the following:
class data having the characteristic value is colored in a data table.
3. The method of displaying assortment data according to claim 1 or 2,
there are a plurality of characteristic values for the class data.
4. The method of displaying categorized data according to claim 1, wherein said determining a characteristic value of the category data to be viewed comprises:
receiving a characteristic value of class data to be viewed input through an input device; or
Receiving one piece of data in the class data to be viewed selected through an input device, and determining the characteristic value of the class data according to the characteristic value of the data.
5. A system for displaying assortment data, comprising:
the classification module is used for determining a characteristic value of class data to be viewed;
the searching module is used for searching the class data with the characteristic value in the data table;
and the display module is used for marking and displaying the class data with the characteristic value in the data table.
6. The system for displaying classified data according to claim 5, wherein the display module is configured to label and display the class data with the characteristic value in the data table by one or more of the following manners:
class data having the characteristic value is colored in a data table.
7. The system for displaying categorized data according to claim 5, wherein the categorization module, for determining the characteristic values of the categorized data to be viewed, comprises:
receiving a characteristic value of class data input through an input device; or
Receiving one piece of data in the class data to be viewed selected through an input device, and determining the characteristic value of the class data according to the characteristic value of the data.
8. A computer-readable storage medium storing computer-executable instructions which, when executed by a processor, implement the steps of a method of displaying assortment data according to any one of claims 1 to 4.
9. A terminal for displaying classified data, comprising:
a memory to store instructions;
a processor for executing the instructions to perform the steps of the method of displaying assortment data according to any one of claims 1 to 4.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810796911.8A CN110807054A (en) | 2018-07-19 | 2018-07-19 | Method, system and terminal for displaying classified data |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810796911.8A CN110807054A (en) | 2018-07-19 | 2018-07-19 | Method, system and terminal for displaying classified data |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN110807054A true CN110807054A (en) | 2020-02-18 |
Family
ID=69486622
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201810796911.8A Pending CN110807054A (en) | 2018-07-19 | 2018-07-19 | Method, system and terminal for displaying classified data |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110807054A (en) |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1920810A (en) * | 2005-08-23 | 2007-02-28 | 国际商业机器公司 | Spreadsheet display method and system |
| CN101404009A (en) * | 2008-10-31 | 2009-04-08 | 金蝶软件（中国）有限公司 | Data classification filtering method, system and equipment |
| CN103942299A (en) * | 2014-04-15 | 2014-07-23 | 湖南中烟工业有限责任公司 | Data linkage display device and method |
| CN106415626A (en) * | 2014-05-23 | 2017-02-15 | 微软技术许可有限责任公司 | Group selection initiated from a single item |
| CN107958029A (en) * | 2017-11-17 | 2018-04-24 | 网易乐得科技有限公司 | Link methods of exhibiting, medium, device and computing device |
-
2018
- 2018-07-19 CN CN201810796911.8A patent/CN110807054A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1920810A (en) * | 2005-08-23 | 2007-02-28 | 国际商业机器公司 | Spreadsheet display method and system |
| CN101404009A (en) * | 2008-10-31 | 2009-04-08 | 金蝶软件（中国）有限公司 | Data classification filtering method, system and equipment |
| CN103942299A (en) * | 2014-04-15 | 2014-07-23 | 湖南中烟工业有限责任公司 | Data linkage display device and method |
| CN106415626A (en) * | 2014-05-23 | 2017-02-15 | 微软技术许可有限责任公司 | Group selection initiated from a single item |
| CN107958029A (en) * | 2017-11-17 | 2018-04-24 | 网易乐得科技有限公司 | Link methods of exhibiting, medium, device and computing device |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US8150742B2 (en) | System and method for managing merchandise information | |
| US11475074B2 (en) | Real-time document filtering systems and methods | |
| CN109582192B (en) | Hierarchical menu display method and device | |
| CN106354519A (en) | Method and device for generating label for user portrait | |
| CN106940721B (en) | Data processing method and system for user-defined selection box | |
| US11215476B2 (en) | Gas meter query over internet of things (IOT) | |
| US20150058716A1 (en) | System and method for summarizing documents | |
| CN111026753A (en) | Label storage method and device based on tree structure | |
| CN112465601A (en) | Electronic order generation method and device and storage medium | |
| WO2013173194A1 (en) | A user recommendation method and device | |
| CN110807054A (en) | Method, system and terminal for displaying classified data | |
| JP5912949B2 (en) | Business document processing system and program | |
| CN112579664A (en) | Processing method and device for chart linkage | |
| CN105468575A (en) | Multi-type-based form loading method and system | |
| CN107977459B (en) | Report generation method and device | |
| CN111737369A (en) | Relationship map updating method and device and storage medium | |
| US8112070B2 (en) | Electronic device and method for searching a merchandise location | |
| CN116127154A (en) | Knowledge tag recommendation method and device, electronic equipment and storage medium | |
| US9460190B1 (en) | Attribute value dependent classification of items | |
| CN109325149B (en) | XML message retrieval method and device | |
| CN113688899A (en) | Data fusion method and device, storage medium and electronic equipment | |
| CN110020227B (en) | Data sorting method and device | |
| CN109800385B (en) | Object marking method, electronic equipment, bill and computer readable storage medium | |
| CN113806526B (en) | Feature extraction method, device and storage medium | |
| CN111709210A (en) | Method and device for generating component list, terminal equipment and storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |