CN108959230A - A kind of method and apparatus generating report template - Google Patents
A kind of method and apparatus generating report template Download PDFInfo
- Publication number
- CN108959230A CN108959230A CN201810816631.9A CN201810816631A CN108959230A CN 108959230 A CN108959230 A CN 108959230A CN 201810816631 A CN201810816631 A CN 201810816631A CN 108959230 A CN108959230 A CN 108959230A
- Authority
- CN
- China
- Prior art keywords
- template
- column
- report
- data
- self
- 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/166—Editing, e.g. inserting or deleting
- G06F40/186—Templates
-
- 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/174—Form filling; Merging
Abstract
The embodiment of the invention discloses a kind of method and apparatus for generating report template, which comprises creation self-defined template, and set the attribute arranged in the template；The template generated is imported into system after filling data；The verifying of data is carried out according to the template, and is saved in corresponding system database as system data.The embodiment of the present invention can accomplish customizable for different reports, save a large amount of development time, improve work efficiency, also increase the ease for use of system.
Description
Technical field
The present invention relates to cloud computing technology, espespecially a kind of method and apparatus for generating report template.
Background technique
JavaWeb is the system by page access realized with java technology, in a javaWeb system, is imported
The data set of excel is common function.In actual application, since system can be applied by the subsidiary of each province, often
A subsidiary is all less identical for the call format of the data of excel, has a column data to have to fill out if any whole family company,
But another subsidiary is then without the data of the column.In the prior art, it is needed according to previous development Experience public to each height
Department carries out excel model customization, but since subsidiary is more, using the very big workload of the method needs of customization and very much
It is all low-level repetition.
Therefore, the prior art is long there are the development time, working efficiency is low, the problem of system ease for use difference.
Summary of the invention
In order to solve the above-mentioned technical problem, the embodiment of the invention provides it is a kind of generate report template method and apparatus,
Customizable can be accomplished for different reports, save a large amount of development time, improve work efficiency, also increase
The ease for use of system.
In order to reach the object of the invention, on the one hand, the embodiment of the invention provides a kind of method for generating report template, packets
It includes:
Self-defined template is created, and sets the attribute arranged in the template；
The template generated is imported into system after filling data；
The verifying of data is carried out according to the template, and is saved in corresponding system database as system data.
Further, the creation self-defined template includes:
The union of the related column name of all report demands of summarizing, and save in correspondence table in the database；
Corresponding column are arranged, determine the general essential column of all reports.
Further, the method also includes:
Self-defined template interface is created, interface is divided into left and right two large divisions, and left side shows all column names, and right side is described
Column in self-defined template.
Further, the method also includes:
After the column for determining right side, the corresponding format of right-hand column is determined, wherein corresponding three kinds of formats difference in system
It is Rich Text Format, number format, date format.
Further, the method also includes:
User is perhaps dragged to right side when creating the self-defined template, by the double-click of the column in left side or by right side
Column remove.
Further, the method also includes:
Corresponding report file is found in systems and is downloaded, and according to the requirement arranged in report after downloading, is filled in corresponding
The format setting of data and part column；
After data are filled in, when importing, the corresponding template of the report file is selected in the page, then system is believed according to template
The excel report Auto-matching to importing is ceased, verifies and imported into database.
On the other hand, the embodiment of the invention also provides a kind of devices for generating report template, comprising:
Creation module for creating self-defined template, and sets the attribute arranged in the template；
Import modul, the template for generation are imported into system after filling data；
Preserving module for carrying out the verifying of data according to the template, and is saved in corresponding system database and makees
For system data.
Further, the creation module is also used to:
The union of the related column name of all report demands of summarizing, and save in correspondence table in the database；
Corresponding column are arranged, determine the general essential column of all reports.
Further, the creation module is also used to:
Self-defined template interface is created, interface is divided into left and right two large divisions, and left side shows all column names, and right side is described
Column in self-defined template.
Further, the creation module is also used to:
After the column for determining right side, the corresponding format of right-hand column is determined, wherein corresponding three kinds of formats difference in system
It is Rich Text Format, number format, date format.
Further, the creation module is also used to:
User is perhaps dragged to right side when creating the self-defined template, by the double-click of the column in left side or by right side
Column remove.
Further, described device is also used to:
Corresponding report file is found in systems and is downloaded, and according to the requirement arranged in report after downloading, is filled in corresponding
The format setting of data and part column；
After data are filled in, when importing, the corresponding template of the report file is selected in the page, then system is believed according to template
The excel report Auto-matching to importing is ceased, verifies and imported into database.
The embodiment of the present invention sets the attribute arranged in the template by creation self-defined template；The mould generated
Plate is imported into system after filling data；The verifying of data is carried out according to the template, and is saved in corresponding system data
System data is used as in library.The embodiment of the present invention can accomplish customizable for different reports, save and largely open
The time is sent out, improves work efficiency, also increases the ease for use of system.
Other features and advantages of the present invention will be illustrated in the following description, also, partly becomes from specification
It obtains it is clear that understand through the implementation of the invention.The objectives and other advantages of the invention can be by specification, right
Specifically noted structure is achieved and obtained in claim and attached drawing.
Detailed description of the invention
Attached drawing is used to provide to further understand technical solution of the present invention, and constitutes part of specification, with this
The embodiment of application technical solution for explaining the present invention together, does not constitute the limitation to technical solution of the present invention.
Fig. 1 is the flow chart for the method that the embodiment of the present invention generates report template；
Fig. 2 is the structure chart for the device that the embodiment of the present invention generates report template.
Specific embodiment
To make the objectives, technical solutions, and advantages of the present invention clearer, below in conjunction with attached drawing to the present invention
Embodiment be described in detail.It should be noted that in the absence of conflict, in the embodiment and embodiment in the application
Feature can mutual any combination.
Step shown in the flowchart of the accompanying drawings can be in a computer system such as a set of computer executable instructions
It executes.Also, although logical order is shown in flow charts, and it in some cases, can be to be different from herein suitable
Sequence executes shown or described step.
Fig. 1 is the flow chart for the method that the embodiment of the present invention generates report template, as shown in Figure 1, the embodiment of the present invention
Method the following steps are included:
Step 100: creation self-defined template, and set the attribute arranged in the template；
Step 101: the template of generation is imported into system after filling data；
Step 102: carrying out the verifying of data according to the template, and be saved in corresponding system database as system
Data.
Specifically, the embodiment of the present invention is the customized realization side for importing excel data template in a kind of javaWeb system
Method, including:
Database design, the union of the related column name of the report demand of all subsidiaries of summarizing, and it is stored in number
According in the correspondence table in library, corresponding column are arranged, determine which is the general essential column of all reports.
Interface, at creation self-defined template interface, interface is divided into left and right two large divisions, and the left side shows all column
Name, the right are then the column in the self-defined template, and the column in left side can be double-clicked or be dragged when creating self-defined template by user
It is pulled to right side, or the column on right side are removed.The general essential column determined in database design are defaulted in system
Right side and cannot remove.After the column for determining right side, the corresponding format of right-hand column can be designed, it is corresponding in system at present
Three kinds of formats, Rich Text Format, number format, date format.Save button is clicked, corresponding report name, such as XX are inputted
2018 data sheet of company produces corresponding report file and saves in systems.
User can find corresponding report file in systems and download, and only need to want according to what is arranged in report after downloading
It asks, fill in corresponding data and pays attention to the constraint of required item, wherein required item can be indicated in the report file of generation with red,
And the format setting of part column, after data are filled in, when importing, it is only necessary to select the corresponding template of this document in the page, then
System can be according to Template Information to the excel Auto-matching of importing, verification, including verification must fill out and format, and imported into number
According in library.
Further, the creation self-defined template includes:
The union of the related column name of all report demands of summarizing, and save in correspondence table in the database；
Corresponding column are arranged, determine the general essential column of all reports.
Further, the method also includes:
Self-defined template interface is created, interface is divided into left and right two large divisions, and left side shows all column names, and right side is described
Column in self-defined template.
Further, the method also includes:
After the column for determining right side, the corresponding format of right-hand column is determined, wherein corresponding three kinds of formats difference in system
It is Rich Text Format, number format, date format.
Further, the method also includes:
User is perhaps dragged to right side when creating the self-defined template, by the double-click of the column in left side or by right side
Column remove.
Further, the method also includes:
Corresponding report file is found in systems and is downloaded, and according to the requirement arranged in report after downloading, is filled in corresponding
The format setting of data and part column；
After data are filled in, when importing, the corresponding template of the report file is selected in the page, then system is believed according to template
The excel report Auto-matching to importing is ceased, verifies and imported into database.
The customized implementation method for importing excel data template in a kind of javaWeb system of design of the embodiment of the present invention,
This method will need the bordereau imported to do union according to the needs of specific business, accomplish that importing report column, the column are
It is no must fill out, the Format Type of the column it is customized, customizable has been accomplished for the report of different subsidiary/member companies, so
There is no need to individually be developed for each company, a large amount of development time is saved, the system of also increasing is improved work efficiency
Ease for use.
Further, the customized method for importing report template is generated, user only needs to select to import report mould in the page
Plate includes which column and whether the column must be filled out, the type of the column produces the importing report template that can be downloaded.
Further, which only needs corresponding report template after inserting data in the page
And the report is uploaded, system can carry out verification to affiliated column, date format etc. according to the Template Information of report and will be correct
Data are successfully imported into system.
In the embodiment of the present invention, the method for generating self-defined report template creates self-defined template using the method for dragging,
And the attribute arranged in template can be set, the template of generation is imported into system after filling data, can be carried out according to template
The verifying of data, and be saved in corresponding system database and switch to system data.
Fig. 2 is the structure chart for the device that the embodiment of the present invention generates report template, as shown in Fig. 2, the embodiment of the present invention is another
On the one hand a kind of device of the generation report template provided, comprising:
Creation module 201 for creating self-defined template, and sets the attribute arranged in the template；
Import modul 202, the template for generation are imported into system after filling data；
Preserving module 203 for carrying out the verifying of data according to the template, and is saved in corresponding system database
As system data.
Further, the creation module 201 is also used to:
The union of the related column name of all report demands of summarizing, and save in correspondence table in the database；
Corresponding column are arranged, determine the general essential column of all reports.
Further, the creation module 201 is also used to:
Self-defined template interface is created, interface is divided into left and right two large divisions, and left side shows all column names, and right side is described
Column in self-defined template.
Further, the creation module 201 is also used to:
After the column for determining right side, the corresponding format of right-hand column is determined, wherein corresponding three kinds of formats difference in system
It is Rich Text Format, number format, date format.
Further, the creation module 201 is also used to:
User is perhaps dragged to right side when creating the self-defined template, by the double-click of the column in left side or by right side
Column remove.
Further, described device is also used to:
Corresponding report file is found in systems and is downloaded, and according to the requirement arranged in report after downloading, is filled in corresponding
The format setting of data and part column；
After data are filled in, when importing, the corresponding template of the report file is selected in the page, then system is believed according to template
The excel report Auto-matching to importing is ceased, verifies and imported into database.
The embodiment of the present invention sets the attribute arranged in the template by creation self-defined template；The mould generated
Plate is imported into system after filling data；The verifying of data is carried out according to the template, and is saved in corresponding system data
System data is used as in library.The embodiment of the present invention can accomplish customizable for different reports, save and largely open
The time is sent out, improves work efficiency, also increases the ease for use of system.
The embodiment of the present invention devise it is a kind of can the customized template implementation method for importing excel data, be generate from
The method that definition imports report template, user only need to select importing report template is comprising which column and the column in the page
It is no must fill out, the type of the column produces the importing report template that can download.
The importing report template only needs corresponding report template and uploads to be somebody's turn to do in the page after inserting data
Report, system to affiliated column, date format etc. can verify and successfully lead correct data according to the Template Information of report
Enter into system.
The method of self-defined template of the embodiment of the present invention has accomplished so just to be not required to the customizable for importing template
It individually to be developed for template weekly, save a large amount of development time, improve work efficiency the easy-to-use of the system of also increasing
Property.
Although disclosed herein embodiment it is as above, the content only for ease of understanding the present invention and use
Embodiment is not intended to limit the invention.Technical staff in any fields of the present invention is taken off not departing from the present invention
Under the premise of the spirit and scope of dew, any modification and variation, but the present invention can be carried out in the form and details of implementation
Scope of patent protection, still should be subject to the scope of the claims as defined in the appended claims.
Claims (10)
1. a kind of method for generating report template characterized by comprising
Self-defined template is created, and sets the attribute arranged in the template；
The template generated is imported into system after filling data；
The verifying of data is carried out according to the template, and is saved in corresponding system database as system data.
2. the method according to claim 1 for generating report template, which is characterized in that the creation self-defined template packet
It includes:
The union of the related column name of all report demands of summarizing, and save in correspondence table in the database；
Corresponding column are arranged, determine the general essential column of all reports.
3. the method according to claim 1 for generating report template, which is characterized in that further include:
Self-defined template interface is created, interface is divided into left and right two large divisions, and left side shows all column names, and right side is described makes by oneself
Column in adopted template.
4. the method according to claim 3 for generating report template, which is characterized in that further include:
After the column for determining right side, the corresponding format of right-hand column is determined, wherein corresponding three kinds of formats are general respectively in system
Logical text formatting, number format, date format.
5. the method according to claim 4 for generating report template, which is characterized in that further include:
The column in left side are double-clicked when creating the self-defined template and are perhaps dragged to right side or move the column on right side by user
It removes.
6. the method according to claim 5 for generating report template, which is characterized in that further include:
Corresponding report file is found in systems and is downloaded, and according to the requirement arranged in report after downloading, fills in corresponding data
And the format setting of part column；
After data are filled in, when importing, the corresponding template of the report file is selected in the page, then system is according to Template Information pair
The excel report Auto-matching of importing, verifies and imported into database.
7. a kind of device for generating report template characterized by comprising
Creation module for creating self-defined template, and sets the attribute arranged in the template；
Import modul, the template for generation are imported into system after filling data；
Preserving module for carrying out the verifying of data according to the template, and is saved in be used as in corresponding system database and is
System data.
8. the device according to claim 7 for generating report template, which is characterized in that the creation module is also used to:
The union of the related column name of all report demands of summarizing, and save in correspondence table in the database；
Corresponding column are arranged, determine the general essential column of all reports.
9. the device according to claim 7 for generating report template, which is characterized in that the creation module is also used to:
Self-defined template interface is created, interface is divided into left and right two large divisions, and left side shows all column names, and right side is described makes by oneself
Column in adopted template.
10. the device according to claim 9 for generating report template, which is characterized in that the creation module is also used to:
After the column for determining right side, the corresponding format of right-hand column is determined, wherein corresponding three kinds of formats are general respectively in system
Logical text formatting, number format, date format.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810816631.9A CN108959230B (en) | 2018-07-24 | 2018-07-24 | Method and device for generating report template |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810816631.9A CN108959230B (en) | 2018-07-24 | 2018-07-24 | Method and device for generating report template |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN108959230A true CN108959230A (en) | 2018-12-07 |
| CN108959230B CN108959230B (en) | 2021-11-26 |
Family
ID=64463661
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201810816631.9A Active CN108959230B (en) | 2018-07-24 | 2018-07-24 | Method and device for generating report template |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN108959230B (en) |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110457384A (en) * | 2019-08-15 | 2019-11-15 | 中国银行股份有限公司 | Transaction data processing method and device |
| CN110941658A (en) * | 2019-11-15 | 2020-03-31 | 泰康保险集团股份有限公司 | Data export method, device, server and storage medium |
| CN112101606A (en) * | 2020-10-28 | 2020-12-18 | 上海八彦图信息科技有限公司 | Method and device for processing participant data |
| CN112818655A (en) * | 2021-04-19 | 2021-05-18 | 中建电子商务有限责任公司 | Excel data processing method and tool based on template and file additional writing |
Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6093215A (en) * | 1997-08-12 | 2000-07-25 | International Business Machines Corporation | Method and apparatus for building templates in a component system |
| CN101071416A (en) * | 2007-07-02 | 2007-11-14 | 华为技术有限公司 | Report template generating system, development tool, development method and report client end |
| CN101111839A (en) * | 2004-11-30 | 2008-01-23 | 科格洛斯公司 | Reporting model generation within a multidimensional enterprise software system |
| CN104021219A (en) * | 2014-06-23 | 2014-09-03 | 东莞市西奥计算机智能科技有限公司 | Method and device for generating data template |
| CN104636393A (en) * | 2013-11-13 | 2015-05-20 | 航天信息股份有限公司 | Self-adaptation report form establishing method based on user self-definition behavior analysis |
| CN105302567A (en) * | 2015-11-12 | 2016-02-03 | 用友网络科技股份有限公司 | Device and method for dynamically generating report template |
| CN106649239A (en) * | 2016-12-23 | 2017-05-10 | 郑州云海信息技术有限公司 | Method and device for generating report in cloud monitoring system based on visualization |
| CN107817990A (en) * | 2017-11-24 | 2018-03-20 | 北京恒华伟业科技股份有限公司 | A kind of generation method of list, device and electronic equipment |
-
2018
- 2018-07-24 CN CN201810816631.9A patent/CN108959230B/en active Active
Patent Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6093215A (en) * | 1997-08-12 | 2000-07-25 | International Business Machines Corporation | Method and apparatus for building templates in a component system |
| CN101111839A (en) * | 2004-11-30 | 2008-01-23 | 科格洛斯公司 | Reporting model generation within a multidimensional enterprise software system |
| CN101071416A (en) * | 2007-07-02 | 2007-11-14 | 华为技术有限公司 | Report template generating system, development tool, development method and report client end |
| CN104636393A (en) * | 2013-11-13 | 2015-05-20 | 航天信息股份有限公司 | Self-adaptation report form establishing method based on user self-definition behavior analysis |
| CN104021219A (en) * | 2014-06-23 | 2014-09-03 | 东莞市西奥计算机智能科技有限公司 | Method and device for generating data template |
| CN105302567A (en) * | 2015-11-12 | 2016-02-03 | 用友网络科技股份有限公司 | Device and method for dynamically generating report template |
| CN106649239A (en) * | 2016-12-23 | 2017-05-10 | 郑州云海信息技术有限公司 | Method and device for generating report in cloud monitoring system based on visualization |
| CN107817990A (en) * | 2017-11-24 | 2018-03-20 | 北京恒华伟业科技股份有限公司 | A kind of generation method of list, device and electronic equipment |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110457384A (en) * | 2019-08-15 | 2019-11-15 | 中国银行股份有限公司 | Transaction data processing method and device |
| CN110941658A (en) * | 2019-11-15 | 2020-03-31 | 泰康保险集团股份有限公司 | Data export method, device, server and storage medium |
| CN112101606A (en) * | 2020-10-28 | 2020-12-18 | 上海八彦图信息科技有限公司 | Method and device for processing participant data |
| CN112818655A (en) * | 2021-04-19 | 2021-05-18 | 中建电子商务有限责任公司 | Excel data processing method and tool based on template and file additional writing |
Also Published As
| Publication number | Publication date |
|---|---|
| CN108959230B (en) | 2021-11-26 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108959230A (en) | A kind of method and apparatus generating report template | |
| CN114035773B (en) | Configuration-based low-code form development method, system and device | |
| CN110991157B (en) | Engineering quality assessment system design method based on electronic file trusted technology | |
| CN109753492A (en) | A kind of system constituting method and device based on metadata configurations | |
| CN103617047A (en) | Method, device and processor for developing business processes | |
| CN109086046A (en) | A kind of front-end code automatic generation method and system based on interface specification document | |
| CN108228119A (en) | Method of printing, terminal device and storage medium based on HXML | |
| CN102043626A (en) | Method and device for encapsulating extjs component, and method and system for generating user interface | |
| CN103051652B (en) | A kind of mobile terminal cloud computing distribution platform | |
| CN104899194A (en) | Creating method of medical report on the basis of HTML (Hypertext Markup Language) 5 | |
| CN106713357A (en) | Universal network protocol analysis method | |
| CN104750796A (en) | Method for leading out Word under BS system | |
| CN107122343A (en) | A kind of online contract template edit methods and system | |
| CN104424265A (en) | Digital resource management method and system | |
| CN107506185A (en) | A kind of data parsing and method for exhibiting data and system | |
| CN105719049B (en) | Method and system for realizing intelligent log | |
| CN109445794B (en) | Page construction method and device | |
| CN106933887A (en) | A kind of data visualization method and device | |
| CN110738038A (en) | Contract text generation method, device, equipment and computer readable storage medium | |
| CN105488210A (en) | Batch data matching method and device | |
| CN104378362B (en) | For carrying out the method and device of message interface conversion | |
| CN105094768A (en) | Application interface generation method and application interface generation device | |
| CN104794252A (en) | Three-dimensional model data processing method and electronic terminal | |
| CN110020414A (en) | A kind of electronic contract document creation method, system | |
| CN105590241A (en) | Self-adaptive electronic bill implementation method and system |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |