CN1664817A - Method for automatically switching between Oracle Form 9i and Microsoft Excel perspective charts - Google Patents
Method for automatically switching between Oracle Form 9i and Microsoft Excel perspective charts Download PDFInfo
- Publication number
- CN1664817A CN1664817A CN 200510024604 CN200510024604A CN1664817A CN 1664817 A CN1664817 A CN 1664817A CN 200510024604 CN200510024604 CN 200510024604 CN 200510024604 A CN200510024604 A CN 200510024604A CN 1664817 A CN1664817 A CN 1664817A
- Authority
- CN
- China
- Prior art keywords
- data
- oracle
- perspective
- form9i
- excel
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Document Processing Apparatus (AREA)
Abstract
This invention discloses a Web embedding method in Oracle Form9i based on Oracle AQ, relating to computer technology realm for outer data procession, which can open new FORM based on already opened basis FORM through OPEN_FORM () method by pressing the chain on the WEB page. The method is characterized in that on the user's point, because of the connection of WEBFORM and WEB/JSP, the related WEBFORM can be opened by pressing the related chain on the WEB/JSP, just like pressing the button on FORM page. By this way, it can create attractive appearance, also solve resource consumption problem, and actualize WEBFOR impaction on WEB page.
Description
[technical field]
The present invention relates to be used for the field of computer technology that external data is handled, the automatic converting method of specifically a kind of Oracle Form9i and Microsoft Excel perspective table.
[background technology]
The software of analyzing for data in the database at present has a lot, the analysis tool of Oracle oneself is arranged, the special data analysis software that also has the third party to develop.Its principle all is at first to carry out modeling, then data is derived, and creates the data Layer of multidimensional, then in the enterprising line data analysis of this layer data.These softwares have broken away from FORM, so the advantage of FORM aspect data query just do not display.If use these softwares to carry out data analysis, just must buy, these software is installed, though they are powerful aspect data analysis, the simple analysis in the FORM application uses these instruments just to seem and wastes one's talent on a petty job.
Realize that the data among the Form are exported to the Excel file exists certain degree of difficulty, though this mainly is that the API that realizes IO is arranged among the Form, can write data in the file, but the file that generates is a text, open with Excel if desired, can adopt to import among the Excel, perhaps generating with the comma is the csv file of separator, directly opens with Excel.But these are not real Excel file, therefore for data of different types, just cannot distinguish fully such as text data and numerical data.And have an X-rayed table handling if desired, also need in Excel, carry out certain operations.In Form, can directly generate the Excel file without any API, the xls file that Excel uses is the distinctive file type under the Microsoft Office.File layout is covert, software except that Microsoft company is that the just at present known use FORM that cannot directly generate develops in the product of enterprise application software, data derive and generate the also few of Excel, and mostly are that generation is the csv file of separator with the comma.Csv file is not real Excel type file, though can use Excel to open the type file, the data type of having no idea to distinguish fully, all data are all changed by Excel oneself, occur the conversion that non-user does expectation easily.Such as the data that a text is arranged in Form: 000123, as numbering, these data are very normal, if but be generated as csv file, and opened by Excel, Excel can become 123 to this data-switching, and as numeric type, this has just twisted user's the meaning, and is if do conversion at Excel again, very loaded down with trivial details.
[summary of the invention]
Purpose of the present invention realize exactly can be from Form derived data generate the Excel file, and can be according to setting, the Excel file of generation has had the conversion of perspective table, the user can directly carry out data analysis in this Excel.
To achieve these goals, the present invention adopts following technical scheme:
The automatic converting method of a kind of Oracle Form9i and Microsoft Excel perspective table is characterized in that the step that this method comprises has:
(1) data block of the selected data that will derive;
(2) its perspective tableau format of data definition to deriving;
(3) data in the data block are exported in certain file on the server;
(4) open the WEB/JSP page, read the file of the store data on the server;
(5) VBScript by embedding among the WEB/JSP according to the form of definition, generates the perspective table to data, and opens with Excel;
Have an X-rayed tabular method, also comprising is expert at according to its placement of perspective sheet format requirements definition according to want derived data field goes up or lists and the form of definition is stored in step in the database.
The method of data in the derived data piece also comprises the function of utilization among the FORM, obtains the step that data on the data block are write certain file on the server.
The described WEB/JSP page of opening reads the method for the file of store data on the server, also comprises the Data Filename that generates on the server is passed to the JPS program as parameter, and the JSP program is with the step of the mode read data files of stream then.
Create the method for perspective table by the VBScript that embeds in the JSP program, also be included in and create an Excel object among the VBScript, and the method for using this object to inherit, generate the step of perspective table object.
The perspective sheet format of definition is placed on the step in the data literary composition of derivation.
Generate the method for perspective table, also comprise the identifier that uses the form that each row is comprised in the data that the VBScript language analysis derives, as requested data are put into step in the perspective sheet format object of generation.
The method of assay format also comprises the step of the identifier that one group of predefine can the identification data placement location.
The Oracle Form6i that this method can also be used for, Oracle Form7i, OracleForm8i.
Generate in the method for perspective table, also comprise and open the object that generates Excel at last, and close the step of the browser window of opening at first.
Simultaneously, the present invention is divided into following a few part:
1. the form of Form data in the perspective table is set;
2. use TEXT_IO API that data are exported on the server;
3. use the WEB.SHOW_DOCUMENT function to open the WEB/JSP page that generates Excel;
4.WEB/JSP the data file that page open is derived generates the Excel file, and opens with Excel;
5. close the WEB page.
By above step, just can realize the data among the Form are derived generation perspective table.In the viewpoint that the user uses, the Form data will be opened Excel after deriving, and the data among the Form will be generated as the perspective table automatically.
The present invention compared with prior art, realization can be from Form derived data generate the Excel file, and can be according to setting, the Excel file of generation has had the conversion of perspective table, the user can directly carry out data analysis in this Excel.Simultaneously, the present invention is easy and simple to handle, is fit to the user and uses.
[concrete embodiment]
At first, before the Form data derive, need to be provided with want derived data in the perspective table, need placement be expert on or list, when defining after these want derived series, need be in database the deposit data of these definition.After clicking derivation, can use API that this Form of TEXT_IO carries to want all fields in the derived data piece to circulate to read with all records current, and an every trade is write in certain file on the server, when writing these row, need write down that each is listed in the position in the perspective table, can be placed on capable head and carry out mark.
In Form, use the WEB.SHOW_DOCUMENT function to open a link, this link can be opened a WEB/JSP page, and the last step is derived the filename that comes pass to the WEB/JSP page as parameter, this JSP program the inside has embedded one section VBScript program, and this programmed logic is as follows:
1. create the object of an excel.application type;
2. this object has been inherited the function of creating the perspective table and the Excel page, by the QueryTables.Add method, the file of deriving on the server is read as data source;
3. the perspective table definition sign in the analysis data source uses the cell function in the excel macro that corresponding data are placed on corresponding position;
4. the Excel object output that contains the perspective table that generates is come, client can automatic calling excel be opened this object;
5. close the WEB/JSP page.
At last, use Excel just can analyze the data of derivation, analyze and to preserve current Excel file.
Those skilled in the art no longer does further concrete implementation, because can be narrated explanation and come into effect the present invention by above.
Behind the research instructions, those skilled in the art may appreciate that many changes of the present invention, modification, variation and other purposes and application.Do not deviate from all these changes, modification, variation and other purposes and the application of aim of the present invention and scope, all be considered to be covered by the present invention.
Claims (10)
1. the automatic converting method of Oracle Form9i and Microsoft Excel perspective table is characterized in that the step that this method comprises has:
(1) data block of the selected data that will derive;
(2) its perspective tableau format of data definition to deriving;
(3) data in the data block are exported in certain file on the server;
(4) open the WEB/JSP page, read the file of the store data on the server;
(5) VBScript by embedding among the WEB/JSP according to the form of definition, generates the perspective table to data, and opens with Excel;
2. the automatic converting method of a kind of Oracle Form9i according to claim 1 and MicrosoftExcel perspective table is characterized in that defining and also comprises in the tabular method of perspective being expert at according to its placement of perspective sheet format requirements definition according to want derived data field and go up or list and the form that defines is stored in step in the database.
3. the automatic converting method of a kind of Oracle Form9i according to claim 1 and MicrosoftExcel perspective table, it is characterized in that also comprising in the method for data in the derived data piece function among the utilization FORM, obtain the step that data on the data block are write certain file on the server.
4. the automatic converting method of a kind of Oracle Form9i according to claim 1 and MicrosoftExcel perspective table, it is characterized in that opening the WEB/JSP page, read in the method for the file of store data on the server, comprise also the Data Filename that generates on the server passed to the JPS program as parameter that the JSP program is with the step of the mode read data files of stream then.
5. the automatic converting method of a kind of Oracle Form9i according to claim 1 and MicrosoftExcel perspective table, it is characterized in that creating in the method for perspective table by the VBScript that embeds in the JSP program, also be included in and create an Excel object among the VBScript, and the method for using this object to inherit, generate the step of having an X-rayed table object.
6. according to the automatic converting method of claim 1 or 2 or 3 described a kind of Oracle Form9i and Microsoft Excel perspective table, it is characterized in that also comprising the perspective sheet format of definition is placed on step in the data literary composition of derivation.
7. the automatic converting method of a kind of Oracle Form9i according to claim 5 and MicrosoftExcel perspective table, it is characterized in that generating in the method for perspective table, also comprise the identifier that uses the form that each row is comprised in the data that the VBScript language analysis derives, as requested data are put into step in the perspective sheet format object of generation.
8. the automatic converting method of a kind of Oracle Form9i according to claim 7 and MicrosoftExcel perspective table in the method for the assay format that it is characterized in that, also comprises the step of the identifier that one group of predefine can the identification data placement location.
9. the automatic converting method of a kind of Oracle Form9i according to claim 1 and MicrosoftExcel perspective table, it is characterized in that generating in the method for perspective table, also comprise and open the object that generates Excel at last, and close the step of the browser window of opening at first.
10. the automatic converting method of a kind of Oracle Form9i according to claim 1 and MicrosoftExcel perspective table is characterized in that the Oracle Form6i that this method can also be used for, Oracle Form7i, Oracle Form8i.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNB2005100246040A CN100365630C (en) | 2005-03-24 | 2005-03-24 | Method for automatically switching between Oracle Form 9i and Microsoft Excel perspective charts |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNB2005100246040A CN100365630C (en) | 2005-03-24 | 2005-03-24 | Method for automatically switching between Oracle Form 9i and Microsoft Excel perspective charts |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN1664817A true CN1664817A (en) | 2005-09-07 |
| CN100365630C CN100365630C (en) | 2008-01-30 |
Family
ID=35035910
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CNB2005100246040A Active CN100365630C (en) | 2005-03-24 | 2005-03-24 | Method for automatically switching between Oracle Form 9i and Microsoft Excel perspective charts |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN100365630C (en) |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101908078A (en) * | 2010-08-30 | 2010-12-08 | 深圳市五巨科技有限公司 | Method and device for importing webpage data to EXCEL sheet |
| CN102567019A (en) * | 2011-12-26 | 2012-07-11 | 山东浪潮齐鲁软件产业股份有限公司 | Method for supporting various character sets during application of EXCEL plug-in unit in WEB |
| CN104239048A (en) * | 2014-09-09 | 2014-12-24 | 中国长江三峡集团公司 | Multiplexing method for business logics of Oracle Forms information system |
| CN108875029A (en) * | 2018-06-22 | 2018-11-23 | 国网北京市电力公司 | Data processing method and device, storage medium and processor |
| CN112100126A (en) * | 2020-11-03 | 2020-12-18 | 广州市玄武无线科技股份有限公司 | Excel file-based picture storage and content display method and device |
Family Cites Families (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1041356C (en) * | 1992-03-24 | 1998-12-23 | 松下电器产业株式会社 | Device for digital search |
| US5414808A (en) * | 1992-12-30 | 1995-05-09 | International Business Machines Corporation | Method for accessing and manipulating library video segments |
| US5414626A (en) * | 1993-05-19 | 1995-05-09 | Envirotest Systems Corp. | Apparatus and method for capturing, storing, retrieving, and displaying the identification and location of motor vehicle emission control systems |
-
2005
- 2005-03-24 CN CNB2005100246040A patent/CN100365630C/en active Active
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101908078A (en) * | 2010-08-30 | 2010-12-08 | 深圳市五巨科技有限公司 | Method and device for importing webpage data to EXCEL sheet |
| CN102567019A (en) * | 2011-12-26 | 2012-07-11 | 山东浪潮齐鲁软件产业股份有限公司 | Method for supporting various character sets during application of EXCEL plug-in unit in WEB |
| CN104239048A (en) * | 2014-09-09 | 2014-12-24 | 中国长江三峡集团公司 | Multiplexing method for business logics of Oracle Forms information system |
| CN104239048B (en) * | 2014-09-09 | 2017-06-06 | 中国长江三峡集团公司 | A kind of multiplexing method of Oracle Forms information system service logics |
| CN108875029A (en) * | 2018-06-22 | 2018-11-23 | 国网北京市电力公司 | Data processing method and device, storage medium and processor |
| CN112100126A (en) * | 2020-11-03 | 2020-12-18 | 广州市玄武无线科技股份有限公司 | Excel file-based picture storage and content display method and device |
Also Published As
| Publication number | Publication date |
|---|---|
| CN100365630C (en) | 2008-01-30 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US9026901B2 (en) | Viewing annotations across multiple applications | |
| WO2004029755A3 (en) | Automated report building system | |
| CN1664817A (en) | Method for automatically switching between Oracle Form 9i and Microsoft Excel perspective charts | |
| EP1638021A3 (en) | Creation and Management of Content-Related Objects | |
| CN101075249A (en) | Data warehouse system and its construction for geographical information system | |
| CN1367448A (en) | Code generator system for digital library and its method | |
| Sutton Jr et al. | Aspect-oriented design needs concern modeling | |
| CN1534524A (en) | BOM table automatic comparison system and method | |
| US20110302555A1 (en) | Assigning type parameters | |
| CN1828579A (en) | Patent analyzing system | |
| Prom et al. | A unified platform for archival description and access | |
| Luisa Calanag et al. | Linking preservation metadata and collection management policies | |
| CN1301479C (en) | Organizational architecture establishing method and authority control and management method thereof | |
| Kamita et al. | A database architecture and version control for group work | |
| Tashiro et al. | Implementing a proxy agent based writable web for a dynamic information sharing system | |
| CN1664780A (en) | Method for realizing Web embedding of Oracle Form 9i based on Oracle AQ technology | |
| CN1108576C (en) | Auxiliary system on-line multimedia | |
| Anderson | Issues of data scalability in open hypermedia systems | |
| Quirchmayr | Internet, WWW, and beyond | |
| CN101079875A (en) | A method and system for realizing multi-object event | |
| Zannier et al. | Tool support for complex refactoring to design patterns | |
| Baek et al. | Facet Analysis of Archival Metadata Standards to Support Appropriate Selection, Combination and Use of Metadata Schemas | |
| Harrison et al. | Applying web services within the AEC industry: Enabling semantic searching and information exchange through the digital linking of the knowledge base | |
| Imbusch et al. | Ercatons and organic programming: say good-bye to planned economy | |
| Chmielewski | Interaction interfaces for unrestricted multimedia interaction descriptions |
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 | ||
| C56 | Change in the name or address of the patentee |
Owner name: SHANGHAI HAND ENTERPRISE SOLUTIONS CO.,LTD. Free format text: FORMER NAME: SHANGHAI QUANFU HAND SOFTWARE TECHNOLOGY CO.,LTD. |
|
| CP01 | Change in the name or title of a patent holder |
Address after: 201700 No. 303, No. 5500, Pine Road, Qingpu Industrial Park, Qingpu District, Shanghai Patentee after: HAND Enterprise Solutions Co., Ltd. Address before: 201700 No. 303, No. 5500, Pine Road, Qingpu Industrial Park, Qingpu District, Shanghai Patentee before: Hand Enterprise Solutions Co., Ltd. |