December 2020

ImportExcel - PowerShell module ImportExcel - PowerShell module

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…

Read More How to format an entire Excel row based on the cell values with PowerShell?

This blog post is part of the Festive Tech Calendar. If you want to practice the whole thing I have prepared an interactive notebook for you that could be opened with Azure Data Studio for example (link to the notebook). For more things about the PowerShell module check this post out. I would like to…

Read More The MS Excel: An Unexpected Journey with PowerShell

ImportExcel - PowerShell module ImportExcel - PowerShell module

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…

Read More How to merge/unmerge Excel cells with PowerShell?

ImportExcel - PowerShell module ImportExcel - PowerShell module

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…

Read More How to Excel with PowerShell: Table of contents

ImportExcel - PowerShell module ImportExcel - PowerShell module

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…

Read More How to Excel with PowerShell (ImportExcel)

Last month of the year brings a great topic proposed by Lisa Bohm (blog|twitter). Lisa asks about technical things we have learned from writing or giving the presentation. While ago I have written a post about saving Outlook attachments with PowerShell and that that was actually the thing I learned from the topic I want…

Read More T-SQL Tuesday #133: What (Else) Have You Learned from Presenting?