使用Powershell Excel COM确定指定范围内是否存在单元格

$excel = New-Object -ComObject Excel.Application
$workbook = $excel.Workbooks.Open("C:\path\to\your\file.xlsx")
$worksheet = $workbook.Worksheets.Item(1) # 假设要操作第一个工作表

$range = $worksheet.Range("A1:D10") # 假设要查找的范围是A1到D10
$cell = $range.Find("your value") # 替换"your value"为要查找的值或条件

if ($cell -ne $null) {
    Write-Host "指定范围内存在单元格"
} else {
    Write-Host "指定范围内不存在单元格"
}

$excel = New-Object -ComObject Excel.Application
$workbook = $excel.Workbooks.Open("C:\path\to\your\file.xlsx")
$worksheet = $workbook.Worksheets.Item(1)

$range = $worksheet.Range("A1:D10")
$cell = $range.Find("your value")

if ($cell -ne $null) {
    Write-Host "指定范围内存在单元格"
} else {
    Write-Host "指定范围内不存在单元格"
}

$workbook.Close($false)
$excel.Quit()
[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 excel, workbook, worksheet