CN1499364A - Automatic method for converting graphic display - Google Patents
Automatic method for converting graphic display Download PDFInfo
- Publication number
- CN1499364A CN1499364A CNA021451400A CN02145140A CN1499364A CN 1499364 A CN1499364 A CN 1499364A CN A021451400 A CNA021451400 A CN A021451400A CN 02145140 A CN02145140 A CN 02145140A CN 1499364 A CN1499364 A CN 1499364A
- Authority
- CN
- China
- Prior art keywords
- data
- analyzed pattern
- excel
- ole
- user
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Images
Abstract
The invention relates to the method for preparing and converting graph of correlation analysis in telecom area. The method includes. (1) Collecting data obtains original data needed by generating analysed graph, and the data are led to relevant data area. (2) Based on the said data and data type, the processed data and original data are led to relevant object with corresponding type of data set. (3) Calling relevant interface function with OLE method being encapsulated, passing data in data set to relevant object with corresponding type generates analysed graph under Excel environment. OLE technique utilized in the method raises efficiency greatly for generating each kind of Excel analysed graph needed by users.
Description
Technical field
The present invention relates to a kind of figure conversion method, relate in particular to the making and the conversion method of the correlation analysis figure of field of telecommunications.
Background technology
In the modern life, computing machine offers raw data and each alanysis data of user with the form of figure, can make that the user is very simple and clear to recognize the various states of present data source object and the ruuning situation of equipment.Figure the further function that many two-dimensional table format data sheets are not provided that expanded is provided.With respect to the form that other data provide, have characteristics such as simple and clear, directly perceived and standard, be widely used in all trades and professions.Such as, at field of telecommunications, each big operator of China all can provide the function of pattern analysis to be used for the network of sub-operation systems at different levels and the validity of network element.For example, in disparate networks planning and the network analysis, all the pattern analysis function be to use, various planning and optimization carried out.But use C++Builder usually, the analyzed pattern that software provided that developing instruments such as VB are produced, call format are relatively stricter, single each other can not be compatible, the graphic printing trouble, and the reprocessing difficulty of figure is adjusted the figure difficulty.Such as, the TDBChart control that Borland company provides can be made relevant data analysis figure, but finds that in actual use its call format is relatively stricter, the conversion more complicated between the figure, the print over of figure is difficulty, adds the problem such as less stable of going back of control self.What is more important, the figure that produces under this mode are user-defined format, and the user also can't realize the follow-up analytic function again of figure.And the analyzed pattern that the Office software as Excel generates can be adjusted eaily, prints reprocessing.But because the singularity of general application software graphical format, all kinds of analyzed patterns that generated by general application software all can't be transformed in the such Office software of Excel.
Summary of the invention
The objective of the invention is to: propose figure that a kind of application software of practicality generates solution to the automatic conversion between the figure of Excel generation, can solve above-mentioned two kinds of different pieces of informations effectively and represent the problem that figure turns under the mode, make that the user can be at the analyzed pattern that generates efficiently, flexibly, easily under the general application software GUI interface under the corresponding Excel environment.
For achieving the above object, the technical solution adopted in the present invention is: a kind of graphic presentation automatic switching method is characterized in that: comprise the steps:
A) image data obtains to generate the required raw data of analyzed pattern, and imports to corresponding data area;
B) according to generating required data and the type thereof of described analyzed pattern, judge whether raw data satisfies the needs of analyzed pattern data and type, if can not satisfy, then described raw data is handled by the needs of analyzed pattern, and the data importing that will obtain after will handling is in corresponding data set type object; If need not handle, then raw data is directly imported in the corresponding data set type object;
C) call the interface function that is packaged with the OLE method accordingly, import number of data sets certificate and user selected parameter in the corresponding data set type object into, generate the analyzed pattern under the Excel environment.
Image data in the described steps A can obtain corresponding raw data by the mode of connected reference database, with the form of file or self-defined message described raw data is returned.
Among the described step B described method to original data processing is comprised summation, merger and asks average.
Described step C) may further comprise the steps:
Necessary parameter when a) user selects title, picture time, axle parameter name and the font figures of analyzed pattern to show;
B) control invokes CreateOleObject creates the OLE example automatically, utilize analyzed pattern data and the relevant parameter that the OLE technology is imported the user into to import in the corresponding ole object example, and in the form that the user is defined in the figure guide Excel analyzed pattern that is applied to produce;
C) control is preserved aforesaid Excel figure spanned file automatically under a temp directory, and deletion OleObject example;
D) call ShellExcute and open the rapid temporary file of preserving of previous step, present to the user.
Finish described step C) after, can also be according to the data that import among the different worksheet of described Excel, again the analyzed pattern of automatic generation is carried out personalisation process according to need.
Beneficial effect of the present invention is: by the automatic conversion plan of figure, greatly improved the efficient that the user generates all kinds of analyzed patterns, help the robotization and the normalized enforcement of all kinds of analyzed patterns, the particularly important is, it utilizes the OLE technology directly to produce Excel analyzed pattern file according to the form of customization, has certain versatility and extensibility.
Description of drawings
Fig. 1 is for being that the software data figure of tool making is to Excel figure transformation flow figure with C++Builder.
Fig. 2 is the example used according to Fig. 1, and corresponding data importing produces the process flow diagram of Excel analysis chart later on automatically to control.
Fig. 3 makes a case effect figure for utilizing the present invention.
Embodiment
With embodiment the present invention is described in further detail with reference to the accompanying drawings below:
In Fig. 1, at first, the user connects database by the BDE mode, obtain the needed corresponding raw data of analyzed pattern, generation needed data layout of figure and type thereof are handled in raw data processing, again with data importing in TDataSet type object example, call the control that is packaged with the OLE method accordingly, utilize control interface function MakeChart, import into the TDataSet object instance and corresponding other such as title, the axle title, optional parameter such as query time, encapsulated corresponding OLE method in the MakeChart function, create the OLE example of Excel, with the data among the TDataSet and other parameters, as input, import to and create in the successful OLE example, produce the analyzed pattern file under the Excel environment.The data that comprised among the TDataSet import among the different worksheet of analyzed pattern file simultaneously.The user can reprocess the figure of automatic generation according to the data that import to simultaneously among other sheet of Excel again, perhaps prints relevant figure.
In Fig. 2, the display parameter and the TDataSet object data set of necessity when the user selects title, picture time, axle parameter name and the font figures of analyzed pattern to show are as the input parameter of control.Canonical function CreateOleObject in the control invokes OLE method creates the OLE example of Excel automatically, ready input parameter in the step (1) is imported in the successful ole object example of establishment, the figure spanned file of the Excel example of control preservation step (2) is under a temp directory Temp, and call DeleteOleObject and delete this OLE example, the reason of doing like this is because the OLE example that method CreateOleObject creates must be deleted in program automatically, call the temporary file that ShellExcute opening steps (3) is preserved, present to the user.And in Fig. 3, describe and to finish should scheme and with final graphic example of the actual generation of a practical control of this scheme realization.
Claims (5)
1. a graphic presentation automatic switching method is characterized in that: comprise the steps:
A) image data obtains to generate the required raw data of analyzed pattern, and imports to corresponding data area;
B) according to generating required data and the type thereof of described analyzed pattern, judge whether raw data satisfies the needs of analyzed pattern data and type, if can not satisfy, then described raw data is handled by the needs of analyzed pattern, and the data importing that will obtain after will handling is in corresponding data set type object; If need not handle, then raw data is directly imported in the corresponding data set type object;
C) call the interface function that is packaged with the OLE method accordingly, import number of data sets certificate and user selected parameter in the corresponding data set type object into, generate the analyzed pattern under the Excel environment.
2. graphic presentation automatic switching method according to claim 1, it is characterized in that: the image data in the described steps A can obtain corresponding raw data by the mode of connected reference database, with the form of file or self-defined message described raw data is returned.
3. graphic presentation automatic switching method according to claim 1 and 2 is characterized in that:
Among the described step B described method to original data processing is comprised summation, merger and asks average.
4. graphic presentation automatic switching method according to claim 1 and 2 is characterized in that:
Described step C) may further comprise the steps:
The display parameter of necessity when a) user selects title, picture time, axle parameter name and the font figures of analyzed pattern to show;
B) control invokes CreateOleObject creates the OLE example automatically, utilize analyzed pattern data and the relevant parameter that the OLE technology is imported the user into to import in the corresponding ole object example, and in the form that the user is defined in the figure guide Excel analyzed pattern that is applied to produce;
C) control is preserved aforesaid Excel figure spanned file automatically under a temp directory, and deletion OleObject example;
D) call ShellExcute and open the rapid temporary file of preserving of previous step, present to the user.
5. graphic presentation automatic switching method according to claim 1 and 2 is characterized in that:
Finish described step C) after, can also be according to the data that import among the different worksheet of described Excel, again the analyzed pattern of automatic generation is carried out personalisation process according to need.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN 02145140 CN1280718C (en) | 2002-11-05 | 2002-11-05 | Automatic method for converting graphic display |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN 02145140 CN1280718C (en) | 2002-11-05 | 2002-11-05 | Automatic method for converting graphic display |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN1499364A true CN1499364A (en) | 2004-05-26 |
| CN1280718C CN1280718C (en) | 2006-10-18 |
Family
ID=34232279
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN 02145140 Expired - Fee Related CN1280718C (en) | 2002-11-05 | 2002-11-05 | Automatic method for converting graphic display |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN1280718C (en) |
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN100424698C (en) * | 2006-02-13 | 2008-10-08 | 无锡永中科技有限公司 | Object memory store based custom object processing method |
| CN101882169A (en) * | 2010-05-03 | 2010-11-10 | 蒋菊生 | Drawing method of layer-stranded optical cable core structure diagram based on codes |
| CN101233485B (en) * | 2005-06-02 | 2010-12-08 | 数学工程公司 | Method and system for integrating late bound functions and languages into an external program environment |
| CN102184193A (en) * | 2011-04-19 | 2011-09-14 | 无锡永中软件有限公司 | Quick file processing method compatible with general office software |
| CN102591961A (en) * | 2011-12-30 | 2012-07-18 | 甘肃电力科学研究院 | Method and system for making data charts |
| CN104102734A (en) * | 2014-07-28 | 2014-10-15 | 中国科学院深圳先进技术研究院 | Data display method and system |
| CN106873952A (en) * | 2015-12-14 | 2017-06-20 | 航天信息股份有限公司 | The data handling system and method and application apparatus of mobile terminal webpage development |
-
2002
- 2002-11-05 CN CN 02145140 patent/CN1280718C/en not_active Expired - Fee Related
Cited By (12)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101233485B (en) * | 2005-06-02 | 2010-12-08 | 数学工程公司 | Method and system for integrating late bound functions and languages into an external program environment |
| CN102063315B (en) * | 2005-06-02 | 2015-03-11 | 数学工程公司 | Calling of late bound functions from an external program environment and system thereof |
| CN100424698C (en) * | 2006-02-13 | 2008-10-08 | 无锡永中科技有限公司 | Object memory store based custom object processing method |
| CN101882169A (en) * | 2010-05-03 | 2010-11-10 | 蒋菊生 | Drawing method of layer-stranded optical cable core structure diagram based on codes |
| CN101882169B (en) * | 2010-05-03 | 2012-08-08 | 魏梦姣 | Drawing method of layer-stranded optical cable core structure diagram based on codes |
| CN102184193A (en) * | 2011-04-19 | 2011-09-14 | 无锡永中软件有限公司 | Quick file processing method compatible with general office software |
| CN102591961A (en) * | 2011-12-30 | 2012-07-18 | 甘肃电力科学研究院 | Method and system for making data charts |
| CN102591961B (en) * | 2011-12-30 | 2015-03-18 | 国家电网公司 | Method and system for making data charts |
| CN104102734A (en) * | 2014-07-28 | 2014-10-15 | 中国科学院深圳先进技术研究院 | Data display method and system |
| CN104102734B (en) * | 2014-07-28 | 2018-02-06 | 中国科学院深圳先进技术研究院 | Method for exhibiting data and system |
| CN106873952A (en) * | 2015-12-14 | 2017-06-20 | 航天信息股份有限公司 | The data handling system and method and application apparatus of mobile terminal webpage development |
| CN106873952B (en) * | 2015-12-14 | 2021-07-20 | 航天信息股份有限公司 | Data processing system and method for mobile terminal webpage development and application device |
Also Published As
| Publication number | Publication date |
|---|---|
| CN1280718C (en) | 2006-10-18 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103092621B (en) | The method and device that a kind of chart generates | |
| CN102279848B (en) | Method and device for generating report template | |
| CN108268529B (en) | Data summarization method and system based on business abstraction and multi-engine scheduling | |
| US6760732B2 (en) | Method and system for viewing a record of an organization having a hierarchy of departments | |
| CN1777127A (en) | Protocol conformance measuring device and method | |
| CN112101895A (en) | Establishment method and system supporting adaptation of workflow client and workflow engine | |
| CN104484419A (en) | Test case document conversion system and test case document conversion method | |
| CN1280718C (en) | Automatic method for converting graphic display | |
| CN108255316A (en) | Dynamic adjusts method, electronic device and the computer readable storage medium of emoticon | |
| CN111754087A (en) | Management and control method for production equipment of smart factory | |
| MXPA02008319A (en) | Method for workflow processing through computer network. | |
| CN108984156A (en) | A kind of software auto generating method and system for exempting from code development based on template | |
| CN113626024A (en) | Low code development method and device combining RPA and AI and computing equipment | |
| CN106302125B (en) | The method, apparatus and system that a kind of pair of solicited message is responded | |
| CN105305619A (en) | Method and device for three-remote configuration based on distribution automation | |
| CN112214236B (en) | Method for building management system of application architecture of software rapid development platform | |
| CN115033646B (en) | Method for constructing real-time warehouse system based on Flink and Doris | |
| CN113986985B (en) | IO reading method, system, equipment and storage medium for energy management | |
| CN116009793A (en) | Printing method | |
| CN111796868B (en) | Method for realizing interaction of CAD enhanced attribute block and Excel data | |
| CN101436131A (en) | Method and system for implementing repeat operation in interactive operation software | |
| CN1212585C (en) | Universal electronic checking and signing task creating platform system and its automatic creation method | |
| CN115934236A (en) | Method for converting unstructured primitives into structured primitives, computer device and computer-readable storage medium | |
| CN116991371A (en) | DaaS method based on HTML text object model | |
| CN116466942A (en) | Transaction page generation method and device |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant | ||
| ASS | Succession or assignment of patent right |
Owner name: HAIMEN TECHNOLOGY DEVELOPMENT CORP. Free format text: FORMER OWNER: ZTE CORPORATION Effective date: 20130723 |
|
| C41 | Transfer of patent application or patent right or utility model | ||
| COR | Change of bibliographic data |
Free format text: CORRECT: ADDRESS; FROM: 518057 SHENZHEN, GUANGDONG PROVINCE TO: 226144 NANTONG, JIANGSU PROVINCE |
|
| TR01 | Transfer of patent right |
Effective date of registration: 20130723 Address after: 226144, No. 600, Beijing Road, Haimen, Jiangsu, Nantong province (room 0212 of administrative center) Patentee after: Haimen science and Technology Development General Corporation Address before: 518057 Nanshan District high tech Industrial Park, Guangdong, South Road, science and technology, ZTE building, legal department Patentee before: ZTE Corporation |
|
| CF01 | Termination of patent right due to non-payment of annual fee | ||
| CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20061018 Termination date: 20161105 |