CN108334485A - A method of realizing that a key generates world reports with automatic technology - Google Patents
A method of realizing that a key generates world reports with automatic technology Download PDFInfo
- Publication number
- CN108334485A CN108334485A CN201810040347.7A CN201810040347A CN108334485A CN 108334485 A CN108334485 A CN 108334485A CN 201810040347 A CN201810040347 A CN 201810040347A CN 108334485 A CN108334485 A CN 108334485A
- Authority
- CN
- China
- Prior art keywords
- xml
- word
- browser
- data
- reports
- 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/186—Templates
Abstract
It realizing that a key generates the method that world is reported with automatic technology the present invention relates to a kind of, is run directly in browser with the browser automated test frame in OA technologies, make click, input, opening and verification according to scripted code automatically；XML model is established, graphical XML, table XML, field XML model are formulated according to Word, data-driven generates XML data；Word models are established, according to word developing instruments, XML mapping pane mappings is mapped with XMLl template elements, reach self-defined pattern, custom content；Browser automated test frame drives PhantomJS operations, selection according to user, crawl generates the required graph text information of word reports from system in real time, the information of acquisition is carried out typesetting according to the pattern of program setting or the pattern of prefabricated template, a key exports the word document needed for user.The present invention is based on office standards, and with OA technologies, framework is more flexible, and new user file is generated with data-driven, can change data template at any time.
Description
Technical field
The present invention relates to the technical fields that automation generates report, more particularly, to a kind of real with automatic technology
The method that an existing key generates world reports.
Background technology
Currently, sproc（Program）There are many statistics pages and table to use for production system, can not good export world
Report, format are unsatisfactory for requiring or needing exploitation code again.
Original world deriving methods need that world files are first converted into world2003, reconvert at html files,
It is finally implanted into freemarker language, after being implanted into freemarker Loop, template cannot be opened by world again, it is difficult to be investigated
Template Error.Substantially it is because not supporting picture to generate.
Invention content
Realizing that a key generates with automatic technology it is an object of the invention to overcome the deficiencies of the prior art and provide a kind of
The method of world reports, new user file is generated with data-driven, can change data template at any time, disposition data source is saved
User goes in system the workload of the step of intercepting chart and editor's report manually.
To solve the above problems, technical solution provided by the invention is：It is a kind of to realize that a key generates with automatic technology
The method of world reports, wherein include the following steps：
S1. it is run directly in browser with the browser automated test frame in OA technologies, automatically according to scripted code
Make click, input, opening and verification；Selenium (browser automated test frame)-run directly in browser, from
It is dynamic to make the operations such as click, input, opening, verification according to scripted code, just as real user in operation, used from terminal
The angle measurement application program at family；PhantomJS- is a JavaScript API based on server end, it is supported comprehensively
Web can be used for the page and automate without browser, network monitor, Web page screen-cutting, and without interface operation etc., visually
For server-side browser.
S2. XML model is established, graphical XML, table XML, field XML model are formulated according to Word, data-driven generates
XML data；
S3. Word models are established, according to word developing instruments, XML mapping pane mappings are mapped with XMLl template elements,
Reach self-defined pattern, custom content；
S4. browser automated test frame driving PhantomJS operations are captured from system in real time according to the selection of user
The required graph text information of word reports is generated, the information of acquisition according to the pattern of program setting or the sample of prefabricated template
Formula carries out typesetting, and a key exports the word document needed for user.
Further, further include the java class library created using Docx4j with operating Microsoft Open XML files.
Compared with prior art, advantageous effect is：It is provided by the invention a kind of with automatic technology realization one key generation
The method of word reports, framework is more flexible, and new user file is generated with data-driven, can change data template at any time, match
Set data source；Production system data output capacities are extended, front and back end is integrated, and browser is drawn a diagram, automation driving；Using side
Just, module does not couple directly with module, and export can be provided for arbitrary heterogeneous system and is supported.
Description of the drawings
Fig. 1 is the method for the present invention flow chart.
Fig. 2 is present invention automation generating process schematic diagram.
Fig. 3 is word document generating principle figure of the present invention.
Specific implementation mode
The attached figures are only used for illustrative purposes and cannot be understood as limitating the patent；It is attached in order to more preferably illustrate the present embodiment
Scheme certain components to have omission, zoom in or out, does not represent the size of actual product；To those skilled in the art,
The omitting of some known structures and their instructions in the attached drawings are understandable.Being given for example only property of position relationship described in attached drawing
Illustrate, should not be understood as the limitation to this patent.
If Fig. 1 is to as indicated at 3, a method of realizing that a key generates world reports with automatic technology, wherein packet
Include following steps：
S1. it is run directly in browser with the browser automated test frame in OA technologies, automatically according to scripted code
Make click, input, opening and verification；Selenium (browser automated test frame)-run directly in browser, from
It is dynamic to make the operations such as click, input, opening, verification according to scripted code, just as real user in operation, used from terminal
The angle measurement application program at family；PhantomJS- is a JavaScript API based on server end, it is supported comprehensively
Web can be used for the page and automate without browser, network monitor, Web page screen-cutting, and without interface operation etc., visually
For server-side browser.
S2. XML model is established, graphical XML, table XML, field XML model are formulated according to Word, data-driven generates
XML data；
S3. Word models are established, according to word developing instruments, XML mapping pane mappings are mapped with XMLl template elements,
Reach self-defined pattern, custom content；
S4. browser automated test frame driving PhantomJS operations are captured from system in real time according to the selection of user
The required graph text information of word reports is generated, the information of acquisition according to the pattern of program setting or the sample of prefabricated template
Formula carries out typesetting, and a key exports the word document needed for user.
Specifically, further include the java class library created using Docx4j with operating Microsoft Open XML files.
Obviously, the above embodiment of the present invention be only to clearly illustrate example of the present invention, and not be pair
The restriction of embodiments of the present invention.For those of ordinary skill in the art, may be used also on the basis of the above description
To make other variations or changes in different ways.There is no necessity and possibility to exhaust all the enbodiments.It is all this
All any modification, equivalent and improvement etc., should be included in the claims in the present invention made by within the spirit and principle of invention
Protection domain within.
Claims (2)
1. a kind of method for realizing that a key generates world reports with automatic technology, which is characterized in that include the following steps：
S1. it is run directly in browser with the browser automated test frame in OA technologies, automatically according to scripted code
Make click, input, opening and verification；
S2. XML model is established, graphical XML, table XML, field XML model are formulated according to Word, data-driven generates XML numbers
According to；
S3. Word models are established, according to word developing instruments, XML mapping pane mappings are mapped with XMLl template elements,
Reach self-defined pattern, custom content；
S4. browser automated test frame driving PhantomJS operations are captured from system in real time according to the selection of user
The required graph text information of word reports is generated, the information of acquisition according to the pattern of program setting or the sample of prefabricated template
Formula carries out typesetting, and a key exports the word document needed for user.
2. a kind of method for realizing that a key generates world reports with automatic technology according to claim 1, special
Sign is, further includes the java class library created using Docx4j with operating Microsoft Open XML files.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810040347.7A CN108334485A (en) | 2018-01-16 | 2018-01-16 | A method of realizing that a key generates world reports with automatic technology |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810040347.7A CN108334485A (en) | 2018-01-16 | 2018-01-16 | A method of realizing that a key generates world reports with automatic technology |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN108334485A true CN108334485A (en) | 2018-07-27 |
Family
ID=62925139
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201810040347.7A Pending CN108334485A (en) | 2018-01-16 | 2018-01-16 | A method of realizing that a key generates world reports with automatic technology |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN108334485A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111523296A (en) * | 2020-04-16 | 2020-08-11 | 山东贝赛信息科技有限公司 | Method for generating public opinion report based on Selenium |
| CN112069434A (en) * | 2020-09-24 | 2020-12-11 | 中盈优创资讯科技有限公司 | Method and device for generating word document by one key on web interface |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20130055075A1 (en) * | 2007-12-14 | 2013-02-28 | Ebay Inc. | Identification of content in an electronic document |
| CN103020027A (en) * | 2012-11-16 | 2013-04-03 | 北京北森测评技术有限公司 | Method, device and system for generating dynamic report |
| CN104750796A (en) * | 2014-11-13 | 2015-07-01 | 安徽四创电子股份有限公司 | Method for leading out Word under BS system |
| CN107203627A (en) * | 2017-05-27 | 2017-09-26 | 山东浪潮通软信息科技有限公司 | The method of mutual phase transformation between a kind of structural data and Word document |
-
2018
- 2018-01-16 CN CN201810040347.7A patent/CN108334485A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20130055075A1 (en) * | 2007-12-14 | 2013-02-28 | Ebay Inc. | Identification of content in an electronic document |
| CN103020027A (en) * | 2012-11-16 | 2013-04-03 | 北京北森测评技术有限公司 | Method, device and system for generating dynamic report |
| CN104750796A (en) * | 2014-11-13 | 2015-07-01 | 安徽四创电子股份有限公司 | Method for leading out Word under BS system |
| CN107203627A (en) * | 2017-05-27 | 2017-09-26 | 山东浪潮通软信息科技有限公司 | The method of mutual phase transformation between a kind of structural data and Word document |
Non-Patent Citations (4)
| Title |
|---|
| 姚进林: "基于OOXML的Word文档服务研究与实现", 《中国优秀硕士学位论文全文数据库信息科技辑》 * |
| 方睿，等: "WordML文档转换器", 《计算机应用》 * |
| 王友刚，等: "WordML在线性数字化技术手册中的应用", 《计算机测量与控制》 * |
| 王娟，等: "兴趣社交网站中意见领袖识别的研究——以"点点网"为例", 《图书情报工作》 * |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111523296A (en) * | 2020-04-16 | 2020-08-11 | 山东贝赛信息科技有限公司 | Method for generating public opinion report based on Selenium |
| CN112069434A (en) * | 2020-09-24 | 2020-12-11 | 中盈优创资讯科技有限公司 | Method and device for generating word document by one key on web interface |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US20210318866A1 (en) | Auto-generation of api documentation via implementation-neutral analysis of api traffic | |
| US8065655B1 (en) | System and method for the autogeneration of ontologies | |
| US8490050B2 (en) | Automatic generation of user interfaces | |
| CN105068815B (en) | Page editing device interactive device and method | |
| CN107807913A (en) | A kind of form design system and method based on web | |
| CN110083790A (en) | Page editing method, page output method, device, computer equipment and medium | |
| CN104410720B (en) | A kind of real-time monitoring platform system and method based on web graph shape | |
| US10419568B2 (en) | Manipulation of browser DOM on server | |
| CN103970750B (en) | A kind of method and apparatus generating html web page | |
| CN111930635A (en) | Swagger-based rapid automatic testing method and system | |
| US20020066074A1 (en) | Method and system for developing and executing software applications at an abstract design level | |
| CN108334485A (en) | A method of realizing that a key generates world reports with automatic technology | |
| CN110134427A (en) | A kind of method and apparatus generating code file | |
| CN108984632A (en) | A kind of webpage setting method and device | |
| CN106776638A (en) | Database operation method and device | |
| CN110196809A (en) | Interface test method and device | |
| CN112083926A (en) | Web user interface generation method and device | |
| US20200293592A1 (en) | Methods and systems for browser extension used to generate relative xpath, absolute xpath and/or css selectors | |
| CN113312035B (en) | Hyperledger Fabric-oriented intelligent contract development plug-in implementation method | |
| CN113553269A (en) | Page buried point reporting method and related device | |
| CN109086040A (en) | A kind of method and system quickly generating html code | |
| CN105279032B (en) | A kind of method and device of sync cap message and javaBean | |
| CN112199373A (en) | Form development method and system | |
| CN110807056A (en) | Excel-based report processing method, Excel-based report processing device, Excel-based report processing medium and electronic equipment | |
| CN106598554A (en) | Code generating apparatus |
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 | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20180727 |
|
| RJ01 | Rejection of invention patent application after publication |