Examples/Styles/NewExcelStyle.ps1
|
# https://raw.githubusercontent.com/dfinke/ImportExcel/master/images/NewExcelStyle.png try {Import-Module $PSScriptRoot\..\..\ImportExcel.psd1} catch {throw ; return} $xlfile = "$env:TEMP\test.xlsx" Remove-Item $xlfile -ErrorAction SilentlyContinue $data = ConvertFrom-Csv @" Region,Item,TotalSold North,melon,38 South,screwdriver,21 South,peach,33 South,saw,81 South,kiwi,70 North,orange,59 North,avocado,25 South,lime,48 South,nail,83 North,apple,2 "@ $reportTitle = "This is a report Title" $style = New-ExcelStyle -BackgroundColor LightBlue -FontSize 14 -Bold -Range "A1:H1" -HorizontalAlignment Center -Merge $data | Export-Excel $xlfile -Show -AutoSize -AutoFilter -Title $reportTitle -Style $style |