Generate a Server-side Documents Using PowerTools for OpenXML
ISVs often want to be able to take data and generate documents. It's a common batch processing scenario. The hard part has been figuring out how to generate the documents without putting 2007 Office System on the server. After all, it wasn't meant for servers.
Lawrence Hodson has written a blog posting entitled Generating a document using PowerTools for Open XML and PowerShell. He takes this scenario and shows how to create a report from WMI data. The scenario could be enhanced to use data from a database. Afterall, Powershell gives you access to the .NET Framework.
He uses PowerTools for OpenXML that is available on CodePlex. PowerTools for Open XML are sample source code and guidance for developers showing how to build PowerShell cmdlets that can create and modify Open XML documents. Also included are a number of examples of PowerShell scripts that use the cmdlets.
Combining the technologies of PowerShell and Open XML is a powerful and convenient way to do server-side document processing.
You'll find a screencast, examples, prebuilt binaries, and documentation for PowerShell. Get started at PowerTools for OpenXML.
Posted: Wednesday, April 08, 2009 6:40 PM by Bruce Kyle