How to search a string in an Excel using Powershell

Question

I have a folder containing multiple excel files. I want to search for a string like "2501" and find which of my files contains this string then output it's file name to a file (or display it). I wrote some scripts and googled but did not find the answer.

I wrote this :

$Location = "C:\1.xlsx"
$SearchStr = "Mike"
$Sel = Select-String  -pattern $SearchStr -path $Location  
If ($Sel -eq $null)
{
write-host "$Location does not contain $SearchStr" -ForegroundColor Cyan
}
 Else 
{
    write-host "Found  $SearchStr  `n$Se in $Location"
}

 Write-host "end" -ForegroundColor Yellow

This works only if I specify a txt file, it does not work with Excel.

another example that works with txt files>>Get-Content c:\scripts\test.txt | Select-String "Failed" — PouriaJalilian
– PouriaJalilian, Commented Jul 16, 2017 at 21:02

A Seyam · Accepted Answer · 2017-07-17 04:34:40Z

0

This may help https://gallery.technet.microsoft.com/office/How-to-search-text-in-e16373b8

Also you may need to loop the folder to search in every excel file

answered Jul 17, 2017 at 4:34

A Seyam

3472 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

PouriaJalilian Over a year ago

I used this :$str="26123" GET-CHILDITEM -recurse C:\txt*.txt | SELECT-STRING -pattern "\b$str\b" >>F:\Final.txt Write-Host Done -ForegroundColor Cyan ---------but i first converted xlsx files to txt-tab delimited files

A Seyam Over a year ago

You are welcome :) I followed the link I sent to you and it worked without converting the excel file to txt

Collectives™ on Stack Overflow

How to search a string in an Excel using Powershell

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related