CN109948134B - Report automatic generation method, system, electronic equipment and storage medium - Google Patents
Report automatic generation method, system, electronic equipment and storage medium Download PDFInfo
- Publication number
- CN109948134B CN109948134B CN201910217469.3A CN201910217469A CN109948134B CN 109948134 B CN109948134 B CN 109948134B CN 201910217469 A CN201910217469 A CN 201910217469A CN 109948134 B CN109948134 B CN 109948134B
- Authority
- CN
- China
- Prior art keywords
- variable content
- report
- excel
- content
- variable
- 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 54
- 238000004590 computer program Methods 0.000 claims description 10
- 230000008569 process Effects 0.000 description 10
- 238000005516 engineering process Methods 0.000 description 8
- 238000012360 testing method Methods 0.000 description 8
- 238000004891 communication Methods 0.000 description 7
- 238000010586 diagram Methods 0.000 description 5
- 238000012986 modification Methods 0.000 description 4
- 230000004048 modification Effects 0.000 description 4
- 238000012545 processing Methods 0.000 description 4
- 230000009471 action Effects 0.000 description 3
- 230000006978 adaptation Effects 0.000 description 2
- 230000008859 change Effects 0.000 description 2
- 239000004973 liquid crystal related substance Substances 0.000 description 2
- 238000006467 substitution reaction Methods 0.000 description 2
- 239000012141 concentrate Substances 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 230000006870 function Effects 0.000 description 1
- 238000012423 maintenance Methods 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 238000000691 measurement method Methods 0.000 description 1
- 238000002715 modification method Methods 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 230000008520 organization Effects 0.000 description 1
- 238000011056 performance test Methods 0.000 description 1
- 230000000750 progressive effect Effects 0.000 description 1
- 230000001502 supplementing effect Effects 0.000 description 1
- 230000000007 visual effect Effects 0.000 description 1
Landscapes
- Document Processing Apparatus (AREA)
- Stored Programmes (AREA)
Abstract
The application discloses a report automatic generation method, a system, equipment and a medium, comprising the following steps: acquiring an original report, and determining fixed content and variable content in the original report; determining an association relation between variable content and a preset type label, generating a variable content label, combining fixed content and the variable content label, and generating a report template; extracting variable content labels from the report template, and generating corresponding Excel filling forms by using the variable content labels; and receiving the recorded variable contents in the table, updating the variable contents to the corresponding positions of the variable content labels in the template, and generating a final report. Namely, the writer fills the variable content into the corresponding position of the variable content label in the Excel form, thereby achieving the purpose of editing the report variable content, avoiding the problem that the writer is difficult to directly edit or offline modify when the existing automatic method uses the database to store the variable data, improving the flexibility of the report generating system, and reducing the writing workload and writing errors.
Description
Technical Field
The present application relates to the field of information technology data processing, and more particularly, to a report automatic generation method, system, and electronic device and a computer readable storage medium.
Background
Reports of various types are important written bases for business and technical management and supervision of enterprises. The types and formats of reports are also quite different from the business in which the enterprise is engaged. At present, enterprise staff usually use Word processing software of Microsoft corporation in the report writing process, the report content needs to be repeatedly modified during writing, the editing process is boring, the writer needs to concentrate on, and the error rate of the report in the format and the content is high due to a little carelessness, so that the working efficiency is low. Currently, for such report writing, the following two methods are mainly adopted:
the method of history report and manual modification refers to that after a writer backs up the history report, the writer directly modifies and edits the history report. In the report writing process, a writer needs to perform repeated operations such as searching, replacing, copying, pasting and the like for a plurality of times besides adding and supplementing contents such as characters and the like, and update old contents with new contents. If the content to be updated is scattered in the document, the operation process is complicated. Meanwhile, in the case of a large number of substitutions, the word substitution error rate increases.
The method comprises the steps of firstly, manufacturing a fixed part in a report into a Word document template, storing changed contents in a background database field, combining the Word document template with related contents of the background database, and completing automatic generation of the report. In the method, each company often develops a report automatic generation system by an organization programmer according to the self business condition, the customization is strong, and each time the change of the report template can require corresponding modification and upgrading of a background database field and a software generation functional module. If the report is of a large variety and has variations, the cost of post-maintenance is high. Along with the change update of report types and report contents, staff cannot intervene in the report automation generation process, and cannot directly modify templates or directly operate a background database structure, and only manual update can be performed on the basis of automatically generated reports, so that the flexibility of a report generation system is insufficient.
In the report generation method, the manual report modification method has the advantages of large workload, low efficiency and high error rate, and the existing automatic generation method has the disadvantages of poor universality and insufficient flexibility. Thus, how to increase the efficiency and flexibility of report generation is a problem that one skilled in the art would need to solve.
Disclosure of Invention
The application aims to provide a report automatic generation method, a system, an electronic device and a computer readable storage medium, which improve the efficiency and flexibility of report generation.
In order to achieve the above object, the present application provides a report automatic generation method, including:
acquiring an original report, and determining fixed content and variable content in the original report;
determining the association relation between variable content and a preset type label, generating a variable content label, combining fixed content in an original report and the variable content label, and generating a report template;
extracting variable content labels in the report template, and generating a corresponding Excel filling form by using the variable content labels;
and receiving the recorded variable content in the Excel filling table, and updating the variable content to the corresponding position of the variable content label in the report template to generate a final report.
The Excel filling table comprises any one or any combination of a text type Excel table, a picture type Excel table, a form type Excel table and a sub-document type Excel table.
Before the variable content recorded in the table is filled in by the received Excel, the method further comprises the steps of:
acquiring a form selection instruction, wherein the form selection instruction is an instruction issued by a writer for selecting an Excel filling form type according to the type of the variable content, and displaying a corresponding Excel filling form on a terminal;
correspondingly, the receiving variable content entered in the Excel filling table comprises:
and storing the variable content into cells corresponding to the variable content labels in the Excel filling table.
Wherein, the receiving variable content entered in Excel filling table includes:
when the form selection instruction is to select the text type Excel form, receiving text information input through a preset interface, and storing the text information into cells corresponding to the text type labels in the text type Excel form.
Wherein the updating the variable content to the corresponding position of the variable content tag in the report template comprises:
and filling the text information in the text type Excel table into a report template, and deleting the variable content tag at the corresponding filling position.
Wherein, the receiving variable content entered in Excel filling table includes:
when the form selection instruction is to select a picture type Excel form, a form type Excel form or a sub-document type Excel form, receiving file related information input through a preset interface, and storing the file related information into a cell corresponding to a variable content tag in a corresponding form; the file related information comprises a file name and a file storage path.
Wherein the updating the variable content to the corresponding position of the variable content tag in the report template comprises:
determining target files corresponding to file related information of the picture type Excel table, the form type Excel table and the sub-document type Excel table, inserting the contents of the target files into corresponding positions in a report template, and deleting variable content tags on the corresponding filling positions.
To achieve the above object, the present application provides an automatic report generating system comprising:
the content judging module is used for acquiring the original report and determining fixed content and variable content in the original report;
the template generation module is used for determining the association relation between the variable content and the preset type label, generating a variable content label, combining the fixed content and the variable content label in the original report and generating a report template;
the table generating module is used for extracting the variable content labels in the report template and generating a corresponding Excel filling table by utilizing the variable content labels;
and the report generation module is used for receiving the recorded variable content in the Excel filling table, updating the variable content to the corresponding position of the variable content label in the report template and generating a final report.
To achieve the above object, the present application provides an electronic device including:
a memory for storing a computer program;
a processor for implementing the steps of any of the report auto-generation methods as previously disclosed when executing the computer program.
To achieve the above object, the present application provides a computer-readable storage medium having stored thereon a computer program which, when executed by a processor, implements the steps of any of the report automatic generation methods as previously disclosed.
According to the scheme, the report automatic generation method provided by the application comprises the following steps: acquiring an original report, and determining fixed content and variable content in the original report; determining the association relation between the variable content and the preset type label, generating a variable content label, combining the fixed content and the variable content label in the original report, and generating a report template; extracting variable content labels in the report template, and generating a corresponding Excel filling form by using the variable content labels; and receiving the recorded variable content in the table, updating the variable content to the corresponding position of the variable content label in the report template, and generating a final report. That is, after the report template is generated by using the fixed content and the variable content label, the corresponding various excels are generated by extracting the label in the report template, so that the aim of editing the variable content in the report can be achieved only by filling the variable content into the cell of the corresponding position of the variable content label in the form, the problem that the existing automatic method uses a professional database to store the variable data, and the report writer is difficult to directly access or can not modify offline is avoided, and the report generation efficiency and flexibility are further improved and the automatic editing flow of the report is optimized on the basis of reducing the writing workload of personnel.
The application also discloses an automatic report generating system, an electronic device and a computer readable storage medium, which can realize the technical effects.
It is to be understood that both the foregoing general description and the following detailed description are exemplary and explanatory only and are not restrictive of the application as claimed.
Drawings
In order to more clearly illustrate the embodiments of the application or the technical solutions in the prior art, the drawings that are required in the embodiments or the description of the prior art will be briefly described, it being obvious that the drawings in the following description are only some embodiments of the application, and that other drawings may be obtained according to these drawings without inventive effort for a person skilled in the art.
FIG. 1 is a flow chart of a report automatic generation method disclosed in an embodiment of the present application;
FIG. 2 is a flow chart of another method for automatically generating reports according to an embodiment of the application;
FIG. 3 is a flow chart of yet another method for automatically generating reports in accordance with an embodiment of the application;
FIG. 4 is a block diagram of an automatic report generating system according to an embodiment of the present application;
FIG. 5 is a block diagram of an electronic device according to an embodiment of the present application;
fig. 6 is a block diagram of another electronic device according to an embodiment of the present application.
Detailed Description
The following description of the embodiments of the present application will be made clearly and completely with reference to the accompanying drawings, in which it is apparent that the embodiments described are only some embodiments of the present application, but not all embodiments. All other embodiments, which can be made by those skilled in the art based on the embodiments of the application without making any inventive effort, are intended to be within the scope of the application.
In the prior art, the method for manually modifying the report has the advantages of large workload, low efficiency, high error rate, poor universality and insufficient flexibility.
Therefore, the embodiment of the application discloses an automatic report generation method, which improves the efficiency and flexibility of report generation.
Referring to fig. 1, a flowchart of a report automatic generation method disclosed in an embodiment of the present application, as shown in fig. 1, includes:
s101: acquiring an original report, and determining fixed content and variable content in the original report;
in this embodiment, the original report of the finalized manuscript is acquired, and the fixed content and the variable content in the original report are identified. The variable content is further specially marked, for example, the background of the variable content is changed to yellow, or an underline is added to the variable content, etc., which is not limited in the present application.
It will be appreciated that the same type of report is generally consistent in form, in that the report format and most of the content are relatively fixed, and only a portion of the content needs to be modified and updated, i.e. the variable content referred to in this embodiment.
S102: determining an association relation between the variable content and a preset type label, generating a variable content label, combining the fixed content and the variable content label, and generating a report template;
it can be appreciated that the present embodiment classifies the variable content according to the relationship between the variable content and the preset type tag, and generates the variable content tag. In particular, the variable content types may be classified into text content, picture content, form content, and sub-document content, and correspondingly, the variable content tags may include text type tags, picture type tags, form type tags, and sub-document type tags, and diversity of tag types enhances report versatility and universality.
In one embodiment, the variable content tag may be composed of three parts, a tag prefix, a tag ID, and a tag suffix. For example, the label prefix of the text type label is "{ label text_", and the label suffix is "_label text }"; the label prefix of the picture type label is "{ { label figure_and the label suffix is" _label figure } "; the label prefix of the form type label is "{ { label_able }", and the label suffix is "_label_able }"; the label prefix of the sub-document type label is "{ { label_label }", and the label suffix is "_label }". It should be noted that in this embodiment, the type tags of the same variable content and appearing at different locations of the document are identical. Tag ID may be specifically named according to the true meaning of the variable content, e.g., the complete tag corresponding to the report title may be
"{ { labeltex_report_subject_labeltex }" where "{ labeltex_" and "_labeltex }" are the prefix and suffix of the text type tag and "report-subject" is the tag ID.
After determining the association relationship between the preset type tag and the variable content, the fixed content extracted in step S101 is used as the fixed content in the report template, and the variable content tag is used to replace the variable content, so that the variable content tag and the fixed content are combined, and the report template is generated. For example, the following text is a partial example of a test report template:
the test report describes the basis and standard of { { { labeltext_report-subject_labeltext }, measurement method, test data, test result and the like in detail. The test was performed in { { { labltext_date_labltext }. "
In the above example, { { { labelt_report_subject_labelt } }, and
{ { labeltext_date_labeltext } is variable content to be filled in, represents the name of the test report and the date of implementation of the test, and the rest of characters are fixed content.
S103: extracting the variable content label in the report template, and generating a corresponding Excel filling table by utilizing the variable content label;
further, after the report template is generated, the variable content tag in the report template is extracted and stored in the corresponding Excel filling table. Specifically, the variable content tag is stored in the first column of the corresponding table, and is used for representing the content type and content meaning filled in each row in the table. Corresponding cells in the second column of each Excel filled form are used to enter the corresponding variable content in the report.
It can be understood that, in this embodiment, according to the classification of the text type tag, the picture type tag, the form type tag and the sub-document type tag, a table of a corresponding type is constructed: text type Excel table, picture type Excel table, form type Excel table, sub-document type Excel table.
S104: and receiving the recorded variable content in the Excel filling table, and updating the variable content to the corresponding position of the variable content label in the report template to generate a final report.
In this embodiment, the variable content input by the writer can be received through the preset interface. For example, each Excel filling table can be edited through a preset interface, and the variable content is stored in a second column of the Excel filling table, wherein the obtained variable content is the content which needs to be modified or updated in the report template.
Specifically, in this embodiment, a corresponding report template is created for each type of report, after determining a report question to be generated currently, the report template corresponding to the current question is obtained, and then the variable content in the Excel filling table is updated to the corresponding position of the variable content tag in the report template, so as to generate a final report.
It should be noted that, in this embodiment, the writer can edit the content to be filled in the final report by writing the corresponding content in the second column of the Excel form, so that the problem that the report writer is difficult to directly access the database and modify offline due to the fact that the professional database is used for storing variable data in the existing automation method is avoided, and the flexibility is improved.
In addition, when the variable content is filled into the corresponding position in the report template, only the content corresponding to the label is replaced, so that the defect that the same character string can be replaced only in one replacement process in the traditional Word software function is avoided, the replacement error rate is reduced, a large number of repeated works such as copying and pasting in the traditional report writing process are avoided, and the working efficiency is improved.
According to the scheme, the report automatic generation method provided by the application comprises the following steps: acquiring an original report, and determining fixed content and variable content in the original report; determining the association relation between the variable content and the preset type label, generating a variable content label, combining the fixed content and the variable content label in the original report, and generating a report template; extracting a variable content label in the report template, and generating a corresponding Excel filling form by utilizing the variable content label; and receiving the recorded variable content in the table, updating the variable content to the corresponding position of the variable content label in the report template, and generating a final report. That is, after the report template is generated by using the fixed content and the variable content label, the filling table of the corresponding various types of content is generated by extracting the label in the report template, so that after the report template is made by a writer, the variable content in the table can be edited offline only by filling the variable content in the cell corresponding to the variable content label in the table.
The embodiment of the application discloses another report automatic generation method, and compared with the previous embodiment, the technical scheme is further described and optimized. Specific:
referring to fig. 2, a flowchart of another report automatic generation method provided by an embodiment of the present application, as shown in fig. 2, includes:
s201: acquiring an original report, and determining fixed content and variable content in the original report;
s202: determining an association relation between the variable content and a preset type label, generating a variable content label, combining the fixed content and the variable content label, and generating a report template;
s203: extracting the variable content label in the report template, and generating a corresponding Excel filling table by utilizing the variable content label;
s204: acquiring a form selection instruction, and displaying an Excel filling form of a corresponding type on the terminal; the form selection instruction is an instruction which is issued by a writer according to the type of the variable content and used for selecting Excel to fill the form type;
s205: and receiving the variable content, storing the variable content into a cell corresponding to the variable content label in the Excel filling table, updating the variable content to a corresponding position of the variable content label in the report template, and generating a final report.
It can be understood that the Excel filling table in this embodiment includes any one or any combination of a text type Excel table, a picture type Excel table, a form type Excel table, and a sub-document type Excel table.
In this embodiment, after a table selection instruction of a current writer is obtained, a corresponding Excel filling table is displayed on a terminal according to the table selection instruction. That is, the current writer selects a corresponding form according to the filled variable content type, so that the corresponding Excel filled form is displayed according to the form selection instruction, so that the writer fills the content into the Excel filled form displayed on the terminal screen.
The embodiment of the application discloses a report automatic generation method, and compared with the previous embodiment, the technical scheme of the embodiment is further described and optimized. Specific:
referring to fig. 3, a flowchart of still another report automatic generation method provided by an embodiment of the present application, as shown in fig. 3, includes:
s301: acquiring an original report, and determining fixed content and variable content in the original report;
s302: determining an association relation between the variable content and a preset type label, generating a variable content label, combining the fixed content and the variable content label, and generating a report template;
s303: extracting the variable content label in the report template, and generating a corresponding Excel filling table by utilizing the variable content label;
s304: acquiring a table selection instruction, when the table selection instruction is selecting a text type Excel table, receiving text information input through a preset interface, and storing the text information into cells corresponding to text type labels in the text type Excel table;
it can be understood that if the content to be filled by the writer is text information, selecting a text type Excel form, after the text type Excel form is displayed by the terminal, inputting the text information to be modified or updated, and storing the text information into a cell corresponding to the text type tag in the text type Excel form.
S305: when the form selection instruction is to select a picture type Excel form, a form type Excel form or a sub-document type Excel form, receiving file related information input through a preset interface, and storing the file related information of the picture, the form or the sub-document into a cell corresponding to a variable content tag in a corresponding form; wherein the file related information comprises a file name and a file storage path;
in a specific embodiment, if the content to be newly added by the writer is a form, a picture or a sub-document, that is, the selection object corresponding to the form selection instruction is a picture type Excel form, a form type Excel form or a sub-document type Excel form, the writer may fill in the variable content into the second column in the Excel filling form. Wherein, the first column of the Excel filling form stores the corresponding variable content tag so as to fill in the corresponding content according to the variable content tag. Specifically, if the content to be filled by the writer is text information, directly filling in a second column of the text type Excel form; if the writer needs to add a picture, the writer saves the file in jpg or png format and names the file, and the second column in the picture type Excel table is filled with the picture file name and the related information of the storage path. For example, if a picture of a layout is to be inserted into the template report, the picture may be named as a true meaning of the picture
"figure-layout. Jpg", and filling the file related information containing the file name "figure-layout. Jpg" and the path "C: \pictures\into the picture type Excel table with the tag name of: \picture \"
Filling of the relevant information of the picture file is completed in the second column of cells corresponding to the { la belfigure_figure-layout_la belfigure }', as shown in table 1; if the writer needs to add a new form or sub-document, the relevant information of the form file or sub-document file can be filled into the form according to the mode of adding the picture.
TABLE 1
| Variable content tags | Filling in content |
| {{labelfigure_figure-layout_labelfigure}} | C:\pictures\figure-layout.jpg |
S306: filling the text information in the text type Excel table into the report template, and deleting the variable content tag at the corresponding filling position;
s307: and determining target files corresponding to the file related information in the picture type Excel table, the form type Excel table and the sub-document type Excel table, inserting the content of the target files into corresponding positions in the report template, deleting the variable content labels on the corresponding filling positions, and generating a final report.
In this embodiment, text information in a text type Excel table is filled into a report template, and variable content tags at filling positions are deleted; in addition, corresponding target files are determined according to the file related information stored in the form, the target files are inserted into corresponding positions in the report template, and variable content labels located at the corresponding positions are further deleted, so that the final report filling is completed.
In the present application, an example is taken as an embodiment to show an Excel filling table, table 2 is a text type Excel table, and as shown in table 2, column 1 in the table is a variable content label, and column 2 is the filled variable content.
TABLE 2
| Variable content tags | Filling in content |
| {{labeltext_report-subject_labeltext}} | Performance test of Dongshan limited #2 unit air preheater |
| {{labeltext_manager-name_labeltext}} | Li Ming |
| {{labeltext_date_labeltext}} | 2018, 10, 11 days |
| {{labeltext_company_labeltext}} | Dongshan Co Ltd |
| {{labeltext_background_labeltext}} | Air preheater heat exchange performance and air leakage condition |
| {{labeltext_unit-number_labeltext}} | #2 machine set |
| {{labeltext_experiment-name_labeltext}} | Air leakage test of air preheater |
The following describes an automatic report generating system according to an embodiment of the present application, and the automatic report generating system described below and the automatic report generating method described above may be referred to each other.
Referring to fig. 4, a structure diagram of a report automatic generation system provided by an embodiment of the present application, as shown in fig. 4, includes:
a content discriminating module 100 for acquiring an original report and determining fixed content and variable content in the original report;
the template generating module 200 is configured to determine an association relationship between the variable content and a preset type tag, generate a variable content tag, combine the fixed content and the variable content tag, and generate a report template;
the table generating module 300 is configured to extract a variable content tag in the report template, and generate a corresponding Excel filling table by using the variable content tag;
the report generating module 400 is configured to receive the variable content recorded in the Excel filling table, update the variable content to a corresponding position of the variable content tag in the report template, and generate a final report.
The application also provides an electronic device, referring to fig. 5, and a block diagram of the electronic device provided by the embodiment of the application, as shown in fig. 5, includes:
a memory 11 for storing a computer program;
a processor 12 for executing the computer program may implement the steps of any of the report automatic generation methods provided in the above embodiments.
Specifically, the memory 11 includes a nonvolatile storage medium and an internal memory. The non-volatile storage medium stores an operating system and computer readable instructions, and the internal memory provides an environment for the operating system and the execution of the computer readable instructions in the non-volatile storage medium. Processor 12 may be a central processing unit (Central Processing Unit, CPU), controller, microcontroller, microprocessor, or other data processing chip in some embodiments to provide computing and control capabilities for the electronic device.
On the basis of the above embodiment, as a preferred implementation manner, referring to fig. 6, the electronic device further includes:
an input interface 13, which is connected to the processor 12, for obtaining externally imported computer programs, parameters and instructions, which are stored in the memory 11 under the control of the processor 12. The input interface 13 may be connected to an input device for receiving parameters or instructions manually entered by a user. The input device can be a touch layer covered on a display screen, can also be a key, a track ball or a touch pad arranged on a terminal shell, and can also be a keyboard, a touch pad or a mouse, etc.
A display unit 14 is connected to the processor 12 for displaying data processed by the processor 12 and for displaying a visual user interface. The display unit 14 may be an LED display, a liquid crystal display, a touch-control liquid crystal display, an OLED (Organic Light-Emitting Diode) touch device, or the like.
A network port 15, which is connected to the processor 12 and is used for communication connection with external terminal devices. The communication technology adopted by the communication connection can be a wired communication technology or a wireless communication technology, such as a mobile Ethernet technology, a Universal Serial Bus (USB), a wireless local area network technology (WiFi), a Bluetooth communication technology, a low-power consumption Bluetooth communication technology and the like.
Fig. 6 shows only an electronic device with components 11-15, it will be appreciated by those skilled in the art that the structure shown in fig. 6 is not limiting of the electronic device and may include fewer or more components than shown, or may combine certain components, or a different arrangement of components.
The present application also provides a computer-readable storage medium, which may include: a U-disk, a removable hard disk, a Read-Only Memory (ROM), a random access Memory (Random Access Memory, RAM), a magnetic disk, or an optical disk, or other various media capable of storing program codes. The storage medium has stored thereon a computer program which, when executed by a processor, implements the steps of any of the report automatic generation methods as previously disclosed.
According to the application, after the report template is generated by utilizing the fixed content and the variable content label, the labels in the report template are extracted to generate corresponding Excel filling forms, so that a writer can edit the variable content in the report only by filling the variable content in the cells of the corresponding positions of the variable content labels in the form, the problem that the existing automatic method uses a professional database to store the variable data, and the report writer is difficult to directly access or edit offline is avoided, and therefore, on the basis of reducing the personnel writing workload, the report generating efficiency and flexibility are further improved, and the automatic editing of the report is realized.
In the description, each embodiment is described in a progressive manner, and each embodiment is mainly described by the differences from other embodiments, so that the same similar parts among the embodiments are mutually referred. For the system disclosed in the embodiment, since it corresponds to the method disclosed in the embodiment, the description is relatively simple, and the relevant points refer to the description of the method section. It should be noted that it will be apparent to those skilled in the art that various modifications and adaptations of the application can be made without departing from the principles of the application and these modifications and adaptations are intended to be within the scope of the application as defined in the following claims.
It should also be noted that in this specification, relational terms such as first and second, and the like are used solely to distinguish one entity or action from another entity or action without necessarily requiring or implying any actual such relationship or order between such entities or actions. Moreover, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising one … …" does not exclude the presence of other like elements in a process, method, article, or apparatus that comprises the element.
Claims (6)
1. A method for automatically generating a report, comprising:
acquiring an original report, and determining fixed content and variable content in the original report;
determining an association relation between the variable content and a preset type label, generating a variable content label, combining the fixed content and the variable content label, and generating a report template;
extracting the variable content label in the report template, and generating a corresponding Excel filling table by utilizing the variable content label;
receiving the variable content which is recorded in the Excel filling table, and updating the variable content to the corresponding position of the variable content label in the report template to generate a final report;
wherein the receiving the variable content entered in the Excel filling table comprises:
when a form selection instruction is to select a text type Excel form, receiving text information input through a preset interface, and storing the text information into cells corresponding to text type labels in the text type Excel form;
wherein the updating the variable content to the corresponding position of the variable content tag in the report template includes:
filling the text information in the text type Excel table into the report template, and deleting the variable content tag at the corresponding filling position;
wherein the receiving the variable content entered in the Excel filling table comprises:
when the form selection instruction is to select a picture type Excel form, a form type Excel form or a sub-document type Excel form, receiving file related information input through the preset interface, and storing the file related information into a cell corresponding to the variable content tag in a corresponding form; wherein the file related information comprises a file name and a file storage path;
wherein the updating the variable content to the corresponding position of the variable content tag in the report template includes:
and determining target files corresponding to the file related information in the picture type Excel table, the form type Excel table and the sub-document type Excel table, inserting the content of the target files into corresponding positions in the report template, and deleting the variable content tags on the corresponding filling positions.
2. The automatic report generating method according to claim 1, wherein the Excel filling table includes any one or any combination of the text type Excel table, the picture type Excel table, the form type Excel table, and the sub-document type Excel table.
3. The method for automatically generating a report according to claim 2, further comprising, before said receiving the variable content entered in the Excel-filled form:
acquiring the form selection instruction, wherein the form selection instruction is an instruction which is issued by a writer according to the type of the variable content and used for selecting Excel to fill a form type; displaying the corresponding Excel filling form at the terminal;
correspondingly, the receiving the variable content entered in the Excel filling table comprises:
and storing the variable content into a cell corresponding to the variable content label in the Excel filling table.
4. An automatic report generating system, comprising:
the content judging module is used for acquiring an original report and determining fixed content and variable content in the original report;
the template generation module is used for determining the association relation between the variable content and the preset type label, generating a variable content label, combining the fixed content and the variable content label and generating a report template;
the table generating module is used for extracting the variable content labels in the report template and generating a corresponding Excel filling table by utilizing the variable content labels;
the report generation module is used for receiving the variable content which is recorded in the Excel filling table, updating the variable content to the corresponding position of the variable content label in the report template and generating a final report;
the table generation module is specifically configured to receive text information entered through a preset interface when a table selection instruction is to select a text type Excel table, and store the text information into cells corresponding to text type tags in the text type Excel table;
the table generation module is specifically configured to fill the text information in the text type Excel table into the report template, and delete the variable content tag at the corresponding filling position;
the table generation module is specifically configured to receive file related information entered through the preset interface when the table selection instruction is to select a picture type Excel table, a form type Excel table or a sub-document type Excel table, and store the file related information into a cell corresponding to the variable content tag in a corresponding table; wherein the file related information comprises a file name and a file storage path;
the table generation module is specifically configured to determine the picture type Excel table, the form type Excel table, and the target file corresponding to the file related information in the sub-document type Excel table, insert the content of the target file into the corresponding position in the report template, and delete the variable content tag in the corresponding filling position.
5. An electronic device, comprising:
a memory for storing a computer program;
a processor for implementing the steps of the report auto-generation method according to any one of claims 1 to 3 when executing the computer program.
6. A computer readable storage medium, characterized in that it has stored thereon a computer program which, when executed by a processor, implements the steps of the report automatic generation method according to any of claims 1 to 3.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910217469.3A CN109948134B (en) | 2019-03-21 | 2019-03-21 | Report automatic generation method, system, electronic equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910217469.3A CN109948134B (en) | 2019-03-21 | 2019-03-21 | Report automatic generation method, system, electronic equipment and storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN109948134A CN109948134A (en) | 2019-06-28 |
| CN109948134B true CN109948134B (en) | 2023-12-01 |
Family
ID=67010497
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910217469.3A Active CN109948134B (en) | 2019-03-21 | 2019-03-21 | Report automatic generation method, system, electronic equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109948134B (en) |
Families Citing this family (23)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110599338A (en) * | 2019-08-13 | 2019-12-20 | 上海陆家嘴国际金融资产交易市场股份有限公司 | Transaction data processing method and device, computer equipment and storage medium |
| CN110888882A (en) * | 2019-11-22 | 2020-03-17 | 成都市映潮科技股份有限公司 | Method, device and storage medium for multi-dimensional data extraction and text generation |
| CN111046643A (en) * | 2019-11-23 | 2020-04-21 | 方正株式(武汉)科技开发有限公司 | System and method for generating excel form by rapid customization, server and medium |
| CN111125204A (en) * | 2019-12-17 | 2020-05-08 | 中科鼎富（北京）科技发展有限公司 | Analysis report obtaining method and device, electronic equipment and storage medium |
| CN111310434B (en) * | 2020-02-28 | 2024-01-19 | 北京金堤科技有限公司 | Text generation method and device, electronic equipment and storage medium |
| CN111833981A (en) * | 2020-04-30 | 2020-10-27 | 宁波市科技园区明天医网科技有限公司 | Structured report making and compiling method |
| CN112347127A (en) * | 2020-06-14 | 2021-02-09 | 成玉玺 | Method and system for generating consignment smoke-free master file |
| CN111723129B (en) * | 2020-06-24 | 2024-03-29 | 中国工商银行股份有限公司 | Report generation method, report generation device and electronic equipment |
| CN112035313B (en) * | 2020-07-27 | 2022-03-04 | 珠海格力电器股份有限公司 | Report generation method and device, template customization method and device, and monitoring system |
| CN112052171B (en) * | 2020-09-03 | 2021-05-28 | 上海复深蓝软件股份有限公司 | Test message processing method and device, computer equipment and storage medium |
| CN112052658A (en) * | 2020-09-04 | 2020-12-08 | 深圳市长隆科技有限公司 | Method, system and equipment for automatically generating detection report of water quality detector |
| CN112163834A (en) * | 2020-09-29 | 2021-01-01 | 广州金域司法鉴定技术有限公司 | Detection report generation method, device, electronic equipment and medium |
| CN112949267A (en) * | 2021-02-05 | 2021-06-11 | 中国建设银行股份有限公司 | Method and system for generating financial analysis chart |
| CN112906356A (en) * | 2021-02-05 | 2021-06-04 | 武汉先峰誉得科技有限公司 | Report compiling flow self-defining method and device, client and server |
| CN113076722A (en) * | 2021-03-10 | 2021-07-06 | 北京明略软件系统有限公司 | Report generation method and device, computer equipment and storage medium |
| CN113268968A (en) * | 2021-04-28 | 2021-08-17 | 企查查科技有限公司 | Report file generation method and device, computer equipment and storage medium |
| CN113448567B (en) * | 2021-06-09 | 2024-05-17 | 心医国际数字医疗系统(大连)有限公司 | Method and device for generating follow-up form |
| CN113900561B (en) * | 2021-10-27 | 2023-07-25 | 北京字跳网络技术有限公司 | Form processing method, form processing device, electronic equipment, medium and program product |
| CN114023415A (en) * | 2021-11-08 | 2022-02-08 | 深圳航天智慧城市系统技术研究院有限公司 | Dynamic document template generation method and system based on online editable customization |
| CN114626352B (en) * | 2022-03-11 | 2024-02-06 | 平安科技（深圳）有限公司 | Report automatic generation method, device, computer equipment and storage medium |
| CN115270725A (en) * | 2022-07-04 | 2022-11-01 | 温州佳合标准化信息技术事务所 | Method, system, device and medium for automatically converting standard format |
| CN115630625A (en) * | 2022-09-22 | 2023-01-20 | 中科三清科技有限公司 | Method and device for generating air quality report, storage medium and electronic equipment |
| CN115796140B (en) * | 2022-11-03 | 2023-09-05 | 广州天维信息技术股份有限公司 | Report automatic generation and report template configuration method and device |
Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103279454A (en) * | 2013-06-09 | 2013-09-04 | 广东电网公司电力科学研究院 | Document automatic generation method, device and system |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20070016561A1 (en) * | 2005-07-03 | 2007-01-18 | Research Innovation Aps | Electronic report generator |
-
2019
- 2019-03-21 CN CN201910217469.3A patent/CN109948134B/en active Active
Patent Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103279454A (en) * | 2013-06-09 | 2013-09-04 | 广东电网公司电力科学研究院 | Document automatic generation method, device and system |
Non-Patent Citations (1)
| Title |
|---|
| 使用VBA+Ribbon X实现新媒体报告自动生成插件;武霖;《中国有线电视》;20181015(第10期);全文 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN109948134A (en) | 2019-06-28 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109948134B (en) | Report automatic generation method, system, electronic equipment and storage medium | |
| US9207933B2 (en) | Identifying authors of changes between multiple versions of a file | |
| US7673235B2 (en) | Method and apparatus for utilizing an object model to manage document parts for use in an electronic document | |
| CN104133772A (en) | Automatic test data generation method | |
| CN110705237B (en) | Automatic document generation method, data processing device and storage medium | |
| CN108762743B (en) | Data table operation code generation method and device | |
| CN105677353A (en) | Feature extraction method and machine learning method and device thereof | |
| JP2012510110A (en) | User-created notes on shared documents | |
| CN106844885B (en) | BIM technology-based drawing frame and drawing label design method | |
| CN103559184A (en) | Form page display method and device | |
| CN110555073A (en) | data processing method and device, electronic equipment and storage medium | |
| WO2020259141A1 (en) | File processing method and apparatus, and computer device | |
| US20090049025A1 (en) | System and method for harvesting service metadata from an architecture diagram into a metadata repository | |
| CN107908843B (en) | Management system based on drawing of map label information | |
| US20100185967A1 (en) | Information Processing Device, and File Managing Method | |
| CN115293124A (en) | Automatic generation method and device for software engineering document | |
| CN104375814A (en) | Generation method and device of an interface document | |
| CN114895875B (en) | Zero-code visual information system metadata production application method and system | |
| CN116956838A (en) | Project determining method and device for engineering quantity list | |
| CN111399900B (en) | API document automatic generation method and system based on python and regular expression | |
| CN113610489A (en) | Form informatization management method | |
| CN114116938A (en) | Map plotting method and device based on WebGIS | |
| CN112559318A (en) | Test case generation method and device, electronic equipment and storage medium | |
| CN102254155A (en) | Accurate font activation | |
| CN112686014A (en) | Cable number plate compiling system and method |
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 |