PPT generation and updating system and method

Abstract

The invention relates to the technical field of information, in particular to a PPT generating and updating system and method. The system comprises a data acquisition module, a PPT framework building module, a content writing and resource integration module and a PPT file output module. According to the method, the existing data assets, dynamic data tables and dynamic data charts in the system are embedded into the PPT by adopting the Web technology, so that the PPT and the internal data assets of the system supplement each other and are mutually mapped, bottom layer data updating and PPT content are allowed to be synchronized in real time, and the timeliness and accuracy of data are ensured.

Description

Technical Field

[0001] The present invention relates to the field of information technology, and in particular to a system and method for generating and updating a PPT. Background Art

[0002] Existing PPT production and presentation tools mainly rely on local software, such as Microsoft PowerPoint, which have some limitations in data updates, presentation material preparation, and style uniformity. For example, traditional PPTs usually require manual changes when updating data, which is not only time-consuming but also prone to errors; and due to the diversity of templates, the production process of traditional PPTs is long, and the style and size are difficult to unify. In addition, before using traditional PPTs for roadshows, researchers need to spend a lot of time preparing presentation materials, which often lack real-time interactivity.

[0003] Therefore, it is urgent to propose a PPT data updating method to complete the automatic updating of data. Summary of the invention

[0004] In view of some problems existing in the prior art, the purpose of the present invention is to provide a PPT generation and update system and method to solve the problem that traditional PPT cannot achieve real-time data update.

[0005] To achieve the above object, on the one hand, the present invention provides a PPT generation and updating system, comprising:

[0006] Data acquisition module, used to acquire real-time data content;

[0007] The data acquisition module includes a data chart acquisition unit, a data table acquisition unit and a semantic analysis graph acquisition unit; the data chart acquisition unit generates chart data according to the data content; the data table acquisition unit generates table data according to the data content; the semantic analysis graph acquisition unit generates semantic data according to the data content;

[0008] PPT framework building module, builds the PPT framework based on the real-time user data obtained;

[0009] The PPT framework building module includes a cover and back cover configuration unit, a layout configuration unit and a layer element configuration unit; the cover and back cover configuration unit is used to build and configure the cover and back cover of the PPT; the layout configuration unit is used to configure the layout of the Slide page in the PPT; the layer element configuration unit is used to configure the layer elements for the Slide page in the PPT;

[0010] Content writing and resource integration module, used to write the content of PPT and integrate it with the data in the database;

[0011] PPT file output module, used to output the data content in PPT;

[0012] The PPT file output module includes a file rendering and loading unit, an online dynamic demonstration unit and an output file asset unit; the file rendering and loading unit is used to render and load PPT; the online dynamic demonstration unit is used to realize online dynamic demonstration of PPT; the output file asset unit is used to download PPT locally.

[0013] Preferably, in the system, the content writing and resource integration module includes a data asset deep embedding unit, an external material integration and import unit and a real-time updating chart data unit; the data asset deep embedding unit is used to embed data content into the PPT in the form of tables, charts, logic diagrams or semantic analysis diagrams; the external material integration and import unit is used to receive external imported materials and save them in the PPT after integration; the real-time updating chart data unit is used to update the corresponding chart data in the PPT in real time according to changes in data content.

[0014] On the other hand, the present invention also proposes a method for generating and updating a PPT, using the system as described above, the method comprising the steps of:

[0015] Data asset preparation: storing system data assets in the database;

[0016] Functional framework construction: fix the framework of the cover, back cover and Slide module; customize the cover and back cover through global dynamic configuration; use data mapping to define multiple different layout structures; convert Json into Dom to implement multiple Slide page layout solutions; constrain line styles through Canvas;

[0017] Content writing and data integration: Add data content and build a complete analysis logic chain.

[0018] Preferably, in the method described above, the added data content includes system data assets, external data resources or text; the external data resources include charts, pictures and text.

[0019] Preferably, in the method described above, the embedding form of the system data assets in the PPT includes: charts, tables, logic diagrams or semantic analysis diagrams.

[0020] Preferably, in the method described above, the Highcharts library is used to render and draw the chart; the table is generated by embedding dynamic indicators; and the semantic analysis graph is obtained by performing deep semantic analysis and information extraction in combination with a large language model, NLP or WebAPI;

[0021] When the data content is updated, the charts, tables, logic diagrams or semantic analysis diagrams embedded in the PPT will also be updated in real time.

[0022] Preferably, in the method described above, the system data assets are added by direct insertion, and the external data resources are added by pasting.

[0023] Preferably, in the method described above, the data charts and tables in the external data resources are pasted into the Slide page by way of screenshots, and the positions of the layout elements are interchanged and the layer elements are moved through the Web drag API.

[0024] Preferably, in the method described above, after generating and updating the PPT in real time according to the data content, the method further includes:

[0025] Output PPT file: According to the user's usage scenario and needs, the PPT can be used for online presentation or converted and downloaded into a local PPT file;

[0026] The PPT file is demonstrated online through a virtual loading mode, and adopts Web technology and Dom for rendering; the drawing board function is realized through Canvas; and the full-screen demonstration is realized through the RequestFullscreen method.

[0027] Preferably, in the method described above, downloading the local PPT file includes the steps of:

[0028] Use PptGen's class API to dynamically build the structure and content of PPTX files on the client side;

[0029] Create a PPT instance;

[0030] Add one or more slides;

[0031] Export the constructed PPT file.

[0032] Compared with the prior art, the present invention has at least the following beneficial effects:

[0033] The present invention uses Web technology to embed the existing data assets, dynamic data tables and dynamic data charts in the system into PPT, so that PPT and the internal data assets of the system complement each other and map each other. This structure allows the underlying data to be updated and synchronized with the PPT content in real time, ensuring the timeliness and accuracy of the data.

[0034] In addition, the present invention provides data mapping to convert Json into Dom, thereby realizing layout solutions of various Slide pages and enriching the diversity of typesetting.

[0035] At the same time, the present invention adopts the class API of PptGen to convert the Json structure 1:1 into a static PPT Slide page, and then splices and combines them, thereby realizing the conversion of the online PPT into a local file, which is convenient for secondary expansion of content.

[0036] In addition, the present invention provides an online demonstration mode, which is convenient for screen projection demonstration in roadshows and other occasions, and supports the brush function and interactive display of data points on the graph by hovering the mouse. This mode also allows researchers to log in to the system directly and directly project the PPT content during the roadshow, avoiding the offline loss of data and improving the efficiency and interactivity of the demonstration.

[0037] Finally, the present invention can ensure the loading speed of the entire PPT by adopting a virtual loading mode, prevent memory overflow, and reduce the performance consumption of the client. BRIEF DESCRIPTION OF THE DRAWINGS

[0038] In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the following briefly introduces the drawings required for use in the embodiments. It should be understood that the following drawings only show certain embodiments of the present invention and therefore should not be regarded as limiting the scope. For ordinary technicians in this field, other related drawings can be obtained based on these drawings without creative work.

[0039] Figure 1 A system module structure diagram in a specific embodiment of the present invention;

[0040] Figure 2 It is an overall flow chart of a specific embodiment of the present invention;

[0041] Figure 3 It is a detailed flow chart of a specific embodiment of the present invention. DETAILED DESCRIPTION

[0042] A system and method for generating and updating a PPT of the present invention will be described in more detail below in conjunction with a schematic diagram, wherein a preferred embodiment of the present invention is shown, and it should be understood that those skilled in the art may modify the present invention described herein while still achieving the advantageous effects of the present invention. Therefore, the following description should be understood as being widely known to those skilled in the art, and not as a limitation of the present invention.

[0043] For the sake of clarity, not all features of the actual embodiments are described. In the following description, well-known functions and structures are not described in detail because they would clutter the invention with unnecessary detail. It should be recognized that in the development of any actual embodiment, a large number of implementation details must be made to achieve the developer's specific goals, such as changing from one embodiment to another according to the limitations of the relevant system or the relevant business. In addition, it should be recognized that such development work may be complex and time-consuming, but it is just a routine task for those skilled in the art.

[0044] The present invention is described in more detail in the following paragraphs by way of example with reference to the accompanying drawings. The advantages and features of the present invention will become more apparent from the following description and claims. It should be noted that the drawings are in very simplified form and in non-precise proportions, and are only used to facilitate and clearly assist in illustrating the purpose of the embodiments of the present invention.

[0045] As mentioned in the background technology, the PPT production and presentation tools in the prior art mainly rely on local software, which has some limitations in data update, presentation material preparation, and style uniformity. Manual changes are usually required when updating data, which is not only time-consuming but also prone to errors. In view of this, this embodiment designs a PPT generation and update system and method.

[0046] On the one hand, this embodiment provides a PPT generation and update system, including:

[0047] The data acquisition module is used to acquire real-time data content. The data acquisition module includes a data chart acquisition unit, a data table acquisition unit and a semantic analysis graph acquisition unit; the data chart acquisition unit generates chart data according to the data content; the data table acquisition unit generates table data according to the data content; the semantic analysis graph acquisition unit generates semantic data according to the data content;

[0048] The PPT framework building module builds the PPT framework according to the real-time user data obtained. The PPT framework building module includes a cover and back cover configuration unit, a layout configuration unit and a layer element configuration unit; the cover and back cover configuration unit is used to build and configure the cover and back cover of the PPT; the layout configuration unit is used to configure the layout of the Slide page in the PPT; the layer element configuration unit is used to configure the layer elements for the Slide page in the PPT;

[0049] The content writing and resource integration module is used to write the content of the PPT file and integrate it with the data in the database. The content writing and resource integration module includes a data asset deep embedding unit, an external material integration and import unit, and a real-time updating chart data unit; the data asset deep embedding unit is used to embed data content into the PPT in the form of tables, charts, logic diagrams, or semantic analysis diagrams; the external material integration and import unit is used to receive external imported materials and save them in the PPT after integration; the real-time updating chart data unit is used to update the corresponding chart data in the PPT in real time according to the changes in the data content;

[0050] The PPT file output module is used to output the data content in the PPT. The PPT file output module includes a file rendering and loading unit, an online dynamic demonstration unit and an output file asset unit; the file rendering and loading unit is used to render and load the PPT; the online dynamic demonstration unit is used to realize the online dynamic demonstration of the PPT; the output file asset unit is used to download the PPT locally.

[0051] On the other hand, the present invention also provides a method for generating and updating a PPT, using the system described above. In this embodiment, the method comprises the steps of:

[0052] Data asset preparation: storing system data assets in the database;

[0053] Functional framework construction: fix the framework of the cover, back cover and Slide module; customize the cover and back cover through global dynamic configuration; use data mapping to define multiple different layout structures; convert Json into Dom to implement multiple Slide page layout solutions; constrain line styles through Canvas;

[0054] Content writing and data integration: Add data content and build a complete analysis logic chain.

[0055] In a specific embodiment, the front cover and back cover are globally configured by dynamic configuration; the front cover adopts a combination of positioning and rich text editor to display text and title information. Slide page uses data mapping to define multiple different layout structures, such as 2 Figure 1 Text or 3 Figure 1 The structure of the text. At the same time, by converting Json into Dom, multiple Slide page layout schemes can be realized to enrich the diversity of typesetting. The Slide page also uses Canvas to constrain several commonly used line styles. Lines can be drawn, marks and explanatory text can be added on the mask layer of the Slide page.

[0056] By building a functional framework, we can ensure the standardization and regularization of effects and styles. At the same time, we do not need to rely on any third-party plug-ins. We can completely realize PPT writing and presentation online and ensure compatibility on various devices.

[0057] In a specific embodiment, the added data content includes system data assets, external data resources or text; the external data resources include charts, pictures and text. The embedding form of the system data assets in the PPT includes: charts, tables, logic diagrams or semantic analysis diagrams.

[0058] Furthermore, the Highcharts library is used to render and draw the chart, and combined with the underlying indicator data, different types of icon libraries are generated through internal big data algorithm logic; the table is generated by embedding dynamic indicators; combined with a large language model, NLP or WebApi, deep semantic analysis and information extraction are performed on massive text, voice and video to obtain the semantic analysis diagram.

[0059] When the data content is updated, the charts, tables, logic diagrams or semantic analysis diagrams embedded in the PPT will also be updated in real time.

[0060] In this embodiment, the system data assets are added by direct insertion, and the external data resources are added by pasting. The data charts and tables in the external data resources are pasted into the Slide page by screenshots, and the layout elements are swapped and the layer elements are moved through the Web drag API.

[0061] In a specific embodiment, after generating and updating the PPT in real time according to the data content, the method further includes:

[0062] Output PPT file: According to the user's usage scenario and needs, the PPT can be used for online presentation or converted and downloaded into a local PPT file;

[0063] The PPT file is presented online in a virtual loading mode, and adopts Web technology, uses Dom for rendering, and adopts a virtual list and request grouping method during rendering.

[0064] The drawing board function is realized through Canvas; the full-screen presentation is realized through the RequestFullscreen method.

[0065] Through the virtual loading mode, the loading speed of the entire PPT can be guaranteed, memory overflow can be prevented, and the performance loss of the client can be reduced. At the same time, PPT uses Web technology and DOM for rendering without relying on third-party components, and its scalability is improved. The virtual list is used to control the number of rendered DOMs to prevent a large number of DOMs from occupying too much memory when rendering and causing the system to crash. In order to ensure the real-time and data accuracy of each chart and table in PPT, a large amount of indicator data needs to be requested each time it is rendered, that is, there are a large number of requests. Request grouping is used to group all requests and control the loading of the next group of requests after each group of requests is completed, which can ensure the rationality of memory usage.

[0066] During online demonstrations, RequestFullscreen is used to display the web page in full screen, and then the scroll wheel event is defined to achieve the effect of scrolling and switching the current page Slide. A canvas is initialized at the bottom layer through canvas, and the event is defined to bind the left mouse button as a brush, and then press and drag to generate a drag track. During full-screen demonstrations, the mouse is pressed and moved to highlight and generate lines, which makes it easier for the speaker to better locate specific areas for emphasis and explanation.

[0067] In a specific embodiment, downloading a local PPT file includes the steps of:

[0068] Use PptGen's class API to dynamically build the structure and content of PPTX files on the client side;

[0069] Use new PptxGenJS() to create a PPT instance, which will serve as a container for adding slides, text, pictures and other elements later;

[0070] Use the addSlide() method to add one or more slides. Combined with the specific content, you can use addText() to add text, addImage() to add images, addTable() to add tables, etc. to draw a Slide page, basically achieving 1:1 restoration;

[0071] Use the writeFile() method to export the constructed PPT file to .pptx format and specify the exported file name.

[0072] In summary, this embodiment proposes a system and method for generating and updating PPT, which embeds the existing data assets, dynamic data tables and dynamic data charts in the system into PPT by using Web technology, so as to realize that PPT and the internal data assets of the system complement each other and map each other. This structure allows the underlying data update to be synchronized with the PPT content in real time, ensuring the timeliness and accuracy of the data. In addition, the present invention provides the use of data mapping to convert Json into Dom, thereby realizing the layout scheme of multiple Slide pages and enriching the diversity of typesetting. At the same time, the present invention converts the Json structure 1:1 into a static PPT Slide page by using the class api of PptGen, and then splices and combines them, so as to realize the conversion of the online PPT into a local .pptx file, which is convenient for secondary expansion of content. Not only that, the present invention provides a demonstration mode, which is convenient for screen projection demonstration in roadshows and other occasions, supports brush functions and interactive display of mouse hovering to data points on the graph. This mode also allows researchers to log in directly to the system to directly project the PPT content during the roadshow, avoid offline loss of information, and improve the efficiency and interactivity of the demonstration. Finally, the present invention can ensure the loading speed of the entire PPT by adopting a virtual loading mode, prevent memory overflow, and reduce the performance consumption of the client.

[0073] The above is only a preferred embodiment of the present invention and does not limit the present invention in any way. Any technician in the relevant technical field, without departing from the scope of the technical solution of the present invention, makes any form of equivalent replacement or modification to the technical solution and technical content disclosed in the present invention, which does not depart from the content of the technical solution of the present invention and still falls within the protection scope of the present invention.

Claims

1. A PPT generation and updating system, characterized in that: include: Data acquisition module, used to acquire real-time data content; The data acquisition module includes a data chart acquisition unit, a data table acquisition unit and a semantic analysis graph acquisition unit; the data chart acquisition unit generates chart data according to the data content; the data table acquisition unit generates table data according to the data content; The semantic analysis graph acquisition unit generates semantic data according to the data content; PPT framework building module, builds the PPT framework based on the real-time user data obtained; The PPT framework building module includes a cover and back cover configuration unit, a layout configuration unit and a layer element configuration unit; the cover and back cover configuration unit is used to build and configure the cover and back cover of the PPT; the layout configuration unit is used to configure the layout of the Slide page in the PPT; the layer element configuration unit is used to configure the layer elements for the Slide page in the PPT; Content writing and resource integration module, used to write the content of PPT and integrate it with the data in the database; PPT file output module, used to output the data content in PPT; The PPT file output module includes a file rendering and loading unit, an online dynamic demonstration unit and an output file asset unit; the file rendering and loading unit is used to render and load PPT; the online dynamic demonstration unit is used to realize online dynamic demonstration of PPT; the output file asset unit is used to download PPT locally.

2. The system according to claim 1, characterized in that The content writing and resource integration module includes a data asset deep embedding unit, an external material integration and import unit, and a real-time updating chart data unit; the data asset deep embedding unit is used to embed data content into the PPT in the form of tables, charts, logic diagrams, or semantic analysis diagrams; the external material integration and import unit is used to receive external imported materials and save them in the PPT after integration; the real-time updating chart data unit is used to update the corresponding chart data in the PPT in real time according to changes in data content.

3. A method for generating and updating a PPT, using the system according to any one of claims 1 to 2, characterized in that: The method comprises the steps of: Data asset preparation: storing system data assets in the database; Functional framework construction: fix the framework of the cover, back cover and Slide module; customize the cover and back cover through global dynamic configuration; use data mapping to define multiple different layout structures; convert Json into Dom to implement multiple Slide page layout solutions; constrain line styles through Canvas; Content writing and data integration: Add data content and build a complete analysis logic chain.

4. The method according to claim 3, characterized in that The added data content includes system data assets, external data resources or text; the external data resources include charts, pictures and text.

5. The method according to claim 4, characterized in that The embedding forms of the system data assets in the PPT include: charts, tables, logic diagrams or semantic analysis diagrams.

6. The method according to claim 5, characterized in that The Highcharts library is used to render and draw the chart; the table is generated by embedding dynamic indicators; deep semantic analysis and information extraction are performed in combination with a large language model, NLP or WebAPI to obtain the semantic analysis graph; When the data content is updated, the charts, tables, logic diagrams or semantic analysis diagrams embedded in the PPT will also be updated in real time.

7. The method according to claim 4, characterized in that The system data assets are added by direct insertion, and the external data resources are added by pasting.

8. The method according to claim 7, characterized in that The data charts and tables in the external data resources are pasted into the Slide page by means of screenshots, and the positions of the layout elements are interchanged and the layer elements are moved through the Web drag API.

9. The method according to claim 3, characterized in that: After generating and updating the PPT in real time according to the data content, the method further includes: Output PPT file: According to the user's usage scenario and needs, the PPT can be used for online presentation or converted and downloaded into a local PPT file; The PPT file is demonstrated online through a virtual loading mode, and adopts Web technology and Dom for rendering; the drawing board function is realized through Canvas; and the full-screen demonstration is realized through the RequestFullscreen method.

10. The method according to claim 9, characterized in that The downloading of the local PPT file includes the following steps: Use PptGen's class API to dynamically build the structure and content of PPTX files on the client side; Create a PPT instance; Add one or more slides; Export the constructed PPT file.

Images