CN109977380A - Chart generation method, device, computer equipment and storage medium - Google Patents
Chart generation method, device, computer equipment and storage medium Download PDFInfo
- Publication number
- CN109977380A CN109977380A CN201910015357.XA CN201910015357A CN109977380A CN 109977380 A CN109977380 A CN 109977380A CN 201910015357 A CN201910015357 A CN 201910015357A CN 109977380 A CN109977380 A CN 109977380A
- Authority
- CN
- China
- Prior art keywords
- chart
- data
- parameter
- type
- conversion parameter
- 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
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/186—Templates
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q40/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
- G06Q40/08—Insurance
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- Finance (AREA)
- General Engineering & Computer Science (AREA)
- General Health & Medical Sciences (AREA)
- Computational Linguistics (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Accounting & Taxation (AREA)
- Economics (AREA)
- General Business, Economics & Management (AREA)
- Technology Law (AREA)
- Strategic Management (AREA)
- Marketing (AREA)
- Development Economics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The embodiment of the invention discloses a kind of chart generation method, device, computer equipment and storage medium, include the following steps: to obtain chart data information to be processed, wherein the chart data information includes the type of the chart data；Conversion parameter is chosen from preset template graph according to the type of the chart data；The chart data is converted into chart according to the conversion parameter.Conversion parameter is automatically selected in template graph according to the type, and chart data is converted into chart according to conversion parameter after recognizing the type of pending data by the way that template graph is arranged.When this method needs Transformation Graphs tableau format under different scenes, conversion parameter can be modified automatically, to generate the chart of different formats.This method is not only simple, flexible, but also also eliminates a large amount of manual operation.
Description
Technical field
The present embodiments relate to financial field, especially a kind of chart generation method, device, computer equipment and storage
Medium.
Background technique
Dividend Xian Zhi insurance company is after each fiscal year, by dividing for such share bonus and insurance of a upper fiscal year
With surplus, according to a certain percentage, by cash bonus or increment bonus in a manner of, distribute to a kind of insurance products of client.
In the prior art, to user carry out share out bonus danger introduce when, usually by way of to project team, to participate in this
The sales force of mesh sale gives training, then carries out the basic introduction of insurance products to visiting client by them.
The inventor of the invention has found under study for action, and insurance kind is introduced by the way of artificial in the prior art
When, according to peopleware and the Grasping level of technical ability, there is the uneven phenomenon of level, particularly with each stage interests and difference
Horizontal bonus of sharing out bonus calculates, and often can not make quick answer according to the actual demand of user, lead to customer churn.
Summary of the invention
The embodiment of the present invention provides a kind of chart generation method, device, computer equipment and storage medium.
In order to solve the above technical problems, the technical solution that the embodiment of the invention uses is: providing a kind of figure
Table generating method includes the following steps:
Obtain chart data information to be processed, wherein the chart data information includes the type of the chart data；
Conversion parameter is chosen from preset template graph according to the type of the chart data；
The chart data is converted into chart according to the conversion parameter.
Optionally, the conversion parameter is format parameter；The type according to the chart data is from preset chart
Conversion parameter is chosen in template, is included the following steps:
Type keyword is extracted from the chart data information；
The format parameter with the type Keywords matching is chosen from the template graph.
Optionally, the conversion parameter includes: format parameter and parameters of formula；The type according to the chart data
Conversion parameter is chosen from preset template graph, is included the following steps:
Obtain the format parameter of the chart data；
Parameters of formula is determined according to the result type that the format parameter worked upon data is characterized.
Optionally, the conversion parameter is format parameter；It is described to be converted the chart data according to the conversion parameter
For chart, include the following steps:
The first object cell region of the format parameter effect is extracted from the template graph；
It is chosen and the first object cell regional location identical first from the document where the chart data
Target data；
The first object data are converted into chart according to the format parameter.
Optionally, the conversion parameter is format parameter and parameters of formula；It is described according to the conversion parameter by the figure
Table data are converted to chart, include the following steps:
The second Set cell region of the parameters of formula effect is extracted from the template graph；
It is chosen and the second Set cell regional location identical second from the document where the chart data
Target data；
Second target data is carried out that third target data is calculated according to the parameters of formula；
The third target data is converted into chart according to the format parameter.
Optionally, the chart data is read by the open source code function library of software foundation.To solve above-mentioned technology
Problem, the embodiment of the present invention also provide a kind of chart generating means, comprising:
Module is obtained, for obtaining chart data information to be processed, wherein the chart data information includes the figure
The type of table data；
Processing module, for choosing conversion parameter from preset template graph according to the type of the chart data；
Execution module, for the chart data to be converted to chart according to the conversion parameter.
Optionally, the conversion parameter is format parameter；The processing module includes:
First acquisition submodule, for extracting type keyword from the chart data information；
First processing submodule, joins for choosing from the template graph with the format of the type Keywords matching
Number.
Optionally, the conversion parameter includes: format parameter and parameters of formula；The processing module includes:
Second acquisition submodule, for obtaining the format parameter of the chart data；
Second processing submodule, the result type for being characterized according to the format parameter worked upon data determine that formula is joined
Number.
Optionally, the conversion parameter is format parameter；The execution module includes:
Third acquisition submodule, for extracting the first object unit of the format parameter effect from the template graph
Lattice region；
4th acquisition submodule, for being chosen and the first object cell from the document where the chart data
The identical first object data of regional location；
Third handles submodule, for the first object data to be converted to chart according to the format parameter.
Optionally, the conversion parameter is format parameter and parameters of formula；The execution module includes:
5th acquisition submodule, for extracting the second object element of the parameters of formula effect from the template graph
Lattice region；
Fourth process submodule, for being chosen and second Set cell from the document where the chart data
Identical second target data of regional location；
First implementation sub-module, for second target data carrying out that third is calculated according to the parameters of formula
Target data；
Second implementation sub-module, for the third target data to be converted to chart according to the format parameter.
Optionally, further includes:
6th acquisition submodule, for reading the chart data by the open source code function library of software foundation.
In order to solve the above technical problems, the embodiment of the present invention also provides a kind of computer equipment, including memory and processing
Device is stored with computer-readable instruction in the memory, when the computer-readable instruction is executed by the processor, so that
The processor executes the step of chart generation method described above.
In order to solve the above technical problems, the embodiment of the present invention also provides a kind of storage Jie for being stored with computer-readable instruction
Matter, when the computer-readable instruction is executed by one or more processors, so that one or more processors execute above-mentioned institute
The step of stating chart generation method.
The beneficial effect of the embodiment of the present invention is: by the way that template graph, after recognizing the type of chart data, root is arranged
Conversion parameter is automatically selected in template graph according to the type, and chart data is converted into chart according to conversion parameter.The party
When method needs Transformation Graphs tableau format under different scenes, conversion parameter can be modified automatically, to generate different formats
Chart.This method is not only simple, flexible, but also also eliminates a large amount of manual operation.
Detailed description of the invention
To describe the technical solutions in the embodiments of the present invention more clearly, make required in being described below to embodiment
Attached drawing is briefly described, it should be apparent that, drawings in the following description are only some embodiments of the invention, for
For those skilled in the art, without creative efforts, it can also be obtained according to these attached drawings other attached
Figure.
Fig. 1 is the basic procedure schematic diagram of implementation example figure table generating method provided in an embodiment of the present invention；
Fig. 2 is that a kind of type according to chart data provided in an embodiment of the present invention is chosen turn from preset template graph
Change the basic procedure schematic diagram of the method for parameter；
Fig. 3 is that a kind of type according to chart data provided in an embodiment of the present invention is chosen turn from preset template graph
Change the basic procedure schematic diagram of the method for parameter；
Fig. 4 is a kind of base for the method that chart data is converted to chart according to conversion parameter provided in an embodiment of the present invention
This flow diagram；
Fig. 5 is another method that chart data is converted to chart according to conversion parameter provided in an embodiment of the present invention
Basic procedure schematic diagram；
Fig. 6 is chart generating means basic structure block diagram provided in an embodiment of the present invention；
Fig. 7 is computer equipment basic structure block diagram provided in an embodiment of the present invention.
Specific embodiment
In order to enable those skilled in the art to better understand the solution of the present invention, below in conjunction in the embodiment of the present invention
Attached drawing, technical scheme in the embodiment of the invention is clearly and completely described.
In some processes of the description in description and claims of this specification and above-mentioned attached drawing, contain according to
Multiple operations that particular order occurs, but it should be clearly understood that these operations can not be what appears in this article suitable according to its
Sequence is executed or is executed parallel, and serial number of operation such as 101,102 etc. is only used for distinguishing each different operation, serial number
It itself does not represent and any executes sequence.In addition, these processes may include more or fewer operations, and these operations can
To execute or execute parallel in order.It should be noted that the description such as " first " herein, " second ", is for distinguishing not
Same message, equipment, module etc., does not represent sequencing, does not also limit " first " and " second " and be different type.
Following will be combined with the drawings in the embodiments of the present invention, and technical solution in the embodiment of the present invention carries out clear, complete
Site preparation description, it is clear that described embodiments are only a part of the embodiments of the present invention, instead of all the embodiments.It is based on
Embodiment in the present invention, those skilled in the art's every other implementation obtained without creative efforts
Example, shall fall within the protection scope of the present invention.
Embodiment
Those skilled in the art of the present technique are appreciated that " terminal " used herein above, " terminal device " both include wireless communication
The equipment of number receiver, only has the equipment of the wireless signal receiver of non-emissive ability, and including receiving and emitting hardware
Equipment, have on bidirectional communication link, can execute two-way communication reception and emit hardware equipment.This equipment
It may include: honeycomb or other communication equipments, shown with single line display or multi-line display or without multi-line
The honeycomb of device or other communication equipments；PCS (Personal Communications Service, PCS Personal Communications System), can
With combine voice, data processing, fax and/or communication ability；PDA (PersonalDigital Assistant, it is personal
Digital assistants), it may include radio frequency receiver, pager, the Internet/intranet access, web browser, notepad, day
It goes through and/or GPS (Global Positioning System, global positioning system) receiver；Conventional laptop and/or palm
Type computer or other equipment, have and/or the conventional laptop including radio frequency receiver and/or palmtop computer or its
His equipment." terminal " used herein above, " terminal device " can be it is portable, can transport, be mounted on the vehicles (aviation,
Sea-freight and/or land) in, or be suitable for and/or be configured in local runtime, and/or with distribution form, operate in the earth
And/or any other position operation in space." terminal " used herein above, " terminal device " can also be communication terminal, on
Network termination, music/video playback terminal, such as can be PDA, MID (Mobile Internet Device, mobile Internet
Equipment) and/or mobile phone with music/video playing function, it is also possible to the equipment such as smart television, set-top box.
Client terminal in present embodiment is above-mentioned terminal.
Specifically, referring to Fig. 1, Fig. 1 is the basic procedure schematic diagram of the present embodiment chart generation method.
As shown in Figure 1, chart generation method includes the following steps:
S1100, chart data information is obtained, wherein include the type of chart data in chart data information；
Chart data is the initial data for needing to convert data to chart, for example, the data in Excel document.In general,
Data source in chart data document is in the ephemeral data of database Oracle, MySql etc., or dynamic change.
In one embodiment, when obtaining chart data information, connect by built-in open source code function library application program
Mouth reads data.
Apache POI is preset in terminal, wherein Apache POI is the open source code letter of Apache Software Foundation
Formula library, POI provide API (Application Program Interface, application programming interfaces) to java applet pair
The function that Microsoft office format archives are read and write.POI assembly function is powerful, at the same support office2003,
The excel document of the formats such as office2010 parses, and meets different business demands.
One embodiment obtains chart data document, and to chart numbers when reading chart data by Apache POI
It is parsed according to document.For example, Excel document is converted to the workbook example of operability by Apache POI, with
And Excel document is parsed by the xml configuration file write.Specifically, with sheet pages defined in configuration file and start
Line number is initial position, is successively read row data, and the cell attribute always defined according to configuration file handles row data,
Java data after being parsed call set assignment method to be encapsulated into Java data in specified javabean set.
S1200, conversion parameter is chosen from preset template graph according to the type of chart data；
Chart data type is used to express the type of the chart of data conversion under different scenes, for example, chart can be divided into
Indicate four seed types such as data compare, data distribution, data are constituted and data contact.
Relevant parameter when conversion parameter is for indicating to be converted to chart data chart, comprising: format parameter and formula
Parameter, wherein format parameter indicates figure tableau format, for example, histogram, cake chart, normal distribution etc.；Parameters of formula indicates
The type of used formula when calculating pending data, for example, sum formula, sort formula, seeking poor formula etc..
Preset template graph is in being pre-stored in, for providing various conversion parameters so that pending data is converted to chart
Template, wherein also preset cell region that conversion parameter is acted in template graph and shown the position of chart.
During the present invention is implemented, when choosing conversion parameter according to the type of chart data, firstly, terminal can pass through identification code
Or type keyword determines the type of pending data, comes according still further to the corresponding conversion parameter of type each in template graph true
The applicable conversion parameter of the fixed pending data.For example, as data compare when chart data is reflection data variation trend
Type can choose histogram, cake chart or line chart；When chart data is data distribution type, histogram can choose.
It should be noted that user can be according to customized modification template graph when uniform type and the chart format of multiple selections
In parameter.
S1300, chart data is converted to by chart according to conversion parameter.
During converting chart, when chart data does not need to calculate, format ginseng can be obtained from template graph
Number cell region used, and region identical with the cell regional location is extracted from the document where pending data
To extract data, and the data of extraction are converted directly into chart.
When chart data needs to calculate, format parameter is first obtained from template graph, the number acted on according to format parameter
According to the position in cell region data are extracted from the document where chart data, and be calculated using parameters of formula
Target data, and chart is converted to according to target data.
In some embodiments, the display position of chart in template graph is obtained during showing chart, and is pressed
The chart of conversion is shown in the document where chart data according to display position.
Above-mentioned chart generation method, by the way that template graph is arranged, after recognizing the type of pending data, according to such
Type automatically selects conversion parameter in template graph, and chart data is converted to chart according to conversion parameter.This method is not
When needing Transformation Graphs tableau format under same scene, conversion parameter can be modified, automatically to generate the chart of different formats.
This method is not only simple, flexible, but also also eliminates a large amount of manual operation.
In practical applications, some data do not need processing when can directly convert, at this point, the conversion in template graph is joined
Number only includes format parameter.In this case, the embodiment of the present invention provides a kind of type according to chart data from preset
The method that conversion parameter is chosen in template graph, as shown in Fig. 2, Fig. 2 is provided in an embodiment of the present invention a kind of according to chart numbers
According to type chosen from preset template graph conversion parameter method basic procedure schematic diagram.
Specifically, as shown in Fig. 2, step S1200 includes the following steps:
S1211, type keyword is extracted from chart data information；
Type keyword is preset keyword in pending data, for indicating the type of pending data, with matching
Format parameter.Wherein, the title or filename in pending data can be set in type keyword.
S1212, it is chosen and the format parameter of type Keywords matching from template graph.
Type in template graph according to pending data is preset with multiple format parameter, for example, when chart data is anti-
When reflecting data variation trend, as data comparative type, format parameter can choose appointing in histogram, cake chart or line chart
It is a kind of；When chart data is data distribution type, format parameter can choose any in histogram or normal distribution；
When pending data, which is, indicates the type of incidence relation, format parameter can choose any one of bubble diagram or scatter plot.
Under normal conditions, it needs to handle data in face of mass data, such as operation, sequence etc., obtains processing knot
Fruit, then result data is converted into chart, wherein conversion parameter includes: format parameter and parameters of formula.In this case,
The embodiment of the present invention provides a kind of method that the type according to chart data chooses conversion parameter from preset template graph, such as
Shown in Fig. 3, Fig. 3 is that a kind of type according to chart data provided in an embodiment of the present invention is chosen turn from preset template graph
Change the basic procedure schematic diagram of the method for parameter.
Specifically, as shown in figure 3, step S1200 includes the following steps:
S1221, the format parameter for obtaining chart data；
The method that the format parameter of chart data is obtained in the embodiment of the present invention is referred to Fig. 2 the embodiment described,
This is repeated no more.
S1222, parameters of formula is determined according to the result type that format parameter worked upon data is characterized.
For example, if the data of format parameter effect, that is, when needing to generate the data of chart to indicate summed result, really
Determining parameters of formula is sum formula；If the data of format parameter effect are to determine that parameters of formula is public for sequence when indicating maximum value
Formula.
When pending data only needs format parameter to can be exchanged into chart, the conversion parameter in the embodiment of the present invention is
Format parameter.For this, inventive embodiments provide a kind of method that chart data is converted to chart according to conversion parameter, such as scheme
Shown in 4, Fig. 4 be it is provided in an embodiment of the present invention it is a kind of according to conversion parameter by chart data be converted to chart method it is basic
Flow diagram.
Specifically, as shown in figure 4, step S1300 includes the following steps:
S1311, the first object cell region that format parameter effect is extracted from template graph；
First object cell region, which is generally, to be needed to be converted to the list where the total data of chart according to format parameter
First lattice.Data in the cell are to be converted into the data of the chart of format parameter direction.In general, first object cell can be with
Biggish region, such as a sheet page are set.
S1312, the first mesh identical with first object cell regional location is chosen from the document where chart data
Mark data；
In the embodiment of the present invention, in order to which the chart of conversion is accurate, the document where pending data can be according to chart mould
Data format in plate is configured.In this way, terminal can be according to the position in first object cell region from chart data institute
Document in extract first object data.Wherein, first object data are the chart data in the embodiment of the present invention, i.e., wait turn
It is changed to the data of chart.
S1313, first object data are converted into chart according to format parameter.
When the document where chart data is Excel document, format parameter therein corresponds to the figure in Excel document
First object data are converted to chart according to chart attribute value by Table Properties value.
In some embodiments, Apache POI can carry out assignment to format parameter after reading chart data,
For example, 1 indicates that line chart, 2 indicate that cake chart, 3 indicate histogram.When same type of pending data can there are many optional
When the format parameter selected, user can be configured format parameter according to hobby.
The embodiment of the present invention also provides a kind of method that chart data is converted to chart according to conversion parameter, wherein turns
Changing parameter is format parameter and parameters of formula.As shown in figure 5, Fig. 5 is provided in an embodiment of the present invention another according to conversion ginseng
Chart data is converted to the basic procedure schematic diagram of the method for chart by number.
Specifically, as shown in figure 5, step S1300 includes the following steps:
S1321, the second Set cell region that parameters of formula effect is extracted from template graph；
Second Set cell region is the region where the data of parameters of formula effect.In the embodiment of the present invention, work as figure
When table data are calculated, terminal is when getting the document where chart data, according to the type of chart data
Parameters of formula and format parameter are obtained from icon template, wherein the unit for the data that parameters of formula and format parameter are acted on
Lattice region is different, and for parameters of formula, which needs to calculate the value of data in second unit lattice region.
S1321, the second mesh identical with the second Set cell regional location is chosen from the document where chart data
Mark data；
Second target data is the data for needing to be calculated using parameters of formula in chart data.
It should be noted that the data and chart data in template graph in preset second Set cell region are in text
Position in shelves is identical, so directly can determine chart data according to the position in the second Set cell region in template graph
The position at place.For example, the template graph includes the parameters of formula that sales data is converted to chart, wherein template graph
Sheet 1 indicates the data in January, and the sheet 2 of template graph indicates the data in 2 months, and so on, then terminal is according to figure
The position of January and position sheet 1 and sheet2 where 2 months are gone in the document where chart data to extract in table template
Second target data.
S1323, the second target data is carried out according to parameters of formula third target data is calculated；
Third target data is the data being calculated using formula, that is, needs to be converted to chart using format parameter
Data.
For example, Apache POI reads the chart data when chart data is the sales data in X company half a year,
That is Excel document, for example, extract the first calculation formula from the sheet 1 (position where the sales data of January), i.e., plus
Method operation, and the sales data in Excel document in sheet1 is calculated by the first calculation formula, and then obtain the pin of January
Data are sold, the second calculation formula is extracted from sheet 2, and calculate the sales data in Excel document in sheet2, and then
To the sales data of February, and so on respectively obtain 6 months sales datas.
S1323, third target data is converted into chart according to format parameter.
When the document where chart data is Excel document, format parameter therein corresponds to the figure in Excel document
Third target data is converted to chart according to chart attribute value by Table Properties value.
The embodiment of the present invention also provides a kind of chart generating means to solve above-mentioned technical problem.Referring specifically to Fig. 6, figure
6 be the present embodiment chart generating means basic structure block diagram.
As shown in fig. 6, a kind of chart generating means, comprising: obtain module 2100, processing module 2200 and execution module
2300.Wherein, module 2100 is obtained, for obtaining chart data information to be processed, wherein the chart data information includes
The type of the chart data；Processing module 2200, for the type according to the chart data from preset template graph
Choose conversion parameter；Execution module 2300, for the chart data to be converted to chart according to the conversion parameter.
Chart generating means are existed after recognizing the type of pending data according to the type by the way that template graph is arranged
Conversion parameter is automatically selected in template graph, and chart data is converted into chart according to conversion parameter.This method is different
When needing Transformation Graphs tableau format under scene, conversion parameter can be modified automatically, to generate the chart of different formats.The party
Method is not only simple, flexible, but also also eliminates a large amount of manual operation.
In some embodiments, the conversion parameter is format parameter；The processing module includes: the first acquisition submodule
Block, for extracting type keyword from the chart data information；First processing submodule, for from the template graph
Choose the format parameter with the type Keywords matching.
In some embodiments, the conversion parameter includes: format parameter and parameters of formula；The processing module packet
It includes: the second acquisition submodule, for obtaining the format parameter of the chart data；Second processing submodule, for according to described
The result type that format parameter worked upon data is characterized determines parameters of formula.
In some embodiments, the conversion parameter is format parameter；The execution module includes: that third obtains submodule
Block, for extracting the first object cell region of the format parameter effect from the template graph；4th obtains submodule
Block, for choosing the first mesh identical with the first object cell regional location from the document where the chart data
Mark data；Third handles submodule, for the first object data to be converted to chart according to the format parameter.
In some embodiments, the conversion parameter is format parameter and parameters of formula；The execution module includes:
Five acquisition submodules, for extracting the second Set cell region of the parameters of formula effect from the template graph；The
Four processing submodules, for being chosen and the second Set cell regional location phase from the document where the chart data
The second same target data；First implementation sub-module, based on being carried out according to the parameters of formula to second target data
Calculation obtains third target data；Second implementation sub-module, for converting the third target data according to the format parameter
For chart.
In some embodiments, further includes: the 6th acquisition submodule, for passing through the open source code letter of software foundation
Read the chart data in formula library.
In order to solve the above technical problems, the embodiment of the present invention also provides computer equipment.It is this referring specifically to Fig. 7, Fig. 7
Embodiment computer equipment basic structure block diagram.
As shown in fig. 7, the schematic diagram of internal structure of computer equipment.As shown in fig. 7, the computer equipment includes passing through to be
Processor, non-volatile memory medium, memory and the network interface of bus of uniting connection.Wherein, the computer equipment is non-easy
The property lost storage medium is stored with operating system, database and computer-readable instruction, can be stored with control information sequence in database
Column, when which is executed by processor, may make processor to realize a kind of chart generation method.The computer is set
Standby processor supports the operation of entire computer equipment for providing calculating and control ability.The storage of the computer equipment
It can be stored with computer-readable instruction in device, when which is executed by processor, processor may make to execute one
Kind chart generation method.The network interface of the computer equipment is used for and terminal connection communication.Those skilled in the art can manage
It solves, structure shown in Fig. 7, only the block diagram of part-structure relevant to application scheme, is not constituted to the application side
The restriction for the computer equipment that case is applied thereon, specific computer equipment may include more more or less than as shown in the figure
Component, perhaps combine certain components or with different component layouts.
Processor obtains module 2100, processing module 2200 and execution module for executing in present embodiment in Fig. 6
2300 particular content, program code and Various types of data needed for memory is stored with the above-mentioned module of execution.Network interface is used for
To the data transmission between user terminal or server.Memory in present embodiment is stored in chart generation method and executes
Program code needed for all submodules and data, server is capable of the program code of invoking server and data execute all sons
The function of module.
Computer equipment is being schemed after recognizing the type of pending data according to the type by the way that template graph is arranged
Conversion parameter is automatically selected in table template, and chart data is converted into chart according to conversion parameter.This method is in different fields
When needing Transformation Graphs tableau format under scape, conversion parameter can be modified automatically, to generate the chart of different formats.This method
It is not only simple, flexible, but also also eliminate a large amount of manual operation.
The present invention also provides a kind of storage mediums for being stored with computer-readable instruction, and the computer-readable instruction is by one
When a or multiple processors execute, so that one or more processors execute chart generation method described in any of the above-described embodiment
Step.
Those of ordinary skill in the art will appreciate that realizing all or part of the process in above-described embodiment method, being can be with
Relevant hardware is instructed to complete by computer program, which can be stored in a computer-readable storage and be situated between
In matter, the program is when being executed, it may include such as the process of the embodiment of above-mentioned each method.Wherein, storage medium above-mentioned can be
The non-volatile memory mediums such as magnetic disk, CD, read-only memory (Read-Only Memory, ROM) or random storage note
Recall body (Random Access Memory, RAM) etc..
It should be understood that although each step in the flow chart of attached drawing is successively shown according to the instruction of arrow,
These steps are not that the inevitable sequence according to arrow instruction successively executes.Unless expressly stating otherwise herein, these steps
Execution there is no stringent sequences to limit, can execute in the other order.Moreover, at least one in the flow chart of attached drawing
Part steps may include that perhaps these sub-steps of multiple stages or stage are not necessarily in synchronization to multiple sub-steps
Completion is executed, but can be executed at different times, execution sequence, which is also not necessarily, successively to be carried out, but can be with other
At least part of the sub-step or stage of step or other steps executes in turn or alternately.
The above is only some embodiments of the invention, it is noted that for the ordinary skill people of the art
For member, various improvements and modifications may be made without departing from the principle of the present invention, these improvements and modifications are also answered
It is considered as protection scope of the present invention.
Claims (10)
1. a kind of chart generation method, which is characterized in that include the following steps:
Obtain chart data information to be processed, wherein the chart data information includes the type of the chart data；
Conversion parameter is chosen from preset template graph according to the type of the chart data；
The chart data is converted into chart according to the conversion parameter.
2. chart generation method according to claim 1, which is characterized in that the conversion parameter is format parameter；It is described
Conversion parameter is chosen from preset template graph according to the type of the chart data, is included the following steps:
Type keyword is extracted from the chart data information；
The format parameter with the type Keywords matching is chosen from the template graph.
3. chart generation method according to claim 1, which is characterized in that the conversion parameter include: format parameter and
Parameters of formula；The type according to the chart data chooses conversion parameter, including following steps from preset template graph
It is rapid:
Obtain the format parameter of the chart data；
Parameters of formula is determined according to the result type that the format parameter worked upon data is characterized.
4. chart generation method according to claim 1, which is characterized in that the conversion parameter is format parameter；It is described
The chart data is converted into chart according to the conversion parameter, is included the following steps:
The first object cell region of the format parameter effect is extracted from the template graph；
First object identical with the first object cell regional location is chosen from the document where the chart data
Data；
The first object data are converted into chart according to the format parameter.
5. chart generation method according to claim 1, which is characterized in that the conversion parameter is format parameter and formula
Parameter；It is described that the chart data is converted to by chart according to the conversion parameter, include the following steps:
The second Set cell region of the parameters of formula effect is extracted from the template graph；
The second target identical with the second Set cell regional location is chosen from the document where the chart data
Data；
Second target data is carried out that third target data is calculated according to the parameters of formula；
The third target data is converted into chart according to the format parameter.
6. chart generation method according to claim 1, which is characterized in that pass through the open source code function of software foundation
Read the chart data in library.
7. a kind of chart generating means characterized by comprising
Module is obtained, for obtaining chart data information to be processed, wherein the chart data information includes the chart numbers
According to type；
Processing module, for choosing conversion parameter from preset template graph according to the type of the chart data；
Execution module, for the chart data to be converted to chart according to the conversion parameter.
8. chart generating means according to claim 7, which is characterized in that the conversion parameter is format parameter；It is described
Processing module includes:
First acquisition submodule, for extracting type keyword from the chart data information；
First processing submodule, for choosing the format parameter with the type Keywords matching from the template graph.
9. a kind of computer equipment, including memory and processor, it is stored with computer-readable instruction in the memory, it is described
When computer-readable instruction is executed by the processor, so that the processor executes such as any one of claims 1 to 6 right
It is required that the step of chart generation method.
10. a kind of storage medium for being stored with computer-readable instruction, the computer-readable instruction is handled by one or more
When device executes, so that one or more processors execute the chart generation side as described in any one of claims 1 to 6 claim
The step of method.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910015357.XA CN109977380A (en) | 2019-01-08 | 2019-01-08 | Chart generation method, device, computer equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910015357.XA CN109977380A (en) | 2019-01-08 | 2019-01-08 | Chart generation method, device, computer equipment and storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN109977380A true CN109977380A (en) | 2019-07-05 |
Family
ID=67076538
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910015357.XA Pending CN109977380A (en) | 2019-01-08 | 2019-01-08 | Chart generation method, device, computer equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109977380A (en) |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110727692A (en) * | 2019-10-22 | 2020-01-24 | 北京百度网讯科技有限公司 | Method and device for setting linkage diagram |
| CN112347171A (en) * | 2020-11-03 | 2021-02-09 | 广州朗国电子科技有限公司 | Method and device for converting interface data into visual chart and storage medium |
| CN113536748A (en) * | 2020-04-15 | 2021-10-22 | 北京沃东天骏信息技术有限公司 | Method and device for generating chart data |
| CN113821747A (en) * | 2021-08-31 | 2021-12-21 | 挂号网（杭州）科技有限公司 | Data display method and device, storage medium and electronic equipment |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20080115049A1 (en) * | 2006-11-14 | 2008-05-15 | Microsoft Corporation | Dynamically generating mini-graphs to represent style and template icons |
| CN105868310A (en) * | 2016-03-25 | 2016-08-17 | 联想(北京)有限公司 | Data processing method and device and electronic device |
| CN106155988A (en) * | 2015-03-31 | 2016-11-23 | 阿里巴巴集团控股有限公司 | Data drawing list method for drafting based on excel and relevant apparatus |
| US20180088753A1 (en) * | 2016-09-29 | 2018-03-29 | Google Inc. | Generating charts from data in a data table |
| CN107908604A (en) * | 2017-08-25 | 2018-04-13 | 上海壹账通金融科技有限公司 | Report pattern generation method, device, computer equipment and storage medium |
| WO2018174365A1 (en) * | 2017-03-20 | 2018-09-27 | 주식회사 뉴스젤리 | Method for visualizing chart of data table |
| CN109033043A (en) * | 2018-06-13 | 2018-12-18 | 深圳市买买提信息科技有限公司 | A kind of management through figures method, apparatus and terminal |
-
2019
- 2019-01-08 CN CN201910015357.XA patent/CN109977380A/en active Pending
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20080115049A1 (en) * | 2006-11-14 | 2008-05-15 | Microsoft Corporation | Dynamically generating mini-graphs to represent style and template icons |
| CN106155988A (en) * | 2015-03-31 | 2016-11-23 | 阿里巴巴集团控股有限公司 | Data drawing list method for drafting based on excel and relevant apparatus |
| CN105868310A (en) * | 2016-03-25 | 2016-08-17 | 联想(北京)有限公司 | Data processing method and device and electronic device |
| US20180088753A1 (en) * | 2016-09-29 | 2018-03-29 | Google Inc. | Generating charts from data in a data table |
| WO2018174365A1 (en) * | 2017-03-20 | 2018-09-27 | 주식회사 뉴스젤리 | Method for visualizing chart of data table |
| CN107908604A (en) * | 2017-08-25 | 2018-04-13 | 上海壹账通金融科技有限公司 | Report pattern generation method, device, computer equipment and storage medium |
| CN109033043A (en) * | 2018-06-13 | 2018-12-18 | 深圳市买买提信息科技有限公司 | A kind of management through figures method, apparatus and terminal |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110727692A (en) * | 2019-10-22 | 2020-01-24 | 北京百度网讯科技有限公司 | Method and device for setting linkage diagram |
| CN113536748A (en) * | 2020-04-15 | 2021-10-22 | 北京沃东天骏信息技术有限公司 | Method and device for generating chart data |
| CN112347171A (en) * | 2020-11-03 | 2021-02-09 | 广州朗国电子科技有限公司 | Method and device for converting interface data into visual chart and storage medium |
| CN113821747A (en) * | 2021-08-31 | 2021-12-21 | 挂号网（杭州）科技有限公司 | Data display method and device, storage medium and electronic equipment |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109977380A (en) | Chart generation method, device, computer equipment and storage medium | |
| CN102016822B (en) | High-fidelity rendering of documents in viewer clients | |
| US10963144B2 (en) | Graphically organizing content in a user interface to a software application | |
| US20070282866A1 (en) | Application integration using xml | |
| CN108280200B (en) | Method and device for pushing information | |
| CN109815464A (en) | PDF document generation method, device, electronic equipment and storage medium | |
| CN110084658B (en) | Method and device for matching articles | |
| US6842182B2 (en) | Perceptual-based color selection for text highlighting | |
| CN105027116A (en) | Flat book to rich book conversion in e-readers | |
| EP2601623A2 (en) | Returning estimated value of search keywords of entire account | |
| US20140033030A1 (en) | Indexing and providing electronic publications in a networked computing environment | |
| CN111782933A (en) | Method and device for recommending book list | |
| CN109933749B (en) | Method and device for generating information | |
| CN105468570B (en) | A kind of document synthesis methods of exhibiting and device | |
| CN109472028B (en) | Method and device for generating information | |
| CN110795638A (en) | Method and apparatus for outputting information | |
| CN109410033A (en) | Determination method, apparatus, computer equipment and the storage medium of interest-free loan amount | |
| CN109271397A (en) | Method and apparatus for handling information | |
| CN109584012B (en) | Method and device for generating item push information | |
| CN111125501B (en) | Method and device for processing information | |
| CN109299223B (en) | Method and device for inquiring instruction | |
| CN109388753A (en) | Method and apparatus for handling information | |
| CN111125514A (en) | User behavior analysis method and device, electronic equipment and storage medium | |
| WO2012096681A1 (en) | Method and system for providing an sms-based interactive electronic marketing offer search and distribution system | |
| CN111125572B (en) | Method and device for processing information |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |