Johann Granados - New SpreadSheetML cmdlets at Power Tools for Open Xml
“I have recently added the following new cmdlets to Power Tools for Open Xml for working with SpreadSheetML documents:
Cmdlet Description
Add-OpenXmlSpreadSheetTable Adds a new table to a worksheet
Set-OpenXmlSpreadSheetCellValue Sets a value for a cell (or cell range) in a worksheet
Set-OpenXmlSpreadSheetCellType Sets a Cell Style for a cell (or cell range) in a worksheet
Set-OpenXmlSpreadSheetColumnWidth Sets the width for a column (or column range) in a worksheet
…
And finally, because a sample worth more than thousand words here is a script showing how to use the previously described cmdlets. Enjoy them!!!!”
CodePlex - PowerTools for Open XML
“Combining the technologies of PowerShell and Open XML is a powerful and convenient way to do server-side document processing. The 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.
To install and use the PowerTools for Open XML:
…”
Incase you need to poke data into your XlsX via PowerShell… (Just a reminder that the C# source for these cmdlets is available too ;)
(via Eric White - New Spreadsheet cmdlets for PowerTools for Open XML)
Related Past Post XRef:
Powering into OpenXML with PowerShell
No comments:
Post a Comment
NOTE: Anonymous Commenting has been turned off for a while... The comment spammers are just killing me...
ALL comments are moderated. I will review every comment before it will appear on the blog.
Your comment WILL NOT APPEAR UNTIL I approve it. This may take some hours...
I reserve, and will use, the right to not approve ANY comment for ANY reason. I will not usually, but if it's off topic, spam (or even close to spam-like), inflammatory, mean, etc, etc, well... then...
Please see my comment policy for more information if you are interested.
Thanks,
Greg
PS. I am proactively moderating comments. Your comment WILL NOT APPEAR UNTIL I approve it. This may take some hours...