CN107491426A - The automatic generation method and system of PPT reports - Google Patents
The automatic generation method and system of PPT reports Download PDFInfo
- Publication number
- CN107491426A CN107491426A CN201610941319.3A CN201610941319A CN107491426A CN 107491426 A CN107491426 A CN 107491426A CN 201610941319 A CN201610941319 A CN 201610941319A CN 107491426 A CN107491426 A CN 107491426A
- Authority
- CN
- China
- Prior art keywords
- field
- ppt
- file resource
- region
- content
- 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.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/186—Templates
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/10—Office automation; Time management
Landscapes
- Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Theoretical Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Strategic Management (AREA)
- Human Resources & Organizations (AREA)
- Entrepreneurship & Innovation (AREA)
- Physics & Mathematics (AREA)
- General Health & Medical Sciences (AREA)
- Economics (AREA)
- Health & Medical Sciences (AREA)
- Data Mining & Analysis (AREA)
- Computational Linguistics (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Artificial Intelligence (AREA)
- General Engineering & Computer Science (AREA)
- Marketing (AREA)
- Operations Research (AREA)
- Quality & Reliability (AREA)
- Tourism & Hospitality (AREA)
- General Business, Economics & Management (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present invention proposes that a kind of automatic generation method of PPT reports and system, method comprise the following steps：Target record is chosen from EXCEL inventories, wherein, target record includes information field and file resource field, and the content of file resource field is the positional information of file resource；The report template corresponding to PPT target reportings is obtained, wherein, report template includes the region corresponding to information field and the region corresponding to file resource field；Extract the content of information field, and the region that information field will be corresponded in the content write-in report template of information field；According to the positional information locating file resource of file resource, and file resource is inserted in report template and corresponded in the region of file resource field, to obtain PPT target reportings.The present invention can fast and automatically, batch making PPT reports, have efficiently, accurate, low cost, strong applicability and the advantages of be easy to deployment.
Description
Technical field
The present invention relates to office automatic technical field, the more particularly to a kind of automatic generation method and system of PPT reports.
Background technology
Office automation, many years are carried with no paper at all, actually really played a role the side such as duplication, acquisition of simply data
The improved efficiency in face.The change that office software makes the form of report is obvious, but in pattern, be still with people in face of computer
Based on operation.Substantial amounts of data conformity, synchronizing information, conversion, check and correction or artificial progress.As the epoch are to the need of mass data
To ask, also more prominent the problem of human error, the data conversion between each system usually introduces manual errors, and Version Control is difficult,
Mutual dyssynergia, the reaction time is slow, wastes a large amount of manpowers, office automation is often advocated in work to be needed more
More manpowers participate in, and input cost is high, and operating efficiency is low.
The so-called automation of conventional Microsoft's OFFICE office automation softwares, is also mainly reflected in the excellent of man-machine interface
Change.Automation for further replacing the operations such as people's lookup, duplication, stickup across software, due to the business of every field
Vary, can not unify to provide.Therefore, it provide only the interface of secondary development.The existing office based on secondary development is certainly
Dynamicization usually focuses on：1) artificial operation is facilitated；2) certain automation is realized on a certain software；3) development system is realized
The integration of more people's information；4) information integrated is supplied to librarian use.
Conventional report preparing system, it is often necessary to special software development, it is often necessary to which business department changes existing
Business model and custom, the use of learning software, or the existing data of conversion, existing data input into system, so
Generation report afterwards.So existing business is had a great influence, the introducing of system also brings along extra work amount in itself.In addition,
Business is always continually changing, and special software needs the change of constantly change adaptation business, and therefore, applicability is not high, most
Also need to put into a large amount of human and material resources resources eventually to continually develop and update corresponding software.
The content of the invention
It is contemplated that at least solves one of above-mentioned technical problem.
Therefore, it is an object of the present invention to propose a kind of automatic generation method of PPT reports, this method can be fast
Speed, automatic, batch making PPT reports, the advantages of there is low cost, efficiency and accuracy rate height, strong applicability and be easy to deployment.
It is another object of the present invention to propose a kind of automatic creation system of PPT reports.
To achieve these goals, the embodiment of first aspect present invention discloses a kind of side of automatically generating of PPT reports
Method, comprise the following steps：Target record is chosen from EXCEL inventories, wherein, the target record includes information field and file
Resources field, the content of the file resource field are the positional information of file resource；Obtain the report corresponding to PPT target reportings
Slide former, wherein, the report template is included corresponding to the region of described information field and corresponding to the file resource field
Region；The content of described information field is extracted, and the content of described information field is write in the report template and corresponded to
The region of described information field；And the file resource is searched according to the positional information of the file resource, and by described in
File resource, which is inserted in the report template, to be corresponded in the region of the file resource field, to obtain the PPT targets report
Accuse.
The automatic generation method of PPT reports according to embodiments of the present invention, chooses target record from EXCEL inventories, and
The report template corresponding to PPT target reportings is obtained, the content of the information field included in target record is write into report template
Respective regions in, and according to file resource positional information locating file resource, file resource is inserted in respective regions, with life
Into PPT target reportings.This method does not need manual intervention, whole-course automation, mass, Neng Gouzhen in PPT report generation processes
Office automation in positive meaning, saves substantial amounts of human cost, improves operating efficiency and accuracy, and based on original
The form and content of business are operated, small to original service impact, and key data based on be easy to change EXCEL, easily
The business constantly changed is adapted to, therefore applicability is very strong.
In addition, the automatic generation method of PPT reports according to the above embodiment of the present invention can also have what is added as follows
Technical characteristic：
In some instances, the file resource comprises at least picture, and methods described also includes：According to corresponding to the text
The quantity of picture in the region of part resources field, adjust size, position and the arrangement of the picture.
In some instances, described information field includes the processing mode field of the target record.
In some instances, the PPT target reportings include condition prompting region, and methods described also includes：According to described
The content for handling mode field adjusts the Fill Color in the condition prompting region.
In some instances, wherein, when the content value of the processing mode field is 0~2, the state is controlled to carry
The Fill Color for showing region is red；When the content value of the processing mode field is 3~5, the condition prompting is controlled
The Fill Color in region is yellow；When the content value of the processing mode field is 6, the condition prompting region is controlled
Fill Color is green.
To achieve these goals, the embodiment of second aspect of the present invention discloses a kind of automatically generating for PPT report and is
System, including：Record chooses module, and the record chooses module and is used to choose target record from EXCEL inventories, wherein, it is described
Target record includes information field and file resource field, and the content of the file resource field is believed for the position of file resource
Breath；Template acquisition module, the template acquisition module are used to obtain the report template corresponding to PPT target reportings, wherein, it is described
Report template includes the region corresponding to described information field and the region corresponding to the file resource field；Field writes mould
Block, the field writing module are used for the content for extracting described information field, and by described in the content write-in of described information field
Correspond to the region of described information field in report template；And file insertion module, the file insertion module are used for basis
The positional information of the file resource searches the file resource, and will be right in the file resource insertion report template
In the region of file resource field described in Ying Yu, to obtain the PPT target reportings.
The automatic creation system of PPT reports according to embodiments of the present invention, chooses target record from EXCEL inventories, and
The report template corresponding to PPT target reportings is obtained, the content of the information field included in target record is write into report template
Respective regions in, and according to file resource positional information locating file resource, file resource is inserted in respective regions, with life
Into PPT target reportings.The system does not need manual intervention, whole-course automation, mass, Neng Gouzhen in PPT report generation processes
Office automation in positive meaning, saves substantial amounts of human cost, improves operating efficiency and accuracy, and based on original
The form and content of business are operated, small to original service impact, and key data based on be easy to change EXCEL, easily
The business constantly changed is adapted to, therefore applicability is very strong.
In addition, the automatic creation system of PPT reports according to the above embodiment of the present invention can also have what is added as follows
Technical characteristic：
In some instances, the file resource comprises at least picture, and the system also includes：Picture adjusting module, institute
State picture adjusting module be used for according to corresponding to the file resource field region in picture quantity, adjust the picture
Size, position and arrangement.
In some instances, described information field includes the processing mode field of the target record.
In some instances, the PPT target reportings include condition prompting region, and the system also includes：Color adjusts
Module, the color adjustment module are used for the filling that the condition prompting region is adjusted according to the content of the processing mode field
Color.
In some instances, the color adjustment module is used for：When the content value of the processing mode field is 0~2
When, the Fill Color for controlling the condition prompting region is red；When the content value of the processing mode field is 3~5,
The Fill Color for controlling the condition prompting region is yellow；When the content value of the processing mode field is 6, institute is controlled
The Fill Color for stating condition prompting region is green.
The additional aspect and advantage of the present invention will be set forth in part in the description, and will partly become from the following description
Obtain substantially, or recognized by the practice of the present invention.
Brief description of the drawings
The above-mentioned and/or additional aspect and advantage of the present invention will become in the description from combination accompanying drawings below to embodiment
Substantially and it is readily appreciated that, wherein：
Fig. 1 is the flow chart of the automatic generation method of PPT reports according to embodiments of the present invention；
Fig. 2 is the PPT report template schematic diagrames according to a specific embodiment of the invention；
Fig. 3 is to need to generate report according to the selection major control data EXCEL (issue list) of one specific embodiment of the present invention
The record of announcement；
Fig. 4 is the schematic diagram for automatically generating PPT target reportings according to a specific embodiment of the invention；And
Fig. 5 is the schematic diagram for automatically generating batch PPT target reportings according to a specific embodiment of the invention；And
Fig. 6 is the structured flowchart of the automatic creation system of PPT reports according to embodiments of the present invention.
Embodiment
Embodiments of the invention are described below in detail, the example of the embodiment is shown in the drawings, wherein from beginning to end
Same or similar label represents same or similar element or the element with same or like function.Below with reference to attached
The embodiment of figure description is exemplary, is only used for explaining the present invention, and is not considered as limiting the invention.
In the description of the invention, it is to be understood that term " " center ", " longitudinal direction ", " transverse direction ", " on ", " under ",
The orientation or position relationship of the instruction such as "front", "rear", "left", "right", " vertical ", " level ", " top ", " bottom ", " interior ", " outer " are
Based on orientation shown in the drawings or position relationship, it is for only for ease of the description present invention and simplifies description, rather than instruction or dark
Show that the device of meaning or element there must be specific orientation, with specific azimuth configuration and operation, thus it is it is not intended that right
The limitation of the present invention.In addition, term " first ", " second " are only used for describing purpose, and it is not intended that instruction or hint are relative
Importance.
In the description of the invention, it is necessary to illustrate, unless otherwise clearly defined and limited, term " installation ", " phase
Even ", " connection " should be interpreted broadly, for example, it may be being fixedly connected or being detachably connected, or be integrally connected；Can
To be mechanical connection or electrical connection；Can be joined directly together, can also be indirectly connected by intermediary, Ke Yishi
The connection of two element internals.For the ordinary skill in the art, with concrete condition above-mentioned term can be understood at this
Concrete meaning in invention.
Automatic generation method and the system that PPT according to embodiments of the present invention is reported are described below in conjunction with accompanying drawing.
Fig. 1 is the flow chart of the automatic generation method of PPT reports according to an embodiment of the invention.As shown in figure 1, should
Method comprises the following steps：
Step S1：Target record is chosen from EXCEL inventories, wherein, target record includes information field and file resource
Field, the content of file resource field are the positional information of file resource.In other words, i.e. EXCEL inventories are that is, database,
Multiple records are wherein stored with, that is, generate the main information of PPT target reportings.
Step S2：The report template corresponding to PPT target reportings is obtained, wherein, report template includes corresponding to information word
The region and the region corresponding to file resource field of section.
Step S3：The content of information field is extracted, and information will be corresponded in the content write-in report template of information field
The region of field.In other words, i.e., there are the region of the content (such as word) of special placement information field, all extractions in report template
To the content of information field can be stored in the region.
Step S4：Report template is inserted according to the positional information locating file resource of file resource, and by file resource
In correspond to file resource field region in, to obtain PPT target reportings.In other words, i.e., there is special placement in report template
The region of file resource (such as picture), all file resources extracted can be added in the region.
Wherein, in one embodiment of the invention, file resource comprises at least picture, in some instances, file money
Source is such as also including other report, forms.Based on this, this method also includes：According to the region corresponding to file resource field
The quantity of the picture of middle addition, adjust size, position and the arrangement of picture.For example, when corresponding to the region of file resource field
When having 1 pictures, the picture occupies the height of whole region, then can be by picture side by side when there are 2 or 3 pictures in the region
Place, when the region there are 4 pictures, picture can be discharged for two rows side by side, no longer illustrated one by one herein.
In one embodiment of the invention, processing mode field of the information field for example including target record.In this hair
In another bright embodiment, PPT target reportings are for example including condition prompting region.Based on this, this method also includes：According to place
Manage the Fill Color in the content adjustment condition prompting region of mode field.That is, the processing shape recorded according to current goal
State adjusts the Fill Color in condition prompting region, and processing state that current goal records is represented by Fill Color.More
Specifically, when the content value for handling mode field is 0~2, the Fill Color of state of a control prompting region is red；Work as place
When the content value for managing mode field is 3~5, the Fill Color of state of a control prompting region is yellow；When processing mode field
Content value when being 6, the Fill Color of state of a control prompting region is green.In other words, the method for the embodiment of the present invention will
The document data of different existing business modules is organically bonded together, and can be rapidly introduced into, dispose；Meanwhile not only collect
Information solicitation is among reporting, always according to the different display contents for adjusting PPT target reportings of information.Such as with vehicle problem
Exemplified by inventory form, when problem state be no scheme (i.e. handle mode field content value be 0~2), PPT condition prompting
Region can show red；When problem state is (the content value for handling mode field is 3~5) in processing, PPT state carries
Show that region can show yellow；When problem state is to complete (the content value for handling mode field is 6), PPT condition prompting
Region can show green.
To sum up, the main flow of the method for the above embodiment of the present invention can be for example summarized as：There is provided according to EXCEL inventories
Data determine the content added to report template, and extract corresponding information and resource accordingly, open report template and fill in and change
Corresponding content；Then, by the file renaming finally given generation in output directory, so as to generate single PPT mesh
Mark report or the multiple PPT target reportings of Mass production.
In order to make it easy to understand, below in conjunction with accompanying drawing, the PPT of the above embodiment of the present invention is reported by specific embodiment
Automatic generation method is described in detail.
In the present embodiment, illustrated by taking the one-page report generation process of vehicle mass problem as an example.In this implementation
In example, the one-page report generation PROCESS OVERVIEW of vehicle mass problem is as follows：
First, major control data EXCEL (i.e. EXCEL inventories, in the present embodiment, i.e. issue list), that is, day are chosen
The vehicle problem inventory often used；Secondly, the blank template (i.e. report template) of one-page report is determined, and is stored in D packings
Catalogue, it is named as：BIR-Q.pptx, such as shown in Fig. 2；Further, adjustment programme adapts to form and the position (behaviour of new template
It is, for example, the ALT+F11 of keyboard as mode)；Further, enrich and safeguard major control data EXCEL (issue list), such as, add
Add one or more picture；Further, choosing major control data EXCEL (issue list) needs the record of generation PPT reports (i.e.
Target record), such as shown in Fig. 3；Further, corresponding program is run, according to the major control data EXCEL (issue list) of selection
Record, handle one by one, corresponding content and calculating or respective action extracted according to every record, fills in and changes report template
Content and Format Object, background, position and Fill Color, finally give PPT target reportings, and be saved in the catalogue of setting,
Then next record, final all PPT reports of Mass production are handled.Wherein, the example of a PPT target reporting of generation is such as
Shown in Fig. 4, the example of all PPT reports of Mass production is as shown in Figure 5.
By verification experimental verification, the method whole process of the embodiment of the present invention is not required to the intervention of very important person, can generate one within average 3~5 seconds
Individual report, and people's work report needs report in 15~20 minutes at least, therefore, dramatically saves on the time, improves
Operating efficiency, while reduce manpower consumption.
That is, the method for the embodiment of the present invention describes the pattern and technology of a set of flexibly office automation of practicality
Implementation, route.For example, by OFFICE secondary development program VBA, the basic data based on EXCEL, integrate in computer
Other resources, automatically generate PPT reports and replace artificial report to make.And there are following features：Once report starts to give birth to
Into haveing suffered journey and not needing manual intervention, whole-course automation, mass, office automation truly；Using flexible：It is empty
Between do not limited by system, use more；Cost is low, it is not necessary to expensive input；It is small to original service impact, it is based substantially on original
The form and content of business, considerable influence of the common new system to existing business is efficiently solved, the introducing of system is in itself
The problem of also bringing along extra work amount；Software key data is easily adapted to constantly change based on the EXCEL for being easy to change
Business；Resource is not a part for system, current now to take, therefore system lightweight；The PPT of generation is also that conventional office is soft
Part is manageable, is easy to further operate.
To sum up, the automatic generation method of PPT according to embodiments of the present invention report, target note is chosen from EXCEL inventories
Record, and the report template corresponding to PPT target reportings is obtained, the content of the information field included in target record is write into report
In the respective regions of template, and according to file resource positional information locating file resource, file resource is inserted in respective regions,
To generate PPT target reportings.This method does not need manual intervention, whole-course automation, mass, energy in PPT report generation processes
Enough office automations truly, substantial amounts of human cost is saved, improves operating efficiency and accuracy, and be based on
The form and content of original business are operated, small to original service impact, and key data based on be easy to change EXCEL,
The business constantly changed is easily adapted to, therefore applicability is very strong.
Further embodiment of the present invention proposes a kind of automatic creation system of PPT reports.
Fig. 6 is the structured flowchart of the automatic creation system of PPT reports according to an embodiment of the invention.As shown in fig. 6,
The automatic creation system 100 of PPT reports includes：Record chooses module 110, template acquisition module 120, field writing module
130 and file insertion module 140.
Record chooses module 110 and is used to choose target record from EXCEL inventories, wherein, target record includes information word
Section and file resource field, the content of file resource field are the positional information of file resource.In other words, i.e. EXCEL inventories are
Equivalent to database, wherein being stored with multiple records, that is, the main information of PPT target reportings is generated.
Template acquisition module 120 is used to obtain the report template corresponding to PPT target reportings, wherein, report template includes
Region corresponding to information field and the region corresponding to file resource field.
Field writing module 130 is used for the content for extracting information field, and the content of information field is write into report template
In correspond to information field region.In other words, i.e., having the content (such as word) of special placement information field in report template
Region, the content of all information fields extracted can be stored in the region.
File insertion module 140 is used for according to the positional information locating file resource of file resource, and by file resource
Insert in report template and correspond in the region of file resource field, to obtain PPT target reportings.In other words, i.e. report template
In have the special region for placing file resource (such as picture), all file resources extracted can be added in the region.
In one embodiment of the invention, file resource comprises at least picture, and in some instances, file resource is for example
Also include other report, forms etc..Based on this, the system 100 also includes：The (not shown) of picture adjusting module 150, picture
Adjusting module 150 is used for the quantity according to picture in the region for corresponding to file resource field, adjust the size of picture, position and
Arrangement.For example, when there are 1 pictures in the region corresponding to file resource field, the picture occupies the height of whole region, when this
, then can be placed side by side by picture when there are 2 or 3 pictures in region, can be two side by side by picture when there are 4 pictures in the region
Row's discharge, is no longer illustrated one by one herein.
In one embodiment of the invention, processing mode field of the information field for example including target record.In this hair
In another bright embodiment, PPT target reportings are for example including condition prompting region.Based on this, system 100 also includes：Color
The (not shown) of adjusting module 160, color adjustment module 160 are used to adjust condition prompting according to the content of processing mode field
The Fill Color in region.More specifically, color adjustment module 160 is used for：When the content value of processing mode field is 0~2
When, the Fill Color of state of a control prompting region is red；When the content value for handling mode field is 3~5, state of a control
The Fill Color of prompting region is yellow；When the content value for handling mode field is 6, the filling of state of a control prompting region
Color is green.In other words, the document data of different existing business modules is organically bonded in one by embodiments of the invention
Rise, can be rapidly introduced into, dispose；Meanwhile information solicitation is not only collected among reporting, always according to the different adjustment PPT of information
The display content of target reporting.Such as by taking vehicle problem inventory form as an example, when problem state is that no scheme (handles state
The content value of field is 0~2), PPT condition prompting region can show red；(shape is handled in problem state is processing
The content value of state field is 3~5), PPT condition prompting region can show yellow；When problem state (handles shape for completion
The content value of state field is 6), PPT condition prompting region can show green.
To sum up, the main flow of the system of the above embodiment of the present invention can be for example summarized as：There is provided according to EXCEL inventories
Data determine the content added to report template, and extract corresponding information and resource accordingly, open report template and fill in and change
Corresponding content；Then, by the file renaming finally given generation in output directory, so as to generate single PPT mesh
Mark report or the multiple PPT target reportings of Mass production.
It should be noted that the specific implementation and this hair of the automatic creation system of the PPT reports of the embodiment of the present invention
The specific implementation of the automatic generation method of the PPT reports of bright embodiment is similar, specifically refers to the description of method part, is
Reduction redundancy, here is omitted.
The automatic creation system of PPT reports according to embodiments of the present invention, chooses target record from EXCEL inventories, and
The report template corresponding to PPT target reportings is obtained, the content of the information field included in target record is write into report template
Respective regions in, and according to file resource positional information locating file resource, file resource is inserted in respective regions, with life
Into PPT target reportings.The system does not need manual intervention, whole-course automation, mass, Neng Gouzhen in PPT report generation processes
Office automation in positive meaning, saves substantial amounts of human cost, improves operating efficiency and accuracy, and based on original
The form and content of business are operated, small to original service impact, and key data based on be easy to change EXCEL, easily
The business constantly changed is adapted to, therefore applicability is very strong.
In the description of this specification, reference term " one embodiment ", " some embodiments ", " example ", " specifically show
The description of example " or " some examples " etc. means specific features, structure, material or the spy for combining the embodiment or example description
Point is contained at least one embodiment or example of the present invention.In this manual, to the schematic representation of above-mentioned term not
Necessarily refer to identical embodiment or example.Moreover, specific features, structure, material or the feature of description can be any
One or more embodiments or example in combine in an appropriate manner.
Although an embodiment of the present invention has been shown and described, it will be understood by those skilled in the art that：Not
In the case of departing from the principle and objective of the present invention a variety of change, modification, replacement and modification can be carried out to these embodiments, this
The scope of invention is by claim and its equivalent limits.
Claims (10)
1. a kind of automatic generation method of PPT reports, it is characterised in that comprise the following steps：
Target record is chosen from EXCEL inventories, wherein, the target record includes information field and file resource field, institute
The content for stating file resource field is the positional information of file resource；
The report template corresponding to PPT target reportings is obtained, wherein, the report template is included corresponding to described information field
Region and the region corresponding to the file resource field；
The content of described information field is extracted, and the content of described information field is write in the report template corresponding to described
The region of information field；And
The file resource is searched according to the positional information of the file resource, and the file resource is inserted into the report
Correspond in template in the region of the file resource field, to obtain the PPT target reportings.
2. the automatic generation method of PPT reports according to claim 1, it is characterised in that the file resource at least wraps
Picture is included, methods described also includes：
According to the quantity of picture in the region corresponding to the file resource field, size, position and the row of the picture are adjusted
Cloth.
3. the automatic generation method of PPT reports according to claim 1, it is characterised in that described information field includes institute
State the processing mode field of target record.
4. the automatic generation method of PPT reports according to claim 3, it is characterised in that the PPT target reportings include
Condition prompting region, methods described also include：
The Fill Color in the condition prompting region is adjusted according to the content of the processing mode field.
5. the automatic generation method of PPT reports according to claim 4, it is characterised in that wherein,
When the content value of the processing mode field is 0~2, the Fill Color for controlling the condition prompting region is red
Color；
When the content value of the processing mode field is 3~5, the Fill Color for controlling the condition prompting region is Huang
Color；
When the content value of the processing mode field is 6, the Fill Color for controlling the condition prompting region is green.
A kind of 6. automatic creation system of PPT reports, it is characterised in that including：
Record chooses module, and the record chooses module and is used to choose target record from EXCEL inventories, wherein, the target
Record includes information field and file resource field, and the content of the file resource field is the positional information of file resource；
Template acquisition module, the template acquisition module are used to obtain the report template corresponding to PPT target reportings, wherein, institute
Stating report template includes the region corresponding to described information field and the region corresponding to the file resource field；
Field writing module, the field writing module are used to extracting the content of described information field, and by described information field
Content write in the report template region for corresponding to described information field；And
File inserts module, and the file insertion module is used to search the file money according to the positional information of the file resource
Source, and the file resource is inserted in the report template and corresponded in the region of the file resource field, to obtain
The PPT target reportings.
7. the automatic creation system of PPT reports according to claim 6, it is characterised in that the file resource at least wraps
Picture is included, the system also includes：
Picture adjusting module, the picture adjusting module are used for according to picture in the region for corresponding to the file resource field
Quantity, adjust size, position and the arrangement of the picture.
8. the automatic creation system of PPT reports according to claim 6, it is characterised in that described information field includes institute
State the processing mode field of target record.
9. the automatic creation system of PPT reports according to claim 8, it is characterised in that the PPT target reportings include
Condition prompting region, the system also include：
Color adjustment module, the color adjustment module are used to be carried according to the content adjustment state of the processing mode field
Show the Fill Color in region.
10. the automatic creation system of PPT reports according to claim 9, it is characterised in that the color adjustment module is used
In：
When the content value of the processing mode field is 0~2, the Fill Color for controlling the condition prompting region is red
Color；
When the content value of the processing mode field is 3~5, the Fill Color for controlling the condition prompting region is Huang
Color；
When the content value of the processing mode field is 6, the Fill Color for controlling the condition prompting region is green.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610941319.3A CN107491426A (en) | 2016-10-25 | 2016-10-25 | The automatic generation method and system of PPT reports |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610941319.3A CN107491426A (en) | 2016-10-25 | 2016-10-25 | The automatic generation method and system of PPT reports |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN107491426A true CN107491426A (en) | 2017-12-19 |
Family
ID=60642499
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201610941319.3A Pending CN107491426A (en) | 2016-10-25 | 2016-10-25 | The automatic generation method and system of PPT reports |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107491426A (en) |
Cited By (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108664463A (en) * | 2018-05-15 | 2018-10-16 | 福建省海洋预报台 | The intelligent generation method and system of a kind of PPT documents for Oceanic disasters |
| CN109241515A (en) * | 2018-09-12 | 2019-01-18 | 山东浪潮通软信息科技有限公司 | A kind of method and device generating report file |
| CN109634575A (en) * | 2018-12-24 | 2019-04-16 | 安徽经邦软件技术有限公司 | Intelligence generates PPT analysis report method |
| CN109918628A (en) * | 2019-01-17 | 2019-06-21 | 平安科技（深圳）有限公司 | Report-generating method, device, equipment and storage medium based on speech recognition |
| CN110377895A (en) * | 2019-07-24 | 2019-10-25 | 上海宝尊电子商务有限公司 | A kind of exchange method for data product shopping vehicle type export PPT file |
| CN112102838A (en) * | 2020-03-04 | 2020-12-18 | 浙江大搜车软件技术有限公司 | Vehicle detection report generation method and system and electronic equipment |
| CN112380827A (en) * | 2020-10-16 | 2021-02-19 | 福建天泉教育科技有限公司 | PPTX document batch processing method and terminal |
| CN112883692A (en) * | 2020-10-23 | 2021-06-01 | 广州超深信息技术有限公司 | Automatic generation method of PPT data report |
| WO2021139242A1 (en) * | 2020-07-16 | 2021-07-15 | 平安科技（深圳）有限公司 | Presentation file generation method, apparatus, and device and storage medium |
| CN113553450A (en) * | 2021-08-03 | 2021-10-26 | 广东新学未科技有限公司 | Automatic PPT presentation generation method and device, computing equipment and storage medium |
| CN117350264A (en) * | 2023-12-04 | 2024-01-05 | 税友软件集团股份有限公司 | PPT file generation method, device, equipment and storage medium |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20020152234A1 (en) * | 2000-12-29 | 2002-10-17 | Julio Estrada | Method and system for importing HTML forms |
| US20070198516A1 (en) * | 2006-01-31 | 2007-08-23 | Ganapathy Palamadai R | Method of and system for organizing unstructured information utilizing parameterized templates and a technology presentation layer |
| CN101751461A (en) * | 2009-12-30 | 2010-06-23 | 中兴通讯股份有限公司 | Document conversion method and device |
| CN102169483A (en) * | 2011-04-25 | 2011-08-31 | 江西省电力公司信息通信中心 | Filmstrip automatic generation method based on electronic spreadsheet |
| CN102457643A (en) * | 2010-10-25 | 2012-05-16 | 柯尼卡美能达商用科技株式会社 | Data processing device and data processing method |
| CN105528337A (en) * | 2016-02-23 | 2016-04-27 | 浪潮通信信息系统有限公司 | Method for exporting PPT report form by data conversion implementation performance management system |
| CN105573973A (en) * | 2015-12-13 | 2016-05-11 | 安徽科力信息产业有限责任公司 | Method for performing data correlation on EXCEL data in PPT file |
-
2016
- 2016-10-25 CN CN201610941319.3A patent/CN107491426A/en active Pending
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20020152234A1 (en) * | 2000-12-29 | 2002-10-17 | Julio Estrada | Method and system for importing HTML forms |
| US20070198516A1 (en) * | 2006-01-31 | 2007-08-23 | Ganapathy Palamadai R | Method of and system for organizing unstructured information utilizing parameterized templates and a technology presentation layer |
| CN101751461A (en) * | 2009-12-30 | 2010-06-23 | 中兴通讯股份有限公司 | Document conversion method and device |
| CN102457643A (en) * | 2010-10-25 | 2012-05-16 | 柯尼卡美能达商用科技株式会社 | Data processing device and data processing method |
| CN102169483A (en) * | 2011-04-25 | 2011-08-31 | 江西省电力公司信息通信中心 | Filmstrip automatic generation method based on electronic spreadsheet |
| CN105573973A (en) * | 2015-12-13 | 2016-05-11 | 安徽科力信息产业有限责任公司 | Method for performing data correlation on EXCEL data in PPT file |
| CN105528337A (en) * | 2016-02-23 | 2016-04-27 | 浪潮通信信息系统有限公司 | Method for exporting PPT report form by data conversion implementation performance management system |
Cited By (16)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108664463A (en) * | 2018-05-15 | 2018-10-16 | 福建省海洋预报台 | The intelligent generation method and system of a kind of PPT documents for Oceanic disasters |
| CN109241515A (en) * | 2018-09-12 | 2019-01-18 | 山东浪潮通软信息科技有限公司 | A kind of method and device generating report file |
| CN109241515B (en) * | 2018-09-12 | 2023-04-07 | 浪潮通用软件有限公司 | Method and device for generating report file |
| CN109634575A (en) * | 2018-12-24 | 2019-04-16 | 安徽经邦软件技术有限公司 | Intelligence generates PPT analysis report method |
| CN109918628A (en) * | 2019-01-17 | 2019-06-21 | 平安科技（深圳）有限公司 | Report-generating method, device, equipment and storage medium based on speech recognition |
| CN110377895A (en) * | 2019-07-24 | 2019-10-25 | 上海宝尊电子商务有限公司 | A kind of exchange method for data product shopping vehicle type export PPT file |
| CN112102838A (en) * | 2020-03-04 | 2020-12-18 | 浙江大搜车软件技术有限公司 | Vehicle detection report generation method and system and electronic equipment |
| WO2021139242A1 (en) * | 2020-07-16 | 2021-07-15 | 平安科技（深圳）有限公司 | Presentation file generation method, apparatus, and device and storage medium |
| CN112380827B (en) * | 2020-10-16 | 2022-10-21 | 福建天泉教育科技有限公司 | PPTX document batch processing method and terminal |
| CN112380827A (en) * | 2020-10-16 | 2021-02-19 | 福建天泉教育科技有限公司 | PPTX document batch processing method and terminal |
| CN112883692A (en) * | 2020-10-23 | 2021-06-01 | 广州超深信息技术有限公司 | Automatic generation method of PPT data report |
| CN112883692B (en) * | 2020-10-23 | 2024-04-09 | 广州超深信息技术有限公司 | Automatic generation method of PPT data report |
| CN113553450A (en) * | 2021-08-03 | 2021-10-26 | 广东新学未科技有限公司 | Automatic PPT presentation generation method and device, computing equipment and storage medium |
| CN113553450B (en) * | 2021-08-03 | 2024-01-30 | 广东新学未科技有限公司 | Automatic generation method and device of PPT presentation, computing equipment and storage medium |
| CN117350264A (en) * | 2023-12-04 | 2024-01-05 | 税友软件集团股份有限公司 | PPT file generation method, device, equipment and storage medium |
| CN117350264B (en) * | 2023-12-04 | 2024-02-23 | 税友软件集团股份有限公司 | PPT file generation method, device, equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107491426A (en) | The automatic generation method and system of PPT reports | |
| CN102609967B (en) | Generating and typesetting method of image-text report | |
| CN108345647A (en) | Domain knowledge map construction system and method based on Web | |
| CN106843904A (en) | Interface Dynamic Distribution method and its system | |
| CN106406783B (en) | Label printing method and label print plug-in unit | |
| CN102663103A (en) | Configurable method for automatically generating database and accessing data | |
| CN103186632A (en) | Method and device for customizing operation and maintenance form | |
| CN104063519B (en) | BPA power grid data analyzing and managing method and system based on EXCEL | |
| CN102982399A (en) | System for preparing and managing service manual and method for preparing and managing service manual | |
| CN106445536A (en) | Automated business design management system | |
| CN101196948B (en) | CAD apparatus, method for editing graphic data | |
| CN102156640A (en) | Method for generating data operation code | |
| CN108255926A (en) | A kind of legal affairs management method and system based on Gantt chart | |
| CN106919547A (en) | Method based on key element table and standard form Mass production form document | |
| CN105279301A (en) | Customizable-output plan design method | |
| CN109542438A (en) | One kind being based on visual chart development approach | |
| CN106250388A (en) | A kind of method updating geography information with map making data that links | |
| CN108170855A (en) | A kind of CityGML and IFC data unified query and data pick-up method | |
| CN109033523A (en) | A kind of Assembly process specification generation System and method for based on three-dimensional CAD model | |
| US20040098673A1 (en) | System and method for managing reference values | |
| Densmore et al. | A platform-based design environment for synthetic biological systems | |
| CN107122182A (en) | A kind of code construction and the method and system of issue | |
| US20040049742A1 (en) | Document creation support system | |
| CN101615188B (en) | Method and device for importing multi-source data into data template | |
| CN104424214B (en) | A kind of self-defined method and apparatus for extracting directory content |
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 |