Add-Worksheet
BrooksV opened this issue · 0 comments
BrooksV commented
I couldn't find an Add-Worksheet cmdlet so I created this one. Please see attached and let me know what you think. I based it off the Get-Worksheet.
The idea behind Add-Worksheet was to Get-Worksheet -Name 'MyWorksheet' and create it if it does not exist. I added parameters for passing a HashTable of Header Column Names and the Row Number to put the header column names into. It also Freezes the Header and adds a Light Gray background.
It needs to reviewed for code correctness and style and could be improved by added Parameters for -Color and -BackgroundColor, and others.
Regards, Brooks
Add-Worksheet.ps1.txt