ImportExcel - PowerShell module ImportExcel - PowerShell module

MS Excel offers many different functionalities and one of them is making things to disappear like hiding worksheets or columns and rows, even cells. This week’s post is for your eyes only 😉 Preparation Let’s prepare our environment now to make sure the file does not exist. As an example, we will use a workbook…

Read More How to hide Excel using PowerShell?

ImportExcel - PowerShell module ImportExcel - PowerShell module

Last week I have mentioned the new functions waiting to be included into the module. This week I would like to write about another set of functions: Add-ExcelHyperlink Get-ExcelHyperlink Remove-ExcelHyperlink Those are fresh too and were inspired by a query I have got from Garry Bargsley (blog|twitter) who needed adding hyperlinks to the existing cells…

Read More How to make Excel hyperlinks using PowerShell?

ImportExcel - PowerShell module ImportExcel - PowerShell module

The first week of the new shiny 2021 is a fact. While I was preparing for the series I spotted a pull request adding three more functions. Listing the functions with links to Michael Hokanson’s repo where you can grab to code as at the moment these functions are not part of the module yet.…

Read More How to manage notes in Excel with PowerShell?

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

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)

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? How to format an entire Excel row based on the cell values with PowerShell? How to manage notes in Excel with PowerShell? 4. How to make Excel hyperlinks using PowerShell 5. the next post on…

Read More How to Excel with PowerShell: Table of contents

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?

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?