Inventory documentation with Excel is something that most infrastructure administrators have to deal with on a daily basis. Sometimes, I have to search for a bulk of IP addresses in multiple Excel files, but I have to do it by opening the Excel files one by one. After investigating how this can be achieved in PowerShell, I found that using comObject is the way to go, as it can be used to automate most Windows applications. Make sure Microsoft Excel is already installed before you run the script.
Continue reading “Search Multiple Words in Multiple Excel files using Powershell !”
Skip to content
A Passionated System Admin's Blog
Powershell, Windows Servers, VMware and Scriptings