PSWriteOffice
PSWriteOffice copied to clipboard
Search method in Excel case sensitive
hello, I use the search method as shown below in the script, I noticed that the search function respects case, if the searched word is in lower case like Password instead of PASSWORD it returns false to me, so on Is there a way to add a case option or take this into account because with the dsk dll this does not cause a problem I think the function is in the closed.dll module I have not managed to find her. Thank you so much
Import-Module PSWriteOffice
$excel = Get-OfficeExcel -FilePath $filepath
[string]$findtext = $excel.Search($pattern)