2020

Another week and another tip for Excel using Powershell. This post was inspired by one of my readers (thank you Harsha). Conditional formatting is important, however by default we change the look of the cells that have specific values. What about changing the entire row if a specific cell meets certain conditions? Preparation Let’s prepare…

While ago I have posted an introduction to the PowerShell module to manage Excel. This year I have created a series about dbatools.io. This week winter has come to this part of the world and I thought that a bit of PowerShell magic can be used to warm up our data hearts. This winter I…

In this series I would like to give you some examples of the power of PowerShell module to manage Excel files without MS Excel being installed on the server – it is ImportExcel I have introduced while ago. This week I am going to share how to merge and unmerge Excel cells with PowerShell via…

Table of contents for the How to Excel with PowerShell series. How to merge cells/split cells in Excel with PowerShell?By default Excel spreadsheet is a grid made of same size cells, but this can be changed by merging cells. How to format an entire Excel row based on the cell values with PowerShell?Conditional formatting is…