CN100365630C - 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
- CN100365630C CN100365630C CNB2005100246040A CN200510024604A CN100365630C CN 100365630 C CN100365630 C CN 100365630C CN B2005100246040 A CNB2005100246040 A CN B2005100246040A CN 200510024604 A CN200510024604 A CN 200510024604A CN 100365630 C CN100365630 C CN 100365630C
- Authority
- CN
- China
- Prior art keywords
- data
- excel
- perspective
- oracle
- file
- 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.)
- Active
Links
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Document Processing Apparatus (AREA)
Abstract
The present invention relates to the technical field of computers used for processing external data, more specifically a method for automatically switching Oracle Form 9i and Microsoft Excel perspective charts. The method for automatically switching the Oracle Form 9i and the Microsoft Excel perspective charts is characterized in that the method comprises following steps: (1) selecting a data block of data to be derived; (2) defining the format of the perspective chart of the data to be derived; (3) deriving the data in the data block to some one file on a server; (4) opening a WEB/JSP page and reading the file stored with the data on the server; (5) generating the data into the perspective chart and opening the perspective chart by Excel via VBScript embedded the WEB/JSP according to the defined format. Compared with the prior art, the present invention realizes that the data can be derived from Form to generate an Excel file, the generated Excel file already has the conversion of the perspective chart according to the setting, a user can directly analyze data in the Excel. At the same time, the present invention having the advantages of easy operation is suitable for being used by the users.
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 that 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 are derived, create the data Layer of multidimensional, then in the enterprising line data analysis of this layer data. these softwares have broken away from FORM, if therefore the advantage of FORM aspect data query just do not display. and 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 and import among the Excel, perhaps generate with the comma is the csv file of separator, directly open 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 cannot directly generate. in the product of just at present known use FORM exploitation enterprise application software, data derive and generate the also few of Excel, and mostly be that to generate with the comma be that the csv file .CSV file of separator is not real Excel type file, though can use Excel to open the type file, but have no idea to distinguish fully data type, all data are all changed by Excel oneself, the conversion that non-user does expectation appears 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 the words of being opened by Excel, Excel can become 123 to this data-switching, and as numeric type, this has just twisted user's the meaning, if it is 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.
[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 can preserve current Excel file.
No longer do further concrete implementation, because those skilled in the art 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, this VBScript programmed logic is as follows: a). create the object of an excel.application type;
B). 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;
C). analyze the perspective table definition sign in the data source, use the cell function in the excel macro that corresponding data are placed on corresponding position;
D). the Excel object output that contains the perspective table that generates is come, and client can automatic calling excel be opened this object;
E). close the WEB/JSP page;
At last, use Excel just can analyze the data of derivation, analyze and to preserve current Excel file.
2. the automatic converting method of a kind of Oracle Form9i according to claim 1 and Microsoft Excel 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 Microsoft Excel 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 Microsoft Excel 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 Microsoft Excel 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 MicrosoftExcel 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 Microsoft Excel 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 Microsoft Excel 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 Microsoft Excel 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 Microsoft Excel perspective table is characterized in that the OracleForm6i 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 CN1664817A (en) | 2005-09-07 |
| CN100365630C true 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) |
Families Citing this family (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 |
| 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 |
| CN112100126B (en) * | 2020-11-03 | 2021-06-18 | 广州市玄武无线科技股份有限公司 | Excel file-based picture storage and content display method and device |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1076797A (en) * | 1992-03-24 | 1993-09-29 | 松下电器产业株式会社 | Data searcher |
| 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
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1076797A (en) * | 1992-03-24 | 1993-09-29 | 松下电器产业株式会社 | Data searcher |
| 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 |
Also Published As
| Publication number | Publication date |
|---|---|
| CN1664817A (en) | 2005-09-07 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| JP5046881B2 (en) | Information processing apparatus, display control method, and program | |
| Van der Aalst et al. | Prom: The process mining toolkit | |
| US20130018805A1 (en) | Method and system for linking information regarding intellectual property, items of trade, and technical, legal or interpretive analysis | |
| Allesina et al. | WAND: an ecological network analysis user-friendly tool | |
| US20070005635A1 (en) | Importing database data to a non-database program | |
| US20110178981A1 (en) | Collecting community feedback for collaborative document development | |
| CA2669479A1 (en) | Generating end-user presentations from structured data | |
| MX2007011598A (en) | Determining fields for presentable files and extensible markup language schemas for bibliographies and citations. | |
| CN101288066B (en) | Directed signature workflow | |
| Ito et al. | A visual environment for dynamic web application composition | |
| CN101477516B (en) | Electronic data processing method and system | |
| CN100365630C (en) | Method for automatically switching between Oracle Form 9i and Microsoft Excel perspective charts | |
| CN101488086A (en) | Software generation method and apparatus based on field model | |
| CN101470861A (en) | Post model construction system and method based on GB/T19487 | |
| JPWO2004111877A1 (en) | Information processing method and apparatus, and program thereof | |
| CN105468793A (en) | Automated management method for simulation model data | |
| US7475090B2 (en) | Method and apparatus for moving data from an extensible markup language format to normalized format | |
| Bose et al. | Report on the International Provenance and Annotation Workshop: (IPAW'06) 3-5 May 2006, Chicago | |
| Shepherd et al. | Are ISO 15489‐1: 2001 and ISAD (G) compatible? Part 1 | |
| Khungar et al. | A context based storage for ubiquitous computing applications | |
| Singh et al. | Personalized information access in a wiki using structured tagging | |
| Gilliland-Swetland | Testing our truths: Delineating the parameters of the authentic archival electronic record | |
| Kemal Ataman | Requirements for information professionals in a digital environment: some thoughts | |
| EP1304630A2 (en) | Report generating system | |
| Simmons et al. | Patents, literature |
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. |