CN1280718C - Automatic method for converting graphic display - Google Patents
Automatic method for converting graphic display Download PDFInfo
- Publication number
- CN1280718C CN1280718C CN 02145140 CN02145140A CN1280718C CN 1280718 C CN1280718 C CN 1280718C CN 02145140 CN02145140 CN 02145140 CN 02145140 A CN02145140 A CN 02145140A CN 1280718 C CN1280718 C CN 1280718C
- 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.)
- Expired - Fee Related
Links
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present invention relates to a method for making and converting correlation analysis figures in the field of telecommunication. The method comprises the following steps: 1, collecting data to obtain original data required by generating analysis figures, and importing the data to a corresponding data area; 2, importing processed data and the original data to a corresponding data set type object according to the data required by generating analysis figures and the type of the data; 3, invoking interface functions correspondingly packaging an OLE method, and introducing data set data and user selection parameters in the data set type object to generate analysis figures under the environment of Excel. Because the method utilizes the OLE technology, the method greatly enhances the efficiency of generating various Excel analysis figures required by users, and has certain universality and expandability.
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 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:
Described step B) in 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, it 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 CN1499364A (en) | 2004-05-26 |
| CN1280718C true 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) |
Families Citing this family (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US8046777B2 (en) * | 2005-06-02 | 2011-10-25 | The Mathworks, Inc. | Calling of late bound functions from an external program environment |
| CN100424698C (en) * | 2006-02-13 | 2008-10-08 | 无锡永中科技有限公司 | Object memory store based custom object processing method |
| 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 |
| CN102591961B (en) * | 2011-12-30 | 2015-03-18 | 国家电网公司 | Method and system for making data charts |
| CN104102734B (en) * | 2014-07-28 | 2018-02-06 | 中国科学院深圳先进技术研究院 | Method for exhibiting data and system |
| CN106873952B (en) * | 2015-12-14 | 2021-07-20 | 航天信息股份有限公司 | Data processing system and method for mobile terminal webpage development and application device |
-
2002
- 2002-11-05 CN CN 02145140 patent/CN1280718C/en not_active Expired - Fee Related
Also Published As
| Publication number | Publication date |
|---|---|
| CN1499364A (en) | 2004-05-26 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US6760732B2 (en) | Method and system for viewing a record of an organization having a hierarchy of departments | |
| CN108268529B (en) | Data summarization method and system based on business abstraction and multi-engine scheduling | |
| 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 | |
| CN115022304B (en) | Method, device and system for realizing IA (IA-IA) cross-platform file processing based on RPA (remote procedure A) and AI (advanced technology attachment) | |
| CN113986985B (en) | IO reading method, system, equipment and storage medium for energy management | |
| CN108984156A (en) | A kind of software auto generating method and system for exempting from code development based on template | |
| CN1620060B (en) | Method and device for integrating browser-incompatible information into web content and for displaying the information | |
| CN112214236B (en) | Method for building management system of application architecture of software rapid development platform | |
| CN112631584A (en) | Metadata dynamic form generation method and system | |
| CN115033646B (en) | Method for constructing real-time warehouse system based on Flink and Doris | |
| CN110427512A (en) | Expression pattern sending method, device, electronic equipment and storage medium | |
| CN115168361A (en) | Label management method and device | |
| 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 | |
| CN113011688A (en) | Task management system for power system | |
| CN1212585C (en) | Universal electronic checking and signing task creating platform system and its automatic creation method | |
| CN112685865B (en) | Multi-topology model merging method, device, equipment and storage medium | |
| CN115934236A (en) | Method for converting unstructured primitives into structured primitives, computer device and computer-readable storage medium | |
| KR20010053766A (en) | Automation device of intelligent network service customer data change management and method thereof | |
| CN1780449A (en) | Tag displaying method for mobile communication terminal with screen of standby status | |
| CN1704941A (en) | Wire-electrode cutting path code generation system and method | |
| CN116861115A (en) | Page color adaptation method, electronic device and storage medium | |
| JPH1168938A (en) | Tmn agent generating system |
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 |
Granted publication date: 20061018 Termination date: 20161105 |
|
| CF01 | Termination of patent right due to non-payment of annual fee |