Closed. This question needs
CodePudding user response：
Save your Excel as CSV file
Then in PowerShell do:
$csv = Import-Csv -Path 'X:\theFile.csv' -Header 'path','exists' -UseCulture
foreach ($item in $csv) {
$item.exists = if (Test-Path -Path $item.path) {'OK'} else {'error'}
}
$csv | Export-Csv -Path 'X:\theFile.csv' -UseCulture -NoTypeInformation
Finally double click that file to open in Excel
