Web to PowerPoint Conversion
If you've ever been asked to periodically produce a report in Microsoft PowerPoint, you know that this
can be very time consuming and error-prone. The solution is to automate the data extraction
and create the PowerPoint presentation "on the fly", saving you hours of work for each presentation, and
increasing the accuracy of the final report.
How it Works
In this example, we have a web-application that contains data that needs to be used to populate a
PowerPoint presentation. This data consists of text as well as data to be graphed.
Our first step is to ensure that the data can be reliably extracted. While access to the underlying
database or through a web-service (or XML call) is preferable, we can "screen scrape" web-pages
to extract the needed information.
The next step is to design the PowerPoint template. The best way to start is to have the customer
provide an existing presentation to base the new template off of, but we can also perform custom
design if needed.
The third step is to create the tool to insert the extracted data into the presentation. This takes
the form of a "VBA Macro" that loads and inserts the data, properly formatted, into the template.
The final step is to perform rigorous testing and to obtain customer sign-off. The final tool is
then delivered, complete with documentation and all source code.
To learn more or to request a quote, please use the comment form or
e-mail me directly.
Scovetta.com is a personal website. Opinions expressed are my own, and not those of my employer or any groups I am affiliated with.