CN105786779A - Method for achieving multi-line report based on document template in WPS online plug-in - Google Patents
Method for achieving multi-line report based on document template in WPS online plug-in Download PDFInfo
- Publication number
- CN105786779A CN105786779A CN201610114950.6A CN201610114950A CN105786779A CN 105786779 A CN105786779 A CN 105786779A CN 201610114950 A CN201610114950 A CN 201610114950A CN 105786779 A CN105786779 A CN 105786779A
- Authority
- CN
- China
- Prior art keywords
- document template
- endtype
- multirow
- wps
- begintype
- 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
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/12—Use of codes for handling textual entities
- G06F40/151—Transformation
- G06F40/154—Tree transformation for tree-structured or markup documents, e.g. XSLT, XSL-FO or stylesheets
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Document Processing Apparatus (AREA)
Abstract
The invention aims at providing a processing method for achieving a multi-line report based on a document template in a WPS online plug-in through marks in a safe and reliable environment. In order to achieve the purpose, according to the technical scheme, the purpose of achieving the multi-line report based on the document template in the WPS online plug-in in the safe and reliable environment is achieved by means of the method, domestication migration of office information systems is promoted, the problem about generation of the universal multi-line report based on the document template can be solved, complex office format files can be processed, the workload and difficulty of customized development can be reduced, and modification and maintenance of the office information systems are promoted.
Description
Technical field
The present invention relates to a kind of method realizing in the online plug-in unit of WPS reporting under safe and reliable environment based on the multirow of document template.
Background technology
Government information system relates to official document and the file of a large amount of formatting, can simplify the editing of document by setting up document template, and based in the online office realm of safe and reliable hardware environment, the online plug-in unit of WPS occupies leading position.The replacement of single content of text can be realized by modes such as the keyword replacement in document template, boomard comment replacement, official document territories, but the multirow for comprising complex format is reported, then needing according to different document template customizations, exploitation and maintenance workload are big, in-convenience in use.
Summary of the invention
It is an object of the invention to provide a kind of processing method being realized by labelling and realizing in the online plug-in unit of WPS reporting based on the multirow of document template under safe and reliable environment.
In order to achieve the above object, the technical scheme is that and provide a kind of method realizing in the online plug-in unit of WPS reporting based on the multirow of document template under safe and reliable environment, it is characterised in that comprise the following steps:
Step 1, the original position that multirow is reported in document template add character string begintype, character string endtype is added in end place, for the content of a line report between begintype and endtype, keyword is to start ending and corresponding with the field name in database table；
Step 2, in the online plug-in unit of WPS, read multirow field value in document template and associated databases；
Step 3, retrieve and record the original position value PosBegin1 of begintype, end position value PosBegin2；Retrieve and record the original position value PosEnd1 of endtype, end position value PosEnd2
Step 4, replicate document content from PosBegin2 to PosEnd2 to clipbook, delete character string begintype；
Step 5, according in data base read data line, add before and after field name, replace from PosBegin2 to PosEnd1 the keyword content in region；
Step 6, from PosEnd1 position, choose endtype, the content in copying to Clipboard in gluing steps 4；
Step 7, repetition step 5 and step 6, until the multirow record read in data base has all been replaced；
Step 8, delete character string endtype；
Step 9, end.
Method provided by the invention, solve the problem realizing in the online plug-in unit of WPS reporting under safe and reliable environment based on the multirow of document template, the production domesticization being conducive to office information system migrates, advantageously account for the generalization multirow report generation problem based on document template, be conducive to processing complicated office formatted file, be conducive to, to workload and the difficulty reducing customized development, being conducive to change and the maintenance of office information system.
Detailed description of the invention
For making the present invention become apparent, hereby it is described in detail below with preferred embodiment.
An existing notice of meeting file needs, based on notice of meeting template file, to generate according to many units (including organization, unit address, contact person, contact method) of record in data base.
Replaced by the keyword based on document template, the mode such as boomard comment replacement, be only capable of processing single line of data, it is impossible to process multirow data；Customized development then needs to develop respectively according to each template, and user is difficult to freely adjust form, lacks versatility, and the construction cycle, long workload was big.
If using multirow reporting and processing method proposed by the invention, multirow data segment being carried out labelling, duplication and replacement, it is possible to freely defined reporting format by user, in the way of general, generating multirow report, without customized development.
Assuming that notice of meeting template file is meet.dot, corresponding database table is company, and field is compname, compaddr, contact, phone, it is necessary to the notice of meeting of generation is notice of meeting 001, then perform following steps:
Step 1, in notice of meeting template file meet.dot unit list part original position add begintype, end position add endtype.Add entry format word, form etc. at begintype and endtype according to call format, add compname in organization position, add compaddr in unit address position, add contact in contact location, add phone in telephone number position.
Step 2, to read notice of meeting template file in the online plug-in unit of WPS be the record (assuming there are 10 row) of meet.dot and database table company.
Step 3, retrieve and record the original position value PosBegin1 of begintype be 109, end position value PosBegin2 be 120；Retrieve and record the original position value PosEnd1 of endtype be 283, end position value PosEnd2 be 291.
Step 4, replicate from the document content of 120 to 291 to clipbook, delete character string begintype.
Step 5, according in data base read data line (unit A, XX road, Shanghai City YY, Zhang San, 021-11111111), replace the keyword content from 120 to 283 regions: compname replaces with unit A, compaddr replaces with XX road, Shanghai City YY, contact replaces with Zhang San, and phone replaces with 021-11111111.
Step 6, from 283 positions, choose endtype, the content in copying to Clipboard in gluing steps 4.
Step 7, repetition step 5 and step 6, until the 10 row records read in data base have all been replaced.
Step 8, delete character string endtype.
Step 9, end.
Above step describes the process realizing reporting based on the multirow of document template under safe and reliable environment in the online plug-in unit of WPS.
This method is realized by adopting, solve the problem realizing in the online plug-in unit of WPS reporting under safe and reliable environment based on the multirow of document template, the production domesticization being conducive to office information system migrates, advantageously account for the generalization multirow report generation problem based on document template, be conducive to processing complicated office formatted file, be conducive to, to workload and the difficulty reducing customized development, being conducive to change and the maintenance of office information system.
Claims (1)
1. the method realizing in the online plug-in unit of WPS reporting based on the multirow of document template under safe and reliable environment, it is characterised in that comprise the following steps:
Step 1, the original position that multirow is reported in document template add character string begintype, character string endtype is added in end place, for the content of a line report between begintype and endtype, keyword is to start ending and corresponding with the field name in database table；
Step 2, in the online plug-in unit of WPS, read multirow field value in document template and associated databases；
Step 3, retrieve and record the original position value PosBegin1 of begintype, end position value PosBegin2；Retrieve and record the original position value PosEnd1 of endtype, end position value PosEnd2；
Step 4, replicate document content from PosBegin2 to PosEnd2 to clipbook, delete character string begintype；
Step 5, according in data base read data line, add before and after field name, replace from PosBegin2 to PosEnd1 the keyword content in region；
Step 6, from PosEnd1 position, choose endtype, the content in copying to Clipboard in gluing steps 4；
Step 7, repetition step 5 and step 6, until the multirow record read in data base has all been replaced；
Step 8, delete character string endtype；
Step 9, end.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610114950.6A CN105786779B (en) | 2016-03-01 | 2016-03-01 | The method of the multirow report based on document template is realized in the online plug-in unit of WPS |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610114950.6A CN105786779B (en) | 2016-03-01 | 2016-03-01 | The method of the multirow report based on document template is realized in the online plug-in unit of WPS |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN105786779A true CN105786779A (en) | 2016-07-20 |
| CN105786779B CN105786779B (en) | 2019-03-05 |
Family
ID=56386899
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201610114950.6A Active CN105786779B (en) | 2016-03-01 | 2016-03-01 | The method of the multirow report based on document template is realized in the online plug-in unit of WPS |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN105786779B (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106897389A (en) * | 2017-01-24 | 2017-06-27 | 深圳市评估王信息科技有限公司 | Generate the device and method of report |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101131688A (en) * | 2006-08-24 | 2008-02-27 | 国际商业机器公司 | Spell checking documents with marked data blocks |
| CN103514343A (en) * | 2012-06-18 | 2014-01-15 | 奥林巴斯株式会社 | Device and method for generating endoscope inspection reports |
| US8661332B2 (en) * | 2004-04-30 | 2014-02-25 | Microsoft Corporation | Method and apparatus for document processing |
| CN103714492A (en) * | 2014-01-02 | 2014-04-09 | 广西电网公司电力科学研究院 | Automatic report generating method capable of meeting power distribution network management specific data standards |
| CN103729464A (en) * | 2014-01-15 | 2014-04-16 | 北京神州普惠科技股份有限公司 | Method for collecting report files |
| CN104424159A (en) * | 2013-09-04 | 2015-03-18 | 上海复旦微电子集团股份有限公司 | Software project document generating method and software project document generator |
-
2016
- 2016-03-01 CN CN201610114950.6A patent/CN105786779B/en active Active
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US8661332B2 (en) * | 2004-04-30 | 2014-02-25 | Microsoft Corporation | Method and apparatus for document processing |
| CN101131688A (en) * | 2006-08-24 | 2008-02-27 | 国际商业机器公司 | Spell checking documents with marked data blocks |
| CN103514343A (en) * | 2012-06-18 | 2014-01-15 | 奥林巴斯株式会社 | Device and method for generating endoscope inspection reports |
| CN104424159A (en) * | 2013-09-04 | 2015-03-18 | 上海复旦微电子集团股份有限公司 | Software project document generating method and software project document generator |
| CN103714492A (en) * | 2014-01-02 | 2014-04-09 | 广西电网公司电力科学研究院 | Automatic report generating method capable of meeting power distribution network management specific data standards |
| CN103729464A (en) * | 2014-01-15 | 2014-04-16 | 北京神州普惠科技股份有限公司 | Method for collecting report files |
Non-Patent Citations (3)
| Title |
|---|
| 李广利 等: "科技查新报告自动生成软件的设计与实现", 《现代图书情报技术》 * |
| 航爱: "基于关系型数据库和电子表格的独立报表工具的实现", 《中国优秀硕士学位论文全文数据库 信息科技辑》 * |
| 金良锋 等: "WORD试验报告的自动生成", 《中国测试技术》 * |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106897389A (en) * | 2017-01-24 | 2017-06-27 | 深圳市评估王信息科技有限公司 | Generate the device and method of report |
| CN106897389B (en) * | 2017-01-24 | 2021-01-15 | 深圳市评估王信息科技有限公司 | Report generation device and method |
Also Published As
| Publication number | Publication date |
|---|---|
| CN105786779B (en) | 2019-03-05 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103761318B (en) | A kind of method and system of relationship type synchronization of data in heterogeneous database | |
| CN103699638B (en) | Method for realizing cross-database type synchronous data based on configuration parameters | |
| CN103914458A (en) | Mass data migration method and device | |
| CN104331285A (en) | Automatic code generation method and system | |
| CN101697169A (en) | Method, device and system for data synchronization between source database and destination database | |
| CN105955970A (en) | Log analysis-based database copying method and device | |
| CN105183860A (en) | Data synchronization method and system | |
| CN105574109A (en) | Database synchronizing method and equipment and system | |
| CN106919612A (en) | A kind of processing method and processing device of SQL script of reaching the standard grade | |
| CN113051347B (en) | Method, system, equipment and storage medium for synchronizing data between heterogeneous databases | |
| CN102508886A (en) | Extensive makeup language (XML)-based method for synchronously updating increment of spatial data | |
| CN105488210A (en) | Batch data matching method and device | |
| CN104252531A (en) | File type identification method and device | |
| CN107273449B (en) | Breakpoint processing method and system based on memory database | |
| CN104123376B (en) | A kind of intelligent text collecting method and system based on row template | |
| CN106407288B (en) | Method and system for synchronously updating information | |
| CN106055582A (en) | Method and apparatus for replacing table name of database | |
| CN102262633A (en) | Structural data safe retrieving method oriented to full text retrieval | |
| CN105786779A (en) | Method for achieving multi-line report based on document template in WPS online plug-in | |
| CN102737082A (en) | Method and system for dynamically updating file data indexes | |
| CN103176979A (en) | Method, device and system for copying layout files online | |
| JP2015210815A (en) | Database management method and database management system | |
| CN116303777A (en) | Real-time synchronous replication method and system between heterogeneous databases | |
| CN110287185A (en) | The storage organization and method of the many-one relationship inquiry of Oriented Documents key value database | |
| CN105653509A (en) | Document processing 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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |