This release requires Powershell version 3.0 (And of course .NET 4.x)What was Fixed / Added / Removed ?
*Added a reduced enum EnumConditionalFormattingRuleType based on the OfficeOpenXml.ConditionalFormatting.eExcelConditionalFormattingRuleType enum
*Added a new cmdlet Add-OOXMLConditionalFormatting that let you add conditional formating rule to single or multiple ranges
*Improved the Export-OOXML Cmdlet with a new parameter that allow you to use 4 Conditional Styles that are named: Red, Orange, Yellow and Green. This new "ConditionalFormatings" parameter can receives
array of objects of the following format:
"Name" is the name of one propertie of the array of object you want to export
"Style" is the style you want to apply Red, Orange, Yellow and Green
"Condition" is a string coming from the enum "EnumConditionalFormattingRuleType"
"Value" is the condition value.
For more informations see the Demo.ps1 file
*Added a new command-line Get-OOXMLConditonalFormattingCustomObject that returns a "PSCustomObject" ready to be used with the Export-OOXML "ConditionalFormatings" parameter. It has Auto-Complete for "Style" and "Condition"
*Improved the Export-OOXML cmdlet with a new switch parameter "AutoFit" that will resize all the column accordingto the size of their content
*Fixed the way that conditional formatting was applied in the Export-OOXML because the range was row count +1
*Fixed the "invoke member w/ expression name" exception introduced in version 0.5.5 for those using PS 3.0... Sorry about this !