CN109948134A - A kind of report automatic generation method, system and electronic equipment and storage medium - Google Patents
A kind of report automatic generation method, system and electronic equipment and storage medium Download PDFInfo
- Publication number
- CN109948134A CN109948134A CN201910217469.3A CN201910217469A CN109948134A CN 109948134 A CN109948134 A CN 109948134A CN 201910217469 A CN201910217469 A CN 201910217469A CN 109948134 A CN109948134 A CN 109948134A
- Authority
- CN
- China
- Prior art keywords
- variable content
- report
- excel
- label
- 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.)
- Granted
Links
- 238000000034 method Methods 0.000 title claims abstract description 62
- 238000003860 storage Methods 0.000 title claims description 15
- 239000000126 substance Substances 0.000 claims abstract description 31
- 238000004590 computer program Methods 0.000 claims description 11
- 239000007787 solid Substances 0.000 claims description 2
- 238000012986 modification Methods 0.000 abstract description 5
- 230000004048 modification Effects 0.000 abstract description 5
- 230000008569 process Effects 0.000 description 10
- 238000005516 engineering process Methods 0.000 description 7
- 238000012360 testing method Methods 0.000 description 7
- 238000004891 communication Methods 0.000 description 5
- 238000012545 processing Methods 0.000 description 4
- 239000000284 extract Substances 0.000 description 3
- 230000008859 change Effects 0.000 description 2
- 230000006872 improvement Effects 0.000 description 2
- 239000004973 liquid crystal related substance Substances 0.000 description 2
- 238000005457 optimization Methods 0.000 description 2
- 230000009467 reduction Effects 0.000 description 2
- 230000003252 repetitive effect Effects 0.000 description 2
- 206010054949 Metaplasia Diseases 0.000 description 1
- 238000012512 characterization method Methods 0.000 description 1
- 239000012141 concentrate Substances 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 239000000945 filler Substances 0.000 description 1
- 230000006870 function Effects 0.000 description 1
- 230000014509 gene expression Effects 0.000 description 1
- 238000003780 insertion Methods 0.000 description 1
- 230000037431 insertion Effects 0.000 description 1
- 238000012423 maintenance Methods 0.000 description 1
- 230000014759 maintenance of location Effects 0.000 description 1
- 238000000691 measurement method Methods 0.000 description 1
- 230000015689 metaplastic ossification Effects 0.000 description 1
- 239000000203 mixture Substances 0.000 description 1
- 230000008520 organization Effects 0.000 description 1
- 238000011056 performance test Methods 0.000 description 1
- 238000002360 preparation method Methods 0.000 description 1
- 238000004321 preservation Methods 0.000 description 1
- 230000000750 progressive effect Effects 0.000 description 1
- 239000013589 supplement Substances 0.000 description 1
Landscapes
- Document Processing Apparatus (AREA)
- Stored Programmes (AREA)
Abstract
This application discloses a kind of report automatic generation method, system and equipment and media, comprising: obtains initial report, determines wherein immobilized substance and variable content;It determines the incidence relation between variable content and preset kind label, generates variable content label, merge immobilized substance and variable content label, generate report template;Variable content label in report template is extracted, corresponding Excel is generated using variable content label and fills table;Variable content is updated to the corresponding position of variable content label in template by the variable content for receiving typing in the table, generates Final Report.That is writer's corresponding position that variable content is filled in the variable content label into Excel table, achieve the purpose that editor's report variable content, avoid the problem that existing automated method is difficult to direct editing or offline modification using writer when database purchase variable data, the flexibility ratio for improving report preparing system reduces text and writes workload and write mistake.
Description
Technical field
This application involves information technology data process fields, more specifically to a kind of report automatic generation method, are
System and a kind of electronic equipment and a kind of computer readable storage medium.
Background technique
All types of reports is the important written foundation that enterprise carries out business and technical management, supervision.What enterprise was engaged in
Business is different, and the type and format of report are also far from each other.Currently, enterprise staff is during report is write, it will usually use
The Word Word of Microsoft needs to modify report content repeatedly when writing, and editing process is uninteresting, needs writer
It concentrates one's energy, careless slightly will cause is reported in error rate height on format and content, causes working efficiency low.Currently for such
Report is write, and following two method is mainly used:
Historical report+manual amendment method after referring to that writer backs up historical report, directly carries out on historical report
Modification and editor.In writing reporting process, writer also needs to carry out multiple other than carrying out increasing supplement to contents such as texts
The repetitive operations such as lookup, replacement, duplication, stickup, with the new and old content of new content.If the content to be updated is in document
Middle position is more dispersed, and it is cumbersome to will cause operating process.Meanwhile in the case where replacing often, words and expressions replaces error rate
It will increase.
Document template+database+programming automation method, is first made Word document template for fixed part in report,
The content of variation is stored in background data base field, Word document template and background data base related content are closed
And completion report automatically generates.In such method, each company is often according to own service situation, organization procedure person's exploitation
It reports automatic creation system, customizes by force, the variation of report template may require that background data base field and Software Create each time
Functional module makes corresponding modification and upgrading.If report type it is more and when change, the cost of later maintenance is big.With
The variation of reporter species and report content update, employee can not intervene report automation generating process and be difficult to directly modify mould
Plate directly operates back-end data library structure, can only do again manual update on the basis of the report automatically generated, report is caused to give birth to
It is insufficient at the flexibility ratio of system.
In above-mentioned report-generating method, the method heavy workload of manual amendment's report, low efficiency, error rate is high, and shows
Some automatic generating method poor universalities, flexibility ratio are insufficient.Therefore, how to improve the efficiency of report generation and flexibility is
Those skilled in the art's problem to be solved.
Summary of the invention
The application's is designed to provide a kind of report automatic generation method, system and a kind of electronic equipment and a kind of calculating
Machine readable storage medium storing program for executing improves the efficiency and flexibility of report generation.
To achieve the above object, this application provides a kind of report automatic generation methods, comprising:
Initial report is obtained, and determines immobilized substance and variable content in initial report;
It determines the incidence relation between variable content and preset kind label, generates variable content label, merge original report
Immobilized substance and the variable content label in announcement, generate report template;
The variable content label in report template is extracted, and generates corresponding Excel using variable content label and fills table
Lattice;
The variable content of typing in Excel filling table is received, and variable content is updated in report template and can be changed
The corresponding position of content tab generates Final Report.
Wherein, the Excel fills table, including text type Excel table, picture type Excel table, list class
Any one of type Excel table, subdocument type Excel table or any combination.
It is wherein, described to receive in Excel filling table before the variable content of typing, further includes:
Table selection instruction is obtained, the table selection instruction is the selection that writer issues according to the type of variable content
Excel fills the instruction of form types, and shows corresponding Excel filling table in terminal;
Correspondingly, the variable content for receiving typing in Excel filling table, comprising:
Variable content is saved into Excel filling table in cell corresponding with variable content label.
Wherein, the variable content for receiving typing in Excel filling table, comprising:
When the table selection instruction is selection text type Excel table, the text for passing through preset interface typing is received
This information, by text information preservation into text type Excel table in cell corresponding with text type label.
Wherein, the corresponding position that variable content is updated to variable content label in report template, comprising:
Text information in the text type Excel table is filled into report template, and deletes corresponding filler
The variable content label set.
Wherein, the variable content for receiving typing in Excel filling table, comprising:
When the table selection instruction is selection picture type Excel table, form types Excel table or subdocument class
When type Excel table, the file-related information for passing through preset interface typing is received, variable content in corresponding table is saved to
In the corresponding cell of label;Wherein, the file-related information includes that filename and file store path.
Wherein, the corresponding position that variable content is updated to variable content label in report template, comprising:
Determine the file phase of picture type Excel table, form types Excel table and subdocument type Excel table
The corresponding file destination of information is closed, and file destination content is inserted into the corresponding position in report template, and delete corresponding filling
Variable content label on position.
To achieve the above object, this application provides a kind of report automatic creation systems, comprising:
Content discrimination module for obtaining initial report, and determines immobilized substance and variable content in initial report;
Template generation module generates in variable for determining the incidence relation between variable content and preset kind label
Hold label, merge immobilized substance and variable content label in initial report, generates report template;
Table generation module is generated for extracting the variable content label in report template, and using variable content label
Corresponding Excel fills table;
Report generation module for receiving the variable content of typing in Excel filling table, and variable content is updated
The corresponding position of variable content label into report template generates Final Report.
To achieve the above object, this application provides a kind of electronic equipment, comprising:
Memory, for storing computer program;
Processor realizes any one report automatic generation method as previously disclosed when for executing the computer program
The step of.
To achieve the above object, this application provides a kind of computer readable storage medium, the computer-readable storages
It is stored with computer program on medium, any one report as previously disclosed is realized when the computer program is executed by processor
The step of automatic generation method.
By above scheme it is found that a kind of report automatic generation method provided by the present application, comprising: initial report is obtained,
And determine immobilized substance and variable content in initial report;Determine being associated between variable content and preset kind label
System generates variable content label, merges immobilized substance and variable content label in initial report, generates report template;It extracts
Variable content label in report template, and generate corresponding Excel using variable content label and fill table;Receive the table
In typing variable content, and the variable content is updated to the corresponding position of variable content label in report template, generated
Final Report.That is, being reported after the application generates report template using immobilized substance and variable content label by extracting
Label in slide former generates corresponding all types of Excel and fills table, only needs to fill out variable content so that writer is subsequent
It is written to the purpose that in the cell of variable content label corresponding position, that is, can reach variable content in editor's report in table, is kept away
Existing automatic method is exempted from using the database of profession to store variable data, report writer is difficult to directly to access or not
The problem of capable of modifying offline, thus on the basis of reduction personnel write workload, further improve report generation efficiency and
Flexibility optimizes the automation editing process of report.
Disclosed herein as well is a kind of report automatic creation system, a kind of electronic equipment and a kind of computer-readable storage medium
Matter is equally able to achieve above-mentioned technical effect.
It should be understood that the above general description and the following detailed description are merely exemplary, this can not be limited
Application.
Detailed description of the invention
In order to illustrate the technical solutions in the embodiments of the present application or in the prior art more clearly, to embodiment or will show below
There is attached drawing needed in technical description to be briefly described, it should be apparent that, the accompanying drawings in the following description is only this
Some embodiments of application for those of ordinary skill in the art without creative efforts, can be with
It obtains other drawings based on these drawings.
Fig. 1 is a kind of flow chart for reporting automatic generation method disclosed in the embodiment of the present application;
Fig. 2 is the flow chart that another kind disclosed in the embodiment of the present application reports automatic generation method;
Fig. 3 is the flow chart of another disclosed report automatic generation method of the embodiment of the present application;
Fig. 4 is a kind of structure chart for reporting automatic creation system disclosed in the embodiment of the present application;
Fig. 5 is the structure chart of a kind of electronic equipment disclosed in the embodiment of the present application;
Fig. 6 is the structure chart of another kind electronic equipment disclosed in the embodiment of the present application.
Specific embodiment
Below in conjunction with the attached drawing in the embodiment of the present application, technical solutions in the embodiments of the present application carries out clear, complete
Site preparation description, it is clear that described embodiments are only a part of embodiments of the present application, instead of all the embodiments.It is based on
Embodiment in the application, it is obtained by those of ordinary skill in the art without making creative efforts every other
Embodiment shall fall in the protection scope of this application.
In the prior art, the method heavy workload of manual amendment's report, low efficiency, error rate is high, and automatic metaplasia
At method poor universality, flexibility ratio is insufficient.
Therefore, the embodiment of the present application discloses a kind of report automatic generation method, improve report generation efficiency and
Flexibility.
Referring to Fig. 1, a kind of flow chart for reporting automatic generation method disclosed in the embodiment of the present application, as shown in Figure 1, packet
It includes:
S101: obtaining initial report, and determines immobilized substance and variable content in the initial report;
In the present embodiment, the initial report finalized a text is obtained, and identify the immobilized substance in initial report and variable content.
Variable content is further subjected to special marking, for example, variable content background is become yellow, or adds lower stroke for variable content
Line etc., which is not limited by the present invention.
It is understood that same type of report is unanimous on the whole in form, it is embodied in reporting format and big portion
Divide content relatively fixed, only a fraction content needs the variable content modified with updated namely the present embodiment is mentioned.
S102: determining the incidence relation between the variable content and preset kind label, generates variable content label, closes
And the immobilized substance and the variable content label, generate report template;
It is understood that the present embodiment classifies to variable content according to variable content and the relationship of preset kind label,
Generate variable content label.Specifically, variable content type can be divided into content of text, image content, list content, in subdocument
Hold, correspondingly, variable content label may include text type label, picture type label, form types label, subdocument type
Label, the diversity of tag types enhance the versatility and universality of report.
In a specific embodiment, variable content label can be by label prefix, tag ID and tag suffix three
Divide and constitutes.For example, the label prefix of text type label is " { { labeltext_ ", tag suffix is " _ labeltext } } ";
The label prefix of picture type label is " { { labelfigure_ ", and tag suffix is " _ labelfigure } } ";Form types
The label prefix of label is " { { labeltable_ ", and tag suffix is " _ labeltable } } ";The mark of subdocument type label
Signing prefix is " { { labeldocument_ ", and tag suffix is " _ labeldocument } } ".It should be noted that the present embodiment
In same variable content and appear in the type label of document different location and be consistent.Tag ID can be according to the true of variable content
Real meaning is specifically named, for example, the corresponding complete tag of report heading can be
" { { labeltext_report-subject_labeltext } } ", wherein " labeltext_ " and " _
Labeltext } } " be text type label prefix and suffix, " report-subject " be tag ID.
After determining the incidence relation of preset kind label and variable content, the immobilized substance that step S101 is extracted is made
For the immobilized substance in report template, and variable content tag replacement variable content is utilized, thus by variable content label and solid
Determine content to merge, generates report template.For example, following text is the few examples of a test report template:
" this test report describes the foundation and mark of { { labeltext_report-subject_labeltext } } in detail
Standard, measurement method, test data and test result etc..It tests and is carried out in { { labeltext_date_labeltext } }."
In the examples described above, { { labeltext_report-subject_labeltext } } and
{ { labeltext_date_labeltext } } is in blank variable content, indicates the title and examination of test report
The date of implementation is tested, remaining text is immobilized substance.
S103: the variable content label in the report template is extracted, and is generated using the variable content label
Corresponding Excel fills table;
Further, the present embodiment extracts the variable content label in report template, by it after generating report template
It stores into corresponding Excel filling table.Specifically, storing variable content label into the first row of corresponding table, use
The content type and content meaning that each row is filled in characterization table.Corresponding unit in the secondary series of each Excel filling table
Lattice are used to the corresponding variable content in typing report.
It is understood that the present embodiment is according to text type label, picture type label, form types label, Ziwen
The classification of shelves type label, constructs the table of respective type: text type Excel table, picture type Excel table, list
Type Excel table, subdocument type Excel table.
S104: the variable content of typing in the Excel filling table is received, and the variable content is updated
To the corresponding position of variable content label described in the report template, Final Report is generated.
In the present embodiment, by preset interface, the variable content ready to receive inputted by writer.Such as it can be by default
Each Excel of interface editor fills table, and variable content is saved into the secondary series of Excel filling table, wherein gets
Variable content be needed in report template modify or update content.
Specifically, the present embodiment is that the report of each type creates corresponding report template, currently to be generated in determination
Report topic after, obtain the corresponding report template of current question, then Excel is filled into the variable content in table and is updated to report
The corresponding position of variable content label in slide former generates Final Report.
It should be noted that writer can be by writing the corresponding content in Excel table secondary series in the present embodiment
It realizes purpose to fill substance in editor's Final Report, avoids and stored in existing automatic method using specialized database
Report writer caused by variable data is difficult to the problem of directly accessing the database and modifying offline, improves flexibility ratio.
In addition, it is corresponding only to replace label when variable content is inserted the corresponding position into report template by the present embodiment
Content avoids in traditional Word software function, and in a replacement process, only the defect of replaceable identical characters string, is reduced
Error rate is replaced, while avoiding the repetitive operations such as massive duplication, stickup when tradition writes report, is improved work efficiency.
By above scheme it is found that a kind of report automatic generation method provided by the present application, comprising: initial report is obtained,
And determine immobilized substance and variable content in the initial report;Determine being associated between variable content and preset kind label
System generates variable content label, merges immobilized substance and variable content label in initial report, generates report template;It extracts
Variable content label in this report template, and generate corresponding Excel using the variable content label and fill table;Receiving should
The variable content of typing in table, and variable content is updated to the correspondence of variable content label described in the report template
Position generates Final Report.That is, after the application generates report template using immobilized substance and variable content label,
The filling table that corresponding all types of contents are generated by extracting the label in report template, so that writer is carrying out report mould
After plate, subsequent copy editor only needs to fill in variable content into table in cell corresponding to variable content label, i.e.,
It can reach the purpose of variable content in off-line editing report.
The embodiment of the present application discloses another report automatic generation method, relative to a upper embodiment, the present embodiment pair
Technical solution has made further instruction and optimization.It is specific:
Referring to fig. 2, the flow chart of another report automatic generation method provided by the embodiments of the present application, as shown in Fig. 2, packet
It includes:
S201: obtaining initial report, and determines immobilized substance and variable content in the initial report;
S202: determining the incidence relation between the variable content and preset kind label, generates variable content label, closes
And the immobilized substance and the variable content label, generate report template;
S203: the variable content label in the report template is extracted, and is generated using the variable content label
Corresponding Excel fills table;
S204: obtaining table selection instruction, and the Excel of respective type displayed on the terminals fills table;Table selection
Instruction is the instruction that the selection Excel that writer issues according to the type of variable content fills form types;
S205: receiving the variable content, by the variable content save to the Excel filling table in it is described can
Become in the corresponding cell of content tab, and the variable content is updated to variable content label described in the report template
Corresponding position, generate Final Report.
It is understood that the Excel in the present embodiment fills table, including text type Excel table, picture type
Any one of Excel table, form types Excel table, subdocument type Excel table or any combination.
In the present embodiment, after getting the table selection instruction of current writer, according to the table selection instruction in terminal
Show corresponding Excel filling table.That is, current writer selects corresponding table according to the variable content type of filling,
To show that corresponding Excel fills table according to table selection instruction, so that writer fills in content to display in terminal
In Excel filling table on screen.
The embodiment of the present application discloses another report automatic generation method, relative to a upper embodiment, the present embodiment pair
Technical solution has made further instruction and optimization.It is specific:
Referring to Fig. 3, the flow chart of another report automatic generation method provided by the embodiments of the present application, as shown in figure 3, packet
It includes:
S301: obtaining initial report, and determines immobilized substance and variable content in the initial report;
S302: determining the incidence relation between the variable content and preset kind label, generates variable content label, closes
And the immobilized substance and the variable content label, generate report template;
S303: the variable content label in the report template is extracted, and is generated using the variable content label
Corresponding Excel fills table;
S304: obtaining table selection instruction, when the table selection instruction is selection text type Excel table, connects
The text information for passing through preset interface typing is received, the text information is saved into the text type Excel table and text
In the corresponding cell of this type label;
It is understood that selecting text type Excel table if the content that writer needs to fill in is text information
Lattice input the text information to be modified or be updated, and by this text envelope after terminal shows this text type Excel table
Breath is saved into text type Excel table in cell corresponding with text type label.
S305: when the table selection instruction is selection picture type Excel table, form types Excel table or son
When Doctype Excel table, the file-related information for passing through preset interface typing is received, by picture, list or subdocument
File-related information is saved into corresponding table in the corresponding cell of variable content label;Wherein, the file-related information
Path is stored comprising filename and file;
In a specific embodiment, if it is list, picture or subdocument, i.e. table that writer, which needs newly-increased content,
The corresponding selecting object of selection instruction is picture type Excel table, form types Excel table or subdocument type Excel
When table, variable content can be filled in the secondary series into Excel filling table by writer.Wherein, Excel fills table the
One column save corresponding variable content label, to fill in corresponding content according to variable content label.Specifically, if writing
The content that people needs to fill in is text information, then is directly filled in the secondary series of text type Excel table;If writer
Newly-increased picture is needed, then file is saved with jpg or png format and is named, the secondary series filling in picture type Excel table
The relevant information of picture file name and storage path.For example, the picture of a layout is if desired inserted into template report, it can
Picture is named as according to the real meaning of picture
" figure-layout.jpg ", and will comprising filename " figure-layout.jpg " and path " C:
Tag name is in the file-related information filling picture type Excel table of pictures "
It is complete in secondary series cell corresponding to " { { labelfigure_figure-layout_labelfigure } } "
At filling in for the picture file relevant information, as shown in table 1;If writer needs newly-increased list or subdocument, can be according to above-mentioned
The mode of addition picture fills in the relevant information of formfile or Ziwen files into table.
Table 1
Variable content label | Fill substance |
{{labelfigure_figure-layout_labelfigure}} | C:\pictures\figure-layout.jpg |
S306: the text information in the text type Excel table is filled into the report template, and is deleted
Except the variable content label on corresponding filling position;
S307: the picture type Excel table, the form types Excel table and the subdocument type are determined
The corresponding file destination of the file-related information in Excel table, and the file destination content is inserted into the report
Corresponding position in template, and the variable content label on corresponding filling position is deleted, generate Final Report.
In the present embodiment, the text information in text type Excel table is filled into report template, and delete filling
Variable content label on position;In addition, corresponding file destination is determined according to the file-related information stored in table, by mesh
The corresponding position in file insertion report template is marked, further deletes the variable content label for being located at corresponding position, it is complete
At filling in for Final Report.
In the application, using a kind of specific embodiment as example, Excel filling table is shown, table 2 is text type
Excel table, as shown in table 2, the 1st is classified as variable content label in table, and the 2nd is classified as the variable content of filling.
Table 2
Variable content label | Fill substance |
{{labeltext_report-subject_labeltext}} | Dongshan Co., Ltd #2 unit air preheater performance test |
{{labeltext_manager-name_labeltext}} | Li Ming |
{{labeltext_date_labeltext}} | On October 11st, 2018 |
{{labeltext_company_labeltext}} | Dongshan Co., Ltd |
{{labeltext_background_labeltext}} | Air preheater heat exchange property and situation of leaking out |
{{labeltext_unit-number_labeltext}} | #2 unit |
{{labeltext_experiment-name_labeltext}} | Air preheater air leakage test |
A kind of report automatic creation system provided by the embodiments of the present application is introduced below, a kind of report described below
Accusing automatic creation system can be cross-referenced with a kind of above-described report automatic generation method.
Referring to fig. 4, a kind of structure chart for reporting automatic creation system provided by the embodiments of the present application, as shown in figure 4, packet
It includes:
Content discrimination module 100 for obtaining initial report, and determines the immobilized substance in the initial report and can be changed
Content;
Template generation module 200 generates variable for determining the incidence relation between variable content and preset kind label
Content tab merges immobilized substance and variable content label, generates report template;
Table generation module 300 for extracting the variable content label in the report template, and utilizes variable content mark
Label generate corresponding Excel and fill table;
Report generation module 400, for receiving the variable content of typing in Excel filling table, and by variable content
It is updated to the corresponding position of variable content label in report template, generates Final Report.
Present invention also provides a kind of electronic equipment, referring to Fig. 5, the knot of a kind of electronic equipment provided by the embodiments of the present application
Composition, as shown in Figure 5, comprising:
Memory 11, for storing computer program;
Any report provided by above-described embodiment may be implemented in processor 12 when for executing the computer program
The step of automatic generation method.
Specifically, memory 11 includes non-volatile memory medium, built-in storage.The non-volatile memory medium is stored with
Operating system and computer-readable instruction, the built-in storage are the operating system and computer-readable in non-volatile memory medium
The operation of instruction provides environment.Processor 12 can be a central processing unit (Central in some embodiments
Processing Unit, CPU), controller, microcontroller, microprocessor or other data processing chips, mentioned for electronic equipment
For calculating and control ability.
On the basis of the above embodiments, preferably, referring to Fig. 6, the electronic equipment further include:
Input interface 13 is connected with processor 12, for obtaining computer program, parameter and the instruction of external importing, warp
The control of processor 12 is saved into memory 11.The input interface 13 can be connected with input unit, receive user and be manually entered
Parameter or instruction.The input unit can be the touch layer covered on display screen, be also possible to be arranged in terminal enclosure by
Key, trace ball or Trackpad are also possible to keyboard, Trackpad or mouse etc..
Display unit 14 is connected with processor 12, for the data of the processing of video-stream processor 12 and for showing visually
The user interface of change.The display unit 14 can be light-emitting diode display, liquid crystal display, touch-control liquid crystal display and OLED
(Organic Light-Emitting Diode, Organic Light Emitting Diode) touches device etc..
The network port 15 is connected with processor 12, for being communicatively coupled with external each terminal device.The communication connection
The used communication technology can be cable communicating technology or wireless communication technique, and such as mobile ethernet network technology, general serial is total
Line (USB), wireless local area network technology (WiFi), Bluetooth Communication Technology, low-power consumption bluetooth communication technology etc..
Fig. 6 illustrates only the electronic equipment with component 11-15, it will be appreciated by persons skilled in the art that Fig. 6 is shown
Structure do not constitute the restriction to electronic equipment, may include more certain than illustrating less perhaps more components or combination
Component or different component layouts.
Present invention also provides a kind of computer readable storage medium, the storage medium may include: USB flash disk, mobile hard disk,
Read-only memory (Read-Only Memory, ROM), random access memory (Random Access Memory, RAM), magnetic
The various media that can store program code such as dish or CD.Computer program, the calculating are stored on the storage medium
The step of any one report automatic generation method as previously disclosed is realized when machine program is executed by processor.
After the application generates report template using immobilized substance and variable content label, by extracting in report template
Label generates corresponding all types of Excel and fills table, only needs to fill in variable content into table so that writer is subsequent
In the cell of the corresponding position of variable content label, that is, it can reach the purpose of variable content in editor's report, avoid existing
Automatic method store variable data using the database of profession, report writer is difficult to directly to access or off-line editing
Problem, to further improve report generation efficiency and flexibility on the basis of reduction personnel write workload, realize
The automation of report is edited.
Each embodiment is described in a progressive manner in specification, the highlights of each of the examples are with other realities
The difference of example is applied, the same or similar parts in each embodiment may refer to each other.For system disclosed in embodiment
Speech, since it is corresponded to the methods disclosed in the examples, so being described relatively simple, related place is referring to method part illustration
?.It should be pointed out that for those skilled in the art, under the premise of not departing from the application principle, also
Can to the application, some improvement and modification can also be carried out, these improvement and modification also fall into the protection scope of the claim of this application
It is interior.
It should also be noted that, in the present specification, relational terms such as first and second and the like be used merely to by
One entity or operation are distinguished with another entity or operation, without necessarily requiring or implying these entities or operation
Between there are any actual relationship or orders.Moreover, the terms "include", "comprise" or its any other variant meaning
Covering non-exclusive inclusion, so that the process, method, article or equipment for including a series of elements not only includes that
A little elements, but also including other elements that are not explicitly listed, or further include for this process, method, article or
The intrinsic element of equipment.In the absence of more restrictions, the element limited by sentence "including a ...", is not arranged
Except there is also other identical elements in the process, method, article or apparatus that includes the element.
Claims (10)
1. a kind of report automatic generation method characterized by comprising
Initial report is obtained, and determines immobilized substance and variable content in the initial report;
It determines the incidence relation between the variable content and preset kind label, generates variable content label, merge described solid
Determine content and the variable content label, generates report template;
The variable content label in the report template is extracted, and corresponding using variable content label generation
Excel fills table;
The variable content of typing in the Excel filling table is received, and the variable content is updated to the report
The corresponding position of variable content label described in slide former generates Final Report.
2. report automatic generation method according to claim 1, which is characterized in that the Excel fills table, including text
It is this type Excel table, picture type Excel table, form types Excel table, any in subdocument type Excel table
Item or any combination.
3. report automatic generation method according to claim 2, which is characterized in that described to receive the Excel filling table
In lattice before the variable content of typing, further includes:
Table selection instruction is obtained, the table selection instruction is the selection that writer issues according to the type of the variable content
The instruction of Excel filling form types;And the corresponding Excel filling table is shown in terminal;
Correspondingly, the variable content for receiving typing in the Excel filling table, comprising:
The variable content is saved into Excel filling table in cell corresponding with the variable content label.
4. report automatic generation method according to claim 3, which is characterized in that described to receive the Excel filling table
The variable content of typing in lattice, comprising:
When the table selection instruction is to select the text type Excel table, the text for passing through preset interface typing is received
The text information is saved into the text type Excel table cell corresponding with text type label by this information
In.
5. report automatic generation method according to claim 4, which is characterized in that described to be updated to the variable content
The corresponding position of variable content label described in the report template, comprising:
The text information in the text type Excel table is filled into the report template, and deletes correspondence and fills out
Fill the variable content label on position.
6. report automatic generation method according to claim 3, which is characterized in that described to receive the Excel filling table
The variable content of typing in lattice, comprising:
When the table selection instruction is to select the picture type Excel table, the form types Excel table or described
When subdocument type Excel table, the file-related information for passing through preset interface typing is received, the file-related information is protected
It deposits into the corresponding cell of variable content label described in corresponding table;Wherein, the file-related information includes filename
And file stores path.
7. report automatic generation method according to claim 6, which is characterized in that described to be updated to the variable content
The corresponding position of variable content label described in the report template, comprising:
Determine the picture type Excel table, the form types Excel table and the subdocument type Excel table
In the corresponding file destination of the file-related information, the correspondence file destination content being inserted into the report template
Position, and delete the variable content label on corresponding filling position.
8. a kind of report automatic creation system characterized by comprising
Content discrimination module for obtaining initial report, and determines immobilized substance and variable content in the initial report;
Template generation module generates in variable for determining the incidence relation between the variable content and preset kind label
Hold label, merge the immobilized substance and the variable content label, generates report template;
Table generation module for extracting the variable content label in the report template, and utilizes the variable content
Label generates corresponding Excel and fills table;
Report generation module, for receiving the variable content of typing in the Excel filling table, and will be described variable
The corresponding position of variable content label described in content update to the report template generates Final Report.
9. a kind of electronic equipment characterized by comprising
Memory, for storing computer program;
Processor is realized when for executing the computer program and reports the side of automatically generating as described in any one of claim 1 to 7
The step of method.
10. a kind of computer readable storage medium, which is characterized in that be stored with computer on the computer readable storage medium
Program is realized when the computer program is executed by processor and reports automatic generation method as described in any one of claim 1 to 7
The step of.
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 true CN109948134A (en) | 2019-06-28 |
CN109948134B 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) |
Cited By (24)
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 |
CN111310434A (en) * | 2020-02-28 | 2020-06-19 | 北京金堤科技有限公司 | Text generation method and device, electronic equipment and storage medium |
CN111723129A (en) * | 2020-06-24 | 2020-09-29 | 中国工商银行股份有限公司 | Report generation method, report generation device and electronic equipment |
CN111833981A (en) * | 2020-04-30 | 2020-10-27 | 宁波市科技园区明天医网科技有限公司 | Structured report making and compiling method |
CN112035313A (en) * | 2020-07-27 | 2020-12-04 | 珠海格力电器股份有限公司 | Report generation method and device, template customization method and device, and monitoring system |
CN112052658A (en) * | 2020-09-04 | 2020-12-08 | 深圳市长隆科技有限公司 | Method, system and equipment for automatically generating detection report of water quality detector |
CN112052171A (en) * | 2020-09-03 | 2020-12-08 | 上海复深蓝软件股份有限公司 | Test message processing method and device, computer equipment and storage medium |
CN112163834A (en) * | 2020-09-29 | 2021-01-01 | 广州金域司法鉴定技术有限公司 | Detection report generation method, device, electronic equipment and medium |
CN112347127A (en) * | 2020-06-14 | 2021-02-09 | 成玉玺 | Method and system for generating consignment smoke-free master file |
CN112906356A (en) * | 2021-02-05 | 2021-06-04 | 武汉先峰誉得科技有限公司 | Report compiling flow self-defining method and device, client and server |
CN112949267A (en) * | 2021-02-05 | 2021-06-11 | 中国建设银行股份有限公司 | Method and system for generating financial analysis chart |
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 |
CN113448567A (en) * | 2021-06-09 | 2021-09-28 | 心医国际数字医疗系统(大连)有限公司 | Method and device for generating follow-up form |
CN113900561A (en) * | 2021-10-27 | 2022-01-07 | 北京字跳网络技术有限公司 | Form processing method, apparatus, electronic device, medium, and program product |
CN114023415A (en) * | 2021-11-08 | 2022-02-08 | 深圳航天智慧城市系统技术研究院有限公司 | Dynamic document template generation method and system based on online editable customization |
CN114626352A (en) * | 2022-03-11 | 2022-06-14 | 平安科技(深圳)有限公司 | Report automatic generation method and 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 |
CN115796140A (en) * | 2022-11-03 | 2023-03-14 | 广州天维信息技术股份有限公司 | Report automatic generation method and device and report template configuration method and device |
CN112906356B (en) * | 2021-02-05 | 2024-06-11 | 武汉先峰誉得科技有限公司 | Report writing flow self-defining method and device, client and server |
Citations (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20070016561A1 (en) * | 2005-07-03 | 2007-01-18 | Research Innovation Aps | Electronic report generator |
CN103279454A (en) * | 2013-06-09 | 2013-09-04 | 广东电网公司电力科学研究院 | Document automatic generation method, device and system |
-
2019
- 2019-03-21 CN CN201910217469.3A patent/CN109948134B/en active Active
Patent Citations (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20070016561A1 (en) * | 2005-07-03 | 2007-01-18 | Research Innovation Aps | Electronic report generator |
CN103279454A (en) * | 2013-06-09 | 2013-09-04 | 广东电网公司电力科学研究院 | Document automatic generation method, device and system |
Non-Patent Citations (1)
Title |
---|
武霖: "使用VBA+Ribbon X实现新媒体报告自动生成插件", 《中国有线电视》 * |
Cited By (32)
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 |
CN111310434A (en) * | 2020-02-28 | 2020-06-19 | 北京金堤科技有限公司 | Text generation 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 |
CN111723129A (en) * | 2020-06-24 | 2020-09-29 | 中国工商银行股份有限公司 | Report generation method, report generation device and electronic equipment |
CN111723129B (en) * | 2020-06-24 | 2024-03-29 | 中国工商银行股份有限公司 | Report generation method, report generation device and electronic equipment |
CN112035313A (en) * | 2020-07-27 | 2020-12-04 | 珠海格力电器股份有限公司 | Report generation method and device, template customization method and device, and monitoring system |
CN112035313B (en) * | 2020-07-27 | 2022-03-04 | 珠海格力电器股份有限公司 | Report generation method and device, template customization method and device, and monitoring system |
CN112052171A (en) * | 2020-09-03 | 2020-12-08 | 上海复深蓝软件股份有限公司 | Test message processing method and device, computer equipment and storage medium |
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 |
CN112906356B (en) * | 2021-02-05 | 2024-06-11 | 武汉先峰誉得科技有限公司 | Report writing flow self-defining method and device, client and server |
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 |
CN113448567A (en) * | 2021-06-09 | 2021-09-28 | 心医国际数字医疗系统(大连)有限公司 | 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 |
CN113900561A (en) * | 2021-10-27 | 2022-01-07 | 北京字跳网络技术有限公司 | Form processing method, apparatus, electronic device, medium, and program product |
CN114023415A (en) * | 2021-11-08 | 2022-02-08 | 深圳航天智慧城市系统技术研究院有限公司 | Dynamic document template generation method and system based on online editable customization |
CN114626352A (en) * | 2022-03-11 | 2022-06-14 | 平安科技(深圳)有限公司 | Report automatic generation method and device, computer equipment and storage medium |
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 |
CN115796140A (en) * | 2022-11-03 | 2023-03-14 | 广州天维信息技术股份有限公司 | Report automatic generation method and device and report template configuration method and device |
CN115796140B (en) * | 2022-11-03 | 2023-09-05 | 广州天维信息技术股份有限公司 | Report automatic generation and report template configuration method and device |
Also Published As
Publication number | Publication date |
---|---|
CN109948134B (en) | 2023-12-01 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN109948134A (en) | A kind of report automatic generation method, system and electronic equipment and storage medium | |
CN1961314B (en) | Methods and apparatus for modifying process control data | |
CN102331970B (en) | Safety critical system-oriented automatic testing resource management method and platform | |
CN114035773B (en) | Configuration-based low-code form development method, system and device | |
US20100199167A1 (en) | Document processing apparatus | |
CN106469140A (en) | A kind of report generating system and its method | |
CN104267964B (en) | A kind of template generation device | |
CN106844885B (en) | BIM technology-based drawing frame and drawing label design method | |
US9953331B2 (en) | Extensibility for sales predictor (SPE) | |
EP1830275A1 (en) | Information distribution system | |
US20100107048A1 (en) | Document processor and document processing method | |
CN109725933A (en) | Big data document structure tree method, apparatus, equipment and computer readable storage medium | |
CN106599375A (en) | P&ID-based seal point automatic identification system and method | |
US20070234201A1 (en) | Information Management Device | |
US20100185967A1 (en) | Information Processing Device, and File Managing Method | |
US20090064205A1 (en) | System and method for harvesting service metadata from a metadata repository into an architecture diagram | |
CN111612379A (en) | Audit scheme automatic generation method and device | |
CN107463368A (en) | A kind of static and dynamic man-machine interface automatic generation method | |
KR101942289B1 (en) | System and method for management electronic testing report, recording medium having program thereof | |
AU2008101326A4 (en) | Methods and apparatus for collaborative process modeling | |
CN102043769A (en) | Method and device for editing documents | |
EP3414654A1 (en) | Method of computerized presentation of a document set view for auditing information and managing sets of multiple documents and pages | |
CN108845857A (en) | A kind of icon management method and device based on cloud platform | |
EP1744271A1 (en) | Document processing device | |
US20080147957A1 (en) | Archiver Device, Data Acquisition Device, and Data Acquisition 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 |