CN113822025A - Office file automatic generation method, device, equipment and storage medium - Google Patents
Office file automatic generation method, device, equipment and storage medium Download PDFInfo
- Publication number
- CN113822025A CN113822025A CN202111408305.2A CN202111408305A CN113822025A CN 113822025 A CN113822025 A CN 113822025A CN 202111408305 A CN202111408305 A CN 202111408305A CN 113822025 A CN113822025 A CN 113822025A
- Authority
- CN
- China
- Prior art keywords
- file
- template
- office
- information
- data source
- 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
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/186—Templates
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
Abstract
The invention discloses an office file automatic generation method, device, equipment and storage medium, and belongs to the technical field of automatic office. The method and the device have the advantages that the label information is obtained, the content reference for generating the file template is provided, the file template is generated according to the label information and the preset template frame, the file template is generated by combining the label information on the basis of the preset template frame, the file template creating process is simplified, the diversity of file template elements is improved, and the applicability of the file template is improved; the demand attribute is determined to obtain the actual demand intention, the office file is generated according to the demand attribute, the preset data source and the file template, the data source is adapted, the diversity of the data source is enriched, the personalized demand is met, and therefore the adaptability of automatic generation of the office file is improved.
Description
Technical Field
The invention relates to the technical field of automatic office work, in particular to an automatic office file generation method, device, equipment and storage medium.
Background
In daily work and life, office files are more and more valued by people, for example, PPT (Power Point, presentation) is one of document editing tools frequently used by users. Reports such as personal work summary, work progress report and the like are displayed through the PPT, and great convenience is brought to work communication. When a user makes PPT, the user usually selects a template and manually replaces the template to complete the report output. Manually making PPT reports takes a long time, and for some users who need to periodically output reports of the same type like monthly reports, the repetitive operation is cumbersome and inefficient. In a conventional means, automatic generation of a PPT report is usually based on a PPT template, a newly-built component is adopted to create the PPT, template elements cannot be completely copied, generation of a target PPT needs to be introduced and developed after each change, time consumption is long, a style is single, personalized requirements cannot be met, a data source is single, and multiple data sources cannot be adapted.
Disclosure of Invention
The invention mainly aims to provide a method, a device, equipment and a storage medium for automatically generating an office file, and aims to solve the technical problem of improving the adaptability of the automatically generated office file.
In order to achieve the above object, the present invention provides an office file automatic generation method, which comprises the following steps:
acquiring label information;
generating a file template according to a preset template frame and the label information;
and determining a demand attribute, and generating an office file according to the demand attribute, a preset data source and a file template.
Optionally, the step of generating a file template according to a preset template frame and the tag information includes:
determining a keyword in the tag information;
determining a keyword type corresponding to the keyword;
and generating a file template according to the keyword type and the preset template frame.
Optionally, the step of generating a document template according to the keyword type and the preset template frame includes:
determining attribute information corresponding to the keyword type;
and adding the attribute information and the keyword types into the preset template frame to generate a file template.
Optionally, the step of generating an office file according to the data source and the file template includes:
determining attribute information in the file template, and replacing the attribute information with the requirement attribute;
determining all the subdata sources in the preset data source, determining a demand attribute in the file template, determining the subdata sources matched with the demand attribute in all the subdata sources, and taking the subdata sources matched with the demand attribute as a target data source;
and generating an office file according to the target data source and the file template.
Optionally, the step of generating an office file according to the target data source and the file template includes:
converting the target data source based on the keyword type in the file template to generate target data;
and importing the target data into a file template to generate an office file.
Optionally, the step of importing the target data into a document template to generate an office document includes:
determining a node position corresponding to the label information in the file template;
and importing the target data into the node position to generate an office file.
Optionally, the step of obtaining tag information includes:
acquiring input information, and determining position information and content information corresponding to the input information;
and taking the position information and the content information as label information.
In addition, to achieve the above object, the present invention provides an office file automatic generation apparatus, including:
the information acquisition module is used for acquiring the label information;
the template generating module is used for generating a file template according to a preset template frame and the label information;
and the file generation module is used for determining the demand attribute and generating the office file according to the demand attribute, the preset data source and the file template.
In addition, in order to achieve the above object, the present invention further provides an office file automatic generation apparatus, including a memory, a processor, and an office file automatic generation program stored in the memory and operable on the processor, wherein: the automatic office file generation program realizes the steps of the automatic office file generation method described above when executed by the processor.
In addition, to achieve the above object, the present invention further provides a storage medium having stored thereon an office file automatic generation program, which when executed by a processor, implements the steps of the office file automatic generation method as described above.
The invention provides an automatic office file generation method, device, equipment and storage medium, which are used for acquiring label information, providing content reference for generating a file template, generating the file template according to the label information and a preset template frame, and generating the file template by combining the label information on the basis of the preset template frame, thereby simplifying the creation process of the file template, improving the diversity of file template elements and improving the applicability of the file template; the demand attribute is determined to obtain the actual demand intention, the office file is generated according to the demand attribute, the preset data source and the file template, the data source is adapted, the diversity of the data source is enriched, the personalized demand is met, and therefore the adaptability of automatic generation of the office file is improved.
Drawings
Fig. 1 is a schematic structural diagram of an office file automatic generation device of a hardware operating environment according to an embodiment of the present invention;
FIG. 2 is a schematic flow chart illustrating a first embodiment of an office document automatic generation method according to the present invention;
FIG. 3 is a schematic flow chart of an embodiment of the present invention;
fig. 4 is a schematic structural diagram of an office file automatic generation device according to the present invention.
The implementation, functional features and advantages of the objects of the present invention will be further explained with reference to the accompanying drawings.
Detailed Description
It should be understood that the specific embodiments described herein are merely illustrative of the invention and are not intended to limit the invention.
Referring to fig. 1, fig. 1 is a schematic structural diagram of an office file automatic generation device in a hardware operating environment according to an embodiment of the present invention.
As shown in fig. 1, the office file automatic generation device may include: a processor 1001, such as a Central Processing Unit (CPU), a communication bus 1002, a user interface 1003, a network interface 1004, and a memory 1005. Wherein a communication bus 1002 is used to enable connective communication between these components. The user interface 1003 may include a Display screen (Display), an input unit such as a Keyboard (Keyboard), and the optional user interface 1003 may also include a standard wired interface, a wireless interface. The network interface 1004 may optionally include a standard wired interface, a WIreless interface (e.g., a WIreless-FIdelity (WI-FI) interface). The Memory 1005 may be a Random Access Memory (RAM) Memory, or may be a Non-Volatile Memory (NVM), such as a disk Memory. The memory 1005 may alternatively be a storage device separate from the processor 1001 described previously.
Those skilled in the art will appreciate that the configuration shown in fig. 1 does not constitute a limitation of the office document automatic generation apparatus, and may include more or less components than those shown, or combine some components, or a different arrangement of components.
As shown in fig. 1, the memory 1005, which is a storage medium, may include therein an operating system, a data storage module, a network communication module, a user interface module, and an office file auto generation program.
In the office file automatic generation apparatus shown in fig. 1, the network interface 1004 is mainly used for data communication with other apparatuses; the user interface 1003 is mainly used for data interaction with a user; the processor 1001 and the memory 1005 of the office file automatic generation device of the present invention may be provided in the office file automatic generation device, and the office file automatic generation device calls the office file automatic generation program stored in the memory 1005 through the processor 1001 and executes the office file automatic generation method provided by the embodiment of the present invention.
An embodiment of the present invention provides an office file automatic generation method, and referring to fig. 2, fig. 2 is a schematic flow diagram of a first embodiment of an office file automatic generation method according to the present invention.
In this embodiment, the method for automatically generating an office file includes the steps of:
step S100, label information is obtained;
in this embodiment, it should be noted that the office file is automatically generated by automatically importing the user data into the file template. In this embodiment, a PPT file (PowerPoint, presentation) is used as an example for description, and it is understood that an office file is not limited to a PPT file, and may also be other files that can implement the method, and is not limited herein. Wherein, the file template is set according to actual requirements. The label information is used for feeding back the actual requirements of the user. The label information refers to information which is designed by a user according to actual requirements and is used for being filled in a file template so as to realize the actual requirements. The tag information may include location information and content information of the tag; the content information may include specific content such as keyword information and attribute information in the tag. By setting the label information, the positions for filling and replacing the data can be reserved in the file template.
Step S200, generating a file template according to a preset template frame and the label information;
in this embodiment, it should be noted that the preset template frame refers to a preset frame for providing a file template base. The preset template frame is provided with a file content frame in various forms, such as a text frame, a picture frame, a statistical frame, a cyclic page frame and other content frames in different forms. The template frame is designed in advance based on the content frames of different forms, and a preset template frame is generated. The file template is a file template which is generated by acquiring user requirements on the basis of a preset template frame and filling the frame according to the user requirements and meets the requirements of the user. The user can set commonly used templates uniformly based on own requirements. For example, when a user needs to make a PPT with a fixed content format, such as a monthly newspaper, after the PPT template is made for the first time based on the preset template frame and the tag information, the data is replaced by modifying the tag information directly in the subsequent monthly newspaper lessons, and the finally displayed monthly newspaper PPT is generated quickly. Specifically, after the preset template frame is acquired, the preset template frame is modified based on the acquired tag information, and a file template is generated. The preset template frame can be used for filling, deleting, adding and the like of the file content frame.
And step S300, determining a demand attribute, and generating an office file according to the demand attribute, a preset data source and a file template.
In this embodiment, it should be noted that the requirement attribute refers to attribute information that needs to meet the requirement of the user. And after the file template is generated, the user creates an office file based on the file template. When the preset data source is called by using the file template, the attribute information in the file template needs to be replaced, and the attribute information is changed into the attribute information meeting the actual requirement of the user, namely the requirement attribute. The preset data source refers to a data source for filling in the file template for showing the essential data. The data sources may be diverse, such as web page data, databases, Excel tables, data crawls, and the like. The office file is a file which is finally generated and fed back to the user. The acquisition of the data source and the generation of the file template are independent respectively, and the data source is connected with the file template by introducing a json format file, connecting a database, an api interface and the like. In this embodiment, the process of creating the office file is based on the openoffice protocol. Because the data source does not directly conform to the addition specification of the file template, when the data source is combined with the file template, certain processing can be carried out on the data source so as to realize the adaptation of the data source and the file template. Specifically, after the requirement attribute is determined, the attribute information of the file template is replaced, and based on the replaced file template, a preset data source is connected for template filling, so that the office file is generated.
In the embodiment, by acquiring the tag information, providing a content reference for generating the file template, generating the file template according to the tag information and the preset template frame, and generating the file template by combining the tag information on the basis of the preset template frame, the diversity of file template elements is improved, the applicability of the file template is improved, the demand attribute is determined, so as to acquire the actual demand intention, the office file is generated according to the demand attribute, the preset data source and the file template, the adaptation to the diversity of the data source is realized, the personalized demand is met, and the adaptability of the automatic generation of the office file is improved.
Further, based on the first embodiment of the office file automatic generation method of the present invention, a second embodiment of the office file automatic generation method of the present invention is proposed, where in the step S200, the step of generating the file template according to the preset template frame and the tag information includes:
step a, determining keywords in the label information;
b, determining a keyword type corresponding to the keyword;
and c, generating a file template according to the keyword type and the preset template frame.
In this embodiment, it should be noted that the generation of the file template is based on a preset template frame, and the preset template frame is filled with and replaced with the tag information. Wherein the tag information includes a keyword. The keyword is an identifier used for marking the content to be filled and replaced at the position corresponding to the label information. The keyword type refers to a representation form of the content that needs to be filled and replaced at the position corresponding to the tag information, for example, a form of text, picture, statistics, circulation, and the like. For example, { text, attribute }, the type of the keyword corresponding to the tag information in the preset template frame is determined, and the specific expression form of the tag information in the preset template frame may be determined. For example, when the title text is displayed on the first page of the design document template, the title text is text. Therefore, label information is inserted into the first page of the preset template frame, and the keyword type in the label information is set as a text type. And when the file template is generated, acquiring the keyword type in the label information and determining the keyword type as a text type. Namely, after the file template is generated, the position corresponding to the label information is text information. When the user needs to use the file template, the data content can be displayed in a text form at the corresponding position of the label information only by importing the corresponding data content. Specifically, after the tag information is obtained, a keyword in the tag information is determined, a keyword type corresponding to the keyword is obtained, and the preset template frame is modified based on the keyword type to generate the file template.
And generating a file template based on the keyword types in the tag information and a preset template frame, and determining the display form of the content in the file template in a user-defined mode, so that the real requirements of users are met, and the diversification of the text template is realized. And the file template can be modified by directly utilizing the design of the keywords without redeveloping the file template, so that the file manufacturing time is reduced, and the office file manufacturing efficiency is improved.
Further, the step of generating a document template according to the keyword type and the preset template frame includes:
d, determining attribute information corresponding to the keyword type;
and e, adding the attribute information and the keyword types into the preset template frame to generate a file template.
In this embodiment, it should be noted that the tag information includes a keyword, and the keyword corresponds to a related keyword type and attribute information corresponding to the keyword type. The attribute information refers to the attribute of the data source imported according to the keyword type. For associating data sources. For example, the keyword is { text, name }, which means that the type of the keyword is text and the attribute information is name. The attribute information corresponding to the keyword type in the preset template frame is determined, and the data source of the tag information in the preset template frame can be determined. The attribute is predetermined in the data source, and when the file template is designed, attribute information is added in the key words according to the existing attribute in the data source so as to associate the attribute in the data source, thereby determining the specific position of the data source import of the attribute and the specific representation form after the data source import. When the keyword type is a text, the attribute information represents a value corresponding to the attribute in the data source; when the keyword type is a picture, the attribute information represents a picture address corresponding to the attribute in the data source; when the keyword type is statistics, the attribute information represents statistics of the attribute in the data source; when the keyword type is a loop, the keyword type represents that the keyword is a loop page, the attribute information indicates that all attributes are obtained through the loop, and the keyword type is based on the loop and can be copied and generated into a plurality of pages with different values through attribute combination corresponding to other keyword types such as texts. Specifically, after the keyword is determined, attribute information corresponding to the keyword type is obtained based on the keyword type, and the preset template frame is modified based on the keyword type and the attribute information to generate the file template.
The attribute information is designed for the text template, the attribute of the data filling source is determined, the data source is accurately associated, the stability and the accuracy of the data source when the file template is used are ensured, the data source is associated through the attribute information, the data source containing capacity is improved, the range of the data source is expanded, and the adaptability of the file template is further improved.
Further, the step of generating the office file according to the data source and the file template comprises:
step f, determining attribute information in the file template, and replacing the attribute information with the requirement attribute;
step g, determining all the sub data sources in the preset data source, determining a demand attribute in the file template, determining the sub data sources matched with the demand attribute in all the sub data sources, and taking the sub data sources matched with the demand attribute as target data sources;
and h, generating an office file according to the target data source and the file template.
In this embodiment, it should be noted that the data source refers to data used for filling in the file template. And the user uses the generated file template to perform association of the data source, and fills and replaces the data to finally generate the office file. In this embodiment, a plug-in may be set in the data source, and when the office file needs to be edited, the file template is directly called out through the plug-in the data source, and the office file is generated by one key. In one embodiment, the file template may be opened first, and the data source is directly imported, so as to generate the office file. The processing of the data source and the generation of the file template exist independently and are associated with each other, and the sequence and the association form between the data source and the file template are not limited. In practical application, the data source is likely to be a huge data set, all data is not necessarily required for generating the office file by the user, and the required data needs to be associated with the attribute information in the keywords in the file template, so that a target data source required for currently creating the office file in the data source needs to be determined first. For example, the keyword in the file template is { picture, check photo }, the attribute information can be determined to be "check photo", the target data source with the attribute of "check photo" is screened out from the data source, and the picture address corresponding to the attribute of "check photo" is fed back, so that the picture corresponding to the picture address is added to the corresponding label position in the file template. Specifically, after the requirement attribute is determined, the attribute information corresponding to the keyword in the current file template is searched, the attribute information is replaced by the requirement attribute, and the file template based on the requirement attribute is generated; all the subdata sources in the preset database are obtained, subdata sources, namely target data sources, which are associated with the demand attributes in the preset data sources are screened out through the demand attributes corresponding to the keywords in the file template, and the target data sources are combined with the file template to finally generate the office file.
The method comprises the steps of determining a target data source based on a demand attribute, rapidly screening a preset data source, calling the target data source corresponding to an actual demand, ensuring the accuracy of data in the created office file, directly associating the data source with a file template through attribute information, reducing development cost and improving the efficiency of generating the office file.
Further, the step of generating an office file according to the target data source and the file template includes:
i, converting the target data source based on the keyword type in the file template to generate target data;
and j, importing the target data into a file template to generate an office file.
In this embodiment, it should be noted that the target data source is a data source that needs to be added, but the format of the target data source is a format stored in the data source and does not necessarily conform to the expression form defined by the keyword type in the file template, so after the target data source is obtained, the target data source needs to be further converted to obtain target data that conforms to the specified format of the file template. For example, if the keyword is { statistics, procedure }, the keyword type is "statistics" and the attribute information is "procedure", that is, the tag position corresponding to the keyword should show the statistical result of the target data source with the attribute of "procedure". When the document template is in the expression form of the statistical chart, if 100 pieces of process data exist in the target data source, the process data are specifically divided into a first process, a second process and a third process. Because the target data source can not directly switch the expression forms aiming at different procedures, the target data source is subjected to statistical processing to obtain target data: obtaining a statistical result through statistical calculation, wherein 20 working procedures exist and account for 20% of the total; 50 in the second step, accounting for 50% of the total; and 30 in the third step, which accounts for 30% of the total, wherein the statistical result is the target data. Specifically, determining a keyword type in a file template, analyzing a target data source based on the keyword type to obtain target data, importing the target data into a corresponding position of the file template, and generating an office file.
The target data is obtained by analyzing and processing the target data source, the conversion of the target data source is completed, the adaptability of the data source is enhanced, and the adaptability of the file template is improved.
Further, the step of importing the target data into a document template to generate an office document includes:
k, determining the node position corresponding to the label information in the file template;
and step l, importing the target data into the node position to generate an office file.
In this embodiment, it should be noted that, when an office file is created using a file template, actual data needs to be filled in the file template. The node position refers to a position of the label information which needs to be filled and replaced by the data source after the file template is analyzed. For example, after the PPT file template is analyzed, an xml file is obtained, an xml element that needs to be modified in the xml file is searched, and the position of the xml element is the node position. Specifically, a file template and target data are obtained, the file template is analyzed, a node position corresponding to label information needing data filling and replacing in the file template is searched, the target data are imported into the node position, and the office file is manufactured. Referring to fig. 3, fig. 3 illustrates an example of generating a PPT template, which is generated according to a keyword, and obtains data from a data source; analyzing the PPT template to obtain an xml file, acquiring keywords in the xml file, and finding out corresponding xml elements needing to be modified, namely node positions; generating target data in a specified format, such as a json format, by combining the keywords and the data source; combining target data, node positions and an operation xml file; and replacing the new element according to the openoffice protocol, and regenerating the PPT, namely the final PPT file.
The position of target data import is determined through the node position, the accuracy of data in office files is ensured, and the file generation efficiency is improved. The user only needs to design the file template once based on the preset template framework, and then can simply reduce the modification of the label information aiming at the file template, so that the office file meeting the actual requirement can be generated by one key, the operation is convenient and fast, and the efficiency is high.
Further, the step of obtaining the tag information includes:
step m, acquiring input information, and determining position information and content information corresponding to the input information;
and n, taking the position information and the content information as label information.
In this embodiment, it should be noted that, when creating a file template, a user only needs to enter tag content information into a preset template frame according to actual needs, so as to quickly create the file template. The label information is mark information used for reserving the actual data adding position of the user when the file template is created, the file template meets the requirements of the user, and can be designed according to the real intention of the user, so that the input information of the user needs to be acquired, and the input information comprises the specific input position and the input content information. The method is characterized in that a certain rule is preset for limiting the content form of the tag information, namely limiting the input rule of the input information, so as to realize the standardization of the tag information. Specifically, input information of a user is acquired, position information and content information corresponding to the input information are analyzed, and the position information and the content information are used as tag information. And combining the label information with a preset template frame to generate a file template.
Based on the preset template framework, the user can determine the label information through user-defined input information to generate a file template, and based on the file template, the user only needs to change the content of the label information to generate the final office file by one key. The method can meet the requirements of users without secondary development of the file template, greatly reduces time cost and development cost, and improves the efficiency of making office files.
Further, referring to fig. 4, the present invention provides an automatic office file generation device, comprising:
an information acquisition module 2001 for acquiring tag information;
a template generating module 2002, configured to generate a file template according to a preset template frame and the tag information;
and the file generation module 2003 is used for determining the requirement attribute and generating the office file according to the requirement attribute, the preset data source and the file template.
Optionally, the template generating module 2002 is further configured to:
determining a keyword in the tag information;
determining a keyword type corresponding to the keyword;
and generating a file template according to the keyword type and the preset template frame.
Optionally, the template generating module 2002 is further configured to:
determining attribute information corresponding to the keyword type;
and adding the attribute information and the keyword types into the preset template frame to generate a file template.
Optionally, the file generation module 2003 is further configured to:
determining attribute information in the file template, and replacing the attribute information with the requirement attribute;
determining all the subdata sources in the preset data source, determining a demand attribute in the file template, determining the subdata sources matched with the demand attribute in all the subdata sources, and taking the subdata sources matched with the demand attribute as a target data source;
and generating an office file according to the target data source and the file template.
Optionally, the file generation module 2003 is further configured to:
converting the target data source based on the keyword type in the file template to generate target data;
and importing the target data into a file template to generate an office file.
Optionally, the file generation module 2003 is further configured to:
determining a node position corresponding to the label information in the file template;
and importing the target data into the node position to generate an office file.
Optionally, the information obtaining module 2001 is further configured to:
acquiring input information, and determining position information and content information corresponding to the input information;
and taking the position information and the content information as label information.
The specific implementation of the office file automatic generation device of the present invention is basically the same as that of each embodiment of the office file automatic generation method described above, and will not be described herein again.
Furthermore, the present invention also provides an office file automatic generation device, which is characterized in that the office file automatic generation device includes a memory, a processor, and an office file automatic generation program stored in the memory and operable on the processor, wherein: the automatic office file generation program is executed by the processor to implement the automatic office file generation method according to the embodiments of the present invention.
In addition, the invention also provides a storage medium, and the office file automatic generation program is stored on the storage medium. The storage medium may be the Memory 20 in the terminal in fig. 1, or may be at least one of a ROM (Read-Only Memory)/RAM (Random Access Memory), a magnetic disk, and an optical disk, and the storage medium includes several instructions to enable an office file automatic generation device with a processor to execute the office file automatic generation method according to the embodiments of the present invention.
It should be noted that, in this document, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or system that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or system. Without further limitation, an element defined by the phrase "comprising an … …" does not exclude the presence of other like elements in a process, method, article, or system that comprises the element.
The above-mentioned serial numbers of the embodiments of the present invention are merely for description and do not represent the merits of the embodiments.
Through the above description of the embodiments, those skilled in the art will clearly understand that the method of the above embodiments can be implemented by software plus a necessary general hardware platform, and certainly can also be implemented by hardware, but in many cases, the former is a better implementation manner. Based on such understanding, the technical solution of the present invention may be embodied in the form of a software product, which is stored in a storage medium (e.g., ROM/RAM, magnetic disk, optical disk) as described above and includes instructions for enabling a terminal device (e.g., a mobile phone, a computer, a server, or a network device) to execute the method according to the embodiments of the present invention.
The above description is only a preferred embodiment of the present invention, and not intended to limit the scope of the present invention, and all modifications of equivalent structures and equivalent processes, which are made by using the contents of the present specification and the accompanying drawings, or directly or indirectly applied to other related technical fields, are included in the scope of the present invention.
Claims (10)
1. An office file automatic generation method is characterized by comprising the following steps:
acquiring label information;
generating a file template according to a preset template frame and the label information;
and determining a demand attribute, and generating an office file according to the demand attribute, a preset data source and a file template.
2. The automatic office document generation method as claimed in claim 1, wherein the step of generating a document template based on a preset template frame and the tag information comprises:
determining a keyword in the tag information;
determining a keyword type corresponding to the keyword;
and generating a file template according to the keyword type and the preset template frame.
3. The method for automatically generating an office document according to claim 2, wherein the step of generating a document template according to the keyword type and the preset template frame comprises:
determining attribute information corresponding to the keyword type;
and adding the attribute information and the keyword types into the preset template frame to generate a file template.
4. The method for automatically generating an office document according to claim 1, wherein the step of generating an office document according to the requirement attribute, the preset data source and the document template comprises:
determining attribute information in the file template, and replacing the attribute information with the requirement attribute;
determining all the subdata sources in the preset data source, determining a demand attribute in the file template, determining the subdata sources matched with the demand attribute in all the subdata sources, and taking the subdata sources matched with the demand attribute as a target data source;
and generating an office file according to the target data source and the file template.
5. The method of automatically generating an office document according to claim 4, wherein the step of generating an office document based on the target data source and document template comprises:
converting the target data source based on the keyword type in the file template to generate target data;
and importing the target data into a file template to generate an office file.
6. The method for automatically generating an office document according to claim 5, wherein the step of importing the target data into the document template to generate the office document comprises:
determining a node position corresponding to the label information in the file template;
and importing the target data into the node position to generate an office file.
7. The method for automatically generating an office file according to claim 1, wherein the step of obtaining tag information comprises:
acquiring input information, and determining position information and content information corresponding to the input information;
and taking the position information and the content information as label information.
8. An office document automatic generation device, characterized by comprising:
the information acquisition module is used for acquiring the label information;
the template generating module is used for generating a file template according to a preset template frame and the label information;
and the file generation module is used for determining the demand attribute and generating the office file according to the demand attribute, the preset data source and the file template.
9. An office document automatic generation device characterized by comprising: a memory, a processor and an office file automatic generation program stored on the memory and executable on the processor, the office file automatic generation program being configured to implement the steps of the office file automatic generation method according to any one of claims 1 to 7.
10. A storage medium, characterized in that the storage medium has stored thereon an office file automatic generation program, which when executed by a processor, implements the steps of the office file automatic generation method according to any one of claims 1 to 7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111408305.2A CN113822025A (en) | 2021-11-25 | 2021-11-25 | Office file automatic generation method, device, equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111408305.2A CN113822025A (en) | 2021-11-25 | 2021-11-25 | Office file automatic generation method, device, equipment and storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN113822025A true CN113822025A (en) | 2021-12-21 |
Family
ID=78918191
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202111408305.2A Pending CN113822025A (en) | 2021-11-25 | 2021-11-25 | Office file automatic generation method, device, equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113822025A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115525918A (en) * | 2022-11-04 | 2022-12-27 | 山东双仁信息技术有限公司 | Encryption method and system for paperless office file |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2013097799A1 (en) * | 2011-12-31 | 2013-07-04 | 北大方正集团有限公司 | Method and device for processing template file |
| WO2019095671A1 (en) * | 2017-11-15 | 2019-05-23 | 平安科技（深圳）有限公司 | Method for making red heading template of red heading file, application server, and computer storage medium |
| CN110096689A (en) * | 2019-05-17 | 2019-08-06 | 北京市律典通科技有限公司 | Template type legal documents information fill method and device |
| CN110705237A (en) * | 2019-09-18 | 2020-01-17 | 深圳证券交易所 | Automatic document generation method, data processing device, and storage medium |
| WO2021045547A1 (en) * | 2019-09-04 | 2021-03-11 | (주)워트인텔리전스 | Method for automatically creating user-customized document, and device and server for same |
| WO2021164255A1 (en) * | 2020-07-28 | 2021-08-26 | 平安科技（深圳）有限公司 | Presentation generation method and apparatus, computer device and storage medium |
| CN113627145A (en) * | 2021-08-02 | 2021-11-09 | 上海浦东发展银行股份有限公司 | Method, device, equipment and medium for generating file of parameterized configuration |
-
2021
- 2021-11-25 CN CN202111408305.2A patent/CN113822025A/en active Pending
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2013097799A1 (en) * | 2011-12-31 | 2013-07-04 | 北大方正集团有限公司 | Method and device for processing template file |
| WO2019095671A1 (en) * | 2017-11-15 | 2019-05-23 | 平安科技（深圳）有限公司 | Method for making red heading template of red heading file, application server, and computer storage medium |
| CN110096689A (en) * | 2019-05-17 | 2019-08-06 | 北京市律典通科技有限公司 | Template type legal documents information fill method and device |
| WO2021045547A1 (en) * | 2019-09-04 | 2021-03-11 | (주)워트인텔리전스 | Method for automatically creating user-customized document, and device and server for same |
| CN110705237A (en) * | 2019-09-18 | 2020-01-17 | 深圳证券交易所 | Automatic document generation method, data processing device, and storage medium |
| WO2021164255A1 (en) * | 2020-07-28 | 2021-08-26 | 平安科技（深圳）有限公司 | Presentation generation method and apparatus, computer device and storage medium |
| CN113627145A (en) * | 2021-08-02 | 2021-11-09 | 上海浦东发展银行股份有限公司 | Method, device, equipment and medium for generating file of parameterized configuration |
Non-Patent Citations (1)
| Title |
|---|
| 郑婵娟等: "《普通高等学校"十三五"规划教材 办公软件高级应用与实践 Office2016》", 31 August 2018, 北京：中国铁道出版社 * |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115525918A (en) * | 2022-11-04 | 2022-12-27 | 山东双仁信息技术有限公司 | Encryption method and system for paperless office file |
| CN115525918B (en) * | 2022-11-04 | 2023-04-28 | 山东双仁信息技术有限公司 | Encryption method and system for paperless office file |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US20020129059A1 (en) | XML auto map generator | |
| US8972854B2 (en) | Graphical creation of a document conversion template | |
| CN107092625B (en) | Data configuration method, data processing method and device | |
| US20070136363A1 (en) | Systems and methods for report design and generation | |
| US20040088653A1 (en) | System and method for copying formatting information between Web pages | |
| CN110543303B (en) | Visual service platform | |
| CN110705237B (en) | Automatic document generation method, data processing device and storage medium | |
| CN111460776B (en) | Method and device for online designing contract form and generating contract text | |
| CN107506383B (en) | Audit data processing method and computer equipment | |
| CN110837501A (en) | User-defined form system, form manufacturing method and storage medium | |
| CN113032633B (en) | Method for customizing table by using reference data item | |
| CN108762743A (en) | Data table operation code generation method and device | |
| CN112016290A (en) | Automatic document typesetting method, device, equipment and storage medium | |
| CN112115695A (en) | Template dynamic generation method, system, computer equipment and storage medium | |
| CN113822025A (en) | Office file automatic generation method, device, equipment and storage medium | |
| CN111464425B (en) | Mail generation method, device, equipment and storage medium | |
| CN113033171A (en) | Template creating method, file generating method, device and computer equipment | |
| CN108228688B (en) | Template generation method, system and server based on XBRL | |
| CN110580330B (en) | File processing method for filling electronic form | |
| CN112328664A (en) | Report generation method and system | |
| CN109344372B (en) | Big data-based document generation method and system | |
| CA2491435A1 (en) | System and method for preparing and using automated forms | |
| US20030050790A1 (en) | Business card processing system and method | |
| CN114581033B (en) | Method, device and equipment for rapidly developing government affair approval business | |
| CN115879435B (en) | Cloud contract generation method in smart engineering scene |
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 | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20211221 |