CN105786779B - The method of the multirow report based on document template is realized in the online plug-in unit of WPS - Google Patents
The method of the multirow report based on document template is realized in the online plug-in unit of WPS Download PDFInfo
- Publication number
- CN105786779B CN105786779B CN201610114950.6A CN201610114950A CN105786779B CN 105786779 B CN105786779 B CN 105786779B CN 201610114950 A CN201610114950 A CN 201610114950A CN 105786779 B CN105786779 B CN 105786779B
- Authority
- CN
- China
- Prior art keywords
- multirow
- document template
- wps
- unit
- endtype
- 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
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
Abstract
The processing method for realizing that the multirow based on document template is reported in the online plug-in unit of WPS under safe and reliable environment is realized by label the object of the present invention is to provide a kind of.In order to achieve the above object, the technical solution of the present invention is to provide a kind of realizes the multirow report based on document template under safe and reliable environment method in the online plug-in unit of WPS.Method provided by the invention, solves the problems, such as to realize the multirow report based on document template in the online plug-in unit of WPS under safe and reliable environment, be conducive to the production domesticization migration of office information system, advantageously account for the generalization multirow report generation problem based on document template, be conducive to the complicated office formatted file of processing, be conducive to be conducive to the change and maintenance of office information system to the workload and difficulty that reduce customized development.
Description
Technical field
The present invention relates to a kind of to realize the multirow report based on document template under safe and reliable environment in the online plug-in unit of WPS
Method.
Background technique
Government information system is related to the official document and file largely formatted, can simplify by establishing document template
The editing of document, in the online office realm based on safe and reliable hardware environment, the online plug-in unit of WPS is occupied predominantly
Position.Single content of text may be implemented by modes such as keyword replacement, boomard comment replacement, official document domains in document template
Replacement, but the multirow comprising complex format is reported, then it needs to customize according to different document templates, exploitation and maintenance work
Amount is big, inconvenient to use.
Summary of the invention
It is realized the object of the present invention is to provide one kind by label and realizes base in the online plug-in unit of WPS under safe and reliable environment
In the processing method that the multirow of document template is reported.
In order to achieve the above object, the technical solution of the present invention is to provide one kind WPS under safe and reliable environment is online
The method of the multirow report based on document template is realized in plug-in unit, which comprises the following steps:
Character string@begintype@is added in step 1, the initial position that multirow is reported in document template, adds at end
It is the content of a line report between padding string@endtype@,@begintype@and@endtype@, keyword starts@@with@@
It ends up and corresponding with the field name in database table;
Step 2 reads multirow field value in document template and associated databases in the online plug-in unit of WPS;
Step 3, initial position value PosBegin1, the end position value PosBegin2 for retrieving and recording@begintype@;
It retrieves and records the initial position value PosEnd1 of@endtype@, end position value PosEnd2
Step 4, document content of the duplication from PosBegin2 to PosEnd2 to clipbook, delete character string
begintype@;
Step 5, according to the data line read in database, before and after field name plus@@, replacement from PosBegin2 to
The keyword content in the region PosEnd1;
Step 6, since the position PosEnd1, choose@endtype@, copied to Clipboard in gluing steps 4 in it is interior
Hold;
Step 7 repeats step 5 and step 6, until the multirow record all replacement completions read in database;
Step 8 deletes character string endtype;
Step 9 terminates.
Method provided by the invention is solved and is realized in the online plug-in unit of WPS based on document template under safe and reliable environment
Multirow report the problem of, be conducive to office information system production domesticization migration, advantageously account for based on the general of document template
Change multirow report generation problem, is conducive to the complicated office formatted file of processing, is conducive to the workload for reducing customized development
And difficulty, be conducive to the change and maintenance of office information system.
Specific embodiment
In order to make the present invention more obvious and understandable, it is hereby described in detail below with preferred embodiment.
An existing notice of meeting file is needed based on notice of meeting template file, according to the more lists recorded in database
Position (including organization, unit address, contact person, contact method) generates.
By modes such as the replacement of keyword based on document template, boomard comment replacements, it is only capable of processing single line of data, it can not
Handle multirow data;Customized development then needs to be developed respectively according to each template, and user is difficult to freely adjust format, lacks general
Property, development cycle long heavy workload.
If multirow data segment is marked, replicates and is replaced using multirow reporting and processing method proposed by the invention
It changes, reporting format can freely be defined by user, multirow report is generated in general mode, 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, the notice of meeting for needing to generate are notice of meeting 001, then execute following step
It is rapid:
Step 1 ,@is added in the initial position of unit list part in notice of meeting template file meet.dot
Begintype@, end position add@endtype@.Format is added according to call format in@begintype@and@endtype@
Text, table etc., add@@compname@@in organization position, add@@compaddr@@in unit address position,
Contact location adds@@contact@@, adds@@phone@@in telephone number position.
Step 2 reads notice of meeting template file in the online plug-in unit of WPS as meet.dot and database table company
Record (assuming that having 10 rows).
Step 3, the initial position value PosBegin1 for retrieving and recording@begintype@are 109, end position value
PosBegin2 is 120;The initial position value PosEnd1 for retrieving and recording@endtype@is 283, end position value PosEnd2
It is 291.
Step 4, document content of the duplication from 120 to 291 to clipbook, delete character string begintype.
Step 5, according to data line (unit A, the Shanghai City road XX YY, Zhang San, 021- read in database
11111111), the keyword content in replacement region from 120 to 283: compname replacement is unit A, compaddr
The Shanghai City road XX YY is replaced with ,@@contact@@replaces with Zhang San, and@@phone@@replaces with 021-11111111.
Step 6, since 283 positions, choose@endtype@, copied to Clipboard in gluing steps 4 in content.
Step 7 repeats step 5 and step 6, until the 10 rows record all replacement completions read in database.
Step 8 deletes character string endtype.
Step 9 terminates.
Above step describes the multirow report realized in the online plug-in unit of WPS under safe and reliable environment based on document template
Process.
By using this implementation method, solves and realized in the online plug-in unit of WPS based on document under safe and reliable environment
The problem of multirow report of template, is conducive to the production domesticization migration of office information system, advantageously accounts for based on document template
Generalization multirow report generation problem is conducive to the complicated office formatted file of processing, is conducive to the work for reducing customized development
Work amount and difficulty are conducive to the change and maintenance of office information system.
Claims (1)
1. a kind of method for realizing the multirow report based on document template in the online plug-in unit of WPS under safe and reliable environment, special
Sign is, comprising the following steps:
Character string@begintype@is added in step 1, the initial position that multirow is reported in document template, and word is added at end
It is the content of a line report between symbol string@endtype@,@begintype@and@endtype@, keyword is ended up with@@beginning@@
And it is corresponding with the field name in database table;
Step 2 reads multirow field value in document template and associated databases in the online plug-in unit of WPS;
Step 3, initial position value PosBegin1, the end position value PosBegin2 for retrieving and recording@begintype@;Retrieval
And record the initial position value PosEnd1 of@endtype@, end position value PosEnd2;
Step 4, document content of the duplication from PosBegin2 to PosEnd2 to clipbook, delete character string begintype;
Step 5, according to the data line read in database, before and after field value plus@@, replacement from PosBegin2 to
The keyword content in the region PosEnd1;
Step 6, since the position PosEnd1, choose@endtype@, copied to Clipboard in gluing steps 4 in content;
Step 7 repeats step 5 and step 6, until the multirow record all replacement completions read in database;
Step 8 deletes character string endtype;
Step 9 terminates.
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 CN105786779A (en) | 2016-07-20 |
CN105786779B true 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) |
Families Citing this family (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN106897389B (en) * | 2017-01-24 | 2021-01-15 | 深圳市评估王信息科技有限公司 | Report generation device and method |
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试验报告的自动生成;金良锋 等;《中国测试技术》;20070731;第33卷(第4期);第112-115页 |
基于关系型数据库和电子表格的独立报表工具的实现;航爱;《中国优秀硕士学位论文全文数据库 信息科技辑》;20090215;第5章 |
科技查新报告自动生成软件的设计与实现;李广利 等;《现代图书情报技术》;20131231(第2期);第82-87页 |
Also Published As
Publication number | Publication date |
---|---|
CN105786779A (en) | 2016-07-20 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN102291453B (en) | Data synchronization method and device | |
CN108776702A (en) | A kind of data make a report on page user-defined visual configuration method | |
CN103377203A (en) | Terminal and sound record management method | |
CN106446292A (en) | Front-end data two-way binding achieving method and device | |
CN106408145A (en) | Fixed asset management system | |
CN105488210A (en) | Batch data matching method and device | |
CN105786779B (en) | The method of the multirow report based on document template is realized in the online plug-in unit of WPS | |
WO2018226255A1 (en) | Functional equivalence of tuples and edges in graph databases | |
CN106407288A (en) | Method and system for synchronously updating information | |
CN103092479A (en) | Method, device and system for information switching through right button | |
CN110716913B (en) | Mutual migration method of Kafka and Elasticissearch database data | |
CN102171696B (en) | The generation method and apparatus of customization data | |
CN103778231A (en) | Method and system for managing operation record information, of databank | |
CN107193961B (en) | Information recording method and apparatus | |
CN113326276A (en) | Graph database updating method and device | |
CN106776510A (en) | Word embeds form generation method and device | |
JP2012155681A (en) | Font server | |
JP2007065778A5 (en) | ||
CN105335503A (en) | Digitized archive information full featured system | |
CN109118156B (en) | Book information collaboration system and method | |
CN105045728A (en) | Local cache method | |
Ozment | From recovery to restoration: Aphra behn and feminist bibliography | |
CN103345441B (en) | Network printing works in coordination with structure and the guard method of the top of a page object typesetting daily record in typesetting | |
CN109582826A (en) | A kind of mobile data services storage exchange method based on general purpose table storage and xml | |
CN110069628A (en) | A kind of accurate software design approach collecting meeting summary |
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 |