Johann Granados (of Staff DotNet ) recently blogged about some new cmdlets for working with spreadsheets. Using these cmdlets, you can: Add a new table to a spreadsheet Set values for a cell or cell range Set the style for a cell or cell range Set the width of a column Working with Open XML using PowerShell is one of the most effective ways to work with Open XML. You can get the source code from CodePlex, or you can download the binaries from Staff DotNet’s web site. See Johann’s blog post for all
Read More...