CN108959230B - Method and device for generating report template - Google Patents
Method and device for generating report template Download PDFInfo
- Publication number
- CN108959230B CN108959230B CN201810816631.9A CN201810816631A CN108959230B CN 108959230 B CN108959230 B CN 108959230B CN 201810816631 A CN201810816631 A CN 201810816631A CN 108959230 B CN108959230 B CN 108959230B
- Authority
- CN
- China
- Prior art keywords
- template
- data
- report
- columns
- column
- 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
- 238000000034 method Methods 0.000 title claims abstract description 30
- 230000008676 import Effects 0.000 claims description 13
- 238000010586 diagram Methods 0.000 description 3
Images
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
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)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The embodiment of the invention discloses a method and a device for generating a report template, wherein the method comprises the following steps: creating a self-defined template, and setting the attributes of the columns in the template; the generated template is imported into a system after being filled with data; and verifying the data according to the template, and storing the data in a corresponding system database as system data. The embodiment of the invention can customize different reports, save a large amount of development time, improve the working efficiency and increase the usability of the system.
Description
Technical Field
The invention relates to a cloud computing technology, in particular to a method and a device for generating a report template.
Background
JavaWeb is a system which is realized by using java technology and is accessed through pages, and in a JavaWeb system, the function of importing excel data sets is a common function. In the actual application process, because the system is applied by the subsidiaries of each province, the format requirements of each subsidiary for the excel data are not very same, if one subsidiary has a column of data to be filled, but another subsidiary does not have the column of data. In the prior art, according to the past development experience, excel template customization needs to be carried out on each subsidiary company, but because the subsidiary companies are more, the adoption of the customization method needs a great deal of workload and a lot of the subsidiary companies are low-level repetition.
Therefore, the prior art has the problems of long development time, low working efficiency and poor system usability.
Disclosure of Invention
In order to solve the above technical problems, embodiments of the present invention provide a method and an apparatus for generating a report template, which can customize different reports, save a large amount of development time, improve work efficiency, and increase usability of a system.
In order to achieve the object of the present invention, in one aspect, an embodiment of the present invention provides a method for generating a report template, including:
creating a self-defined template, and setting the attributes of the columns in the template;
the generated template is imported into a system after being filled with data;
and verifying the data according to the template, and storing the data in a corresponding system database as system data.
Further, the creating of the custom template comprises:
the union set of all the relevant column names required by the report forms is sorted and summarized and is stored in a corresponding table in a database;
and sorting the corresponding columns and determining the necessary columns common to all reports.
Further, the method further comprises:
and (3) creating a custom template interface, wherein the interface is divided into a left part and a right part, all column names are displayed on the left side, and columns in the custom template are displayed on the right side.
Further, the method further comprises:
and after the right column is determined, determining the format corresponding to the right column, wherein the three corresponding formats in the system are respectively a common text format, a digital format and a date format.
Further, the method further comprises:
when creating the custom template, the user double-clicks or drags the left column to the right, or removes the right column.
Further, the method further comprises:
finding out and downloading a corresponding report file in the system, and filling corresponding data and partial column format settings according to the requirements of columns in the report after downloading;
after the data is filled, when the data is imported, selecting a template corresponding to the report file on a page, automatically matching the imported excel report by the system according to the template information, checking and importing the excel report into a database.
On the other hand, an embodiment of the present invention further provides a device for generating a report template, including:
the creating module is used for creating a self-defined template and setting the attributes of the columns in the template;
the import module is used for importing the generated template into a system after being filled with data;
and the storage module is used for verifying the data according to the template and storing the data into a corresponding system database as system data.
Further, the creation module is further configured to:
the union set of all the relevant column names required by the report forms is sorted and summarized and is stored in a corresponding table in a database;
and sorting the corresponding columns and determining the necessary columns common to all reports.
Further, the creation module is further configured to:
and (3) creating a custom template interface, wherein the interface is divided into a left part and a right part, all column names are displayed on the left side, and columns in the custom template are displayed on the right side.
Further, the creation module is further configured to:
and after the right column is determined, determining the format corresponding to the right column, wherein the three corresponding formats in the system are respectively a common text format, a digital format and a date format.
Further, the creation module is further configured to:
when creating the custom template, the user double-clicks or drags the left column to the right, or removes the right column.
Further, the apparatus is further configured to:
finding out and downloading a corresponding report file in the system, and filling corresponding data and partial column format settings according to the requirements of columns in the report after downloading;
after the data is filled, when the data is imported, selecting a template corresponding to the report file on a page, automatically matching the imported excel report by the system according to the template information, checking and importing the excel report into a database.
The embodiment of the invention establishes a self-defined template and sets the attributes of the columns in the template; the generated template is imported into a system after being filled with data; and verifying the data according to the template, and storing the data in a corresponding system database as system data. The embodiment of the invention can customize different reports, save a large amount of development time, improve the working efficiency and increase the usability of the system.
Additional features and advantages of the invention will be set forth in the description which follows, and in part will be obvious from the description, or may be learned by practice of the invention. The objectives and other advantages of the invention will be realized and attained by the structure particularly pointed out in the written description and claims hereof as well as the appended drawings.
Drawings
The accompanying drawings are included to provide a further understanding of the invention and are incorporated in and constitute a part of this specification, illustrate embodiments of the invention and together with the example serve to explain the principles of the invention and not to limit the invention.
FIG. 1 is a flowchart of a method for generating a report template according to an embodiment of the present invention;
fig. 2 is a structural diagram of an apparatus for generating a report template according to an embodiment of the present invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the present invention more apparent, embodiments of the present invention will be described in detail below with reference to the accompanying drawings. It should be noted that the embodiments and features of the embodiments in the present application may be arbitrarily combined with each other without conflict.
The steps illustrated in the flow charts of the figures may be performed in a computer system such as a set of computer-executable instructions. Also, while a logical order is shown in the flow diagrams, in some cases, the steps shown or described may be performed in an order different than here.
Fig. 1 is a flowchart of a method for generating a report template according to an embodiment of the present invention, and as shown in fig. 1, the method according to the embodiment of the present invention includes the following steps:
step 100: creating a self-defined template, and setting the attributes of the columns in the template;
step 101: the generated template is imported into a system after being filled with data;
step 102: and verifying the data according to the template, and storing the data in a corresponding system database as system data.
Specifically, the embodiment of the invention relates to a method for realizing custom import of an excel data template in a java Web system, which comprises the following steps:
and designing a database, arranging and summarizing a union of related column names of report requirements of all subsidiaries, storing the union in a corresponding table in the database, arranging corresponding columns, and determining which columns are necessary columns common to all reports.
The interface design is that when a user-defined template interface is created, the interface is divided into a left part and a right part, all column names are displayed on the left side, columns in the user-defined template are displayed on the right side, and a user can double click or drag the columns on the left side to the right side or remove the columns on the right side when the user creates the user-defined template. The general must-column identified in the database design is by default already on the right side of the system and cannot be removed. After the right column is determined, the format corresponding to the right column can be designed, and the current system corresponds to three formats, namely a common text format, a digital format and a date format. Clicking the save button, inputting the corresponding report name, such as the XX subsidiary 2018 data report, and generating and saving the corresponding report file in the system.
After the data is filled, the system can automatically match and check the imported excel according to the template information, including checking the mandatory filling and the format, and import the excel into the database.
Further, the creating of the custom template comprises:
the union set of all the relevant column names required by the report forms is sorted and summarized and is stored in a corresponding table in a database;
and sorting the corresponding columns and determining the necessary columns common to all reports.
Further, the method further comprises:
and (3) creating a custom template interface, wherein the interface is divided into a left part and a right part, all column names are displayed on the left side, and columns in the custom template are displayed on the right side.
Further, the method further comprises:
and after the right column is determined, determining the format corresponding to the right column, wherein the three corresponding formats in the system are respectively a common text format, a digital format and a date format.
Further, the method further comprises:
when creating the custom template, the user double-clicks or drags the left column to the right, or removes the right column.
Further, the method further comprises:
finding out and downloading a corresponding report file in the system, and filling corresponding data and partial column format settings according to the requirements of columns in the report after downloading;
after the data is filled, when the data is imported, selecting a template corresponding to the report file on a page, automatically matching the imported excel report by the system according to the template information, checking and importing the excel report into a database.
The implementation method for self-defining import of the excel data template in the javaWeb system, which is designed by the embodiment of the invention, merges business reports needing to be imported according to the specific business requirements, realizes import of report columns, whether the columns need to be filled and self-definition of format types of the columns, and realizes customization of reports of different subordinate companies, so that independent development for each company is not needed, a large amount of development time is saved, the working efficiency is improved, and the usability of the system is increased.
Further, by the method for generating the user-defined import report template, the user only needs to select which columns are included in the import report template on the page, and the types of the columns can generate the downloadable import report template according to whether the columns need to be filled.
Furthermore, after the data is filled in the report template, the system can check the column, date format and the like of the report according to the template information of the report and successfully import the correct data into the system as long as the corresponding report template is needed and the report is uploaded in the page.
In the embodiment of the invention, the method for generating the custom report template adopts a dragging method to create the custom template, can set the attributes of the columns in the template, and leads the generated template into the system after being filled with data, can verify the data according to the template, and stores the data in the corresponding system database to be converted into the system data.
Fig. 2 is a structural diagram of an apparatus for generating a report template according to an embodiment of the present invention, and as shown in fig. 2, an apparatus for generating a report template according to another aspect of the embodiment of the present invention includes:
a creating module 201, configured to create a custom template, and set attributes of columns in the template;
an importing module 202, configured to import the generated template into a system after being filled with data;
and the storage module 203 is configured to verify data according to the template, and store the data in a corresponding system database as system data.
Further, the creating module 201 is further configured to:
the union set of all the relevant column names required by the report forms is sorted and summarized and is stored in a corresponding table in a database;
and sorting the corresponding columns and determining the necessary columns common to all reports.
Further, the creating module 201 is further configured to:
and (3) creating a custom template interface, wherein the interface is divided into a left part and a right part, all column names are displayed on the left side, and columns in the custom template are displayed on the right side.
Further, the creating module 201 is further configured to:
and after the right column is determined, determining the format corresponding to the right column, wherein the three corresponding formats in the system are respectively a common text format, a digital format and a date format.
Further, the creating module 201 is further configured to:
when creating the custom template, the user double-clicks or drags the left column to the right, or removes the right column.
Further, the apparatus is further configured to:
finding out and downloading a corresponding report file in the system, and filling corresponding data and partial column format settings according to the requirements of columns in the report after downloading;
after the data is filled, when the data is imported, selecting a template corresponding to the report file on a page, automatically matching the imported excel report by the system according to the template information, checking and importing the excel report into a database.
The embodiment of the invention establishes a self-defined template and sets the attributes of the columns in the template; the generated template is imported into a system after being filled with data; and verifying the data according to the template, and storing the data in a corresponding system database as system data. The embodiment of the invention can customize different reports, save a large amount of development time, improve the working efficiency and increase the usability of the system.
The embodiment of the invention designs a template realization method capable of importing excel data in a self-defined mode, which is a method for generating a self-defined import report template.
After the data is filled in the report template, the system can check the column, date format and the like of the report according to the template information of the report and successfully import the correct data into the system only by needing the corresponding report template and uploading the report in the page.
The method for customizing the template achieves customization of the imported template, so that the template does not need to be developed independently for each week, a large amount of development time is saved, the working efficiency is improved, and the usability of the system is improved.
Although the embodiments of the present invention have been described above, the above description is only for the convenience of understanding the present invention, and is not intended to limit the present invention. It will be understood by those skilled in the art that various changes in form and details may be made therein without departing from the spirit and scope of the invention as defined by the appended claims.
Claims (3)
1. A method for generating a report template is characterized by comprising the following steps:
creating a self-defined template, and setting the attributes of the columns in the template;
the generated template is imported into a system after being filled with data;
verifying data according to the template, and storing the data into a corresponding system database as system data;
wherein the creating of the custom template comprises:
the union set of all the relevant column names required by the report forms is sorted and summarized and is stored in a corresponding table in a database;
sorting the corresponding columns and determining the necessary columns common to all reports;
creating a custom template interface, wherein the interface is divided into a left part and a right part, all column names are displayed on the left side, and columns in the custom template are displayed on the right side;
after the right column is determined, determining the format corresponding to the right column, wherein the three corresponding formats in the system are respectively a common text format, a digital format and a date format;
when creating the custom template, the user double-clicks or drags the left column to the right, or removes the right column.
2. The method for generating reporting templates of claim 1, further comprising:
finding out and downloading a corresponding report file in the system, and filling corresponding data and partial column format settings according to the requirements of columns in the report after downloading;
after the data is filled, when the data is imported, selecting a template corresponding to the report file on a page, automatically matching the imported excel report by the system according to the template information, checking and importing the excel report into a database.
3. An apparatus for generating a report template, comprising:
the creating module is used for creating a self-defined template and setting the attributes of the columns in the template;
the import module is used for importing the generated template into a system after being filled with data;
the storage module is used for verifying data according to the template and storing the data into a corresponding system database as system data;
wherein the creation module is further to:
the union set of all the relevant column names required by the report forms is sorted and summarized and is stored in a corresponding table in a database;
sorting the corresponding columns and determining the necessary columns common to all reports;
creating a custom template interface, wherein the interface is divided into a left part and a right part, all column names are displayed on the left side, and columns in the custom template are displayed on the right side;
after the right column is determined, determining the format corresponding to the right column, wherein the three corresponding formats in the system are respectively a common text format, a digital format and a date format;
when creating the custom template, the user double-clicks or drags the left column to the right, or removes the right column.
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 CN108959230A (en) | 2018-12-07 |
| CN108959230B true 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) |
Families Citing this family (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 |
| CN112818655B (en) * | 2021-04-19 | 2021-08-03 | 中建电子商务有限责任公司 | 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 | 科格洛斯公司 | Report template generation in 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 | 科格洛斯公司 | Report template generation in 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 |
Also Published As
| Publication number | Publication date |
|---|---|
| CN108959230A (en) | 2018-12-07 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108959230B (en) | Method and device for generating report template | |
| WO2019095424A1 (en) | Data acquisition method and device, storage medium and terminal | |
| CN103617047A (en) | Method, device and processor for developing business processes | |
| CN113076096B (en) | Desktop application program development method, device, equipment and storage medium | |
| CN112015412A (en) | Device and method for generating business model based on form engine | |
| CN114035773A (en) | Configuration-based low-code form development method, system and device | |
| CN103051652B (en) | A kind of mobile terminal cloud computing distribution platform | |
| CN105528418A (en) | Design document generation method and apparatus | |
| CN104007984A (en) | Data converting method and device | |
| CN104424265A (en) | Digital resource management method and system | |
| CN110263007A (en) | A kind of file naming method, system and electronic equipment and storage medium | |
| CN108829653A (en) | A kind of generation method of report, device, equipment and medium | |
| CN110738038A (en) | Contract text generation method, device, equipment and computer readable storage medium | |
| CN106407172A (en) | XML (Extensible Markup Language)-based report generating method | |
| CN101702218A (en) | Information sending method applied to enterprise resource planning ERP and device | |
| CN111090976B (en) | Method and device for generating inspection document based on dynamic data | |
| CN115840567A (en) | Application editing method and related equipment | |
| CN103903085A (en) | Method and device for isolating report application scene | |
| CN111026756A (en) | Method for dynamically generating form and associated query | |
| CN105094768A (en) | Application interface generation method and application interface generation device | |
| CN104615422A (en) | Procedure customizing method for application software interface | |
| CN105573973A (en) | Method for performing data correlation on EXCEL data in PPT file | |
| CN113435160A (en) | Data processing method and device | |
| CN117522094A (en) | Seal management method, platform, electronic equipment and storage medium | |
| CN110020414A (en) | A kind of electronic contract document creation method, 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 |