PSWriteOffice icon indicating copy to clipboard operation
PSWriteOffice copied to clipboard

Search method in Excel case sensitive

Open dakhama-mehdi opened this issue 5 months ago • 2 comments

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)

dakhama-mehdi avatar Sep 24 '24 10:09 dakhama-mehdi