January 2021

ImportExcel - PowerShell module ImportExcel - PowerShell module

The Microsoft Excel spreadsheet is very flexible, users can put whatever they want and it will accept it – even if it does not make much sense. Data Validation in Excel Luckily there is a feature called Data Validation (under Data > Data Tools). The feature helps to control the values in the spreadsheet, so…

Read More How to validate Excel using PowerShell?

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?