Eric White's Blog
Open XML, SharePoint, and Office
XLSX Generation
Back to TOCCondensed TOC
Generating spreadsheets is the most common usage of SpreadsheetML.
- Automated Processing of Open XML Documents using PowerShell
Processing Open XML documents using PowerShell is a powerful approach for creating, modifying, and transforming Open XML documents. The PowerTools for Open XML are examples and guidance that show how to do this. They consist of PowerShell cmdlets, and a number of example scripts that demonstrate the use of the cmdlets. Examples include automated word processing document and spreadsheet generation, and preparing documents for distribution external to a company, including removing comments, accepting revisions, applying a uniform theme to them, and applying a watermark to them. (Article)