How to search a message in a excel file using PowerShell SCript. I have excel file which has No Rows Found message and I need to get a count of this message. I would like to know how it can done in PowerShell script.
Example: if an excel file have No Rows Found message appears 5 times and I need to get count of 5.
Any help is appreciated.