A method, apparatus, device, and medium for table processing
By determining the cell range and judgment conditions in table processing and dynamically adjusting the cell style, the problem of low table processing efficiency and effectiveness in the existing technology is solved, and more efficient table setting and processing is achieved.
Patent Information
- Application Number
- CN202111627642.0
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- Filing Date
- 2021-12-28
- Publication Date
- 2025-06-13
- Estimated Expiration
- 2041-12-28
AI Technical Summary
In the prior art, the table processing efficiency and effect are not high enough to meet the more complex and efficient table setting requirements.
By determining the cell range and its judgment conditions, we can determine whether the cell content meets these conditions, and dynamically adjust the cell style according to the conditions that meet.
Improve the effect and efficiency of cell style settings, thereby improving the effect and efficiency of the entire table processing.
Smart Images

Figure CN114297995B_ABST
Abstract
Description
Technical Field
[0001] This application relates to the field of computer technology, and in particular, to a table processing method, apparatus, device, and medium. Background Art
[0002] In the prior art, various table files can be constructed, and there is also a need to set tables.
[0003] In view of this, a more effective and efficient table setting solution is needed. Summary of the Invention
[0004] Embodiments of this specification provide a table processing method, apparatus, device, and medium to solve the technical problem of how to process tables more effectively and efficiently.
[0005] To solve the above technical problem, the embodiments of this specification provide the following technical solutions:
[0006] Embodiments of this specification provide a table processing method, including:
[0007] Determine a cell range and a judgment condition corresponding to the cell range;
[0008] Judge whether the content of each cell within the cell range meets the judgment condition;
[0009] For any cell within the cell range, if the content of the cell meets the judgment condition, the cell is displayed in the style corresponding to the judgment condition.
[0010] Optionally, the method further includes:
[0011] The cell range corresponds to multiple judgment conditions;
[0012] For any cell within the cell range, if the content of the cell meets a certain judgment condition, the cell is displayed in the style corresponding to the certain judgment condition.
[0013] Optionally, determining a cell range and a judgment condition corresponding to the cell range includes:
[0014] Determine the cell range or the judgment condition corresponding to the cell range according to configuration data.
[0015] Optionally, the method further includes:
[0016] Determine the style corresponding to the judgment condition according to configuration data.
[0017] Optionally, making the cell be displayed in the style corresponding to the judgment condition includes:
[0018] If the style includes a cell style, then cause the cell to be displayed according to the cell style;
[0019] Or,
[0020] If the style includes a content style, then cause the content of the cell to be displayed according to the content style;
[0021] Or,
[0022] If the style includes an interaction style, then cause the cell to be displayed according to the interaction style.
[0023] Optionally, the style includes a picture style;
[0024] Causing the cell to be displayed according to the style corresponding to the judgment condition includes:
[0025] Converting the content of the cell into a picture;
[0026] Or,
[0027] Inserting a picture into the cell.
[0028] Optionally, the method further includes:
[0029] The content of the cell changes dynamically. If the content of the cell before the change meets the first judgment condition, then cause the cell before the content change to be displayed according to the style corresponding to the first judgment condition;
[0030] If the content of the cell after the change meets the second judgment condition, then cause the cell after the content change to be displayed according to the style corresponding to the second judgment condition.
[0031] An embodiment of this specification provides a table processing device, including:
[0032] A mapping module, configured to determine a cell range and the judgment condition corresponding to the cell range;
[0033] A judgment module, configured to judge whether the content of each cell within the cell range meets the judgment condition;
[0034] A display module, for any cell within the cell range, if the content of the cell meets the judgment condition, then cause the cell to be displayed according to the style corresponding to the judgment condition.
[0035] An embodiment of this specification provides a table processing device, including:
[0036] At least one processor;
[0037] And,
[0038] A memory communicatively connected to the at least one processor;
[0039] Wherein,
[0040] The memory stores instructions executable by the at least one processor, and when the instructions are executed by the at least one processor, the at least one processor is enabled to execute the above-mentioned table processing method.
[0041] An embodiment of this specification provides a computer-readable storage medium storing computer-executable instructions, and when the computer-executable instructions are executed by a processor, the above-mentioned table processing method is implemented.
[0042] The above-mentioned at least one technical solution adopted in the embodiments of this specification can achieve the following beneficial effects:
[0043] By determining whether the cell content meets the judgment condition and determining the style of the cell content, the above-mentioned technical solution can improve the effect and efficiency of cell style setting, thereby improving the effect and efficiency of table setting, and also improving the effect and efficiency of table processing. BRIEF DESCRIPTION OF THE DRAWINGS
[0044] In order to more clearly illustrate the technical solutions in the embodiments of this specification or the prior art, the following will briefly introduce the drawings required for the description of the embodiments of this specification or the prior art. Obviously, the drawings introduced below are only some of the drawings that may be involved in the embodiments recorded in this specification. For those of ordinary skill in the art, without creative efforts, other drawings can also be obtained based on these drawings.
[0045] Figure 1 It is a schematic diagram of the execution subject of the table processing method in the first embodiment of this specification.
[0046] Figure 2 It is a flowchart of the table processing method in the first embodiment of this specification.
[0047] Figure 3 It is a page schematic diagram in the first embodiment of this specification.
[0048] Figure 4 It is another page schematic diagram in the first embodiment of this specification.
[0049] Figure 5 It is another page schematic diagram in the first embodiment of this specification.
[0050] Figure 6 It is another page schematic diagram in the first embodiment of this specification.
[0051] Figure 7It is another page schematic diagram in the first embodiment of this specification.
[0052] Figure 8 It is another page schematic diagram in the first embodiment of this specification.
[0053] Figure 9 It is another page schematic diagram in the first embodiment of this specification.
[0054] Figure 10 It is another page schematic diagram in the first embodiment of this specification.
[0055] Figure 11 It is another page schematic diagram in the first embodiment of this specification.
[0056] Figure 12 It is a schematic structural diagram of a table processing device in the second embodiment of this specification. Detailed implementation manners
[0057] In order to enable those skilled in the art to better understand the technical solutions in this specification, the technical solutions in the embodiments of this specification will be clearly and completely described below in conjunction with the accompanying drawings of the embodiments of this specification. Obviously, the embodiments described in this specification are only partial embodiments of this application, rather than all embodiments. Based on the embodiments of this specification, all other embodiments obtained by those of ordinary skill in the art without creative efforts shall fall within the scope of protection of this application.
[0058] In the prior art, various table files can be constructed, and there is also a need to set tables, including but not limited to setting the styles of the cell contents of the table.
[0059] The first embodiment of this specification (hereinafter referred to as "Embodiment 1") provides a table processing method. The execution subject of Embodiment 1 can be a terminal (including but not limited to mobile phones, computers, pads, TVs) or a server or an operating system or an application or a table processing platform or a table processing system, etc. That is, the execution subject can be various and can be set, used, or changed according to needs. In addition, a third-party application can assist the execution subject in executing Embodiment 1. For example Figure 1 As shown, the server can execute the table processing method in Embodiment 1, and a corresponding application can be installed on the terminal (held by the user). Data can be transmitted between the terminal or the application and the server, and data can be collected or input or output or page or information processing can be performed (to the user) through the terminal or the application, so as to assist the server in executing the table processing method in Embodiment 1.
[0060] AsFigure 2 As shown in the figure, the table processing method provided by the first embodiment includes:
[0061] S101: (Execution entity) Determine the cell range and the corresponding judgment condition for the cell range;
[0062] In the first embodiment, the execution entity of the first embodiment can display a table (referred to as the target table for convenience). The target table can be created by the execution entity of the first embodiment or created by other devices and sent to the execution entity of the first embodiment. The form or content of the target table can be diverse. For example Figure 3 As shown in the figure, the first embodiment does not limit the form or content of the target table.
[0063] The execution entity of the first embodiment can set the cell range, and the cell range covers one or more cells in the target table. Among them, the execution entity of the first embodiment can determine the cell range according to the configuration data. Specifically, the execution entity of the first embodiment can display the first configuration page, generate the configuration data for the first configuration page according to the user's operation on the first configuration page, and determine the cell range according to the configuration data for the first configuration page. The first configuration page is, for example Figure 4 or Figure 5 As shown in the figure, Figure 4 or Figure 5 The box selection range in the figure can represent the cell range. The first configuration page can provide candidate items, such as candidate items like "All", "Odd rows", "Even rows", "Odd columns", "Even columns". The user can select all cells or cells in odd rows or even rows or odd columns or even columns to form the cell range. For example Figure 4 As shown in the figure; or the user can customize the cell range, such as selecting cells in a certain row or certain rows, a certain column or certain columns to form the cell range. For example Figure 5 As shown in the figure.
[0064] The execution entity of the first embodiment can set the judgment condition corresponding to the cell range. The judgment condition corresponding to the cell range is applicable to the cells within the cell range. Among them, the execution entity of the first embodiment can determine the judgment condition corresponding to the cell range according to the configuration data. Specifically, the execution entity of the first embodiment can display the second configuration page, generate the configuration data for the second configuration page according to the user's operation on the second configuration page, and determine the judgment condition corresponding to the cell range according to the configuration data for the second configuration page.
[0065] The execution entity of the first embodiment can set the styles corresponding to each judgment condition, and the styles can be applied to cells. For any judgment condition, the execution entity of the first embodiment can determine the style corresponding to this judgment condition according to the configuration data. Specifically, the execution entity of the first embodiment can display a third configuration page, generate configuration data for the third configuration page according to the user's operations on the third configuration page, and determine the style corresponding to this judgment condition according to the configuration data of the third configuration page. In the first embodiment, the styles can include cell styles, content styles, and interaction styles. Among them, the cell style is used to represent the style of the cell itself, the content style is used to represent the style of the content of the cell, and the interaction style is used to represent the interaction characteristics of the cell.
[0066] For example, the "General Settings" section in the third configuration page Figure 6 shown below Figure 6 can be used to configure cell styles. When the "General Settings" section is expanded, it can be as shown in Figure 7 below. It is possible to configure the cell size (belonging to the size style), row / column spacing (belonging to the spacing style), filled content (belonging to the filling style), picture content (belonging to the picture style), rounded corner form (belonging to the rounded corner style), margin size (belonging to the margin style), opacity (belonging to the transparency style), whether to enable the table header (belonging to the table header style), etc.
[0067] Figure 6 The "Data" section in it can be used to configure content styles. When the "Data" section is expanded, it can be as shown in Figure 8 below. It is possible to configure the font, line break, alignment method, spacing, etc.
[0068] Figure 6 The "Interaction" section in it can be used to configure interaction styles. When the "Interaction" section is expanded, it can be as shown in Figure 9 below. It is possible to configure interaction methods such as scrolling and carousel. The content of the cell can produce a dynamic effect in the scrolling or carousel mode.
[0069] Users can customize cell styles, content styles, or interaction styles. For example, users can select Figure 7 the "+" in it to add a custom cell style. The custom cell style can be as shown in Figure 10 below. Figure 10 In it, users can customize the cell range, the judgment conditions corresponding to the cell range (such as Figure 10 the judgment - logic - judgment in it) and the various styles corresponding to the judgment conditions. Each time users configure the cell range, judgment conditions, and various styles through Figure 10 it, they can be used as a custom item, as shown in Figure 10 the "Custom 1", "Custom 2",... in the marked box (the marked box is used for marking and is generally notFigure 7 (which comes with it). The same applies to customizing content styles or interaction styles.
[0070] In addition, the target table and the first configuration page, the second configuration page, and the third configuration page can also belong to the same page or different components of the same page. For example Figure 11 as shown.
[0071] S103: (The execution entity) determines whether the content of each cell within the cell range meets the determination condition;
[0072] For any cell range (let's call it the target range), the execution entity in the first embodiment can determine whether the content of each cell within the target range meets the "determination condition corresponding to the target range". For example, if the determination condition corresponding to the target range is that the value of the cell (i.e., the content of the cell, the same below) is greater than 5, then it is determined whether the values of each cell within the target range meet the determination condition of being greater than 5.
[0073] S105: (The execution entity) for any cell within the cell range, if the content of the cell meets the determination condition, then make the cell display according to the style corresponding to the determination condition.
[0074] For any cell within the target range, if the content of the cell meets the determination condition corresponding to the target range, then make the cell display according to the style corresponding to the "determination condition corresponding to the target range".
[0075] Among them, making the cell display according to the style corresponding to the "determination condition corresponding to the target range" may include:
[0076] If the style corresponding to the "determination condition corresponding to the target range" includes a cell style (referred to as the target cell style), then make the cell display according to the target cell style and make the cell have the target cell style;
[0077] Or,
[0078] If the style corresponding to the "determination condition corresponding to the target range" includes a content style (referred to as the target content style), then make the content of the cell display according to the target content style and make the content of the cell have the target content style;
[0079] Or,
[0080] If the style corresponding to the "determination condition corresponding to the target range" includes an interaction style (referred to as the target interaction style), then make the cell display according to the target interaction style and make the cell have the target interaction style.
[0081] In the first embodiment, the target range can correspond to multiple judgment conditions (the multiple judgment conditions are generally mutually exclusive). For any cell within the target range, if the content of the cell meets a certain judgment condition among the "multiple judgment conditions corresponding to the target range", the execution entity of the first embodiment causes the cell to be displayed in the style corresponding to that judgment condition.
[0082] For example, the target range corresponds to three judgment conditions, which are: (1) the value of the cell is greater than or equal to 0 and less than 5; (2) the value of the cell is greater than or equal to 5 and less than 10; (3) the value of the cell is greater than or equal to 10 and less than 15. The style corresponding to judgment condition (1) includes blue font, the style corresponding to judgment condition (2) includes red font, and the style corresponding to judgment condition (3) includes green font. For any cell within the target range, if the content of the cell meets judgment condition (1), the execution entity of the first embodiment causes the value of the cell to be displayed in blue; if the content of the cell meets judgment condition (2), the execution entity of the first embodiment causes the value of the cell to be displayed in red; if the content of the cell meets judgment condition (3), the execution entity of the first embodiment causes the value of the cell to be displayed in green.
[0083] As described above, the style can include a picture style; assuming that the style corresponding to a certain judgment condition is a picture style, causing the cell to be displayed in the style corresponding to that judgment condition can include:
[0084] Converting the content of the cell into a picture. For example, if the content in the cell is the name of an animal, the content of the cell can be converted into an animal picture corresponding to the animal name;
[0085] Or, inserting a picture into the cell. The inserted picture can be related to the content of the cell. Continuing with the above example, if the content in the cell is the name of an animal, the animal picture can be inserted into the cell.
[0086] In the first embodiment, the content of the cells within the target range can change dynamically, that is, the data in the cells can be dynamic data. For example, the data in each cell of the target table represents the traffic flow of each road in a certain city. Then, the target table is docked with the corresponding traffic flow data interface to achieve the change of the content of the cells with the change of the traffic flow in the actual situation.
[0087] The target range may correspond to a judgment condition. For example, the judgment condition is that the traffic flow is greater than 50 vehicles per minute, and the corresponding style of the judgment condition is red font. Then, for any cell within the target range, since the content of this cell changes dynamically, it may cause the content of this cell to change from not meeting this judgment condition to meeting this judgment condition, so that the cell after the content change is displayed according to the style corresponding to this judgment condition; or, the content of this cell changes from meeting this judgment condition to not meeting this judgment condition, so that the cell before the content change is displayed according to the style corresponding to this judgment condition.
[0088] The target range may correspond to multiple judgment conditions. As the content of the cell changes, the judgment conditions met by the content of the cell can also change. In the first embodiment, if the content of a certain cell before a certain change meets the first judgment condition, the execution entity in the first embodiment causes the cell before the content change to be displayed according to the style corresponding to the first judgment condition; if the content of this cell after this change meets the second judgment condition, the execution entity in the first embodiment causes the cell after the content change to be displayed according to the style corresponding to the second judgment condition.
[0089] For example, the target range corresponds to two judgment conditions: "the traffic flow is greater than 50 vehicles per minute" and "the traffic flow is less than 20 vehicles per minute". The corresponding style for the traffic flow being greater than 50 vehicles per minute is red font, and the corresponding style for the traffic flow being less than 20 vehicles per minute is green font. For any cell within the target range, the data of this cell is refreshed every ten minutes, so that the data of this cell can change dynamically. Assume that 10:00 is the refresh time point, and the data of this cell has changed before and after the refresh. Then, if the content of this cell before the refresh (i.e., before the change) meets the condition of "the traffic flow is greater than 50 vehicles per minute", the data of this cell before the refresh is displayed in red; if the content of this cell after the refresh (i.e., after the change) meets the condition of "the traffic flow is less than 20 vehicles per minute", the data of this cell after the refresh is displayed in green.
[0090] In the first embodiment, by determining whether the cell content meets the judgment condition and automatically determining the style of the cell content, the effect and efficiency of cell style setting can be improved, thereby improving the effect and efficiency of table setting, and also improving the effect and efficiency of table processing.
[0091] In the first embodiment, multiple cells can be determined at one time through the cell range. It is possible to batch-judge whether the cell contents within the cell range meet the judgment condition, and it is also possible to batch-modify the styles of the cell contents that meet the judgment condition to the styles corresponding to the judgment condition, further improving the effect and efficiency of table processing.
[0092] In the first embodiment, the cell range may include only one cell, so that it can be determined whether this single cell meets the judgment condition, so as to determine its style. In this way, each cell is actually equivalent to an independent configurable area, and the style of each cell can be determined independently, with higher flexibility.
[0093] In the first embodiment, if the content of the cell changes dynamically, then through the preset judgment condition and the style corresponding to the judgment condition, when the cell content changes, which judgment condition it meets, the cell content will be automatically displayed according to the style corresponding to that judgment condition. Therefore, the first embodiment is particularly suitable for cells with dynamically changing content or tables with dynamically changing cell content, further improving the table processing effect and efficiency. Of course, the first embodiment is also applicable to static cell content.
[0094] As Figure 12 shown, the second embodiment of this specification provides a table processing device corresponding to the table processing method described in the first embodiment, including:
[0095] A mapping module 202, configured to determine a cell range and the judgment condition corresponding to the cell range;
[0096] A judgment module 204, configured to judge whether the content of each cell within the cell range meets the judgment condition;
[0097] A display module 206, for any cell within the cell range, if the content of the cell meets the judgment condition, then make the cell display according to the style corresponding to the judgment condition.
[0098] Optionally, the display module 206 is configured to, if the cell range corresponds to multiple judgment conditions, for any cell within the cell range, if the content of the cell meets a certain judgment condition, then make the cell display according to the style corresponding to that judgment condition.
[0099] Optionally, the device further includes:
[0100] A configuration module, configured to determine the cell range or the judgment condition corresponding to the cell range according to configuration data.
[0101] Optionally, the device further includes:
[0102] A configuration module, configured to determine the style corresponding to the judgment condition according to configuration data.
[0103] Optionally, making the cell display according to the style corresponding to the judgment condition includes:
[0104] If the style includes a cell style, then make the cell display according to the cell style;
[0105] Or,
[0106] If the style includes a content style, display the content of the cell according to the content style;
[0107] Or,
[0108] If the style includes an interaction style, display the cell according to the interaction style.
[0109] Optionally, the style includes a picture style;
[0110] Displaying the cell according to the style corresponding to the judgment condition includes:
[0111] Convert the content of the cell into a picture;
[0112] Or,
[0113] Insert a picture into the cell.
[0114] Optionally, the display module 206 is configured to, if the content of the cell changes dynamically and the content before the change of the cell meets the first judgment condition, display the cell before the content change according to the style corresponding to the first judgment condition;
[0115] If the content after the change of the cell meets the second judgment condition, display the cell after the content change according to the style corresponding to the second judgment condition.
[0116] The third embodiment of this specification provides a table processing device, including:
[0117] At least one processor;
[0118] And,
[0119] A memory communicatively connected to the at least one processor;
[0120] Wherein,
[0121] The memory stores instructions executable by the at least one processor, and when the instructions are executed by the at least one processor, the at least one processor is enabled to execute the table processing method described in the first embodiment.
[0122] The fourth embodiment of this specification provides a computer-readable storage medium, and the computer-readable storage medium stores computer-executable instructions, and when the computer-executable instructions are executed by a processor, the table processing method described in the first embodiment is implemented.
[0123] The above embodiments can be combined for use, and modules with the same name between different embodiments or within the same embodiment can be the same or different modules.
[0124] The above description has been made of specific embodiments of this specification, and other embodiments are within the scope of the appended claims. In some cases, the actions or steps recited in the claims may be performed in a different order than in the embodiments and still achieve the desired result. Additionally, the processes depicted in the drawings do not necessarily have to be performed in the particular order or continuous order shown to achieve the desired result. In certain embodiments, multitasking and parallel processing are also possible or may be advantageous.
[0125] The various embodiments in this specification are described in a progressive manner. For the parts that are the same or similar among the various embodiments, reference can be made to each other. Each embodiment focuses on the differences from other embodiments. In particular, for the embodiments of the apparatus, device, and non-volatile computer-readable storage medium, since they are basically similar to the method embodiments, the description is relatively simple, and reference can be made to the relevant parts of the method embodiments for the related content.
[0126] The apparatus, device, and non-volatile computer-readable storage medium provided in the embodiments of this specification correspond to the method. Therefore, the apparatus, device, and non-volatile computer storage medium also have beneficial technical effects similar to those of the corresponding method. Since the beneficial technical effects of the method have been described in detail above, the beneficial technical effects of the corresponding apparatus, device, and non-volatile computer storage medium will not be elaborated here.
[0127] In the 1990s, it was possible to clearly distinguish whether an improvement in a technology was a hardware improvement (e.g., improvement in circuit structures such as diodes, transistors, switches, etc.) or a software improvement (improvement in method processes). However, with the development of technology, many improvements in method processes today can be regarded as direct improvements in hardware circuit structures. Almost all designers obtain the corresponding hardware circuit structures by programming the improved method processes into the hardware circuits. Therefore, it cannot be said that an improvement in a method process cannot be implemented with a hardware entity module. For example, a Programmable Logic Device (PLD) (such as a Field Programmable Gate Array (FPGA)) is such an integrated circuit whose logical function is determined by the user programming the device. The designer can program by himself / herself to "integrate" a digital system on a PLD, without having to ask a chip manufacturer to design and fabricate a dedicated integrated circuit chip. Moreover, nowadays, instead of manually fabricating integrated circuit chips, this programming is mostly implemented using "logic compiler" software, which is similar to the software compiler used in program development and writing. The original code before compilation also has to be written in a specific programming language, which is called a Hardware Description Language (HDL), and there is not only one kind of HDL, but many kinds, such as ABEL (Advanced Boolean Expression Language), AHDL (Altera Hardware Description Language), Confluence, CUPL (Cornell University Programming Language), HDCal, JHDL (Java Hardware Description Language), Lava, Lola, MyHDL, PALASM, RHDL (Ruby Hardware Description Language), etc. Currently, the most commonly used are VHDL (Very-High-Speed Integrated Circuit Hardware Description Language) and Verilog. Those skilled in the art should also be aware that by simply performing a little logical programming on the method process with the above-mentioned several hardware description languages and programming it into the integrated circuit, it is easy to obtain the hardware circuit that implements the logical method process.
[0128] The controller can be implemented in any suitable manner. For example, the controller can take the form of, for example, a microprocessor or a processor and a computer-readable medium storing computer-readable program code (such as software or firmware) executable by the (micro)processor, logic gates, switches, an application specific integrated circuit (ASIC), a programmable logic controller, and an embedded microcontroller. Examples of the controller include, but are not limited to, the following microcontrollers: ARC 625D, Atmel AT91SAM, Microchip PIC18F26K20, and Silicone Labs C8051F320. The memory controller can also be implemented as part of the control logic of the memory. Those skilled in the art also know that in addition to implementing the controller in the form of pure computer-readable program code, it is entirely possible to logically program the method steps to enable the controller to be implemented in the form of logic gates, switches, application specific integrated circuits, programmable logic controllers, and embedded microcontrollers to achieve the same function. Therefore, such a controller can be considered a hardware component, and the devices included therein for implementing various functions can also be regarded as the structures within the hardware component. Or even, the devices for implementing various functions can be regarded as either software modules for implementing the method or the structures within the hardware component.
[0129] The systems, devices, modules, or units illustrated in the above embodiments can be specifically implemented by computer chips or entities, or by products with certain functions. A typical implementation device is a computer. Specifically, the computer can be, for example, a personal computer, a laptop computer, a cellular phone, a camera phone, a smart phone, a personal digital assistant, a media player, a navigation device, an email device, a game console, a tablet computer, a wearable device, or any combination of these devices.
[0130] For the convenience of description, when describing the above devices, they are described separately as various units according to their functions. Of course, when implementing this specification, the functions of each unit can be implemented in the same or multiple software and / or hardware.
[0131] Those skilled in the art should understand that the embodiments of this specification can be provided as a method, a system, or a computer program product. Therefore, the embodiments of this specification can take the form of a complete hardware embodiment, a complete software embodiment, or an embodiment combining software and hardware aspects. Moreover, the embodiments of this specification can take the form of a computer program product implemented on one or more computer-usable storage media (including but not limited to disk memories, CD-ROMs, optical memories, etc.) containing computer-usable program code.
[0132] This specification is described with reference to the flowcharts and / or block diagrams of methods, apparatuses (systems), and computer program products according to embodiments of the specification. It should be understood that each flow and / or block in the flowchart and / or block diagram, and the combination of flows and / or blocks in the flowchart and / or block diagram, can be implemented by computer program instructions. These computer program instructions can be provided to the processors of general-purpose computers, special-purpose computers, embedded processors, or other programmable data processing devices to generate a machine, such that the instructions executed by the processors of the computer or other programmable data processing devices generate means for implementing the functions specified in one flow Figure 1 one flow or multiple flows and / or blocks Figure 1 or means for implementing the functions specified in one block or multiple blocks.
[0133] These computer program instructions can also be stored in a computer-readable memory that can direct a computer or other programmable data processing device to work in a specific manner, such that the instructions stored in the computer-readable memory generate a manufactured article including instruction means that implement the functions specified in one flow Figure 1 one flow or multiple flows and / or blocks Figure 1 or means for implementing the functions specified in one block or multiple blocks.
[0134] These computer program instructions can also be loaded onto a computer or other programmable data processing device, such that a series of operation steps are executed on the computer or other programmable device to generate a computer-implemented process, and thus the instructions executed on the computer or other programmable device provide steps for implementing the functions specified in one flow Figure 1 one flow or multiple flows and / or blocks Figure 1 or means for implementing the functions specified in one block or multiple blocks.
[0135] In a typical configuration, a computing device includes one or more processors (CPUs), an input / output interface, a network interface, and a memory.
[0136] The memory may include non-permanent memory in the form of computer-readable media, random access memory (RAM), and / or non-volatile memory such as read-only memory (ROM) or flash memory (flash RAM). The memory is an example of computer-readable media.
[0137] Computer readable media include permanent and non-permanent, removable and non-removable media that can be implemented by any method or technology to store information. Information can be computer readable instructions, data structures, program modules or other data. Examples of computer storage media include, but are not limited to, phase change memory (PRAM), static random access memory (SRAM), dynamic random access memory (DRAM), other types of random access memory (RAM), read-only memory (ROM), electrically erasable programmable read-only memory (EEPROM), flash memory or other memory technology, compact disk read-only memory (CD-ROM), digital versatile disk (DVD) or other optical storage, magnetic cassettes, magnetic disk storage or other magnetic storage devices or any other non-transmission media that can be used to store information that can be accessed by a computing device. As defined herein, computer readable media does not include temporary computer readable media (transitory media), such as modulated data signals and carrier waves.
[0138] It should also be noted that the terms "include", "comprises" or any other variations thereof are intended to cover non-exclusive inclusion, so that a process, method, commodity or device including a series of elements includes not only those elements, but also other elements not explicitly listed, or also includes elements inherent to such process, method, commodity or device. In the absence of more restrictions, the elements defined by the sentence "comprises a ..." do not exclude the existence of other identical elements in the process, method, commodity or device including the elements.
[0139] This specification may be described in the general context of computer-executable instructions executed by a computer, such as program modules. Generally, program modules include routines, programs, objects, components, data structures, etc. that perform specific tasks or implement specific abstract data types. This specification may also be practiced in distributed computing environments where tasks are performed by remote processing devices connected through a communication network. In a distributed computing environment, program modules may be located in local and remote computer storage media, including storage devices.
[0140] Each embodiment in this specification is described in a progressive manner, and the same or similar parts between the embodiments can be referred to each other, and each embodiment focuses on the differences from other embodiments. In particular, for the system embodiment, since it is basically similar to the method embodiment, the description is relatively simple, and the relevant parts can be referred to the partial description of the method embodiment.
[0141] The above description is only for the embodiments of this specification and is not intended to limit this application. For those skilled in the art, various changes and modifications can be made to this application. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of this application shall be included within the scope of the claims of this application.
Claims
1. A table processing method, comprising: displaying a target table; displaying a first configuration page, generating configuration data for the first configuration page according to the user's operation on the first configuration page, and determining a cell range according to the configuration data for the first configuration page; the cell range covers one or more cells in the target table; displaying a second configuration page, generating configuration data for the second configuration page according to the user's operation on the second configuration page, and determining a judgment condition corresponding to the cell range according to the configuration data for the second configuration page; displaying a third configuration page, generating configuration data for the third configuration page according to the user's operation on the third configuration page, and determining a style corresponding to the judgment condition according to the configuration data for the third configuration page; judging whether the content of each cell within the cell range conforms to the judgment condition corresponding to the cell range; for any cell within the cell range, if the content of the cell conforms to the judgment condition, then display the cell according to the style corresponding to the judgment condition.
2. The method according to claim 1, the method further comprising: the cell range corresponds to multiple judgment conditions; for any cell within the cell range, if the content of the cell conforms to a certain judgment condition, then display the cell according to the style corresponding to the certain judgment condition.
3. The method according to claim 1, displaying the cell according to the style corresponding to the judgment condition comprising: if the style includes a cell style, then display the cell according to the cell style; or, if the style includes a content style, then display the content of the cell according to the content style; or, if the style includes an interaction style, then display the cell according to the interaction style.
4. The method according to claim 1, the style includes a picture style; displaying the cell according to the style corresponding to the judgment condition includes: converting the content of the cell into a picture; or, inserting a picture into the cell.
5. The method according to any one of claims 1 to 4, the method further comprising: the content of the cell changes dynamically, if the content of the cell before the change conforms to a first judgment condition, then display the cell before the content change according to the style corresponding to the first judgment condition; if the content of the cell after the change conforms to a second judgment condition, then display the cell after the content change according to the style corresponding to the second judgment condition.
6. A table processing device, comprising: a mapping module for displaying a target table; displaying a first configuration page, generating configuration data for the first configuration page according to the user's operation on the first configuration page, and determining a cell range according to the configuration data for the first configuration page; the cell range covers one or more cells in the target table; Display a second configuration page, generate configuration data for the second configuration page according to the user's operations on the second configuration page, and determine the judgment condition corresponding to the cell range according to the configuration data for the second configuration page; Display a third configuration page, generate configuration data for the third configuration page according to the user's operations on the third configuration page, and determine the style corresponding to the judgment condition according to the configuration data for the third configuration page; A judgment module, configured to judge whether the content of each cell within the cell range conforms to the judgment condition corresponding to the cell range; A display module, for any cell within the cell range, if the content of the cell conforms to the judgment condition, then display the cell according to the style corresponding to the judgment condition.
7. A table processing device, comprising: At least one processor; and, A memory communicatively connected to the at least one processor; wherein, The memory stores instructions executable by the at least one processor, and when the instructions are executed by the at least one processor, the at least one processor is enabled to execute the table processing method according to any one of claims 1 to 5.
8. A computer-readable storage medium storing computer-executable instructions, and when the computer-executable instructions are executed by a processor, the table processing method according to any one of claims 1 to 5 is implemented.
Citation Information
Patent Citations
Method and system for generating parameterized report
CN102841938A
Report file processing method, server and system
CN103150647A