New Spreadsheet cmdlets for PowerTools for Open XML
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 the details.
