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
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
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?OK, so it is Vaccinary (13th month of 2020 or 2020+1) and James McGillivray (blog|twitter) is inviting us for another #TSQL2SDAY. This month the topic is a break. Break at home Children – can break things 🙂 but also help to take breaks from work. Watching children grow and learn One of my favourite activity…
Read More T-SQL Tuesday #134: give me a break 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?