CN105022723A - Table generating method and apparatus - Google Patents
Table generating method and apparatus Download PDFInfo
- Publication number
- CN105022723A CN105022723A CN201410159296.1A CN201410159296A CN105022723A CN 105022723 A CN105022723 A CN 105022723A CN 201410159296 A CN201410159296 A CN 201410159296A CN 105022723 A CN105022723 A CN 105022723A
- Authority
- CN
- China
- Prior art keywords
- data
- row
- gap
- value
- row 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.)
- Granted
Links
Landscapes
- Image Generation (AREA)
Abstract
A table generating method comprises: acquiring table data and acquiring designated data for which bars need to be drawn in the table data; calculating a bar height corresponding to each data in the designated data and enabling the difference between the each data in the designated data and other data in a line where the data is located to be proportional to the difference between the bar height corresponding to the each data and the bar height corresponding to the other data in the line where the data is located; drawing a table according to the table data; and drawing corresponding longitudinal bars in cells where the designated data is located, wherein the heights of the longitudinal bars are the bar heights corresponding to the data in the cells where the longitudinal bars are located. In the generated table, multi-dimensional information of the table data can be displayed. Furthermore, the present invention further provides a table generating apparatus.
Description
Technical field
The present invention relates to field of computer technology, particularly relate to a kind of form and generate method and apparatus.
Background technology
Form is made up of multiple cell.Item in form is organized as row and column.In form, the cell of same row is for showing the data of same attribute, and the first cell in same row shows the title of this Column Properties, the cell below first cell, then for the value of display column attribute.
Form is one of the most frequently used data processing method, be mainly used in input, export, display, process and print data, may be used for the form document making various complexity, user even can be helped to carry out complicated statistical calculation and pictorialization displaying etc.Form be also usually used in presenting of data in database and edit, data inputting interface, exchanges data, data sheet and distribution etc.
Usually, the numeral comprised in form is all simply be illustrated in cell, the trend of to analyze and observing in form numeral or the accounting understanding data intuitively then need by independently figure, such as histogram, cake chart, curve map etc., form can only show this single information of size of comprised numeral.
Summary of the invention
Based on this, be necessary to provide a kind of form generation method, its form generated can show the various dimensions information of comprised numeral.
A kind of form generation method, comprises the following steps:
Obtain list data, and obtain the data that corresponding post bar drawn by the need of specifying in described list data;
Calculate the post bar height that in the data of specifying, each data are corresponding, make the gap of in the data of specifying each data and the gap of other data of the being expert at post bar height corresponding with each data post bar height corresponding with other data of being expert at proportional;
Draw form according to described list data, described list data is arranged in respectively in the cell of described list data correspondence position;
In the cell at the data place of specifying, draw corresponding longitudinal post bar, the height of described longitudinal post bar is post bar height corresponding to the data in the cell of place.
In addition, there is a need to provide a kind of form generating apparatus, its form generated can show the various dimensions information of comprised numeral.
A kind of form generating apparatus, comprising:
Data acquisition module, for obtaining list data, and obtains the data that corresponding post bar drawn by the need of specifying in described list data;
Post bar high computational module, for calculating the post bar height that in the data of specifying, each data are corresponding, make the gap of in the data of specifying each data and the gap of other data of the being expert at post bar height corresponding with each data post bar height corresponding with other data of being expert at proportional;
Form drafting module, for drawing form according to described list data, is arranged in the cell of described list data correspondence position respectively by described list data;
Post bar drafting module, for drawing corresponding longitudinal post bar in the cell at the data place of specifying, the height of described longitudinal post bar is post bar height corresponding to the data in the cell of place.
Above table generates method and apparatus, not only draw form according to list data, list data is arranged in the cell of correspondence position respectively, but also longitudinal post bar that data in cell in drawing unit lattice are corresponding, the gap of the post bar height that other data of being expert at due to each data post bar height corresponding with each data with the gap of other data that each data are expert at and each data are corresponding is proportional, therefore the relative height between the post bar that in every a line, each data are corresponding can reflect the relative size between each data, therefore, the form that above table generation method and apparatus generates not only can show the concrete numerical values recited of comprised data, but also reflect the relative size in every data line between each data intuitively by the height of longitudinal post bar, thus show the variation tendency of data in form, naturally, the form that above table generation method and apparatus generates can show the various dimensions information of comprised numeral.
Accompanying drawing explanation
Fig. 1 is the schematic flow sheet of the form generation method in an embodiment;
Fig. 2 is the schematic flow sheet of the step S106 of Fig. 1 in an embodiment;
Fig. 3 is the schematic flow sheet of the form generation method in another embodiment;
Fig. 4 is the schematic flow sheet of the step S304 of Fig. 3 in an embodiment;
Fig. 5 is the schematic flow sheet of the step S304 of Fig. 3 in another embodiment;
Fig. 6 is the form schematic diagram that the form generation method in an embodiment generates;
Fig. 7 is the structural representation of the form generating apparatus in an embodiment;
Fig. 8 is the structural representation of the post bar high computational module in an embodiment;
Fig. 9 is the structural representation of the form generating apparatus in another embodiment;
Figure 10 is the structural representation of the color value computing module in an embodiment;
Figure 11 is the structural representation of the color value computing module in another embodiment;
Figure 12 is the module map of a computer system 1000 that can realize the embodiment of the present invention.
Embodiment
In order to make object of the present invention, technical scheme and advantage clearly understand, below in conjunction with drawings and Examples, the present invention is further elaborated.Should be appreciated that specific embodiment described herein only in order to explain the present invention, be not intended to limit the present invention.
Unless context separately has the description of specific distinct.Although the step in the present invention arranges with label, and be not used in and limit the precedence of step, the order of step or the execution of certain step need based on other steps unless expressly stated, otherwise the relative rank of step is adjustable.
As shown in Figure 1, a kind of form generation method, comprises the following steps:
Step S102, obtains list data, and obtains the data that corresponding post bar drawn by the need of specifying in list data.
In one embodiment, list data can be obtained from the data source of specifying, such as, export from the database of specifying, file or application program and obtain list data etc.The first row data of form are generally used for representing row title, and each data in first row are also generally be expert at identification data, and these data generally do not need to draw post bar.Can pre-set the capable N column element of M rise to the capable Q column element of P be the list data need drawing corresponding post article, wherein line number and row number be all more than or equal to M and N and the element that line number and row number are all less than or equal to P and Q be all included in need draw corresponding post bar list data within the scope of, M, N, P and Q are preset value.
Step S106, the post bar height that in computation sheet data, each data are corresponding, the gap of the post bar height that the post bar height making each data and the gap of other data of being expert at corresponding with each data is corresponding with other data of being expert at is proportional.
As shown in Figure 2, in one embodiment, step S106 comprises the following steps:
Step S202, obtains the maximum data in the data of specifying in each row data and minimum data.
Step S204, the most pillar bar height arranging that most huge pillar bar height that the maximum data correspondence in each row data presets and minimum data correspondence preset.
Step S206, calculates the post bar height that other data in each row data are corresponding, and the step calculating the wherein color value that some data are corresponding comprises:
The minimum data that the maximum data of being expert at according to these data, these data, these data are expert at and most huge pillar bar height and post bar height corresponding to most these data of pillar bar high computational, post bar height corresponding to the gap of the post bar height making the gap of the gap of these data and the maximum data that these data are expert at, these data and the minimum data that these data are expert at, these data corresponding and most huge pillar bar height, these data is proportional with the gap of most pillar bar height.
Namely other data in certain data line refer to the data beyond the maximum data of the row data and minimum data.
Step S108, draws form according to list data, is arranged in respectively by list data in the cell of list data correspondence position.
Step S110, draws corresponding longitudinal post bar in the cell at the data place of specifying, and the height of longitudinal post bar is post bar height corresponding to the data in the cell of place.
Above table generation method, not only draw form according to list data, list data is arranged in the cell of correspondence position respectively, but also longitudinal post bar that data in cell in drawing unit lattice are corresponding, the gap of the post bar height that other data of being expert at due to each data post bar height corresponding with each data with the gap of other data that each data are expert at and each data are corresponding is proportional, therefore the relative height between the post bar that in every a line, each data are corresponding can reflect the relative size between each data, therefore, the form that above table generation method and apparatus generates not only can show the concrete numerical values recited of comprised data, but also reflect the relative size in every data line between each data intuitively by the height of longitudinal post bar, thus show the variation tendency of data in form, naturally, the form that above table generation method generates can show the various dimensions information of comprised numeral.
As shown in Figure 3, in one embodiment, a kind of form generation method, comprises the following steps:
Step S302, obtains list data, and obtains the data that corresponding post bar drawn by the need of specifying in list data.
Step S304, calculates the color value that in the data of specifying, each row data are corresponding, and the gap of the color value that the color value making the gap of each row data and other row data in the data of specifying corresponding with each row data is corresponding with other row data is proportional.
Step S306, the post bar height that in computation sheet data, each data are corresponding, the gap of the post bar height that the post bar height making each data and the gap of other data of being expert at corresponding with each data is corresponding with other data of being expert at is proportional.
Step S308, draws form according to list data, is arranged in respectively by list data in the cell of list data correspondence position.
Step S310, draws corresponding longitudinal post bar in the cell at the data place of specifying, and the color value of longitudinal post bar is color values corresponding to the data in the cell of place, and the height of longitudinal post bar is post bar height corresponding to the data in the cell of place.
As shown in Figure 4, in one embodiment, step S304 comprises the following steps:
Step S402, calculates the weighted mean value of each row data in the data of specifying.
Wherein, the step calculating the weighted mean value of certain data line comprises: obtain the weight coefficient preset that the row data are corresponding, each data the row data comprised are multiplied with each self-corresponding weight coefficient, the long-pending addition obtained being multiplied further, again by be added the result that obtains divided by weight coefficient and, obtain weighted mean value.
Step S404, the size of the weighted mean value of more each row data, obtains maximum weighted mean value and minimum weight mean value.
Step S406, the low haze value that the most dark colour value arranging that row data correspondence in maximum weighted mean value place presets and minimum weight mean value place row data correspondence are preset.
Step S408, calculates the color value that in the data of specifying, other row data are corresponding, and the step calculating the wherein color value that certain data line is corresponding comprises:
Calculate color value corresponding to the row data according to the weighted mean value of the row data, maximum weighted mean value, minimum weight mean value and most dark colour value and low haze value, the gap of the color value that the gap of the color value making the weighted mean value of the row data and the gap of maximum weighted mean value, the gap of the weighted mean value of the row data and minimum weight mean value, the row data corresponding and most dark colour value, the row data are corresponding and low haze value is proportional.
Other row data namely refer to maximum weighted mean value in the data of specifying be expert at minimum weight mean value be expert at beyond the data of row.
As shown in Figure 5, in another embodiment, step S304 comprises the following steps:
Step S502, calculates the weighted sum of each row data in the data of specifying.
Wherein, the step calculating the weighted sum of certain data line comprises: obtain the weight coefficient preset that the row data are corresponding, each data the row data comprised are multiplied with each self-corresponding weight coefficient, and the long-pending addition obtained being multiplied further, obtains weighting.
Step S504, the size of the weighted sum of more each row data, obtain maximum weighted and and minimum weight and.
Step S506, arranges most dark colour value and minimum weight that maximum weighted and place row data correspondence preset and the low haze value that row data correspondence in place is preset.
Step S508, calculates the color value that in the data of specifying, other row data are corresponding, and the step calculating the wherein color value that certain data line is corresponding comprises:
According to the weighted sum of the row data, maximum weighted and, minimum weight and and most dark colour value and low haze value calculate color value corresponding to the row data, make the weighted sum of the row data and maximum weighted and gap, the row data weighted sum and described minimum weight and color value corresponding to the gap of color value corresponding to gap, the row data and most dark colour value, the row data and the gap of low haze value proportional.
Other row data namely refer to maximum weighted in the data of specifying and institute be expert at minimum weight be expert at beyond the data of row.
As shown in Figure 6, in form, in unit lattice, not only display data, and depict post bar.Differ with the post bar height in a line cell, and the color of different rows post bar is different.Thus the trend of data is reflected by the height of post bar and the color of post bar, show multidimensional information.
In one embodiment, above table generation method also comprises step: show the form generated.
Above table generation method, not only draw form according to list data, list data is arranged in the cell of correspondence position respectively, but also longitudinal post bar that data in cell in drawing unit lattice are corresponding, because the gap of the color value that each row data are corresponding with each row data with the gap of other row data color value corresponding with other row data is proportional, the relative depth between the color of therefore longitudinal post bar of each row data can reflect the relative size between each row data, in addition, the gap of the post bar height that other data of being expert at due to each data post bar height corresponding with each data with the gap of other data that each data are expert at and each data are corresponding is proportional, therefore the relative height between the post bar that in every a line, each data are corresponding can reflect the relative size between each data, therefore, the form that above table generation method and apparatus generates not only can show the concrete numerical values recited of comprised data, but also reflect the relative size between each row data intuitively by the color of longitudinal post bar, and reflect the relative size in every data line between each data intuitively by the height of longitudinal post bar, thus show the variation tendency of data in form, naturally, the form that above table generation method generates can show the various dimensions information of comprised numeral.
Further, above table generation method effectively by various dimensions information display in limited table area, the space of a whole page shown needed for various dimensions information can be saved, thus the display screen that the size that can adapt to mobile terminal is limited, and save the power consumption of mobile terminal.
As shown in Figure 7, a kind of form generating apparatus, comprises data acquisition module 702, post bar high computational module 706, form drafting module 708 and post bar drafting module 710, wherein:
Data acquisition module 702 for obtaining list data, and obtains the data that corresponding post bar drawn by the need of specifying in list data.
In one embodiment, data acquisition module 702 can obtain list data from the data source of specifying, and such as, exports obtain list data etc. from the database of specifying, file or application program.The first row data of form are generally used for representing row title, and each data in first row are also generally be expert at identification data, and these data generally do not need to draw post bar.Above table generating apparatus also comprises post bar scope of drawing and arranges module (not shown), for arrange the capable N column element of M rise to the capable Q column element of P be the list data need drawing corresponding post article, wherein line number and row number be all more than or equal to M and N and the element that line number and row number are all less than or equal to P and Q be all included in need draw corresponding post bar list data within the scope of, M, N, P and Q are preset value.
As shown in Figure 8, in one embodiment, post bar high computational module 706 comprises extreme value data capture unit 802, post bar height setting unit 804 and post bar height calculation unit 806, wherein:
Extreme value data capture unit 802 is for obtaining maximum data in the data of specifying in each row data and minimum data;
The most pillar bar height that the most huge pillar bar height that post bar height setting unit 804 is preset for the maximum data correspondence arranged in each row data and minimum data correspondence are preset.
Post bar height calculation unit 806 is for calculating post bar height corresponding to other data in each row data, and the process calculating the wherein color value that some data are corresponding comprises:
The minimum data that the maximum data of being expert at according to these data, these data, these data are expert at and most huge pillar bar height and post bar height corresponding to most these data of pillar bar high computational, post bar height corresponding to the gap of the post bar height making the gap of the gap of these data and the maximum data that these data are expert at, these data and the minimum data that these data are expert at, these data corresponding and most huge pillar bar height, these data is proportional with the gap of most pillar bar height.
Namely other data in certain data line refer to the data beyond the maximum data of the row data and minimum data.
List data, for drawing form according to list data, is arranged in the cell of list data correspondence position by form drafting module 708 respectively.
Post bar drafting module 710 for drawing corresponding longitudinal post bar in the cell at the data place of specifying, and the height of longitudinal post bar is post bar height corresponding to the data in the cell of place.
Above table generating apparatus, not only draw form according to list data, list data is arranged in the cell of correspondence position respectively, but also longitudinal post bar that data in cell in drawing unit lattice are corresponding, the gap of the post bar height that other data of being expert at due to each data post bar height corresponding with each data with the gap of other data that each data are expert at and each data are corresponding is proportional, therefore the relative height between the post bar that in every a line, each data are corresponding can reflect the relative size between each data, therefore, the form that above table generation method and apparatus generates not only can show the concrete numerical values recited of comprised data, but also reflect the relative size in every data line between each data intuitively by the height of longitudinal post bar, thus show the variation tendency of data in form, naturally, the form that above table generating apparatus generates can show the various dimensions information of comprised numeral.
As shown in Figure 9, in one embodiment, a kind of form generating apparatus, comprising: data acquisition module 902, color value computing module 904, post bar high computational module 906, form drafting module 908 and post bar drafting module 910, wherein:
Data acquisition module 902 is identical with the function of data acquisition module 702, does not repeat them here.
Color value computing module 904 is for calculating the color value that in the data of specifying, each row data are corresponding, and the gap of the color value that the color value making the gap of each row data and other row data in the data of specifying corresponding with each row data is corresponding with other row data is proportional.
The gap of two data is the absolute value of the difference of two data.The gap of certain data line and other row data can comprise: the gap etc. of the gap of the weighted sum of the row data and other row data weighted sum separately or the weighted mean value of the row data and other row data weighted mean value separately.
As shown in Figure 10, in one embodiment, color value computing module 904 comprises average calculation unit 914, mean value comparing unit 924, first color value setting unit 934 and the first color value computing unit 944, wherein:
Average calculation unit 914 is for calculating the weighted mean value of each row data in the data of specifying.
The process that average calculation unit 914 calculates the weighted mean value of certain data line comprises: obtain the weight coefficient preset that the row data are corresponding, each data the row data comprised are multiplied with each self-corresponding weight coefficient, the long-pending addition obtained being multiplied further, again by be added the result that obtains divided by weight coefficient and, obtain weighted mean value.
Mean value comparing unit 924, for the size of the weighted mean value of more each row data, obtains maximum weighted mean value and minimum weight mean value.
The low haze value that first color value setting unit 934 is preset for the most dark colour value that arranges that row data correspondence in maximum weighted mean value place presets and minimum weight mean value place row data correspondence.
First color value computing unit 944 is for calculating the color value that in the data of specifying, other row data are corresponding, and the process calculating the wherein color value that certain data line is corresponding comprises:
Calculate color value corresponding to the row data according to the weighted mean value of the row data, maximum weighted mean value, minimum weight mean value and most dark colour value and low haze value, the gap of the color value that the gap of the color value making the weighted mean value of the row data and the gap of maximum weighted mean value, the gap of the weighted mean value of the row data and minimum weight mean value, the row data corresponding and most dark colour value, the row data are corresponding and low haze value is proportional.
Other row data namely refer to maximum weighted mean value in the data of specifying be expert at minimum weight mean value be expert at beyond the data of row.
As shown in figure 11, in another embodiment, color value computing module 904 comprises weighted sum computing unit 954, weighted sum comparing unit 964, second color value setting unit 974 and the second color value computing unit 984, wherein:
Weighted sum computing unit 954 is for calculating the weighted sum of each row data in the data of specifying.
Wherein, the step calculating the weighted sum of certain data line comprises: obtain the weight coefficient preset that the row data are corresponding, each data the row data comprised are multiplied with each self-corresponding weight coefficient, and the long-pending addition obtained being multiplied further, obtains weighting.
Weighted sum comparing unit 964 for the size of the weighted sum of more each row data, obtain maximum weighted and and minimum weight and.
The low haze value that second color value setting unit 974 is preset for the most dark colour value that arranges maximum weighted and place row data correspondence and preset and minimum weight and place row data correspondence.
Second color value computing unit 984 is for calculating the color value that in the data of specifying, other row data are corresponding, and the process calculating the wherein color value that certain data line is corresponding comprises:
According to the weighted sum of the row data, maximum weighted and, minimum weight and and most dark colour value and low haze value calculate color value corresponding to the row data, make the weighted sum of the row data and maximum weighted and gap, the row data weighted sum and described minimum weight and color value corresponding to the gap of color value corresponding to gap, the row data and most dark colour value, the row data and the gap of low haze value proportional.
Other row data namely refer to maximum weighted in the data of specifying and institute be expert at minimum weight be expert at beyond the data of row.
Post bar high computational module 906 is identical with the function of form drafting module 708 with post bar high computational module 706 respectively with the function of form drafting module 908, does not repeat them here.
Post bar drafting module 910 for drawing corresponding longitudinal post bar in the cell at the data place of specifying, the color value of longitudinal post bar is color values corresponding to the data in the cell of place, and the height of longitudinal post bar is post bar height corresponding to the data in the cell of place.
In one embodiment, above table generating apparatus also comprises display module (not shown), for showing the form of generation.
Above table generating apparatus, not only draw form according to list data, list data is arranged in the cell of correspondence position respectively, but also longitudinal post bar that data in cell in drawing unit lattice are corresponding, because the gap of the color value that each row data are corresponding with each row data with the gap of other row data color value corresponding with other row data is proportional, the relative depth between the color of therefore longitudinal post bar of each row data can reflect the relative size between each row data, in addition, the gap of the post bar height that other data of being expert at due to each data post bar height corresponding with each data with the gap of other data that each data are expert at and each data are corresponding is proportional, therefore the relative height between the post bar that in every a line, each data are corresponding can reflect the relative size between each data, therefore, the form that above table generating apparatus generates not only can show the concrete numerical values recited of comprised data, but also reflect the relative size between each row data intuitively by the color of longitudinal post bar, and reflect the relative size in every data line between each data intuitively by the height of longitudinal post bar, thus show the variation tendency of data in form, naturally, the form that above table generating apparatus generates can show the various dimensions information of comprised numeral.
Further, above table generating apparatus effectively by various dimensions information display in limited table area, the space of a whole page shown needed for various dimensions information can be saved, thus the display screen that the size that can adapt to mobile terminal is limited, and save the power consumption of mobile terminal.
Figure 12 is the module map of a computer system 1000 that can realize the embodiment of the present invention.This computer system 1000 is an example being applicable to computer environment of the present invention, can not think to propose any restriction to usable range of the present invention.Computer system 1000 can not be interpreted as the combination needing the one or more parts depending on or have in illustrated exemplary computer system 1000.
Computer system 1000 shown in Figure 12 is the examples being suitable for computer system of the present invention.Other framework with different sub-systems configuration also can use.The similar devices such as the desktop computer known by masses, notebook, personal digital assistant, panel computer are such as had to go for some embodiments of the present invention.But be not limited to above cited equipment.
As shown in figure 12, computer system 1000 comprises processor 1010, storer 1020 and system bus 1022.The various system components comprising storer 1020 and processor 1010 are connected on system bus 1022.Processor 1010 is the hardware being used for being performed by arithmetic sum logical operation basic in computer system computer program instructions.Storer 1020 be one for storing the physical equipment of calculation procedure or data (such as, program state information) temporarily or permanently.System bus 1020 can be any one in the bus structure of following several types, comprises memory bus or memory controller, peripheral bus and local bus.Processor 1010 and storer 1020 can carry out data communication by system bus 1022.Wherein storer 1020 comprises ROM (read-only memory) (ROM) or flash memory (all not shown in figure), and random-access memory (ram), and RAM typically refers to the primary memory being loaded with operating system and application program.
Computer system 1000 also comprises display interface 1030(such as, Graphics Processing Unit), display device 1040(such as, liquid crystal display), audio interface 1050(such as, sound card) and audio frequency apparatus 1060(such as, loudspeaker).Display device 1040 and audio frequency apparatus 1060 are the media devices for experiencing content of multimedia.
Computer system 1000 generally comprises a memory device 1070.Memory device 1070 can be selected from multiple computer-readable medium, and computer-readable medium refers to any available medium can accessed by computer system 1000, that comprise movement and fixing two media.Such as, computer-readable medium includes but not limited to, flash memory (miniature SD card), CD-ROM, digital versatile disc (DVD) or other optical disc storage, tape cassete, tape, disk storage or other magnetic storage apparatus, or can be used for storing information needed and other medium any can accessed by computer system 1000.
Computer system 1000 also comprises input media 1080 and input interface 1090(such as, I/O controller).User can pass through input media 1080, and as the touch panel equipment in keyboard, mouse, display device 1040, input instruction and information are in computer system 1000.Input media 1080 is normally connected on system bus 1022 by input interface 1090, but also can be connected by other interface or bus structure, as USB (universal serial bus) (USB).
Computer system 1000 can be carried out logic with one or more network equipment in a network environment and is connected.The network equipment can be PC, server, router, smart phone, panel computer or other common network node.Computer system 1000 is connected with the network equipment by Local Area Network interface 1100 or mobile comm unit 1110.Local Area Network refers in limited area, such as family, school, computer laboratory or use the office building of the network media, the computer network of interconnected composition.WiFi and twisted-pair feeder wiring Ethernet are two kinds of technology of the most frequently used structure LAN (Local Area Network).WiFi is a kind of technology that can make computer system 1000 swapping data or be connected to wireless network by radiowave.Mobile comm unit 1110 can be answered by radio communication diagram while movement and call in a wide geographic area.Except call, mobile comm unit 1110 is also supported in the 2G providing mobile data service, carries out internet access in 3G or 4G cellular communication system.
It should be pointed out that other computer system comprising the subsystem more more or less than computer system 1000 also can be applicable to invention.Such as, computer system 1000 can comprise the bluetooth unit that can exchange data in short distance, for the imageing sensor of taking a picture, and for the accelerometer of acceleration measurement.
As described in detail, be applicable to the command operating of computer system 1000 of the present invention energy executive table generation method above.What computer system 1000 operated in software instruction in computer-readable medium by processor 1010 performs following operation: obtain list data, and obtain the data that corresponding post bar drawn by the need of specifying in described list data; Calculate the post bar height that in the data of specifying, each data are corresponding, make the gap of in the data of specifying each data and the gap of other data of the being expert at post bar height corresponding with each data post bar height corresponding with other data of being expert at proportional; Draw form according to described list data, described list data is arranged in respectively in the cell of described list data correspondence position; In the cell at the data place of specifying, draw corresponding longitudinal post bar, the height of described longitudinal post bar is post bar height corresponding to the data in the cell of place.These software instructions can be read into storer 1020 from memory device 1070 or by lan interfaces 1100 from another equipment.The form drawn shown by display device 1040.
In addition, also the present invention can be realized equally by hardware circuit or hardware circuit in conjunction with software instruction.Therefore, the combination that the present invention is not limited to any specific hardware circuit and software is realized.
The above embodiment only have expressed several embodiment of the present invention, and it describes comparatively concrete and detailed, but therefore can not be interpreted as the restriction to the scope of the claims of the present invention.It should be pointed out that for the person of ordinary skill of the art, without departing from the inventive concept of the premise, can also make some distortion and improvement, these all belong to protection scope of the present invention.Therefore, the protection domain of patent of the present invention should be as the criterion with claims.
Claims (10)
1. a form generation method, comprises the following steps:
Obtain list data, and obtain the data that corresponding post bar drawn by the need of specifying in described list data;
Calculate the post bar height that in the data of specifying, each data are corresponding, make the gap of in the data of specifying each data and the gap of other data of the being expert at post bar height corresponding with each data post bar height corresponding with other data of being expert at proportional;
Draw form according to described list data, described list data is arranged in respectively in the cell of described list data correspondence position;
In the cell at the data place of specifying, draw corresponding longitudinal post bar, the height of described longitudinal post bar is post bar height corresponding to the data in the cell of place.
2. form generation method according to claim 1, it is characterized in that, the post bar height that in the data that described calculating is specified, each data are corresponding, makes the proportional step of the gap of in the data of specifying each data and the gap of other data of the being expert at post bar height corresponding with each data post bar height corresponding with other data of being expert at comprise:
Obtain the maximum data in the data of specifying in each row data and minimum data;
The most pillar bar height that the most huge pillar bar height that the described maximum data correspondence arranged in described each row data is preset and described minimum data correspondence are preset;
Calculate the post bar height that in described each row data, other data are corresponding, the step calculating the wherein color value that some data are corresponding comprises:
The minimum data that the maximum data of being expert at according to these data, these data, these data are expert at and described most huge pillar bar height and post bar height corresponding to most these data of pillar bar high computational, the gap of the post bar height that the gap of the post bar height making the gap of the gap of these data and the maximum data that these data are expert at, these data and the minimum data that these data are expert at, these data corresponding and described most huge pillar bar height, these data are corresponding and described most pillar bar height is proportional.
3. form generation method according to claim 1, is characterized in that, described in the cell at the data place of specifying, draw the step of corresponding longitudinal post bar before, described method also comprises step:
Calculate the color value that in the data of specifying, each row data are corresponding, the gap of the color value that the color value making the gap of each row data and other row data in the data of specifying corresponding with each row data is corresponding with other row data is proportional;
The color value of described longitudinal post bar drawn is color values corresponding to the data in the cell of described longitudinal post bar place.
4. form generation method according to claim 3, it is characterized in that, the color value that in the data that described calculating is specified, each row data are corresponding, makes the proportional step of the gap of the gap of each row data and other row data in the data of the specifying color value corresponding with each row data color value corresponding with other row data comprise:
Calculate the weighted mean value of each row data in the data of specifying;
The size of the weighted mean value of more described each row data, obtains maximum weighted mean value and minimum weight mean value;
The low haze value that the most dark colour value arranging that row data correspondence in described maximum weighted mean value place presets and minimum weight mean value place row data correspondence are preset;
Calculate the color value that in the data of specifying, other row data are corresponding, the step calculating the wherein color value that certain data line is corresponding comprises:
Calculate color value corresponding to the row data according to the weighted mean value of the row data, described maximum weighted mean value, described minimum weight mean value and described most dark colour value and low haze value, the gap of the color value that the gap of the color value making the weighted mean value of the row data and the described gap of maximum weighted mean value, the gap of the weighted mean value of the row data and described minimum weight mean value, the row data corresponding and described most dark colour value, the row data are corresponding and described low haze value is proportional.
5. form generation method according to claim 3, it is characterized in that, the color value that in the data that described calculating is specified, each row data are corresponding, makes the proportional step of the gap of the gap of each row data and other row data in the data of the specifying color value corresponding with each row data color value corresponding with other row data comprise:
Calculate the weighted sum of each row data in the data of specifying;
The size of the weighted sum of more described each row data, obtain maximum weighted and and minimum weight and;
Most dark colour value and minimum weight that described maximum weighted and place row data correspondence preset and the low haze value that row data correspondence in place is preset are set;
Calculate the color value that in the data of specifying, other row data are corresponding, the step calculating the wherein color value that certain data line is corresponding comprises:
According to the weighted sum of the row data, described maximum weighted and, described minimum weight and and described most dark colour value and low haze value calculate color value corresponding to the row data, make the weighted sum of the row data and described maximum weighted and gap, the row data weighted sum and described minimum weight and color value corresponding to the gap of color value corresponding to gap, the row data and described most dark colour value, the row data and the gap of described low haze value proportional.
6. a form generating apparatus, is characterized in that, comprising:
Data acquisition module, for obtaining list data, and obtains the data that corresponding post bar drawn by the need of specifying in described list data;
Post bar high computational module, for calculating the post bar height that in the data of specifying, each data are corresponding, make the gap of in the data of specifying each data and the gap of other data of the being expert at post bar height corresponding with each data post bar height corresponding with other data of being expert at proportional;
Form drafting module, for drawing form according to described list data, is arranged in the cell of described list data correspondence position respectively by described list data;
Post bar drafting module, for drawing corresponding longitudinal post bar in the cell at the data place of specifying, the height of described longitudinal post bar is post bar height corresponding to the data in the cell of place.
7. form generating apparatus according to claim 6, is characterized in that, described post bar high computational module comprises:
Extreme value data capture unit, for obtaining maximum data in the data of specifying in each row data and minimum data;
Post bar height setting unit, the most pillar bar height that the most huge pillar bar height preset for the described maximum data correspondence arranged in described each row data and described minimum data correspondence are preset;
Post bar height calculation unit, for calculating the post bar height that in described each row data, other data are corresponding, the process calculating the wherein color value that some data are corresponding comprises:
The minimum data that the maximum data of being expert at according to these data, these data, these data are expert at and described most huge pillar bar height and post bar height corresponding to most these data of pillar bar high computational, the gap of the post bar height that the gap of the post bar height making the gap of the gap of these data and the maximum data that these data are expert at, these data and the minimum data that these data are expert at, these data corresponding and described most huge pillar bar height, these data are corresponding and described most pillar bar height is proportional.
8. form generating apparatus according to claim 6, is characterized in that, also comprise:
Color value computing module, for calculating the color value that in the data of specifying, each row data are corresponding, the gap of the color value that the color value making the gap of each row data and other row data in the data of specifying corresponding with each row data is corresponding with other row data is proportional;
The color value of described longitudinal post bar that post bar drafting module is drawn is color values corresponding to the data in the cell of described longitudinal post bar place.
9. form generating apparatus according to claim 8, is characterized in that, described color value computing module comprises:
Average calculation unit, for calculating the weighted mean value of each row data in the data of specifying;
Mean value comparing unit, for the size of the weighted mean value of more described each row data, obtains maximum weighted mean value and minimum weight mean value;
First color value setting unit, for the low haze value that the most dark colour value that arranges that row data correspondence in described maximum weighted mean value place presets and minimum weight mean value place row data correspondence are preset;
First color value computing unit, for calculating the color value that in the data of specifying, other row data are corresponding, the process calculating the wherein color value that certain data line is corresponding comprises:
Calculate color value corresponding to the row data according to the weighted mean value of the row data, described maximum weighted mean value, described minimum weight mean value and described most dark colour value and low haze value, the gap of the color value that the gap of the color value making the weighted mean value of the row data and the described gap of maximum weighted mean value, the gap of the weighted mean value of the row data and described minimum weight mean value, the row data corresponding and described most dark colour value, the row data are corresponding and described low haze value is proportional.
10. form generating apparatus according to claim 8, is characterized in that, described color value computing module comprises:
Weighted sum computing unit, for calculating the weighted sum of each row data in the data of specifying;
Weighted sum comparing unit, for the size of the weighted sum of more described each row data, obtain maximum weighted and and minimum weight and;
Second color value setting unit, for arranging most dark colour value and minimum weight that described maximum weighted and place row data correspondence preset and the low haze value that row data correspondence in place is preset;
Second color value computing unit, for calculating the color value that in the data of specifying, other row data are corresponding, the process calculating the wherein color value that certain data line is corresponding comprises:
According to the weighted sum of the row data, described maximum weighted and, described minimum weight and and described most dark colour value and low haze value calculate color value corresponding to the row data, make the weighted sum of the row data and described maximum weighted and gap, the row data weighted sum and described minimum weight and color value corresponding to the gap of color value corresponding to gap, the row data and described most dark colour value, the row data and the gap of described low haze value proportional.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410159296.1A CN105022723B (en) | 2014-04-18 | 2014-04-18 | table generation method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410159296.1A CN105022723B (en) | 2014-04-18 | 2014-04-18 | table generation method and device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN105022723A true CN105022723A (en) | 2015-11-04 |
| CN105022723B CN105022723B (en) | 2018-11-23 |
Family
ID=54412707
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410159296.1A Active CN105022723B (en) | 2014-04-18 | 2014-04-18 | table generation method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN105022723B (en) |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109241170A (en) * | 2018-08-21 | 2019-01-18 | 山东电力高等专科学校 | Electric power big data Visual Dynamic adjusts system |
| CN109543162A (en) * | 2018-10-17 | 2019-03-29 | 金蝶软件（中国）有限公司 | More diagrammatic representation method, apparatus, computer equipment and the storage medium of data |
| CN109582941A (en) * | 2018-11-29 | 2019-04-05 | 杭州迪普科技股份有限公司 | A kind of list data display methods, device, equipment and storage medium |
| CN113391861A (en) * | 2021-05-21 | 2021-09-14 | 军事科学院系统工程研究院网络信息研究所 | Table dynamic drawing method based on android platform |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1416078A (en) * | 2001-10-30 | 2003-05-07 | 艾默生网络能源有限公司 | Data processing method of monitoring system |
| US20110289397A1 (en) * | 2010-05-19 | 2011-11-24 | Mauricio Eastmond | Displaying Table Data in a Limited Display Area |
-
2014
- 2014-04-18 CN CN201410159296.1A patent/CN105022723B/en active Active
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1416078A (en) * | 2001-10-30 | 2003-05-07 | 艾默生网络能源有限公司 | Data processing method of monitoring system |
| US20110289397A1 (en) * | 2010-05-19 | 2011-11-24 | Mauricio Eastmond | Displaying Table Data in a Limited Display Area |
Non-Patent Citations (2)
| Title |
|---|
| MICHAEL THOMPSON: "WebI Tricks: Bars embedded into rows", 《D1-WEBI TRICKS_ BARS EMBEDDED INTO ROWS _ SAP BLOGS（HTTPS://BLOGS.SAP.COM/2010/09/27/WEBI-TRICKS-BARS-EMBEDDED-INTO-ROWS）》 * |
| 刘 闯: "基于LabVIEW的报表生成", 《测控技术》 * |
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109241170A (en) * | 2018-08-21 | 2019-01-18 | 山东电力高等专科学校 | Electric power big data Visual Dynamic adjusts system |
| CN109241170B (en) * | 2018-08-21 | 2020-07-28 | 山东电力高等专科学校 | Power big data visualization dynamic adjustment system |
| CN109543162A (en) * | 2018-10-17 | 2019-03-29 | 金蝶软件（中国）有限公司 | More diagrammatic representation method, apparatus, computer equipment and the storage medium of data |
| CN109543162B (en) * | 2018-10-17 | 2023-11-03 | 金蝶软件（中国）有限公司 | Multi-chart display method and device for data, computer equipment and storage medium |
| CN109582941A (en) * | 2018-11-29 | 2019-04-05 | 杭州迪普科技股份有限公司 | A kind of list data display methods, device, equipment and storage medium |
| CN113391861A (en) * | 2021-05-21 | 2021-09-14 | 军事科学院系统工程研究院网络信息研究所 | Table dynamic drawing method based on android platform |
| CN113391861B (en) * | 2021-05-21 | 2023-12-29 | 军事科学院系统工程研究院网络信息研究所 | Android platform-based form dynamic drawing method |
Also Published As
| Publication number | Publication date |
|---|---|
| CN105022723B (en) | 2018-11-23 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN104615336B (en) | A kind of information processing method and electronic equipment | |
| DE102014010217A1 (en) | Dynamic information customization for a multi-power computing device | |
| CN105447034A (en) | Method and system for generating picture thumbnail | |
| CN104851117A (en) | Method for fusing image with two-dimensional barcode and device thereof | |
| US9524701B2 (en) | Display apparatus and method for processing image thereof | |
| CN101867637A (en) | Method and terminal for dynamically generating standby interface | |
| CN109359141B (en) | Visual report data display method and device | |
| CN105022723A (en) | Table generating method and apparatus | |
| EP3905672B1 (en) | Color space mapping method and device, computer readable storage medium and apparatus | |
| CN106708483B (en) | Method and device for generating control interface of Internet of things equipment | |
| CN107403014A (en) | The display methods of image file, apparatus and system | |
| EP2874054A1 (en) | Application text adjusting method, device, and terminal | |
| WO2015096588A1 (en) | Method and device for switching display pages | |
| EP2741196A1 (en) | Power-saving in a portable electronic device operating in a telecommunication network | |
| CN105005550A (en) | Table generation method and apparatus | |
| WO2015141006A1 (en) | Information processing device, display method and control program | |
| CN107122104B (en) | Data display method and device | |
| US10083164B2 (en) | Adding rows and columns to a spreadsheet using addition icons | |
| CN107678636A (en) | The webpage representation method and apparatus of electronic equipment | |
| CN106535002B (en) | Desktop starter template layout updating method and device | |
| CN105096355A (en) | Image processing method and system | |
| CN117112090A (en) | Business page theme generation method, device, computer equipment, medium and product | |
| CN105389308A (en) | Display processing method and device for web pages | |
| CN104793837A (en) | Picture generation method and device | |
| US10140258B2 (en) | Portable device and image displaying method thereof |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |