CN105005550A - Table generation method and apparatus - Google Patents
Table generation method and apparatus Download PDFInfo
- Publication number
- CN105005550A CN105005550A CN201410158912.1A CN201410158912A CN105005550A CN 105005550 A CN105005550 A CN 105005550A CN 201410158912 A CN201410158912 A CN 201410158912A CN 105005550 A CN105005550 A CN 105005550A
- Authority
- CN
- China
- Prior art keywords
- data
- graph
- correspondence
- sequence
- specifying
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Landscapes
- Image Generation (AREA)
Abstract
According to the invention, a table generation method comprises the following steps of: acquiring table data and acquiring a designated data column which needs to draw a corresponding graph of the table data; drawing a table according to the table data, and separately arranging the table data in cells corresponding to positions of the table data; adding a graph column corresponding to the designated data column to the table; and drawing a graph corresponding to respective data of the designated data column in cells of the graph column, and making a ratio between respective data of each designated data column be equal to a ratio between geometric parameters designated by graphs corresponding to the respective data. According to the above table generation method, specific values of numbers comprised in the table are displayed, and via the graph, relative values of the respective data of the respective data column are intuitively displayed and data trend of the data column is displayed as well, thus displaying multi-dimensional information of the numbers comprised in the table. Furthermore, a table generation apparatus is further provided.
Description
Technical field
The present invention relates to field of computer technology, particularly relate to 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 rows that corresponding figure drawn by the needs of specifying in described list data;
Draw form according to described list data, described list data is arranged in respectively in the cell of described list data correspondence position;
The data rows graph of a correspondence row of specifying are increased in described form;
In figure column unit lattice, draw each data graph of a correspondence in the data rows of specifying, make the ratio that the ratio in each data rows of specifying between each data equals between the geometric parameter of specifying of each data graph of a correspondence.
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 rows that corresponding figure drawn by the needs of specifying in described list data;
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;
Row increase module, for increasing the data rows graph of a correspondence row of specifying in described form;
Graphic plotting module, for drawing each data graph of a correspondence in the data rows of specifying in figure column unit lattice, make the ratio that the ratio in each data rows of specifying between each data equals between the geometric parameter of specifying of each data graph of a correspondence.
Above table generates method and apparatus, increase data rows graph of a correspondence row in the table, and each data graph of a correspondence is drawn in figure column unit lattice, make the ratio that the ratio in each data rows of specifying between each data equals between the geometric parameter of specifying of each data graph of a correspondence, above table generates the concrete size that method and apparatus not only can represent the numeral comprised in form, also show the relative size in each data rows between each data by graph direct ground, show the variation tendency of data in data rows, thus the various dimensions information of the numeral comprised in displaying form.
Accompanying drawing explanation
Fig. 1 is the schematic flow sheet of the form generation method in an embodiment;
Fig. 2 is the schematic diagram of the form that the form generation method in an embodiment generates;
Fig. 3 is the schematic diagram of the form that the form generation method in an embodiment generates;
Fig. 4 is the schematic diagram of the form that the form generation method in an embodiment generates;
Fig. 5 is the schematic diagram of the form that the form generation method in an embodiment generates;
Fig. 6 is the structural representation of the form generating apparatus in an embodiment;
Fig. 7 is the structural representation of graphic plotting module 80 in an embodiment;
Fig. 8 is the structural representation of graphic plotting module 80 in an embodiment;
Fig. 9 is the structural representation of graphic plotting module 80 in an embodiment;
Figure 10 is the structural representation of graphic plotting module 80 in an embodiment;
Figure 11 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, the element in the present invention and assembly, the form that quantity both can be single exists, and form that also can be multiple exists, and the present invention does not limit this.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.Be appreciated that term "and/or" used herein relates to and contains the one or more any and all possible combination in the Listed Items be associated.
As shown in Figure 1, in one embodiment, a kind of form generation method, comprises the following steps:
Step S102, obtains list data, and obtains the data rows that corresponding figure drawn by the needs 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.
In one embodiment, before step S102, above table generation method also comprises step: arrange the row number of the data rows need drawing corresponding figure and the start-stop line number of data rows.Such as, the row number of a certain data rows of setting are 3 and start-stop line number is respectively 2 and 5, then illustrate that in form, in the 3rd column data, second to the 5th data need to draw corresponding figure.
Step S104, draws form according to list data, is arranged in respectively by list data in the cell of list data correspondence position.
Step S106, increases the data rows graph of a correspondence row of specifying in form.
In one embodiment, the right side of the data rows can specified at each increases row, arranges as data rows graph of a correspondence.
Step S108, draws each data graph of a correspondence in the data rows of specifying in figure column unit lattice, makes the ratio that the ratio in each data rows of specifying between each data equals between the geometric parameter of specifying of each data graph of a correspondence.
In one embodiment, the geometric parameter of specifying of figure is the area of figure.
Such as, remember that a certain data rows of specifying comprises data D1, D2 and D3, the area of each data graph of a correspondence is respectively S1, S2 and S3, then D1:D2:D3=S1:S2:S3.
In one embodiment, figure is line segment, square bar, figure sequence or fan-shaped.In one embodiment, figure sequence is point range, triangle sequence, rectangle sequence or star sequence.
When the thickness of each line segment is equal, the area ratio of each line segment is equivalent to the length ratio of each line segment; When the height of each square bar is equal, the area ratio of each square bar is equivalent to the ratio of the width of each square bar; When shape and the equal and opposite in direction of the figure that each figure sequence comprises, the area ratio of each figure sequence is equivalent to the ratio of the figure quantity that each figure sequence comprises; When each fan-shaped radius is equal, each fan-shaped area ratio is equivalent to the ratio of each fan-shaped central angle.
In one embodiment, line segment, figure sequence and the direction of square bar and the line direction of form consistent.The direction of figure sequence refers to the direction of the straight line of the figure in figure sequence.The direction of square bar refers to the direction of square bar extension; The square bar that larger data is corresponding has increase part relative to the square bar corresponding compared with small data, and namely the direction of square bar is the direction increasing part extension.The line direction of form refers to the direction of the straight line through row data.
Because the every data line in the data rows of specifying all will draw graph of a correspondence, if figure is consistent with the column direction of form, then need the height of the every a line increasing form to hold figure, and in the present embodiment, line segment, figure sequence is consistent with the direction of square bar and the line direction of form, do not need the height increasing every a line to hold figure, only need the length increasing row in form, the length increased just equals the width of figure row, therefore form area occupied can be saved, thus also reduce the space of a whole page shown needed for form, adapt to the display screen that mobile terminal size is relatively little.
In one embodiment, step S108 comprises the following steps: calculate the accounting of each data in column data in the data rows of specifying, calculating line segment length corresponding to each data is the long-pending of default maximum length and respective accounting, in graph of a correspondence column unit lattice, draw line segment corresponding to each data according to the line segment length calculated, the thickness of each line segment is equal.
The accounting of some data in column data equals the number percent of these data and column data sum, carry out in the data that computation process comprises in the data rows of specifying herein, namely the data used in computation process are all contained in the data rows of specifying, therefore, above-mentioned column data are also contained in the data rows of specifying.Based on above-mentioned example, the accounting in column data calculating D1 is: D1/ (D1+D2+D3) × 100%.
Wherein, the maximum length preset can be less than or equal to the width of figure column unit lattice.
Line segment length corresponding to any some data is the long-pending of default maximum length and the accounting of this data in column data.
Fig. 2 is the schematic diagram of the form that the form generation method in an embodiment generates." active users/accounting " data rows and " installing amount/accounting " data rows graph of a correspondence row are added in form shown in Fig. 2, and line segment corresponding to each data is drawn in graph of a correspondence column unit lattice, what line segment length was default maximum length with the accounting of corresponding data in column data is long-pending, and the ratio in data rows between each data equals the ratio between corresponding line segment length.
In one embodiment, step S108 comprises the following steps: calculate the accounting of each data in column data in the data rows of specifying, calculating square bar width corresponding to each data is the long-pending of default breadth extreme and respective accounting, in graph of a correspondence column unit lattice, draw square bar corresponding to each data according to the square bar width calculated, the height of each square bar is equal.
Wherein, the breadth extreme preset can be less than or equal to the width of figure column unit lattice.
Square bar width corresponding to any some data is the long-pending of default breadth extreme and the accounting of this data in column data.
Fig. 3 is the schematic diagram of the form that the form generation method in an embodiment generates." active users/accounting " data rows and " installing amount/accounting " data rows graph of a correspondence row are added in form shown in Fig. 3, and in graph of a correspondence column unit lattice, draw square bar corresponding to each data, what square bar length was default maximum length with the accounting of corresponding data in column data is long-pending, and the ratio in data rows between each data equals the ratio between corresponding square bar length.
In one embodiment, step S108 comprises the following steps: calculate the accounting of each data in column data in the data rows of specifying, the figure quantity calculating each data graph of a correspondence sequence is the long-pending of default maximum quantity and respective accounting, in graph of a correspondence column unit lattice, each data graph of a correspondence sequence is drawn, the shape of each figure and equal and opposite in direction according to calculating figure quantity.
The size of single figure can be pre-set, and according to can the maximum figure quantity of array in the size of single figure and the width of figure column unit lattice and high computational figure column unit lattice, and the maximum quantity arranging figure in figure sequence be the maximum figure quantity calculated.The width sum of all figures in figure sequence is less than the width of figure column unit lattice, and its height sum is less than or equal to the height of figure sequence cell.
In any some data graph of a correspondence sequences, figure quantity is the long-pending of default maximum data and the accounting of this data in column data, specifically, long-pending rounding is obtained figure quantity downwards.
Fig. 4 is the schematic diagram of the form that the form generation method in an embodiment generates." active users/accounting " data rows and " installing amount/accounting " data rows graph of a correspondence row are added in form shown in Fig. 4, and in graph of a correspondence column unit lattice, draw each data graph of a correspondence sequence, figure sequence in Fig. 4 is round dot sequence, calculate amassing of maximum quantity and the accounting of corresponding data in column preset, and this each rounding is obtained round dot sequence orbicular spot quantity, the maximum quantity wherein preset and the long-pending width being less than or equal to figure column unit lattice of round dot diameter downwards.Ratio in data rows between each data approximates the ratio between corresponding round dot quantity.
In one embodiment, step S108 comprises the following steps: calculate the accounting of each data in column data in the data rows of specifying, calculating the fan-shaped central angle number of degrees corresponding to each data is 360 ° of long-pending with respective accounting, in graph of a correspondence column unit lattice, draw corresponding fan-shaped of each data described according to the central angle number of degrees calculated, each fan-shaped radius is equal.
Wherein, fan-shaped diameter is less than or equal to height and the width of figure column unit lattice.
The fan-shaped central angle number of degrees corresponding to any some data are 360 ° of long-pending with the accounting of these data in column data.
Fig. 5 is the schematic diagram of the form that the form generation method in an embodiment generates." active users/accounting " data rows and " installing amount/accounting " data rows graph of a correspondence row are added in form shown in Fig. 5, and in graph of a correspondence column unit lattice, draw corresponding fan-shaped of each data, the fan-shaped central angle number of degrees be 360 ° with the accounting of corresponding data in column data and long-pending, the ratio in data rows between each data equals the ratio between the corresponding fan-shaped central angle number of degrees.
In one embodiment, above table generation method also comprises step: the form showing above-mentioned generation.
As shown in Figure 6, in one embodiment, a kind of form generating apparatus, comprises data acquisition module 20, form drafting module 40, row increase module 60 and graphic plotting module 80, wherein:
Data acquisition module 20 for obtaining list data, and obtains the data rows that corresponding figure drawn by the needs of specifying in list data.
In one embodiment, data acquisition module 20 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.
In one embodiment, above table generating apparatus also comprises data area and arranges module (not shown), for the start-stop line number of the row number and data rows that arrange the data rows need drawing corresponding figure.Such as, the row number of a certain data rows of setting are 3 and start-stop line number is respectively 2 and 5, then illustrate that in form, in the 3rd column data, second to the 5th data need to draw corresponding figure.
List data, for drawing form according to list data, is arranged in the cell of list data correspondence position by form drafting module 40 respectively.
Row increase module 60 for increasing the data rows graph of a correspondence row of specifying in form.
In one embodiment, the right side that row increase the data rows that module 60 can be specified at each increases row, arranges as data rows graph of a correspondence.
Graphic plotting module 80, for drawing each data graph of a correspondence in the data rows of specifying in figure column unit lattice, makes the ratio that the ratio in each data rows of specifying between each data equals between the geometric parameter of specifying of each data graph of a correspondence.
In one embodiment, the geometric parameter of specifying of figure is the area of figure.
In one embodiment, figure is line segment, square bar, figure sequence or fan-shaped.In one embodiment, figure sequence is point range, triangle sequence, rectangle sequence or star sequence.
When the thickness of each line segment is equal, the area ratio of each line segment is equivalent to the length ratio of each line segment; When the height of each square bar is equal, the area ratio of each square bar is equivalent to the ratio of the width of each square bar; When shape and the equal and opposite in direction of the figure that each figure sequence comprises, the area ratio of each figure sequence is equivalent to the ratio of the figure quantity that each figure sequence comprises; When each fan-shaped radius is equal, each fan-shaped area ratio is equivalent to the ratio of each fan-shaped central angle.
In one embodiment, line segment, figure sequence and the direction of square bar and the line direction of form consistent.The direction of figure sequence refers to the direction of the straight line of the figure in figure sequence.The direction of square bar refers to the direction of square bar extension; The square bar that larger data is corresponding has increase part relative to the square bar corresponding compared with small data, and namely the direction of square bar is the direction increasing part extension.The line direction of form refers to the direction of the straight line through row data.
Because the every data line in the data rows of specifying all will draw graph of a correspondence, if figure is consistent with the column direction of form, then need the height of the every a line increasing form to hold figure, and in the present embodiment, line segment, figure sequence is consistent with the direction of square bar and the line direction of form, do not need the height increasing every a line to hold figure, only need the length increasing row in form, the length increased just equals the width of figure row, therefore form area occupied can be saved, thus also reduce the space of a whole page shown needed for form, adapt to the display screen that mobile terminal size is relatively little.
As shown in Figure 7, in one embodiment, graphic plotting module 80 comprises accounting computing unit 801, line segment length computing unit 802 and line segment drawing unit 803, wherein
Accounting computing unit 801 is for calculating the accounting of each data in column data in the data rows of specifying, line segment length computing unit 802 is the long-pending of default maximum length and respective accounting for calculating line segment length corresponding to each data, line segment drawing unit 803 for drawing line segment corresponding to each data according to the line segment length calculated in graph of a correspondence column unit lattice, and the thickness of each line segment is equal.
The accounting of some data in column data equals the number percent of these data and column data sum, and above-mentioned column packet is contained in the data rows of specifying.
Wherein, the maximum length preset can be less than or equal to the width of figure column unit lattice.
Line segment length corresponding to any some data is the long-pending of default maximum length and the accounting of this data in column data.
As shown in Figure 8, in one embodiment, graphic plotting module 80 comprises accounting computing unit 801, square bar width calculation unit 804 and square bar drawing unit 805, wherein:
Square bar width calculation unit 804 is the long-pending of default breadth extreme and respective accounting for calculating square bar width corresponding to each data, square bar drawing unit 805 for drawing square bar corresponding to each data according to the square bar width calculated in graph of a correspondence column unit lattice, and the height of each square bar is equal.
Wherein, the breadth extreme preset can be less than or equal to the width of figure column unit lattice.
Square bar width corresponding to any some data is the long-pending of default breadth extreme and the accounting of this data in column data.
As shown in Figure 9, in one embodiment, graphic plotting module 80 comprises accounting computing unit 801, figure amount calculation unit 806 and chart drawing unit 807, wherein:
Figure amount calculation unit 806 is the long-pending of default maximum quantity and respective accounting for calculating the figure quantity of each data graph of a correspondence sequence, chart drawing unit 807 for drawing each data graph of a correspondence sequence, the shape of each figure and equal and opposite in direction according to calculating figure quantity in graph of a correspondence column unit lattice.
In one embodiment, above table generating apparatus also comprises maximum figure quantity and arranges module (not shown), for arranging the size of single figure, and according to can the maximum figure quantity of array in the size of single figure and the width of figure column unit lattice and high computational figure column unit lattice, and the maximum quantity arranging figure in figure sequence be the maximum figure quantity calculated.The width sum of all figures in figure sequence is less than the width of figure column unit lattice, and its height sum is less than or equal to the height of figure sequence cell.
In any some data graph of a correspondence sequences, figure quantity is the long-pending of default maximum data and the accounting of this data in column data, specifically, long-pending rounding is obtained figure quantity downwards.
As shown in Figure 10, in one embodiment, in one embodiment, graphic plotting module 80 comprises accounting computing unit 801, central angle computing unit 808 and fan-shaped drawing unit 809, wherein:
Central angle computing unit 808 is 360 ° of long-pending with respective accounting for calculating the fan-shaped central angle number of degrees corresponding to each data, fan-shaped drawing unit 809 for drawing corresponding fan-shaped of each data described in graph of a correspondence column unit lattice according to the central angle number of degrees calculated, each fan-shaped radius is equal.
Wherein, fan-shaped diameter is less than or equal to height and the width of figure column unit lattice.
The fan-shaped central angle number of degrees corresponding to any some data are 360 ° of long-pending with the accounting of these data in column data.
In one embodiment, above table generating apparatus also comprises display module (not shown), for showing the form generated by data acquisition module 20, form drafting module 40, row increase module 60 and graphic plotting module 80.
Above table generates method and apparatus, increase data rows graph of a correspondence row in the table, and each data graph of a correspondence is drawn in figure column unit lattice, make the ratio that the ratio in each data rows of specifying between each data equals between the geometric parameter of specifying of each data graph of a correspondence, above table generates the concrete size that method and apparatus not only can represent the numeral comprised in form, also show the relative size in each data rows between each data by graph direct ground, show the variation tendency of data in data rows, thus the various dimensions information of the numeral comprised in displaying form.
Further, above table generate method and 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 11 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 11 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, smart phone, 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 11, 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.Computer system 1000 performs following operation by the software instruction that processor 1010 operates in computer-readable medium: obtain list data, and obtain the data rows that corresponding figure drawn by the needs of specifying in described list data; Draw form according to described list data, described list data is arranged in respectively in the cell of described list data correspondence position; The data rows graph of a correspondence row of specifying are increased in described form; In figure column unit lattice, draw each data graph of a correspondence in the data rows of specifying, make the ratio that the ratio in each data rows of specifying between each data equals between the geometric parameter of specifying of each data graph of a correspondence.These software instructions can be read into storer 1020 from memory device 1070 or by lan interfaces 1100 from another equipment.The form generated 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 rows that corresponding figure drawn by the needs of specifying in described list data;
Draw form according to described list data, described list data is arranged in respectively in the cell of described list data correspondence position;
The data rows graph of a correspondence row of specifying are increased in described form;
In figure column unit lattice, draw each data graph of a correspondence in the data rows of specifying, make the ratio that the ratio in each data rows of specifying between each data equals between the geometric parameter of specifying of each data graph of a correspondence.
2. form generation method according to claim 1, is characterized in that, described figure is line segment, square bar, figure sequence or fan-shaped.
3. form generation method according to claim 2, is characterized in that, described figure sequence is point sequence, triangle sequence, rectangle sequence or star sequence.
4. form generation method according to claim 1, is characterized in that, described line segment, described figure sequence are consistent with the line direction of described form with the direction of described square bar.
5. form generation method according to claim 1, it is characterized in that, describedly in figure column unit lattice, draw each data graph of a correspondence in the data rows of specifying, the step of the ratio that the ratio in each data rows of specifying between each data is equaled between the geometric parameter of each data graph of a correspondence comprises:
One of calculate the described accounting of each data in column data, and following step:
What to calculate line segment length corresponding to each data described be default maximum length with respective accounting is long-pending, the line segment that described in drawing in graph of a correspondence column unit lattice according to the line segment length calculated, each data are corresponding, and the thickness of each line segment is equal;
What to calculate square bar width corresponding to each data described be default breadth extreme with respective accounting is long-pending, the square bar that described in drawing in graph of a correspondence column unit lattice according to the square bar width calculated, each data are corresponding, and the height of each square bar is equal;
The figure quantity calculating each data graph of a correspondence sequence described is default maximum quantity and the amassing of respective accounting, in graph of a correspondence column unit lattice, each data graph of a correspondence sequence described is drawn, the shape of each figure and equal and opposite in direction according to calculating figure quantity;
Calculating the fan-shaped central angle number of degrees corresponding to each data described is 360 ° of long-pending with respective accounting, and corresponding fan-shaped of each data described in drawing in graph of a correspondence column unit lattice according to the central angle number of degrees calculated, each fan-shaped radius is equal.
6. a form generating apparatus, is characterized in that, comprising:
Data acquisition module, for obtaining list data, and obtains the data rows that corresponding figure drawn by the needs of specifying in described list data;
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;
Row increase module, for increasing the data rows graph of a correspondence row of specifying in described form;
Graphic plotting module, for drawing each data graph of a correspondence in the data rows of specifying in figure column unit lattice, make the ratio that the ratio in each data rows of specifying between each data equals between the geometric parameter of specifying of each data graph of a correspondence.
7. form generating apparatus according to claim 6, is characterized in that, described figure is line segment, square bar, figure sequence or fan-shaped.
8. form generating apparatus according to claim 7, is characterized in that, described figure sequence is point range, triangle sequence, rectangle sequence or star sequence.
9. form generating apparatus according to claim 6, is characterized in that, described line segment, described figure sequence are consistent with the line direction of described form with the direction of described square bar.
10. form generating apparatus according to claim 6, is characterized in that, described graphic plotting module comprises:
Accounting computing unit, for calculating the described accounting of each data in column data;
Described graphic plotting module also comprises:
Line segment length computing unit, for to calculate line segment length corresponding to each data described be default maximum length and the amassing of respective accounting, and line segment drawing unit, for drawing line segment corresponding to each data described in graph of a correspondence column unit lattice according to the line segment length calculated, the thickness of each line segment is equal; Or,
Square bar width calculation unit, for to calculate square bar width corresponding to each data described be default breadth extreme and the amassing of respective accounting, and square bar drawing unit, for drawing square bar corresponding to each data described in graph of a correspondence column unit lattice according to the square bar width calculated, the height of each square bar is equal; Or,
Figure amount calculation unit, for to calculate the figure quantity of each data graph of a correspondence sequence described be default maximum quantity and the amassing of respective accounting, and chart drawing unit, for drawing each data graph of a correspondence sequence described in graph of a correspondence column unit lattice, the shape of each figure and equal and opposite in direction according to calculating figure quantity; Or,
Central angle computing unit, for calculate the fan-shaped central angle number of degrees corresponding to each data described be 360 ° with the amassing of respective accounting, and fan-shaped drawing unit, for drawing corresponding fan-shaped of each data described in graph of a correspondence column unit lattice according to the central angle number of degrees calculated, each fan-shaped radius is equal.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410158912.1A CN105005550A (en) | 2014-04-18 | 2014-04-18 | Table generation method and apparatus |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410158912.1A CN105005550A (en) | 2014-04-18 | 2014-04-18 | Table generation method and apparatus |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN105005550A true CN105005550A (en) | 2015-10-28 |
Family
ID=54378226
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410158912.1A Pending CN105005550A (en) | 2014-04-18 | 2014-04-18 | Table generation method and apparatus |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN105005550A (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 |
| CN109359255A (en) * | 2018-09-03 | 2019-02-19 | 中国平安人寿保险股份有限公司 | A kind of list data methods of exhibiting and terminal device |
| CN109582941A (en) * | 2018-11-29 | 2019-04-05 | 杭州迪普科技股份有限公司 | A kind of list data display methods, device, equipment and storage medium |
| CN111382559A (en) * | 2020-04-17 | 2020-07-07 | 中交第一公路勘察设计研究院有限公司 | Form self-adaptive drawing method applied to bridge health monitoring |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101065723A (en) * | 2004-11-26 | 2007-10-31 | 菲利普·K·钦 | Method of displaying data in a table |
| CN101576881A (en) * | 2008-05-07 | 2009-11-11 | 万德洪 | Data visualization system and realization method |
| CN102004723A (en) * | 2009-09-02 | 2011-04-06 | 英业达股份有限公司 | Electronic form system with dynamic display and method thereof |
-
2014
- 2014-04-18 CN CN201410158912.1A patent/CN105005550A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101065723A (en) * | 2004-11-26 | 2007-10-31 | 菲利普·K·钦 | Method of displaying data in a table |
| CN101576881A (en) * | 2008-05-07 | 2009-11-11 | 万德洪 | Data visualization system and realization method |
| CN102004723A (en) * | 2009-09-02 | 2011-04-06 | 英业达股份有限公司 | Electronic form system with dynamic display and method thereof |
Non-Patent Citations (3)
| Title |
|---|
| 于保国: ""Excel2007中以数据条显示百分比 于保国制作"", 《百度文库》 * |
| 杨小丽: "《Excel应用大全 全新版》", 31 March 2014, 中国铁道出版社 * |
| 禾爹: ""Excel中显示进度条"", 《百度文库》 * |
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 |
| CN109359255A (en) * | 2018-09-03 | 2019-02-19 | 中国平安人寿保险股份有限公司 | A kind of list data methods of exhibiting and terminal device |
| CN109359255B (en) * | 2018-09-03 | 2023-09-01 | 中国平安人寿保险股份有限公司 | Form data display method and terminal equipment |
| CN109582941A (en) * | 2018-11-29 | 2019-04-05 | 杭州迪普科技股份有限公司 | A kind of list data display methods, device, equipment and storage medium |
| CN111382559A (en) * | 2020-04-17 | 2020-07-07 | 中交第一公路勘察设计研究院有限公司 | Form self-adaptive drawing method applied to bridge health monitoring |
| CN111382559B (en) * | 2020-04-17 | 2023-04-28 | 中交第一公路勘察设计研究院有限公司 | Self-adaptive drawing method of table applied to bridge health monitoring |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106791212B (en) | A kind of control method, device and the mobile terminal of mobile terminal refresh rate | |
| US10884611B2 (en) | Method and apparatus for controlling touch screen of terminal, and terminal | |
| US20120311436A1 (en) | Dynamic display of content using an electronic device | |
| CN107247540B (en) | Application icon adjusting method and device | |
| EP2874054B1 (en) | Application text adjusting method, device, and terminal | |
| TW201351259A (en) | User-resizable icons | |
| TW201435798A (en) | Drawing method, device and terminal | |
| CN103164114A (en) | Method and device of classifying icons of terminal operation interface | |
| CN105447034A (en) | Method and system for generating picture thumbnail | |
| CN109359141B (en) | Visual report data display method and device | |
| CN103164231A (en) | Input method virtual keyboard skin management method and device | |
| CN105005550A (en) | Table generation method and apparatus | |
| CN113010063A (en) | File preview method and device, electronic equipment and storage medium | |
| WO2015096588A1 (en) | Method and device for switching display pages | |
| EP2741196A1 (en) | Power-saving in a portable electronic device operating in a telecommunication network | |
| CN106815274B (en) | Hadoop-based log data mining method and system | |
| CN113986076A (en) | Icon display control method and device, electronic equipment and storage medium | |
| CN105022723A (en) | Table generating method and apparatus | |
| CN106168959A (en) | Page layout method and device | |
| CN104808975A (en) | Filter realizing method and device of camera application | |
| WO2022216426A1 (en) | Management of user interface elements based on historical configuration data | |
| CN106535002B (en) | Desktop starter template layout updating method and device | |
| CN104572667A (en) | Web service system, web server and web providing method | |
| CN105389308A (en) | Display processing method and device for web pages | |
| CN111553962A (en) | Chart display method, system and display equipment |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20151028 |