How to Quickly Find Hyperlinks in Excel using PowerShell
I recently had the requirement to fetch out all of the hyperlinks from a Large excel worksheet to prepare another
How to call REST APIs using Powershell
What is API? The API is not the database or even the server, it is the code that governs the
How to Create XML file for the current Running services using Powershell
As a System Admin, I came up with a requirement of creating an XML file for a currently running process
Creating a Simple XML Document using Powershell XmlWriter()
Recently, I came up with a requirement of creating an XML file as output using PowerShell code. I want to
Merge/Combine JSON objects using Array in PowerShell
In which Scenario do we use JSON object? Mostly When REST APIs return data in JSON format, you can get
How to add values to the string array from xml using Powershell
We already discussed the reading/Writing XML file using PowerShell in previous posts. Now in this post, we will discuss how
Work with Environment Variables using Windows PowerShell – Part I
Question: Hey dotnet-helpers, I wanted to see the values of all the Environment variables in my servers/PC, How do I
How to Un-ZIP compressed files using PowerShell Expand-Archive cmdlet
In the previous post, we have discussed how to zip the folder/files, so here we going to discuss how to
How to Remove Empty Folders/Directories recursively with PowerShell
As part of System Admin, you will have control of more servers and there may be hundreds of empty folders
Creating Multiple Tables in single HTML Report using Powershell
Actually System Admins do a lot stuff with Powershell Scripts. Often in Powershell you get lists where data is collected
How to remove duplicate rows in a CSV using Powershell
We are maintaining the user database in our environment, every week automatically the excel will be placed in the the
How to create Basic Chart by reading excel using PowerShell
As system admins, we are used to digging through heaps of searching, selecting, sorting, filtering, until we got what we
How to use splatting in Powershell – Part I
Splatting is a method of passing a collection of parameter values to a command as unit. PowerShell associates each value
Creating Chart Reports using Powershell Chart controls
As system admins, we are used to digging through heaps of searching, selecting, sorting, filtering, until we got what we
How To Monitor a Folder changes using Powershell
In our environment, large numbers of users are working on a daily basis and it very difficult to track what
