Excel Powershell Library 0.5.6

Rating: No reviews yet
Downloads: 158
Released: Sep 23, 2014
Updated: Sep 25, 2014 by Avalon77
Dev status: Alpha Help Icon

Recommended Download

Application Excel PowerShell Library Installer
application, 508K, uploaded Sep 24, 2014 - 105 downloads

Other Available Downloads

Source Code Module Source Code
source code, 15K, uploaded Sep 25, 2014 - 53 downloads

Release Notes

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:

@(
PSCustomObject@{
Name="DeviceID";
Style="Red";
Condition="BeginsWith";
Value="L"
}
)

"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 !

Reviews for this release

No reviews yet for this release.