powershell

Post thumbnail

Recently I have got a question about resources to learn PowerShell. There is plenty out there in the wild, but I came across an interesting module I would like to write today – PSKoans. What is PSKoans? The PSKoans module was created by Joel Sallow (blog|twitter) and here is its brief description taken from the…

Read More PSKoans – learn PowerShell with Pester

Saving emails attachments with PowerShell Saving emails attachments with PowerShell

Problem Save attachments from hundreds of emails received via Microsoft Outlook using PowerShell. Scenario One of the systems generates report daily and sends it out via email as an attachment, that is being saved in the Inbox subfolder MyAlerts. Sample email below. After 6 months someone decides to analyze all the reports from the attachments.…

Read More Saving Outlook attachments with PowerShell

ImportExcel - PowerShell module ImportExcel - PowerShell module

Last week I have introduced you to ImportExcel PowerShell module and its capability to manipulate the worksheets and create pivot tables and pivot charts. This week let’s jump on some other features: conditional formatting and charts. ImportExcel – how to? If you have not installed the module before, use the below code to do so…

Read More PowerShell into Excel:ImportExcel Module Part 2

ImportExcel - PowerShell module ImportExcel - PowerShell module

While ago I needed to do some manipulation on Excel spreadsheets but had no Office installed on the server. For the specific case, I looked for a way to complete my task with the PowerShell. A quick look into Google search results and… Even though the name is not specified, both articles talk about the…

Read More PowerShell into Excel:ImportExcel Module Part 1