CN104715030B - A kind of document form covers printing method - Google Patents
A kind of document form covers printing method Download PDFInfo
- Publication number
- CN104715030B CN104715030B CN201510107187.XA CN201510107187A CN104715030B CN 104715030 B CN104715030 B CN 104715030B CN 201510107187 A CN201510107187 A CN 201510107187A CN 104715030 B CN104715030 B CN 104715030B
- Authority
- CN
- China
- Prior art keywords
- original document
- page
- document page
- cell
- actual
- 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.)
- Expired - Fee Related
Links
Landscapes
- Processing Or Creating Images (AREA)
Abstract
The invention discloses a kind of document form to cover printing method, comprises the following steps:Step 1):It is picture by original document scanning;Step 2) the newly-built original document page;Step 3) original document picture is imported to the original document page;Step 4) the design original document page;Step 5) the actual document page of design;Step 6) preserve report form template;Step 7) browse form;Step 8) report printing.It is also that non-set is beaten that the present invention, which makes reports user that document form set can be selected to beat when browsing form, adds the flexibility of document printing;And the non-set of document form beats the scanning figure without using original document as Background, ensure that the print quality of document form.
Description
Technical field
The present invention relates to a kind of document form to cover printing method.
Background technology
Report Form Design is the pith in IT application in enterprises, and according to statistics, 60% work of enterprise's application and development is all system
Make all kinds of forms, and wherein, document form is that bill occupies consequence wherein.The printing type of document form is divided into set
Beat and non-set is beaten, set, which is beaten, to be referred on the document printed, and printing content is printed into the position specified like clockwork;Rather than set
Beat to refer to and print document form on the document printing paper of blank and include the full content of form.Traditional report tool, it is necessary to
Data are measured out with a yardstick in the position beaten in background of set, then again on screen according to the position of sizing data place cell
Put, quite cumbersome, easily error.By the scanning figure of original document when the scheme that current document form set beats main flow is Report Form Design
Corresponding Database field is put as document form background, then in the position that it needs to print content, is only being printed during printing
The data that printing obtains from database on good document, if being desirable for non-set molding formula, the scanning figure of original document is made
It is printed upon for Background on document.
The report form tool of current domestic main flow, it is as follows that it designs the process of document form:1) original document is scanned
Into picture, and it is saved in specified folder;2) the newly-built document form in Report Designer, and using document scanning figure as paper
Background, document scanning background figure whether is printed when specifying document printing;3) form is designed;4) form is preserved to template file;5)
User browses form and performs set and beats in a browser.In the presence of following defect:
1) document form set beat also be it is non-set beat need by Report Form Design personnel design when specify, reports user is browsing
It can not be selected during form;
2) the non-set of document form, which was got through the scanning figure of original document being printed upon on document as Background, realizes, easily
There is the problem of font is fuzzy.
The content of the invention
To solve the above problems, the invention provides a kind of document form to cover printing method.
Technical scheme provided by the invention is:A kind of document form covers printing method, comprises the following steps:
Step 1):It is picture by original document scanning:It is original document picture that original document, which is scanned, the original list
It is identical with original document size according to picture;
Step 2) the newly-built original document page:The original document page is created, the original document page is blank page;
Step 3) original document picture is imported to the original document page:Original document picture is imported into the original document page
As background, the big of the adjustment original document page is as low as completely superposed with original document picture;
Step 4) the design original document page:On the original document page, set and background identical table border and quiet
State word, make the original document page and original document completely the same;
Step 5) the actual document page of design:Create the inchoate instrument page, i.e., actual document page, then by original list
Actual document page is all copied to according to the content outside Background in the page, Database field and form function are placed into reality
The correspondence position of document page;
Step 6) preserve report form template:Report form template saves as XML file, by the original document page, actual document page
Face, the difference of actual document page and the original document page, original document picture and retrieve the query statements of data and be saved in report
The different content node of table template, then preserves report form template;
Step 7) browse form:In report server, the data needed are retrieved with report data query statement, by it
It is filled into actual document page, generation WEB page shows user;
Step 8) report printing:Selection set molding formula or non-set molding formula, directly printing is real if non-set molding formula is selected
Border document page;If selection set is beaten, by the data retrieved by report data query statement and function expression evaluation knot
Fruit is filled into actual document page and the correspondence position in the difference page of the original document page, then prints this difference page.
Further to improve, the original document page and actual document page include some rows and several columns, described
Step 4) comprise the following steps:
1) it is high with row to adjust the col width of the original document page, makes each cell in original document picture, just includes
One or more cells on the original document page;
2) Merge Cells, merge the cell on the original document page, make each cell in background, it is corresponding to include
A cell on the original document page, some cell of document form includes original list even in original document Background
According to multiple cells on the page, then by this multiple cell span so that the unit in cell and Background after merging
Lattice are completely superposed;
3) form and cell borders are set:It is original according to the form and the frame of cell on original document picture
Corresponding cell sets identical frame on document page;
4) static text is added:Position addition corresponding with the word of original document picture is added on the original document page
Identical original document page word;The font and alignment thereof of the original document page word and the text of original document picture
Word is consistent.
Further to improve, the original document page and actual document page include some rows and several columns, described
Step 5) comprise the following steps:
A. the second worksheet is created, i.e., actual document page;
B. original document page actual use region is searched:The last location lattice in the original document page are searched, obtain it
Line number and row number, the line number and row in the region that actual document page needs to use are determined according to the line number of this element lattice and row number
Number;
C. adjustment row height and col width:The width of the height of the row in the region used in actual document page and row is arranged to
It is corresponding identical with the original document page;
D. Merge Cells is handled:The each cell effectively used in area is searched in the original document page, if the unit
Lattice are Merge Cells, then find out the cell set that the Merge Cells includes, and in actual document page by corresponding to
Merging treatment is done in cell set;
E. Copied Cells frame:The search original document page effectively uses each cell in area, if there is frame,
Corresponding unit lattice set identical frame in actual document page;
F. text is replicated:The original document page is searched for effectively using each cell in area, if there is text, in reality
Corresponding unit lattice set identical text in document page;
G., Database field and form function are set:Database field is obtained from data source or form function is placed into
The corresponding position of actual document page.
Further to improve, the original document page and actual document page include some rows and several columns, described
Step 6) in, the report form template saves as XML file, the original document page, actual document page, actual document page with
The difference of the original document page saves as an Area Node in the XML file, and each Area Node includes several rows
Node, the row that the row node corresponds in report form template, each row node include some cell nodes, the cell section
The cell that point corresponds in report form template, the attribute of each cell include width, frame, font, fill color and text etc.,
The attribute of the cell is determined by the setting of respective cells in report form template;The original document page and actual document page
Region child node is obtained by searching for each cell of report form template;The difference of actual document page and the original document page with
Based on the region child node of actual document page, by each cell of actual document page, subtract and appear in original document
All properties in corresponding unit lattice points, that is, obtain actual document worksheet and the region of the difference of original document worksheet
Child node;The original document picture is present under assigned catalogue, and original document picture file name, the number are preserved in report form template
Also it is stored according to query statement in the form of a node in report form template.
It is further to improve, in the step 8) in, set check box to indicate whether to cover on form browser interface
Beat, either set respectively on form browser interface set make button and non-set beat button or respectively setting cover and play menu and non-
Set plays menu.
The invention has the advantages that:
1) it is also that non-set is beaten and can selected by reports user when browsing form that document form set, which is beaten, adds document printing
Flexibility;
2) the non-set of document form beats the scanning figure without using original document as Background, ensure that beating for document form
Print quality.
Brief description of the drawings
When considered in conjunction with the accompanying drawings, by referring to following detailed description, can more completely more fully understand the present invention with
And easily learn many of which with the advantages of, but accompanying drawing described herein be used for a further understanding of the present invention is provided,
The part of the present invention is formed, schematic description and description of the invention is used to explain the present invention, do not formed to this hair
Bright improper restriction, wherein:
Fig. 1 documents form set beat/it is non-cover set meter schematic flow sheet;
Original Bill design process schematic in Fig. 2 EXCEL reporting systems;
The actual Bill design schematic flow sheets of Fig. 3;
Actual document process schematic is designed in Fig. 4 EXCEL reporting systems.
Embodiment
The present invention is described in detail as follows in conjunction with the embodiments:
The Report Designer of the embodiment of the present invention is developed using VSTO technologies based on EXCEL, and Microsoft Excel interface is to report
The Report Form Design interface of table system.
Step 1) by original document scanning be picture:Obtained original document picture size tune will be scanned with image software
Whole is identical with original document.
Step 2) the newly-built original document page:A blank workbook, i.e. original document page are created with Report Designer
Face.
Step 3) original document picture is imported to the original document page:Original document picture is imported to the original document page
As the background of the original document page, the upper left corner of original document picture is alignd with the upper left corner in Microsoft Excel region.
Step 4) the design original document page:Comprise the following steps as shown in Figure 2:
1) it is high with row to adjust the col width of the original document page, makes each cell of original document picture, just comprising original
One or more cells on beginning document worksheet;
2) Merge Cells, merge the cell on the original document page, make each cell in background, it is corresponding to include
A cell on the original document page, some cell of document form includes original list even in original document Background
According to multiple cells on worksheet, then by this multiple cell span so that the list in cell and Background after merging
First lattice are completely superposed;
3) form and cell borders are set:It is original according to the form and the frame of cell on original document picture
Corresponding cell sets identical frame on document page;
4) static text is added:Position addition corresponding with the word of original document picture is added on the original document page
Identical original document page word;The font and alignment thereof of the original document page word and the text of original document picture
Word is consistent.
Step 5) the actual document page of design:Create the inchoate instrument page, i.e., actual document page, then by original list
Actual document page is all copied to according to the content outside Background in the page, Database field and form function are placed into reality
The correspondence position of document page, step is as shown in Figure 3 and Figure 4:
1) the second worksheet, actual document page are created;
2) actual document page actual use region is searched:The lastCell cells in actual document page are searched, this
The line number and row number of cell determine the line number and columns in the region actually used in worksheet, be designated as respectively MaxRow and
MaxColumn;
3) adjustment row height and col width.For each arranging COL in actual document page, if its row number c meets c<=
MaxColumn, its width is arranged to identical with c row in the original document page, for each row in actual document page
ROW, if its line number r meets r<=MaxRow, its height is arranged to identical with r rows in the original document page;
4) Merge Cells is handled:The each cell effectively used in area is searched in the original document page, if the unit
Lattice are Merge Cells, then find out the cell set that the Merge Cells includes, and in actual document page by corresponding to
Merging treatment is done in cell set;
5) Copied Cells frame:The search original document page effectively uses each cell in area, if there is frame,
Corresponding unit lattice set identical frame in actual document page;
6) text is replicated:The original document page is searched for effectively using each cell in area, if there is text, in reality
Corresponding unit lattice set identical text in document page;
7) Database field and form function are set:Database field is obtained from data source or form function is placed into
The correct position of actual document page.
Step 6) preserve report form template:When preserving document report form template, herein below is saved in the difference of report form template
Content node:Original document worksheet, actual document worksheet, actual document worksheet and original document worksheet difference,
Original document picture, retrieve the query statement of data.In the present embodiment, report form template saves as XML file, original document page
Face, actual document page, the difference of actual document page and the original document page all save as a table in XML file
Node, each table nodes include several row nodes, corresponding to the row in document worksheet, if each row nodes include
Dry cell nodes, corresponding to the cell in document worksheet, each cell has width, frame, font, fill color and text
Deng attribute, determined by the setting of respective cells in document worksheet.Original document worksheet and actual document worksheet
Table child nodes are obtained by searching for each cell of its effective workspace.Actual document worksheet works with original document
The difference of table, for each cell therein, is subtracted based on the table child nodes of actual document and appears in original document
Each attribute in table child nodes, that is, obtain actual document worksheet and table of the difference of original document worksheet save
Point.The picture of original document is present under assigned catalogue, its filename is preserved in report form template, data query sentence is also with a section
The form of point is stored in report form template.
Step 7) browse form.Under the support of report server, the number to be shown is retrieved with report data query statement
According to, and fill it into actual document, i.e., replace the data in actual document table child nodes with the real data retrieved
Storehouse field and form function, WEB page is then generated according to this table child node and shows user.
Step 8) report printing.Document report printing is divided into covering to beat is beaten with non-set, and printing side is selected in order to facilitate user
Formula, browsed in form and the button that set is beaten and non-set is beaten is set on web page.When the non-set of progress is beaten, will directly be shown in step 7
Report printing out, when carry out set beat when, by the data in the difference table child nodes of actual document and original document
Storehouse field and form function are substituted with its actual value obtained in step 7, and generate WEB page simultaneously according to this table child node
This difference document is printed on the document paper for being printed with original document, realizes that set is beaten.
The description of the above examples is only intended to facilitate the understand of the core idea of the present invention;Meanwhile for the general of this area
Technical staff, according to the thought of the present invention, there will be changes in specific embodiments and applications, in summary,
This specification content should not be construed as limiting the invention.
Claims (5)
1. a kind of document form covers printing method, it is characterised in that comprises the following steps:
Step 1):It is picture by original document scanning:It is original document picture that original document, which is scanned, the original document figure
Piece is identical with original document size;
Step 2) the newly-built original document page:The original document page is created, the original document page is blank page;
Step 3) original document picture is imported to the original document page:Using original document picture import the original document page as
Background, the big of the adjustment original document page are as low as completely superposed with original document picture;
Step 4) the design original document page:On the original document page, set and background identical table border and static text
Word, make the original document page and original document completely the same;
Step 5) the actual document page of design:Create the inchoate instrument page, i.e., actual document page, then by original document page
Content in face outside Background all copies to actual document page, and Database field and form function are placed into actual document
The correspondence position of the page;
Step 6) preserve report form template:Report form template saves as XML file, by the original document page, actual document page, reality
The query statement of the difference page of border document page and the original document page, original document picture and retrieval data is saved in form
The different content node of template, then preserves report form template;
Step 7) browse form:In report server, the data needed are retrieved with report data query statement, are filled with
Into actual document page, generation WEB page shows user;
Step 8) report printing:Selection set molding formula or non-set molding formula, directly printing is actual single if non-set molding formula is selected
According to the page;If selection set is beaten, the data retrieved by report data query statement and function expression result of evaluation are filled out
Actual document page and the correspondence position in the difference page of the original document page are charged to, is then printed.
2. document form as claimed in claim 1 covers printing method, it is characterised in that the original document page and actual document
The page includes some rows and several columns, the step 4) comprise the following steps:
1) it is high with row to adjust the col width of the original document page, makes each cell of original document picture, just comprising original list
According to one or more cells on the page;
2) Merge Cells:Merge the cell on the original document page, make each cell in background picture, it is corresponding to include
A cell on the original document page, some cell of document form includes original list even in original document Background
According to multiple cells on the page, then by this multiple cell span so that the unit in cell and Background after merging
Lattice are completely superposed;
3) form and cell borders are set:It is original document according to the form and the frame of cell on original document picture
Corresponding cell sets identical frame on the page;
4) static text is added:Addition is identical with position addition corresponding to the word of original document picture on the original document page
Original document page word;The font and alignment thereof of the original document page word and the word one of original document picture
Cause.
3. document form as claimed in claim 1 covers printing method, it is characterised in that the original document page and actual document
The page includes some rows and several columns, the step 5) comprise the following steps:
A. the second worksheet is created, i.e., actual document page;
B. original document page actual use region is searched:The last location lattice (LastCell) in the original document page are searched,
The line number and columns in the region that actual document page needs to use are determined according to the line number of this element lattice and row number;
C. adjustment row height and col width:The width of the height of the row of actual document page and row is arranged to and original document page phase
The height for the row answered is identical with the width arranged;
D. Merge Cells is handled:The each cell effectively used in area is searched in the original document page, if the cell is
Merge Cells, then the cell set that the Merge Cells includes is found out, and by corresponding unit in actual document page
Merging treatment is done in lattice set;
E. Copied Cells frame:The original document page is searched for effectively using each cell in area, if there is frame, in reality
Corresponding unit lattice set identical frame in the document page of border;
F. text is replicated:The original document page is searched for effectively using each cell in area, if there is text, in actual document
Corresponding unit lattice set identical text in the page;
G., Database field and form function are set:Database field is obtained from data source or form function is placed into reality
The corresponding position of document page.
4. document form as claimed in claim 1 covers printing method, it is characterised in that the original document page and actual document
The page includes some rows and several columns, the step 6) in, the report form template saves as XML file, original document page
Face, actual document page, the difference Page-saving of actual document page and the original document page are one in the XML file
Area Node, each Area Node include several row nodes, the row that the row node corresponds in report form template, each row section
Point includes some cell nodes, the cell that the cell node corresponds in report form template, the attribute of each cell
Comprising width, frame, font, fill color and text etc., the attribute of the cell is set by respective cells in report form template
Put decision;The region child node of the original document page and actual document page is obtained by searching for each cell of report form template
Arrive;The difference of actual document page and the original document page, will be actual single based on the region child node of actual document page
According to each cell of the page, all properties appeared in original document corresponding unit lattice points are subtracted, that is, obtain reality
Document worksheet and the region child node of the difference of original document worksheet;The original document picture is present under assigned catalogue,
Original document picture file name is preserved in report form template, the data query sentence is also stored in form in the form of a node
In template.
5. document form as claimed in claim 1 covers printing method, it is characterised in that in the step 8) in, browsed in form
Check box is set to indicate whether that set is beaten, or setting set makes button respectively on form browser interface and non-set is beaten and pressed on interface
Button, or setting set plays menu respectively and non-set plays menu.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201510107187.XA CN104715030B (en) | 2015-03-12 | 2015-03-12 | A kind of document form covers printing method |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201510107187.XA CN104715030B (en) | 2015-03-12 | 2015-03-12 | A kind of document form covers printing method |
Publications (2)
Publication Number | Publication Date |
---|---|
CN104715030A CN104715030A (en) | 2015-06-17 |
CN104715030B true CN104715030B (en) | 2018-02-02 |
Family
ID=53414357
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201510107187.XA Expired - Fee Related CN104715030B (en) | 2015-03-12 | 2015-03-12 | A kind of document form covers printing method |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN104715030B (en) |
Families Citing this family (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN105196708A (en) * | 2015-09-22 | 2015-12-30 | 深圳前海百递网络有限公司 | Printing setting method and printing device |
CN108805684A (en) * | 2018-04-17 | 2018-11-13 | 海闻科技有限公司 | A kind of tax administration platform application system |
CN111367945A (en) * | 2020-02-28 | 2020-07-03 | 平安医疗健康管理股份有限公司 | Report query method, device, equipment and computer readable storage medium |
Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
EP1227407A2 (en) * | 2001-01-24 | 2002-07-31 | Seiko Instruments Inc. | User interface for creating printing templates |
CN101577009A (en) * | 2008-05-08 | 2009-11-11 | 北京润乾信息系统技术有限公司 | Method for realizing overlay printing on prior form |
CN102722899A (en) * | 2012-05-28 | 2012-10-10 | 重庆大学 | Positioning printing system for report |
CN103713901A (en) * | 2013-12-24 | 2014-04-09 | 金蝶软件(中国)有限公司 | Showing method and system of bills |
-
2015
- 2015-03-12 CN CN201510107187.XA patent/CN104715030B/en not_active Expired - Fee Related
Patent Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
EP1227407A2 (en) * | 2001-01-24 | 2002-07-31 | Seiko Instruments Inc. | User interface for creating printing templates |
CN101577009A (en) * | 2008-05-08 | 2009-11-11 | 北京润乾信息系统技术有限公司 | Method for realizing overlay printing on prior form |
CN102722899A (en) * | 2012-05-28 | 2012-10-10 | 重庆大学 | Positioning printing system for report |
CN103713901A (en) * | 2013-12-24 | 2014-04-09 | 金蝶软件(中国)有限公司 | Showing method and system of bills |
Non-Patent Citations (2)
Title |
---|
"EXCEL实现票据套打高效化";hezongwu2009;《百度文库》;20130524;参见第1-8节、图1-9 * |
"如何用excel制作表格套打格式";nhpntyhht,;《百度文库》;20111208;参见第2-4节 * |
Also Published As
Publication number | Publication date |
---|---|
CN104715030A (en) | 2015-06-17 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN104281447B (en) | The system and method that a kind of form is quickly generated and issued | |
DE60314806T2 (en) | Extraction of information from structured documents | |
EP3358470B1 (en) | Method of preparing documents in markup languages | |
CN101025738A (en) | Template-free dynamic website generating method | |
US20020169803A1 (en) | System and user interface for generating structured documents | |
US20120254733A1 (en) | Method for Users to Create and Edit Web Page Layouts | |
CN103778172B (en) | A kind of paper information saving method and a kind of paper edit methods and system | |
CN104715030B (en) | A kind of document form covers printing method | |
CN101788994A (en) | Method for constructing data display model and method and device for displaying data | |
EA012487B1 (en) | A method of displaying data in a table | |
CN102722475A (en) | Method for converting form in portable document format (PDF) document into Excel form | |
CN108399054B (en) | Document segmentation printing method | |
CN104020984A (en) | Method and device for generating static page | |
CN105094930A (en) | Image positioning system and method | |
CN104715032A (en) | Mapping system and method of Chinese and English table name and field name of report system | |
CN112307720A (en) | PSD (position sensitive Detector) document-based HTML (Hypertext markup language) design template automatic conversion method and system | |
CN109213480A (en) | A kind of method, storage medium, equipment and system for developing the back-stage management page | |
US8762398B2 (en) | Method of integrating data of XML document with database on web | |
US20050125724A1 (en) | PPML to PDF conversion | |
CN107193549A (en) | Webpage quick development method based on metadata | |
CN101996190B (en) | Method and device for extracting information from webpage | |
CN111597771A (en) | Method, device, electronic equipment and medium for adjusting document content format | |
CN103605640B (en) | Form adaption method and device | |
CN103559344A (en) | Territory preprocessing method for laser direct imaging | |
US20110126091A1 (en) | Information processing apparatus, control method, and program |
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 | ||
CF01 | Termination of patent right due to non-payment of annual fee | ||
CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20180202 Termination date: 20210312 |