如何使用powershell在整个excel工作簿中搜索特定字符串。

Add-Type -Path "C:\Program Files\Microsoft Office\root\Office16\Excel.dll"

$excel = New-Object -ComObject Excel.Application

$workbook = $excel.Workbooks.Open("C:\path\to\your\workbook.xlsx")

$searchString = "example"

foreach ($worksheet in $workbook.Worksheets) {
    $range = $worksheet.UsedRange
    $foundCells = $range.Find($searchString)

    if ($foundCells) {
        foreach ($cell in $foundCells) {
            Write-Host "Found at Worksheet: $($worksheet.Name), Cell: $($cell.Address)"
        }
    }
}

$workbook.Close()
$excel.Quit()

[System.Runtime.Interopservices.Marshal]::ReleaseComObject($range) | Out-Null
[System.Runtime.Interopservices.Marshal]::ReleaseComObject($worksheet) | Out-Null
[System.Runtime.Interopservices.Marshal]::ReleaseComObject($workbook) | Out-Null
[System.Runtime.Interopservices.Marshal]::ReleaseComObject($excel) | Out-Null

Remove-Variable range, worksheet, workbook, excel